Job Description - Senior Oracle & Informatica Engineer

Experience: 8-10 Years

Job Title: Oracle Engineer / Senior Informatica Engineer

Job Summary

We are looking for an experienced Oracle & Informatica Engineer with strong expertise in Oracle Database, Informatica Data Hub, Shell Scripting, and AutoSys. The candidate will be responsible for developing, maintaining, and supporting enterprise data integration solutions, managing data workflows, automating batch processes, and ensuring reliable data movement across systems.

The ideal candidate should have hands-on experience in Oracle database technologies, Informatica Data Hub, Unix/Linux Shell Scripting, and AutoSys scheduling, along with strong troubleshooting and production support capabilities.

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.