Senior ETL & Data Warehouse Consultant

Lonvec Technologies Private Limited; Dadri; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Lonvec Technologies Private Limited in India is seeking a Senior ETL & Data Warehouse Consultant with 5-8 years of experience to design, develop, and support enterprise data integration and data warehouse solutions. The ideal candidate should be technically strong in Informatica PowerCenter, Informatica IICS, ETL development, SQL, Oracle, PL/SQL, Unix/Linux, and data warehousing concepts.

Experience with Snowflake, AWS, Azure, Python, data modelling, and performance tuning is preferred.

Qualifications

• Experience with enterprise data integration and data warehouse solutions.
• 5-8 years of experience in the role or similar.
• Ability to work individually while collaborating with business and technical teams.

Responsibilities

• Implement scalable ETL workflows and data warehouse solutions.
• Develop and optimize data integration pipelines.
• Perform data validation and troubleshooting.
• Improve ETL performance and support cloud data platforms.
• Provide production data processes support and manage data integration projects end-to-end.

Tools

Informatica PowerCenter

Informatica IICS

SQL

Oracle

PL/SQL

Unix/Linux

Snowflake

AWS

Azure

Python

Job description

ETL Developer / Data Warehouse Engineering Full-time Hybrid

We are hiring a Senior ETL & Data Warehouse Consultant with 5-8 years of experience in designing, developing, and supporting enterprise data integration and data warehouse solutions. The ideal candidate should be technically strong in Informatica PowerCenter, Informatica IICS, ETL development, SQL, Oracle, PL/SQL, Unix/Linux, and data warehousing concepts. Experience with Snowflake, AWS, Azure, Python, data modelling, and performance tuning is preferred. The role requires an individual contributor who can work individually while collaborating with business and technical teams. Key responsibilities include the implementation of scalable ETL workflows and data warehouse solutions, developing and optimizing data integration pipelines, performing data validation and troubleshooting, improving ETL performance, supporting cloud data platforms, providing technical support for production data processes, and managing data integration projects end-to-end from requirements analysis through development, deployment, and maintenance.

Requirements

• Data Warehousing