Informatica IDMC Consultant

Informatica IDMC Consultant

Location - New Jersey (3 Days WFO)

Pay Rate

Market- based on exp.

Long term

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.
• Handle support activities, including ticket creation and resolution using Jira and ServiceNow.

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.