Informatica IDMC Consultant

We are partnering with one of our Global Consulting client to fill a below position...

Job Description:

Role: Informatica IDMC Consultant

Location: Jersey City, NJ (3 days onsite)

Duration: 12 Months

Experience required: 8+ years

Job Summary:

• Sr. ETL Developer. Design, develop, test and deploy the code in the QA and production environment as per the requirement.
• Requirement analysis and design
• Coding and unit testing
• Integration Testing
• User acceptance testing support
• Hyper care support
• Transition to support team

Key Responsibilities:

• Develop ETL processes using Informatica Cloud Data Integration, including constructing mappings, tasks, task flows, schedules, and parameter files.
• Ensure adherence to ETL and ELT best practices and maintain ETL mapping documentation.
• Understand and apply database designs and SQL effectively.
• Familiarize with SDLC and Agile methodologies to enhance project delivery.
• Good to have experience in SAP and Workday integration
• Utilize strong problem-solving and analytical skills to conduct root-cause analysis.
• Communicate effectively in both verbal and written forms to all organizational levels.
• Collaborate with team members and maintain strong interpersonal relationships.
• Demonstrate dedication to quality work with strong organizational skills and attention to detail.

Required Skills:

• 8+ years of experience in Informatica, with at least 2 years of experience in IDMC.
• Strong experience in ETL tools, particularly IDMC as the primary tool and Informatica as secondary.
• Good understanding of ETL and ELT best practices.
• Proficient in database designs and SQL.