Senior Data Engineer

IT Consulting; Mohali, Chandigarh; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

IT Consulting in Mohali, Punjab is hiring an experienced Data Engineer to design, develop, and maintain scalable data pipelines, ETL/ELT processes, and data integration frameworks across multiple data sources.

You will build and optimize enterprise data warehouses, data lakes, and lakehouse architectures to support analytics and reporting requirements, while collaborating with business stakeholders to define KPIs.

Qualifications

• Strong experience designing and implementing enterprise data engineering and analytics solutions.
• Expertise in SQL and advanced database concepts, including query optimization, indexing, partitioning, and performance tuning.
• Hands-on experience with ETL/ELT tools such as Azure Data Factory, SSIS, Informatica, Talend, or similar platforms.
• Strong experience with cloud data platforms including Azure, AWS, or Google Cloud.
• Proficiency in data warehousing concepts, dimensional modeling, star schemas, and data lake architectures.

Responsibilities

• Design, develop, and maintain scalable data pipelines, ETL/ELT processes, and data integration frameworks across multiple data sources.
• Build and optimize enterprise data warehouses, data lakes, and lakehouse architectures to support analytics and reporting requirements.
• Collaborate with business stakeholders to gather requirements, define KPIs, and translate business needs into data solutions.

Skills

SQL

Data pipelines

ETL/ELT

Data warehousing

Cloud platforms

Performance tuning

Tools

Azure Data Factory

SSIS

Informatica

Talend

Matillion

Job description

Role & responsibilities

• Design, develop, and maintain scalable data pipelines, ETL/ELT processes, and data integration frameworks across multiple data sources.


• Build and optimize enterprise data warehouses, data lakes, and lakehouse architectures to support analytics and reporting requirements.


• Collaborate with business stakeholders to gather requirements, define KPIs, and translate business needs into data solutions.

Strong experience designing and implementing enterprise data engineering and analytics solutions.

• Expertise in SQL and advanced database concepts, including query optimization, indexing, partitioning, and performance tuning.


• Hands-on experience with ETL/ELT tools such as Azure Data Factory, SSIS, Informatica, Talend, Matillion, or similar platforms.


• Strong experience with cloud data platforms including Azure, AWS, or Google Cloud.


• Proficiency in data warehousing concepts, dimensional modeling, star schemas, and data lake architectures.

Location: Mohali, Punjab