Description

Key Responsibilities:

• Design, develop, and maintain data integration solutions using Informatica Data Hub.
• Develop, optimize, and maintain Oracle SQL queries, PL/SQL procedures, functions, and database objects.
• Build and maintain data workflows and ETL processes for enterprise data management.
• Develop and maintain Shell scripts for automation, data processing, and batch operations.
• Configure, schedule, and monitor batch jobs using AutoSys.
• Troubleshoot data integration failures, job errors, and database performance issues.
• Ensure data accuracy, consistency, integrity, and reliability across integrated systems.
• Monitor daily batch processing and resolve production incidents within defined SLAs.
• Automate repetitive operational activities using Shell Scripting and scheduling tools.
• Collaborate with application, database, and data engineering teams to deliver reliable data solutions.
• Support application deployments, enhancements, maintenance, and production releases.
• Maintain technical documentation, job schedules, and operational procedures.

Mandatory Technical Skills:

1.Oracle Database

• Strong hands-on experience with Oracle Database.
• Advanced SQL and PL/SQL programming.
• Stored Procedures, Functions, Packages, and Triggers.
• Query optimization and performance tuning.
• Database troubleshooting and production support.

2. Informatica Data Hub

• Hands-on experience with Informatica Data Hub.
• Data integration and data management.
• ETL workflows and data processing.
• Data mapping, transformation, and synchronization.
• Troubleshooting and monitoring Informatica jobs.
• Experience managing enterprise data integration processes.

3. Shell Scripting & AutoSys

• Strong experience with Unix/Linux Shell Scripting.
• Bash / KornShell (KSH) scripting.
• Automation of batch processes and operational tasks.
• Hands-on experience with AutoSys job scheduling and monitoring.
• Job dependencies, scheduling, failure handling, and restart mechanisms.
• Batch job monitoring and production issue resolution.

Good-to-Have Skills:

• Oracle Cloud Infrastructure (OCI).
• Experience with enterprise data platforms.
• Informatica ETL tools and data integration technologies.
• Linux/Unix administration.
• Database performance monitoring and optimization.
• Production support and incident management.
• Experience with large-scale batch processing environments.

Required Experience & Qualifications:

• 8-10 years of overall IT experience.
• Strong hands-on experience in Oracle Database.
• Practical experience with Informatica Data Hub.
• Strong Shell Scripting and AutoSys job scheduling experience.
• Experience in enterprise data integration and batch processing environments.
• Good analytical, troubleshooting, and problem-solving skills.
• Bachelor's degree in Computer Science, Information Technology, Engineering, or equivalent

Key Skills

Education

Bachelor's degree