Informatica IDMC DeveloperThis 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 ResponsibilitiesDesign, build, and maintain cloud-based data warehouse solutionsDevelop ETL/ELT pipelines using Informatica IDMC (CDI, CAI)Build real-time / near real-time integrations across multiple systemsIntegrate data across varied tech stacks and formats (JSON, XML, etc.)Support data modeling (dimensional, star/snowflake)Optimize SQL queries and performanceContribute across the full SDLC: design ? development ?
deploymentEnsure data quality, validation, and consistencyHelp decommission legacy on-prem systems during cloud migrationMust-Have RequirementsStrong Informatica IDMC experience (critical) CDI (Cloud Data Integration)CAI (Cloud Application Integration)Advanced SQLAWS experienceReal-time integration experience (not just batch)Strong ETL design and development backgroundExperience working with: JSON, XML, and varied file formatsAbility to work independently with minimal supervisionNice-to-HaveInformatica certificationsRetail or supply chain domain experienceShell scriptingExperience supporting large-scale cloud migrationsExposure to data governance / metadata / lineageProject EnvironmentSupporting PSDL project + existing systemsRecently migrated to cloud (Informatica Cloud / IDMC)Currently working through on-prem decommissioningHeavy focus on: Real-time integrationsCross-platform system integration (horizontal team)Existing batch processes still exist, but integration work is priorityIdeal Candidate ProfilePure developer mindset (NOT looking for managers or architects)Strong in integration-first thinking, not just ETL pipelinesComfortable in fast-moving, globally distributed teamsFlexible and adaptable across changing requirementsProven ability to own delivery end-to-endInterview ProcessRound 1 (30 min) – Technical panel Given a requirement ? expected to walk through solution designRound 2 – Technical deep-dive Focus on past projects (PSDL + integrations)Deep discussion on design, architecture, and implementationKey DifferentiatorsCandidates will stand out if they have:Strong real-time integration experience (IDMC CAI)Experience handling dynamic file ingestion (JSON/XML automation)Informatica certifications