Role Overview
We are hiring a Senior Informatica Developer (PowerCenter / ETL Engineer) with 8 - 11 years of relevant experience to join our data engineering and enterprise integration team. In this role, you will lead end-to-end ETL pipeline architecture, Informatica PowerCenter (9.x / 10.x) development, environment administration, and L3 production support. You will leverage Informatica Intelligent Cloud Services (IICS / IDMC), optimize complex Oracle SQL workloads, write resilient Unix/Linux shell automation scripts, and govern repository management and high-availability production deployments.
Key Responsibilities
As an Informatica Developer on our team, you will:
- Design, build, optimize, and maintain scalable ETL mappings, sessions, and workflows using Informatica PowerCenter (9.x / 10.x) to support mission-critical enterprise data warehouses.
- Administer Informatica environments, overseeing repository management, user permissions, folder structures, domain configurations, and server health checks.
- Provide L3 production support, conducting root cause analysis (RCA), resolving high-severity data pipeline incidents, and ensuring strict SLA adherence across batch schedules.
- Architect and migrate hybrid and cloud data integration pipelines utilizing Informatica Intelligent Cloud Services (IICS / IDMC).
- Develop and tune complex SQL queries, stored procedures, PL/SQL packages, and partitioning strategies within Oracle database environments to maximize ETL throughput.
- Author, maintain, and automate batch orchestration, file processing, and job monitoring routines using Unix/Linux shell scripting.
- Manage end-to-end ETL code deployments, version control migrations, and release governance across development, QA, UAT, and production environments.
Required Skills & Qualifications
- Total Experience: 8 - 11 years of dedicated, hands-on professional experience as an Informatica PowerCenter / ETL Engineer in enterprise data environments.
- Informatica PowerCenter Mastery: Deep expertise in Informatica PowerCenter (9.x / 10.x) architecture, transformations, performance tuning, pushdown optimization, and grid processing.
- Administration & L3 Support: Proven track record in Informatica domain/repository administration, code migrations, ETL deployments, and L3 production troubleshooting.
- Cloud Integration (IICS / IDMC): Strong working knowledge of Informatica Intelligent Cloud Services (IICS) / Intelligent Data Management Cloud (IDMC) services and connectors.
- Database & SQL Proficiency: Advanced proficiency in SQL, Oracle database architecture, query optimization, indexing, and execution plan analysis.
- Unix/Linux Scripting: Strong hands-on experience writing and debugging Unix/Linux shell scripts for batch automation, log parsing, and operational workflows.
- Release & Repository Governance: Solid understanding of Informatica repository management, deployment groups, XML export/import workflows, and change management best practices.
Preferred Qualifications
- Hands-on experience implementing data profiling, cleansing, and standardization rules using Informatica Data Quality (IDQ).
- Working exposure to complementary ETL and data integration platforms such as Talend.
- Experience integrating or migrating enterprise data workloads into cloud data warehouses like AWS Redshift and relational databases including MySQL.
- Familiarity with real-time application and infrastructure monitoring tools such as Geneos for proactive batch and server alerting.
Education
- Bachelor’s or Master’s Degree in Computer Science, Information Technology, Engineering, or any Graduate / Post Graduate qualification.
Why Build Your Career at InCrest Jobs
- Direct technical ownership over mission-critical enterprise data integration and cloud modernization platforms
- Competitive compensation package benchmarked against top-tier data engineering roles
- Collaborative, engineering-centric culture focused on architectural excellence and high-reliability systems
- Clear career progression pathways with continuous support for advanced cloud and data engineering certifications
Ready to Join InCrest Jobs?
We review applications within 48 business hours.