Apply Now

Data Warehouse Developer(Informatica IDMC)

Remote • Posted 1 hour ago • Updated 1 hour ago

Contract W2

12 Months

Remote

Depends on Experience

Fitment

Dice Job Match Score™

⏳ Almost there, hang tight...

Job Details

Skills

Informatica
SQL
Data Warehouse
Meta-data Management
ELT
SaaS
Salesforce.com
IDMC
CAI
CDI
CDGC
Unit testing
snowflake

Summary

Position: Data Warehouse Developer(Informatica IDMC)

Location: McLean, VA 22102 (100% Remote)

Type:- Long term contract

Overview:

We are seeking a skilled Data Warehouse Developer to design, develop, and maintain scalable data warehouse solutions that support business analytics, reporting, and data-driven decision-making. The ideal candidate has strong experience with ETL/ELT processes, data modeling, SQL optimization, and modern cloud-based data platforms.

Key Responsibilities:

Design, build, and maintain enterprise data warehouse architectures and data marts

Develop and optimize ETL/ELT pipelines to integrate data from multiple source systems

Create and maintain dimensional and relational data models (star/snowflake schemas)

Write, tune, and optimize complex SQL queries, stored procedures, and views

Ensure data quality, accuracy, and consistency through validation and monitoring

Collaborate with data engineers, analysts, BI developers, and business stakeholders to gather requirements

Support reporting, dashboarding, and analytics needs across the organization

Implement performance tuning, indexing, and partitioning strategies

Manage data security, access controls, and compliance requirements

Document data models, pipelines, and warehouse architecture

Participate in Agile ceremonies including sprint planning, standups, and retrospectives

Strong Experience:-

Expertise in Informatica

SQL

IDMC (CDA, CD CAI)

Unit testing

Deployment

ETL Design & Development

AWS(Preferred)

Salesforce(SaaS) Preferred

Required Qualifications:

5+ years of experience as a Data Warehouse Developer or in a similar data-focused role

Advanced proficiency in SQL

Strong development experience with informatica IDMC CDI and CAI is required

Strong understanding of data warehousing concepts, including dimensional modeling

Experience working with large-scale datasets and performance optimization

Familiarity with Agile/Scrum development methodologies

Preferred / Nice-to-Have Skills:

Experience with cloud data platforms such as: AWS

Experience supporting machine learning or advanced analytics workloads

Understanding of data governance, metadata management, and lineage

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 10295358
Position Id: 8971056
Posted 1 hour ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Data Warehouse Developer

Remote

•

6d ago

IO Datasphere, Inc. has been providing project management, software development and IT staff augmentation services to our clients in the Midwest and throughout the U.S. since 1996. We are an approved vendor on contract to provide software development and IT staff augmentation services for the States of Illinois, Michigan, Minnesota, Iowa, and Wisconsin. We also provide these services to businesses, as well as local and county governments, in the Midwest and nationwide. Our client is looking for

Third Party, Contract

$0 - $0

Data Warehouse Developer (PowerCenter to IDMC migration)

Remote

•

3d ago

This role is responsible for designing, developing, testing, and implementing ETL solutions using Informatica Data Management Cloud (IDMC). This role requires strong hands-on experience with Data Integration (DI), Task flows, Mappings, parameter files, and reusable transformations to build scalable, secure, and high-performing data pipelines. The candidate will manage metadata, ensure data accuracy and integrity, and drive continuous optimization within the IDMC and data warehouse environment.

Easy Apply

Contract

Depends on Experience

Data Warehouse Developer

Remote

•

3d ago

Ideal candidate will have skills and experience in the following areas: Knowledge in data warehouse best practice standards Strong experience in PowerCenter to IDMC migration. Experience in design, development, and testing in IDMC. Proficient in writing and analyzing complex SQL queries in Oracle, DB2, SQL Server. Hands-on experience using Control-M for job scheduling and workflow automation. Moderate skills working with relational and dimensional data models Moderate skills working with slowl

Easy Apply

Contract

60 - 65

Data Warehouse Developer II

Remote

•

Today

Data Warehouse Developer II Primary Location: Madison, Wisconsin V-Soft Consulting is currently hiring for a Data Warehouse Developer II for our premier client in Madison, Wisconsin. Knowledge and Skills:Ideal candidate will have skills and experience in the following areas:Knowledge in data warehouse best practice standardsStrong experience in PowerCenter to IDMC migration.Experience in design, development, and testing in IDMC.Proficient in writing and analyzing complex SQL queries in Oracle,

Easy Apply

Contract

Depends on Experience

Search all similar jobs