Description

Design and develop ETL mappings, mapplets, sessions, and workflows to load data from source to target databases using Informatica Power Center.

This role is on-site.

Responsibilities

• Build Type 1 and Type 2 Slowly Changing Dimension mappings to update dimension tables.
• Implement complex transformations including Source Qualifier, Sorter, Aggregator, Expression, Joiner, Look-ups, Stored Procedure, Filter, Sequence, Router, Union, and Update Strategy.
• Participate in data modeling using Data Vault methodology to identify Hub, Link, and Satellite tables.
• Write and optimize complex SQL scripts to improve performance and reduce reliance on Informatica look-ups.

Required Skills

• Informatica Power Center for data integration and workflow development.
• Strong SQL scripting skills with a focus on optimization.
• Experience with ETL transformations and workflow development.
• Data modeling expertise in Star/Snowflake schemas and Data Vault.
• Understanding of Slowly Changing Dimensions (SCD Type 1 and Type 2).
• Data analysis capabilities.
• Ability to travel and/or relocate to various locations throughout the US.

Preferred Skills

• Develop trend lines, statistics, and summary reports using KPIs for dashboards.
• Collaborate with customers to gather requirements and define business logic for design and development.

Key Skills

Education

ANY GRADUATE