About the Role :

We are looking for an experienced Data Engineer with strong expertise in ETL/ELT development, Informatica, SQL, Python, and cloud-based data platforms. The ideal candidate will be responsible for designing, developing, and maintaining scalable data pipelines, managing data integration processes, and supporting enterprise data warehousing initiatives.

Key Responsibilities :

- Design, develop, and maintain ETL/ELT pipelines using Informatica PowerCenter, IICS, and IDMC.

- Develop and optimize data extraction, transformation, and loading processes.

- Write and optimize complex SQL and PL/SQL queries.

- Work with Oracle and Microsoft SQL Server databases.

- Develop and maintain data warehouse solutions using Snowflake.

- Utilize AWS services (EC2, S3, IAM, Lambda, EFS) for cloud-based processing.

- Develop Python scripts for automation and data processing using Pandas and NumPy.

- Perform data profiling, cleansing, and validation.

- Monitor pipeline performance and troubleshoot failures.

- Leverage AI-assisted development tools (LLMs, RAG, embeddings) to enhance productivity.

Required Skills :

- Strong experience in Data Engineering and enterprise data integration.

- Hands-on experience with Informatica PowerCenter, IICS, or IDMC.

- Proficiency in SQL, PL/SQL, and Python (Pandas, NumPy).

- Experience with Snowflake, Oracle, and MS SQL Server.

- Working knowledge of AWS services.

- Familiarity with GitHub and version control.

Education :

- B.Tech / B.E. in any specialization or equivalent qualification.