Informatica Senior Developer

Role Summary

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 qualitificaton

• 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:

• o Informatica PowerCenter
• o Informatica BDM (Big Data Management) / DEI (Data Engineering Integration)
• o Mapping development, workflows, parameterization, deployment, and performance tuning

• Good knowledge of:

• o Informatica PowerExchange
• o CDC (Change Data Capture) concepts
• o Metadata and repository management

Data Engineering

• Strong experience with:

• o Confluent Kafka
• o Hadoop Ecosystem (HDFS, Hive, Spark)
• o Data warehousing concepts
• o 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

Linux & Automation

• Strong Shell/Bash scripting experience
• 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.