Informatica IDMC Consultant

Echo It Solutions, Inc.

Jersey City, NJ, United States

6 days ago

Role details

Contract type

Temporary contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

2 years minimum

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Agile Methodology Unit Testing Data Integration Extract Transform Load (ETL) Database Design Systems Development Life Cycle Workday Integrations SAP (Applications) SQL Databases Informatica Cloud Integration Tests

Job description

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, * 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.

Requirements

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.