Job Title : Informatica Developer
Experience : 7+ Years (5+ Years in ETL / SQL)
Location : Bangalore
Work Mode : Hybrid (3 day)
Notice Period : Immediate to 30 Days
Role Overview :
We are seeking an experienced Informatica Developer to join a high-impact team within a regulated, large-scale banking environment. This role focuses on building scalable and robust ETL workflows, optimizing data integration processes, and ensuring high data quality across large datasets.
Must-Have Skills & Required Depth :
- ETL Tools (Informatica) : Strong hands-on experience with Informatica PowerCenter or similar. Skilled in creating production-grade mappings with Lookup, Aggregator, Expression, Router, etc., and managing environment promotions (Dev ? Test ? Advanced SQL : Proficient in complex SQL queries, nested subqueries, CTEs, and window functions (ROW_NUMBER, RANK). Able to analyze performance using EXPLAIN PLAN, create indexes, and work with large Unix Scripting : Daily use of Unix / Linux CLI for log monitoring, permissions, and writing shell scripts (bash / ksh). Familiar with cron job Data Modeling : Understanding of star / snowflake schemas, SCD Type 1 & 2, surrogate keys, and working knowledge of dimensional data modeling in enterprise projects.
Nice-to-Have Skills :
Data Quality & Deduplication : Experience with data cleansing, hash-key logic, reconciliation reporting.Schedulers : Familiar with Control-M or Autosys to manage ETL job dependencies and SLAs.Version Control : Experience with Git, branching strategies, pull requests in CI workflows.PL / SQL or Python : Scripting to support API-based ingestion or logic extension.Agile & DevOps : Worked in Scrum teams, participated in sprints, reviews, backlog grooming, and CI / CD.Visualization Tools : Exposure to Tableau, Power BI, or others for output validation, dashboards, or monitoring.Key Responsibilities :
Develop and optimize ETL workflows using Informatica PowerCenterWrite advanced SQL for joins, deduplication, transformations, and data quality checksImplement exception handling, recovery logic, and logging within ETL pipelinesCollaborate with data architects on schema evolution, SCD implementations, and key generation strategiesMonitor job performance and apply tuning best practicesSupport Dev / Test / Prod environment configuration and promote ETL artifactsParticipate in code reviews, Agile ceremonies, and CI / CD pipeline activitiesInterview Process :
Virtual Round(s) followed by Face-to-Face (F2F) or Hybrid Mode
Design, develop, and promote ETL workflows using Informatica PowerCenter or equivalent ETL platformsAuthor and optimize SQL queries for joins, deduplication, and complex transformation logicIntegrate validation, exception handling, and restart logic in ETL pipelinesCollaborate with architects on schema design, SCD handling, and surrogate key generationMonitor workflow performance, troubleshoot failures, and apply tuning best practicesref : hirist.tech)