Description

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

Responsibilities

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

Required Skills

• 5+ years of experience in ETL development and data management.
• Deep expertise in Informatica ETL processes and the Informatica Cloud product suite.
• 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