Informatica IDMC Consultant

Role: Informatica IDMC Consultant

Location - Jersey City, NJ ( 3 Days WFO)

Find out if this opportunity is a good fit by reading all of the information that follows below.

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.

Sr. ETL Developer.

Design, develop, test and deploy the code in the QA and production environment as per the requirement.

1. Requirement analysis and design

1. Coding and unit testing

1. Integration Testing

1. User acceptance testing support

1. Hyper care support

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