Job Id: WA-1179-18-ALP (912590718)
Informatica ETL Developer with SQL, DW, ODS, IICS/ Informatica Power Center and QA/UAT Experience
Location: Seattle, WA (King County)
Duration: 7 Months
The Contractor requirements for this position shall include but are not limited to the following:
Code ODS load jobs
Implement Change Data Capture jobs
Implement data integration jobs (ODS to Data Warehouse)
Perform QA testing of other developers’ ETL jobs
Document ETL job designs and configuration information
Design and perform system integration testing
Design and perform user acceptance testing
The Contractor shall be responsible for but not limited to the following deliverables:
High quality, performant ODS load jobs
High quality, DW integration jobs
Documentation for each ETL job
Recommendations for design improvements
Additional related work items may be assigned as determined by the Data Architect and/or Project Manager.
The Contractor’s role shall be to develop ETL jobs that (a) move data from Oracle and SQL
Server source system databases to an Operational Data Store (ODS), (b) implement change data tracking, and (c) transform, integrate and move data from the ODS to the Data Store.
The Contractor shall adhere to standard naming practices, design patterns, and testing processes.
The Contractor shall have experience using the Informatica Intelligent Cloud Services (IICS) or Informatica Power Center.