Description

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

Responsibilities

• Design and develop ETL mappings, mapplets, sessions, and workflows using Informatica Power Center.
• Create Type 1 and Type 2 Slowly Changing Dimension mappings to update dimension database tables.
• Implement 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 complex SQL scripts to optimize performance and reduce reliance on Informatica look-ups.

Required Skills

• Informatica Power Center
• Data Integration
• Data Analysis
• Data Modeling (Star/Snowflake and Data Vault)
• SQL scripting
• Slowly Changing Dimensions (SCD Type 1 and Type 2)
• Experience with ETL transformations and workflow development
• 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