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.