Sr IDMC Consultant

Trenton, New Jersey

Mindlance
Apply for this Job
Pre-ID req

Essential Requirements:

- Extensive experience across all development phases, specifically in the Transformation and Loading (ETL) of data from diverse sources into Data Warehouses and Data Marts.
- Comprehensive knowledge of warehousing architecture techniques, such as Star Schema, Snowflake, and Control M.
- Adherence to the company's software development lifecycle, encompassing the design, coding, configuration, testing, debugging, and documentation of system and application programs.
- Capability in executing migrations through exporting/importing existing content to the SF and/or reconfiguring data connectors to rescan metadata.
- Conducts technical validations and supports User Acceptance Testing (UAT); participates in architecture, design, and code reviews.
- Evaluates functional requirements and analysis and design documents, providing constructive feedback.
- Assists in the preparation of technical design specifications grounded in functional requirements and analysis documents.
- Demonstrates clear communication skills and possesses the ability to troubleshoot and resolve complex technical issues.
- Works collaboratively with other development personnel to ensure quality and consistency.
- A minimum of 6 to 8 years of practical experience is required.
- Essential expertise includes Informatica IDMC (mandatory), Snowflake, Control M, Python, and UNIX. Key

Role Expectations:
1. Extensive experience in all development phases, including the Transformation and Loading (ETL) of data into Data Warehouses and Data Marts from various sources.
2. Profound understanding of warehousing architecture techniques such as Star Schema, Snowflake, and Control M.
3. Follows the company's software development lifecycle for designing, coding, configuring, testing, debugging, and documenting system and application programs.
4. Performs migration tasks, including exporting/importing existing content to environments and reconfiguring data connectors for metadata rescans.

Duration:
Possibility of Extensions

Location:
US 100% Remote

Core requirements:
-5-10 years of experience
-IDMC
-Informatica
-Oracle SQL
-Data warehousing
-Unix

Nice to Have:
-Control M (Scheduling tools)

Interviews:
1-2 Rounds

EEO:

"Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of - Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans."
Date Posted: 28 April 2025
Apply for this Job