Informatica ETL Developer with SQL, DW, ODS, IICS/ Informatica Power Center and QA/UAT Experience

CANCELLED
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

Work Requirements
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
e. Deliverables
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.

Leave a Reply