Skip to main content

Data Engineer - Informatica/Snowflake

Technology
TechnoGen
3 days ago

Job description

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.
Keywords
Microsoft SQL ServerNumPyOracle DatabasePl/sqlPythonSql

Interested in this role?