ETL DEveloper

Dalmia Cement; Dadri; On-site; INR 900,000 - 1,400,000; Full time

Job summary

Dalmia Cement is seeking a data engineer to design and build data marts, optimize ETL/ELT pipelines, and develop dimensional models for robust reporting and analytics.

The role involves ensuring data quality, collaborating with BI teams, and maintaining documentation across data models and workflows. Experience with warehousing platforms and BI tools is preferred.

Qualifications

• Strong SQL and data modeling expertise.
• Experience with ETL tools (e.g., Informatica, Talend, or similar).
• Hands-on experience with data warehousing platforms (e.g., Snowflake, Redshift, BigQuery).
• Knowledge of dimensional modeling and data mart design principles.
• Familiarity with scripting languages (Python preferred).
• Experience with BI tools (e.g., Power BI, Tableau).

Responsibilities

• Design and develop subject-specific data marts based on business requirements.
• Build and optimize ETL/ELT pipelines for data extraction, transformation, and loading.
• Develop dimensional models (star/snowflake schemas) for reporting and analytics.
• Ensure data quality, consistency, and integrity across data systems.
• Collaborate with BI teams and stakeholders to deliver reporting solutions.
• Monitor and optimize performance of data pipelines and queries.
• Maintain documentation for data models, processes, and workflows.

Skills

SQL & data modeling

ETL tools

Data warehousing

Dimensional modeling

Python scripting

BI tools

Tools

Informatica

Talend

Snowflake

Redshift

BigQuery

Power BI

Tableau

Job description

Key Responsibilities

• Design and develop subject-specific data marts based on business requirements
• Build and optimize ETL/ELT pipelines for data extraction, transformation, and loading
• Develop dimensional models (star/snowflake schemas) for reporting and analytics
• Ensure data quality, consistency, and integrity across data systems
• Collaborate with BI teams and stakeholders to deliver reporting solutions
• Monitor and optimize performance of data pipelines and queries
• Maintain documentation for data models, processes, and workflows

Required Skills:

• Strong SQL and data modeling expertise
• Experience with ETL tools (e.g., Informatica, Talend, or similar)
• Hands-on experience with data warehousing platforms (e.g., Snowflake, Redshift, BigQuery)
• Knowledge of dimensional modeling and data mart design principles
• Familiarity with scripting languages (Python preferred)
• Experience with BI tools (e.g., Power BI, Tableau)