Data Engineer - Informatica/Snowflake
First seen by Alion on Nov 13, 2026.
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.
Skills
Data Engineering, Informatica, IICS, SQL, Python, PL-SQL, AWS, Snowflake DB, ETL, Data Pipeline