Description

You will design, develop, and maintain ETL processes to extract, transform, and load data from various sources.

This role is hybrid.

Responsibilities

• Design and maintain ETL processes to handle data extraction, transformation, and loading from multiple sources.
• Perform Informatica PowerCenter version upgrades and convert XML and JSON files.
• Develop and optimize complex SQL queries and stored procedures in PostgreSQL.
• Execute performance tuning for Postgres, Oracle, and Informatica environments.

Required Skills

• 5+ years of experience as an ETL Developer.
• Proficiency in Informatica PowerCenter and Informatica BDM.
• Strong expertise in ETL concepts and Dimensional Data Modeling.
• Advanced SQL skills including ANSI-SQL with PostgreSQL, Oracle, or MySQL.
• Hands-on experience with Presto, Python, and Treasure Data.
• Experience writing Unix scripts and using SourceTree GIT for version control.
• Proficiency in using Visio for technical design.
• Experience with automation tools such as ControlM or ASG ZENDA.

Preferred Skills

• Informatica certifications (ICP, Foundation Level, IDMC, CDCG, or MDM).
• Working knowledge of IDMC.
• Experience with data visualization tools like Qlik, Power BI, or SAP BO.

Key Skills

Education

Any Graduate