Informatica Senior Developer

Blackbuck-Insights; Chennai, Hyderabad; Hybrid; INR 2,500,000 - 4,500,000; Full time

Job summary

BBI is seeking a Senior Developer with deep ETL expertise to design, develop, and support enterprise-scale data integration within a healthcare-focused environment. The role requires hands-on ETL development using Informatica PowerCenter, BDM/DEI, and Confluent Kafka, alongside leadership of cross-functional teams across India and the United States.

You will optimize workflows, mentor engineers, and ensure delivery of scalable data solutions while collaborating closely with Architecture, QA, and

Qualifications

• 8-12 years of progressive data engineering experience with ETL focus.
• Strong communication to articulate technical concepts to both technical and non-technical audiences.
• Hands-on ETL design, development, and performance tuning.

Responsibilities

• Design, develop, and maintain enterprise ETL solutions using Informatica PowerCenter and BDM/DEI.
• Build scalable batch and real-time data pipelines with Confluent Kafka.
• Lead technical design, implement solutions, and mentor junior developers.
• Collaborate with Architecture, Data Engineering, QA, and Business teams.

Skills

ETL development

Data engineering

Technical leadership

Analytical thinking

Problem solving

Mentoring juniors

Stakeholder management

Education

Bachelor’s degree or higher from a reputed university

Tools

Informatica PowerCenter

Informatica BDM/DEI

Confluent Kafka

Hadoop

SQL

Linux scripting

Informatica PowerExchange

GitLab

Jira

Unix/Linux

Job description

BBI is a global data engineering consulting firm that empowers clients to effectively scale and modernize. We combine engineering fundamentals and innovative tools to execute business-critical, end-to-end projects on-time and on-budget. We offer expert services across Data Integration, Data Modernization, Data Migration, Data Architecture, Platform Support, and Application Services. Our goal is to provide business value in the most effective way for our clients so clients can focus on growth.

Job Description

Role Summary:

Location: Chennai and Hyderabad(Hybrid)

We are seeking an experienced and results-oriented Senior Developer with deep ETL expertise in Informatica PowerCenter, Informatica BDM/DEI, Confluent Kafka, Hadoop, SQL, Linux scripting, and good knowledge in Informatica PowerExchange. The successful candidate will play a key role in designing, developing, enhancing, and supporting enterprise-scale data integration and data platform solutions within a complex healthcare environment.

This role requires strong hands-on experience in ETL development, data engineering, performance optimization, troubleshooting, and support production support team. The individual will lead technical design and implementation activities, ensuring delivery of scalable, reliable, and high-performing data solutions.

The Senior Developer will collaborate closely with business and technology stakeholders across India and the United States, providing technical leadership, driving solution architecture discussions, and coordinating cross-functional teams to deliver project objectives. Success in this role demands strong analytical and problem-solving skills, excellent communication abilities, and the capability to independently drive complex data initiatives from requirements gathering through deployment and ongoing support.

Key Responsibilities

• Design, develop, and maintain enterprise ETL solutions using Informatica PowerCenter and Informatica BDM/DEI.
• Build scalable batch and real-time data integration pipelines leveraging Confluent Kafka.
• Develop and optimize data ingestion, transformation, and data quality processes for large-volume datasets.
• Work with Hadoop ecosystem components for data processing and integration.
• Analyze business requirements and translate them into technical design and implementation solutions.
• Work with release management team for project delivery and very good knowledge on GitLab or Jira.
• Perform code reviews, unit testing, deployment support, and production issue resolution.
• Troubleshoot ETL performance bottlenecks and optimize workflows for scalability and reliability.
• Collaborate with Architecture, Data Engineering, QA, and Business teams during project delivery.
• Create and maintain technical documentation, design artifacts, and operational runbooks.
• Mentor junior developers and promote engineering best practices across the team.
• Participate in production support rotations and provide timely resolution of critical issues.

Eligible and Educational qualification

• Bachelor’s degree or higher from a reputed university
• 8-12 years of progressive experience in data engineering, with a strong focus on ETL development.
• Strong verbal and written communication skills with the ability to articulate complex technical concepts to both technical and non-technical audiences.

Required Technical Skills

Informatica

• Strong hands-on experience in:
  • Informatica BDM (Big Data Management) / DEI (Data Engineering Integration)
  • Mapping development, workflows, parameterization, deployment, and performance tuning
• Good knowledge of:
  • CDC (Change Data Capture) concepts
  • Metadata and repository management
• Strong experience with:
  • Confluent Kafka
  • Hadoop Ecosystem (HDFS, Hive, Spark)
  • Data warehousing concepts
  • Data migration and reconciliation processes

Database & Query Optimization

• Advanced SQL development skills
• Experience with Oracle, DB2, Teradata, or similar RDBMS
• Ability to optimize complex queries and ETL processing
• File handling, scheduling, monitoring, and deployment automation
• Knowledge of Unix/Linux administration concepts

Preferred Skills

• Experience with Healthcare data platforms and MDM ecosystems.
• Exposure to cloud-based data integration platforms.
• Knowledge of Spark migration and optimization.
• Experience with CI/CD and DevOps practices for data engineering projects.
• Familiarity with data governance and data quality frameworks.

Soft Skills

• Excellent communication and stakeholder management skills.
• Strong analytical and problem-solving abilities.
• Ability to work independently and drive initiatives with minimal supervision.
• Experience leading small technical teams and mentoring junior engineers.
• Strong ownership mindset and commitment to delivery excellence.