Job ID :
Company :
Internal Postings
Location :
Farmington, MI
Type :
Duration :
8 Months
Salary :
Status :
Openings :
Posted :
25 Jul 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 RHEL Unix.

Nice to have skills (Top 2 only):

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

Detailed Job Description:

  • 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 code. Should have worked on databases (Oracle and DB2), and different file structures (delimited, fixed width, XML files). Should have experience in setting up file transfer protocols, like SFTP and their working.
  • Should be able to come up ETL design for the given business requirements and create ETL detailed design document. Should be able to analyze the impact of the mapping changes and estimate the effort for end to end development activities. 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. Strong planning and organization skills, and Good communication skills is a must. Ability to collaborate with the team but also independently recommend and deliver solutions to complex use cases.
  • Working knowledge of data warehouse techniques including database design and Modelling. Should have working knowledge in end - to-end implementation of DWH OR Data Marts OR Operational Data Stores. Should have knowledge in implementing ETL codes for various dimensional modelled database designs. Should understand various software development methodologies including Agile, Waterfall and Iterative.
  • Experience in Informatica Data Integration Hub/ Data quality tools is a PLUS. Work experience as Informatica Admin is a PLUS. Experience in Informatica Cloud is a PLUS. Experience in Metadata Management tools is a PLUS.

Minimum years of experience*: 5+

Interview Process (Is face to face required?) No

Does this position require Visa independent candidates only? No