Talent.com
This job offer is not available in your country.
Informatica Developer - ETL / SQL

Informatica Developer - ETL / SQL

Coders Brain Technology Private LimitedBangalore
1 day ago
Job description

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 PowerCenter
  • Write advanced SQL for joins, deduplication, transformations, and data quality checks
  • Implement exception handling, recovery logic, and logging within ETL pipelines
  • Collaborate with data architects on schema evolution, SCD implementations, and key generation strategies
  • Monitor job performance and apply tuning best practices
  • Support Dev / Test / Prod environment configuration and promote ETL artifacts
  • Participate in code reviews, Agile ceremonies, and CI / CD pipeline activities
  • Interview 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 platforms
  • Author and optimize SQL queries for joins, deduplication, and complex transformation logic
  • Integrate validation, exception handling, and restart logic in ETL pipelines
  • Collaborate with architects on schema design, SCD handling, and surrogate key generation
  • Monitor workflow performance, troubleshoot failures, and apply tuning best practices
  • ref : hirist.tech)

    Create a job alert for this search

    Informatica Developer • Bangalore