Job Description
We are seeking an experienced Informatica Administrator / Data Integration Engineer with a strong background in managing on-premise and cloud-based Data Integration environments. The ideal candidate will have extensive experience with Informatica Cloud, PowerCenter, PowerExchange (CDC), IDQ, BDM, and expertise in AWS, automation, and scripting. This role requires excellent troubleshooting skills, infrastructure administration, and the ability to optimize business-critical data workflows.
Primary Skill Set
- Informatica Cloud Administration
- PowerCenter Administration
- PowerExchange CDC (Oracle & SQL Server)
- AWS Cloud Services
Secondary Skill Set
- Unix & Shell Scripting
- Oracle SQL / SQL Server
- Talend Administration
- Snowflake Data Warehousing
Key Roles & Responsibilities
- Manage and monitor Informatica & Talend infrastructure across on-prem and cloud environments with proactive incident resolution.
- Install, upgrade, and apply hotfixes/EBFs for Informatica Cloud and PowerCenter platforms.
- Develop automation scripts using Shell, Python, Jenkins, and Informatica utilities (infacmd, pmrep, pmcmd) to enhance operational efficiency.
- Ensure controlled code deployments and environment management through dev-to-prod application lifecycles.
- Troubleshoot performance issues, conduct root cause analysis, and collaborate with product vendors for major issue fixes.
- Configure and maintain AWS services like EC2, S3, Lambda and integrate StreamSets Data Collectors with Cloud Control Hub.
- Register new tables and maintain CDC configurations for Oracle/SQL Server using PowerExchange.
- Perform system health checks, performance optimization, and ensure high availability of data systems.
- Coordinate planned/unplanned maintenance, ensuring operational readiness for applications and scheduled batch jobs.
- Administer and support Snowflake, Oracle, SQL Server, and StreamSets to maintain reliable and scalable data operations.
Qualifications
- UG: Any Graduate
- PG: Any Postgraduate