Data Warehouse Developer

Saxon Global • McLean, VA

1d

About The Position

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.

Requirements

• Strong Informatica IDMC experience (critical)
• 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 Haves

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

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed