Description

You will build and maintain data integration solutions using Informatica, automating acquisition from diverse sources and developing complex SQL transformations for Oracle dimensional models.

This role is on-site.

Responsibilities

• Automate data acquisition from diverse data sources.
• Develop complex SQL scripts to transform source data into dimensional models, creating views and materialized views in Oracle.
• Build automation using Informatica Power Center/IICS to pull and transform external data.
• Collaborate with the Data Engineering Team on optimal data design and implementation.
• Participate in sprint ceremonies and support the enhancement of the data integration hub.

Required Skills

• 5+ years of experience in ETL development.
• Proficiency in SQL for complex script development and validation.
• Expertise with Informatica and Informatica Power Center/IICS.
• Strong understanding of ETL processes.
• Experience working with Oracle databases.
• Familiarity with Agile methodologies.
• Ability to interpret and implement changing business requirements.

Preferred Skills

• Experience with data integration hub enhancements.

Key Skills

Education

Any Gradute