Job ID :
18306
Company :
Internal Postings
Location :
Farmington, MI
Type :
Contract
Duration :
6 Months
Salary :
DOE
Status :
Active
Openings :
1
Posted :
09 Nov 2018
Job Seekers, Please send resumes to resumes@hireitpeople.com

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

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

Nice to have skills (Top 2 only):

  1. Knowledge in Informatica server and application administration. Informatica Data Integration Hub and Data Quality. Data Modelling
  2. Performance Optimization

Detailed Job Description:

  • Extensive experience in designing, building, validating, maintaining and documenting ETL mappings using Informatica Powercenter 10.1.1 client tools.
  • Should have good understanding in UNIX shell scripting.
  • Should be well versed with ETL scheduling process using Autosys R11.
  • 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 co

Minimum years of experience*: 5+

Certifications Needed: No

Top 3 responsibilities you would expect the Subcon to shoulder and execute*:

  1. Should be able to come up ETL design for the given business requirements and create ETL detailed design document
  2. Should be able to analyze the impact of the mapping changes and estimate the effort for end to end development activities.
  3. Participate in meetings with business users to understand the requirement for the purpose of creation of ETL interfaces. Work as an interface between client and offshore team and ensure timelines and quality of the deliverables to the client.

Interview Process (Is face to face required?) No

Does this position require Visa independent candidates only? No