Description

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

Responsibilities

• Design and maintain ETL processes to handle data extraction, transformation, and loading from multiple sources.
• Perform Informatica PowerCenter version upgrades from lower to higher versions.
• Convert XML and JSON files using Informatica PowerCenter.
• Develop and optimize complex SQL queries and stored procedures in PostgreSQL.
• Extract and load delimited and fixed-width flat files using Informatica PowerCenter.
• 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 and experience 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.
• Familiarity with Agile methodologies and JIRA.

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.
• Insurance industry experience with underwriting data terminology.

Key Skills

Education

Any Graduate