Hello ,
We have a requirement with our direct client for an Informatica PowerCenter ETL with P-20W Data Warehouse
Position: Informatica PowerCenter ETL with P-20W Data Warehouse
Duration: 18 months
Location: Olympia, WA
Responsibilities:
This role will report to the P-20W Data Warehouse System Manager and work closely with business staff and state technical staff to:
- provide professional guidance in handling data, creating ETLs and source-to-target mappings
- design, create, test and conduct complex and high quality P-20W data extracts, transfers and loads using Informatica's PowerCenter
- draft complex, high-quality source-to-target mappings between source data and the P-20W system data models
- conduct troubleshooting and error handling
- create SQL statements where necessary
- assist in deployment of code through the P-20W data warehouse environments
- work closely with the data modeler to assist in the maintenance of the P-20W data model and creation of data tables
- support P-20W business intelligence activities
- help create repeatable processes for state staff to use
- perform knowledge transfer and mentoring to state staff in using Informatica PowerCenter to create ETLs
- work closely with state staff in a collaborative manner
Required Skills:
· at least three (3) years experience with Informatica's PowerCenter software performing data Extract, Transformation and Loads
· at least three (3) years experience writing complex source to target mappings and transformations
· experience writing SQL statements
· experience working closely with business and business analyst team members
Preferred Skills:
· Experience using Informatica's PowerCenter with education and/or workforce data
• Experience developing ETLs for a P-20W Data Warehouse built on the Informatica tool set
• Data modeling experience
• Experience performing knowledge transfer to new Informatica Power Center users
• Understanding of the concepts of Informatica's Master Data Management tool and how it integrates into ETLs
Thank you very much
· Technologies: Business Process Rules Management (BPRM) driven Next Generation, Smart and Innovative Service Delivery Platforms
You received this message because you are subscribed to the Google Groups "IT JOBS in USA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to it-jobs-in-usa+unsubscribe@googlegroups.com.
To post to this group, send email to it-jobs-in-usa@googlegroups.com.
Visit this group at http://groups.google.com/group/it-jobs-in-usa.
For more options, visit https://groups.google.com/groups/opt_out.
No comments:
Post a Comment