Informatica IDMC Consultant

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