Job ID :
Company :
Internal Postings
Location :
Farmington, MI
Type :
Duration :
6 Months
Salary :
Status :
Openings :
Posted :
09 Feb 2019
Job Seekers, Please send resumes to

Must Have Skills (Top 3 technical skills only)*:

  1. Designing and implementing Informatica 1 PowerCenter mappings.
  2. Knowledge in DB2 and Oracle databases.
  3. Knowledge in RHELUnix

Nice to have skills (Top 2 only):

  1. Performance Optimization
  2. Knowledge in Informatica server and application administration

Detailed Job Description:

  • 7 of experience in Informatica Powercenter tools
  • Hands on experience in Data Loading
  • Should have handled huge data loads from transactional database to operational data store and create interfaces for data extracts to downstream applications
  • Requirement analysis, create source to target mappings, develop complex mappings, ability to handle difference types of source and targets,well versed with parameter files and integrate tasks to create ETL workflows.
  • End to end testing activities to verify.

Minimum years of experience*: 7

Certifications Needed: No

Responsibilities you would expect the Subcon to shoulder and execute*:

  • Extensive experience in designing, building, validating, maintaining and documenting ETL mappings using Informatica Powercenter 1
  • 1 client tools.
  • Should have good understanding in UNIX shell scripting.
  • Should be well versed with ETL scheduling process using Autosys R1
  • Will be accountable for operational support of production jobs including the maintenance and monitoring of job schedules.
  • Should be expert in writing and performance tuning of SQL queries and performance optimization of ETL

Interview Process (Is face to face required?) No

Does this position require Visa independent candidates only? No