Quick Overview
Seniority
Mid Senior
Work mode
Hybrid
Location
Jersey City, NJ, United States
Posted
3 weeks ago
SQLETLAgileJira
Job Description
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.
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
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.
Similar jobs
- MI
Software Development Consultant - CTJ - TS/SCI with Security Clearance
Microsoft Corporation
Springfield, VA🇺🇸$77.9k - $156.2k/yrHybrid6 weeks agoAzureC#Git+5Technology - CR
SAP SD consultant
CreamIT Inc
United States🇺🇸Hybrid6 weeks agoStakeholder ManagementTechnology - FB
Senior Manager IT - Infrastructure Platforms (Remote)
First-Citizens Bank & Trust Company
TX🇺🇸Remote2 weeks agoPCI DSSActive DirectoryAgile+16 - FB
Senior Manager IT - Infrastructure Platforms (Remote)
First-Citizens Bank & Trust Company
Raleigh, NC🇺🇸Remote2 weeks agoPCI DSSActive DirectoryAgile+16 - CU
IT Network Manager
NewCurtiss-Wright
East Farmingdale, NY🇺🇸HybridYesterday401kOracleActive Directory+7 - AS
IT Systems Engineer
NewAssorthealth
San Francisco🇺🇸Remote7 hours agoSAMLSSOCompliance+4Technology