DWH- Senior Software Engineer

Mid / Senior

Remote

As a Senior Software Engineer focused on modern data warehousing, you will be working on teams that will build a variety of modern DW solutions. More specifically, you will:

Transition data within/across traditional RDBMS, MPP DW, modern cloud-based DW
Build data warehouses & data marts on-premises/cloud
Ingest batch and streaming data, build ELT / ETL pipelines
Perform data profiling and quality analysis
Understand and load dimensional data models
Perform SQL performance tunings on long running queries
Collaborate with business consultants, data scientists, and application developers to develop analytics solutions

Required Experience, Skills & Competencies:

Hands-on experience with:

SQL
ETL tools (e.g. Informatica, Talend, Pentaho, SSIS)
RDBMS (e.g. Oracle, DB2, SQL Server)
DW on cloud (e.g. Snowflake, Redshift, Azure Synapse)
Cloud environments (e.g. AWS, Azure, GCP)
Unix shell scripting
Scheduling tools (e.g. Control-M, Autosys, Cron)

Experience in working with data marts and dimensional models (star, snowflake schema)
3+ years of relevant experience
Designation will be commensurate with expertise/experience. Compensation packages are among the best in the industry.

{"group":"Organization","title":"DWH- Senior Software Engineer","zohoId":"557706000009850345","endDate":"2022-06-30T00:00:00.000Z","jobType":"Full Time","job_url":"196-tiger-analytics-dwh-senior-software-engineer","agencyId":1,"location":[{"lat":13.0833,"lon":80.2833,"city":"Chennai","text":"Chennai, Tamil Nadu 600096, India","state":"Tamil Nadu","country":"","zipCode":"600096","is_state":false,"is_country":false,"state_code":"TN","countryCode":"","isLocationSet":true,"loc_h3_hex_res4":"84618c5ffffffff","isLocationResolved":false,"is_address_available_from_parser":true}],"maxSalary":null,"minSalary":null,"startDate":"2022-05-05T00:00:00.000Z","onBehalfOf":"59","description":"As a Senior Software Engineer focused on modern data warehousing, you will be working on teams that will build a variety of modern DW solutions. More specifically, you will: <ul><li>Transition data within/across traditional RDBMS, MPP DW, modern cloud-based DW </li><li>Build data warehouses & data marts on-premises/cloud </li><li>Ingest batch and streaming data, build ELT / ETL pipelines </li><li>Perform data profiling and quality analysis </li><li>Understand and load dimensional data models </li><li>Perform SQL performance tunings on long running queries </li><li>Collaborate with business consultants, data scientists, and application developers to develop analytics solutions </li></ul>Required Experience, Skills & Competencies: <ul><li>Hands-on experience with: </li><ul><li>SQL </li><li>ETL tools (e.g. Informatica, Talend, Pentaho, SSIS) </li><li>RDBMS (e.g. Oracle, DB2, SQL Server) </li><li>DW on cloud (e.g. Snowflake, Redshift, Azure Synapse) </li><li>Cloud environments (e.g. AWS, Azure, GCP) </li><li>Unix shell scripting </li><li>Scheduling tools (e.g. Control-M, Autosys, Cron) </li></ul><li>Experience in working with data marts and dimensional models (star, snowflake schema) </li><li>3+ years of relevant experience </li><li>Designation will be commensurate with expertise/experience. Compensation packages are among the best in the industry. </li></ul><div> </div> ","isHybridJob":false,"isRemoteJob":true,"noOfOpenings":1,"maxExperience":"7","minExperience":"5","isOnPremiseJob":false,"onBehalfOfName":"Tiger Analytics","otherlocations":[],"zohoCurrencyIn":"USD","experienceLevel":"Mid / Senior","zohoNoOfOpenings":{"noOfOpenings":1,"fulfillmentIds":["557706000009850345-1"]},"otherJobReference":null,"sharpenedJobTitle":"DWH- Senior Software Engineer","job_category_group":3,"portalLocationDisplay":"Chennai TN","expertise_coreskill_or_product":["Other"],"job_id":"2471"}

DWH- Senior Software Engineer

Thank you for your application!