Oracle Engineer

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

Job summary

Artifintech is seeking an experienced Oracle & Informatica Engineer to design, develop, and support enterprise data integration across systems. The role emphasizes Oracle Database, Informatica Data Hub, Shell scripting, and AutoSys scheduling in a production environment.

The candidate will enhance data workflows, automate batch processes, troubleshoot issues, and ensure data quality and reliability while collaborating with cross-functional teams on deployments and maintenance.

Qualifications

• 8-10 years of IT experience with data integration focus.
• Hands-on Oracle database design, SQL/PLSQL, and performance tuning.
• Experience with Informatica Data Hub and batch scheduling tools.

Responsibilities

• Design, develop, and maintain data integration solutions using Informatica Data Hub.
• Develop, optimize, and maintain Oracle SQL queries, PL/SQL procedures, functions, and objects.
• Build ETL workflows and data processing pipelines for enterprise data management.
• Create and maintain Shell scripts for automation 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 systems.
• Monitor daily batch processing and resolve production incidents within SLAs.
• Automate repetitive operational tasks via Shell scripting and scheduling tools.
• Collaborate with application, database, and data engineering teams on deployments.
• Maintain technical documentation, job schedules, and operational procedures.

Skills

Oracle Database

Informatica Data Hub

Unix/Linux Shell Scripting

AutoSys

Education

Bachelor's degree in Computer Science, Information Technology, Engineering, or equivalent

Job description

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

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.