Informatica IDMC Consultant

I nformatica 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. 1. Requirement analysis and design 2. Coding and unit testing 3. Integration Testing 4. User acceptance testing support 5. Hyper care support 6. 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.