Informatica Developer
Persistent Systems · Microsoft_DU
Apply ↗Skills
["Informatica""Fabric"]Technology stack
{}Description
About Persistent We are an AI-led, platform-driven Digital Engineering and Enterprise Modernization partner, combining deep technical expertise and industry experience to help our clients anticipate what's next. Our offerings and proven solutions create a unique competitive advantage for our clients by giving them the power to see beyond and rise above. We work with many industry-leading organizations across the world, including 20 Fortune 50 companies and 4 of the 5 top banks in both the US and India, and numerous innovators across the healthcare ecosystem. Our disruptor's mindset, commitment to client success, and agility to thrive in the dynamic environment have enabled us to sustain our growth momentum. Persistent has been recognized across top industry platforms for innovation, leadership, and inclusion. We have delivered 23 sequential quarters of growth with $422.5M in Q3 FY26 revenue, up 4.0% Q-o-Q and 17.3% Y-o-Y growth. Our 26,500+ global team members, located in 18 countries, have been instrumental in helping the market leaders transform their industries. We won the 2025 ISG Star of Excellence Award for AI and Data Excellence and were named a Leader in the Everest Group Talent Readiness for Next-generation Data, Analytics and AI Services PEAK Matrix Assessment 2025. About Position: The Informatica Developer role is focused on supporting a strategic migration from Azure Synapse to Microsoft Fabric Warehouse. The individual will be responsible for repointing and validating existing Informatica Intelligent Cloud Services (IICS) mappings while ensuring data integrity, schema compatibility, and functional consistency. This is a precise, validation-heavy role for an engineer who can modernize integration plumbing while preserving existing functional behaviour. Role: Informatica Developer - IICS Repointing & Validation Location: PAN India Experience: 7-10 Years Job Type: Full Time Employment What You'll Do: Extract IICS package metadata and group mappings by pattern such as STG to View, STG to SP, SCD1/SCD2, and DIM to TEMP to FACT. Tier mappings by complexity to support migration planning and execution. Repoint source connections to Azure SQL Managed Instance and update connection objects, secure agent configuration, and parameters. Repoint targets from Synapse to Microsoft Fabric Warehouse and update target connections, schema, and table objects against the Fabric Warehouse SQL endpoint. Verify table and column parity, map Synapse to Fabric T-SQL data types, and reconcile metadata using INFORMATION_SCHEMA. Assess SQL overrides, expression and lookup transformations, and stored-procedure calls against the Fabric T-SQL surface area. Fix data-type casts, SCD1/SCD2 logic, and lookup or SQL-override issues without changing business logic. Run mappings through IICS and validate connectivity, syntactic execution, and unit testing outcomes. Perform row counts, key checks, surrogate-key checks, schema verification, and sample comparisons against the Synapse baseline. Log, fix, re-run, and promote objects through to final sign-off using defect management processes. Expertise You'll Bring: Hands-on IICS development and administration experience, including mappings, connections, secure agents, parameters, and the IICS Administrator console. Strong understanding of ETL patterns, including SCD Type 1, SCD Type 2, and dimension-then-fact load sequencing. Solid T-SQL skills for data-type casting, SQL overrides, lookups, and remediation. Working knowledge of Microsoft Fabric Warehouse and Fabric T-SQL surface-area limitations, or strong Synapse/SQL Server background with willingness to ramp up on Fabric. Experience with Azure SQL Managed Instance as a source system. Proficiency in data reconciliation, including row, key, surrogate-key validation, and sample comparison against a baseline. Experience with Azure DevOps (ADO) or Jira for defect tracking and promotion. Prior experience on Synapse-to-Fabric or comparable connection-repointing migrations is preferred. Familiarity with INFORMATION_SCHEMA-driven metadata reconciliation is preferred. Microsoft or Informatica certifications will be an added advantage. Benefits: Competitive salary and benefits package Culture focused on talent development with quarterly growth opportunities and company-sponsored higher education and certifications Opportunity to work with cutting-edge technologies Employee engagement initiatives such as project parties, flexible work hours, and Long Service awards Annual health check-ups Insurance coverage: group term life, personal accident, and Mediclaim hospitalization for self, spouse, two children, and parents Values-Driven, People-Centric & Inclusive Work Environment: Persistent is dedicated to fostering diversity and inclusion in the workplace. We invite applications from all qualified individuals, including those with disabilities, and regardless of gender or gender preference. We welcome diverse candidates from all backgrounds. We support hybrid work and flexible hours to fit diverse lifestyles. Our office is accessibility-friendly, with ergonomic setups and assistive technologies to support employees with physical disabilities. If you are a person with disabilities and have specific requirements, please inform us during the application process or at any time during your employment. Let’s unleash your full potential at Persistent - persistent.com/careers “Persistent is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind.”
Requirements
["Informatica", "Fabric"]
Roles & responsibilities
[]
About