Data Warehouse Developer

Summary We are seeking an experienced ETL Developer with strong hands-on skills in Informatica Data Management Cloud (IDMC). This role focuses on designing, developing, testing, and optimizing scalable data integration solutions using IDMC Taskflows, Mappings, reusable components, and parameterization. The ideal candidate will ensure data quality, accuracy, and performance across the data warehouse environment while managing metadata and supporting ongoing enhancements. You will work closely with business partners and cross-functional IT teams to translate requirements into robust IDMC-based solutions. Responsibilities include developing mapping specifications, tuning ETL and SQL performance, ensuring data security compliance, and supporting migration activities—particularly from PowerCenter to IDMC. Experience Required: 4–5 years of relevant real-time experience 3+ years of hands-on experience with Informatica IDMC Strong understanding of data warehousing concepts and integration methodologies Key Skills & Qualifications Knowledge of data warehouse best practices Experience migrating from PowerCenter to IDMC Strong IDMC design, development, and testing skills Proficient in complex SQL (Oracle, DB2, SQL Server) Hands-on experience with Control-M for scheduling Familiarity with relational/dimensional models and slowly changing dimensions Ability to diagnose and resolve ETL and query performance issues Strong communication and documentation abilities Experience with full SDLC processes and requirements gathering Strong teamwork, organizational, and analytical problem‑solving skills Ability to manage both short- and long-term technical projects Pay: $40.00 - $45.00 per hour Benefits: 401(k) Dental insurance Health insurance Life insurance Vision insurance Work Location: Remote