> Markdown version of [/jobs/ext/257715-informatica-idmc-data-warehouse-developer](https://www.wearedevelopers.com/jobs/ext/257715-informatica-idmc-data-warehouse-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Informatica IDMC Data Warehouse Developer

- **Company:** Stellent IT LLC
- **Location:** McLean, VA, United States
- **Experience:** Expert
- **Contract:** Temporary to permanent
- **Skills:** Amazon Web Services, Batch Processing, Software as a Service, Cloud Database, Data Governance, Data Integration, Extract Transform Load (ETL), Data Warehousing, JSON, Python (Programming Language), Systems Development Life Cycle, Shell Script, Simple Data Format, SQL Databases, Systems Integration, Extensible Markup Language (XML), Sql Optimization, Snowflake, Informatica Cloud, Cloud Migration, Data Pipelines
- **Published:** May 17, 2026
- **Apply:** https://www.careerjet.com/jobad/us3c593e0e8af93745620a964f0f5b02a6

## About the Role

* CDI (Cloud Data Integration)
 * CAI (Cloud Application Integration)
 * Advanced SQL
 * AWS experience
 * Real-time integration experience (not just batch)
 * Strong ETL design and development background
 * Experience working with:

 * JSON, XML, and varied file formats
 * Ability to work independently with minimal supervision

Nice-to-Have

 * Informatica certifications
 * Retail or supply chain domain experience
 * Shell scripting
 * Experience supporting large-scale cloud migrations
 * Exposure to data governance / metadata / lineage

Project Environment

 * Supporting PSDL project + existing systems
 * Recently migrated to cloud (Informatica Cloud / IDMC)
 * Currently working through on-prem decommissioning
 * Heavy focus on:

 * Real-time integrations
 * Cross-platform system integration (horizontal team)
 * Existing batch processes still exist, but integration work is priority, * Pure developer mindset (NOT looking for managers or architects)
 * Strong in integration-first thinking, not just ETL pipelines
 * Comfortable in fast-moving, globally distributed teams
 * Flexible and adaptable across changing requirements
 * Proven ability to own delivery end-to-end

Interview Process * Round 1 (30 min) Technical panel

 * Given a requirement expected to walk through solution design
 * Round 2 Technical deep-dive

 * Focus on past projects (PSDL + integrations)
 * Deep discussion on design, architecture, and implementation

Key Differentiators
Candidates will stand out if they have:

 * Strong real-time integration experience (IDMC CAI)
 * Experience handling dynamic file ingestion (JSON/XML automation)
 * Informatica certifications
 * Supply chain / retail exposure

## Description

This is a hands-on, pure development role focused on building and integrating data solutions in Informatica IDMC. The team is looking for someone who can design, develop, and deliver independently across the full SDLC, with a strong emphasis on real-time integrations over batch processing.
Core Responsibilities

 * Design, build, and maintain cloud-based data warehouse solutions
 * Develop ETL/ELT pipelines using Informatica IDMC (CDI, CAI)
 * Build real-time / near real-time integrations across multiple systems
 * Integrate data across varied tech stacks and formats (JSON, XML, etc.)
 * Support data modeling (dimensional, star/snowflake)
 * Optimize SQL queries and performance
 * Contribute across the full SDLC: design development deployment
 * Ensure data quality, validation, and consistency
 * Help decommission legacy on-prem systems during cloud migration, Data Warehouse Developer/Informatica Developer Location: McLean, VA Duration: 6 months Remote/Hybrid Seeking for a skilled Data Warehouse Developer/Informatica Developer to…
 + 21 hours ago


## Related Videos

- [MCP doesn’t suck — your agent does](https://www.wearedevelopers.com/videos/100202-mcp-doesn-t-suck-your-agent-does)
- [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team)
- [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json)
- [Implementing continuous delivery in a data processing pipeline](https://www.wearedevelopers.com/videos/73-implementing-continuous-delivery-in-a-data-processing-pipeline)
- [Blueprints for Success: Steering a Global Data & AI Architecture](https://www.wearedevelopers.com/videos/1577-blueprints-for-success-steering-a-global-data-ai-architecture)
- [Introducing JSON Structure](https://www.wearedevelopers.com/videos/100219-introducing-json-structure)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Dev Digest 162: AI careers, MCP, AWS best practices & floppy sweaters](https://www.wearedevelopers.com/magazine/571-dev-digest-162-ai-careers-mcp-aws-best-practices-floppy-sweaters)
- [Why Attend a Developer Event in 2026?](https://www.wearedevelopers.com/magazine/688-why-attend-a-developer-event-in-2026)
- [Navigating the AI Shift](https://www.wearedevelopers.com/magazine/629-navigating-the-ai-shift)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [What Makes WeAreDevelopers World Congress Different From Every Other Tech Event?](https://www.wearedevelopers.com/magazine/701-what-makes-wearedevelopers-world-congress-different-from-every-other-tech-event)