Description

You will design and develop enterprise data warehouse ETL processes using Informatica.

Responsibilities

• Design and develop extraction, transformation, and load processes using Informatica and Informatica Cloud.
• Analyze requirements and generate technical design documentation.
• Create source-to-target mappings and database documentation.
• Manage data profiling, data flows, relationships, and quality standards.
• Execute data migrations from legacy databases to new targets.

Required Skills

• 5+ years of experience in ETL development and data management.
• Deep expertise in Informatica ETL processes and Informatica Cloud.
• Hands-on experience with relational and dimensional data warehouse development and testing.
• Proficiency with Oracle and SQL Server databases.
• Experience with data modeling within a data warehouse environment.
• Strong understanding of data flows and data quality processes.
• Ability to implement data warehouse solutions using RDBMS.

Preferred Skills

• Experience with DB2, Erwin, or equivalent data modeling tools.
• Experience working within Amazon Web Services (AWS).
• Previous experience with Texas Workforce Commission.

Key Skills

Education

Any Gradute