Oracle Engineer

Valiant Technologies LLC; Dallas (TX); On-site; USD 110,000 - 170,000; Full time

Job summary

Valiant Technologies LLC is seeking an experienced Oracle & Informatica Engineer to design, implement, and support enterprise data integration solutions in a Dallas, TX environment. You will develop Oracle SQL/PLSQL, manage Informatica Data Hub workflows, and automate batch processes with Shell scripts and AutoSys.

The ideal candidate has 8-10 years in IT, strong troubleshooting abilities, and a proven track record in production support, data movement across systems, and collaboration with

Qualifications

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

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.

Skills

Oracle Database

Unix/Linux Shell Scripting

Informatica Data Hub

AutoSys

Education

Bachelor's degree in Computer Science/IT/Engineering

Tools

Informatica Data Hub

AutoSys

Job description

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.
• 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.
• 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:

• Experience with enterprise data platforms.
• Informatica ETL tools and data integration technologies.
• 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.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.