ETL Informatica Developer

We are seeking a full-time contractor or employee for a ETL Informatica Developer role.Perform Database Architect work as a member of the Data Governance team, overseeing one or more projects concurrently. Test Extraction Transformation Load (ETL) processes for the data warehouse. Document ETL processes to extract data from existing systems into the data warehouse. Document the as-is schemas currently in use at TWC. Perform complex data modeling tasks in a data warehouse environment. Create mapping documents from source to target databases. Create database standards and best practices deliverables. Perform other analysis and documentation tasks as required to facilitate and support TWCs Enterprise Data Warehouse. Define and document the technical architecture. Perform other analysis and documentation tasks as required. Perform other duties as assigned to maintain operations.Required Skills:

Deep hands-on expertise with Informatica ETL processes, development, data management, data profiling, data flows, data relationships, and data quality standards and processes

Hands-on experience with data warehouse development and testing (relational and dimensional) and proven evidence to implement using databases like Oracle, SQL Server etc. but preferably Oracle

Analyzing and generating technical requirements and design

Hands on experience with data modeling preferably in a data warehouse environment

Experience with Informatica product suite in the Informatica cloud

Creating source to target mapping database documentation

Assist with migrating data from legacy database to new target database

Preferred Skills:

More than one type of RDBMS (DB2, SQL Server, Oracle)

erwin or other equivalent data modeling tools

Experience in Amazon Web Services

Texas Workforce Commission experience