Oracle Engineer

Ethereum Technologies; Dallas (TX); On-site; USD 110,000 - 150,000; Full time

Job summary

Ethereum Technologies is seeking an experienced Oracle & Informatica Engineer in Dallas to design, develop, and maintain enterprise data integration solutions. You will manage data workflows, automate batch processes, and ensure reliable data movement across systems.

The role requires hands-on Oracle Database and Informatica Data Hub expertise, plus strong Unix/Linux shell scripting and AutoSys scheduling capabilities, with production support and problem-solving skills to meet SLAs.

Qualifications

• 8-10 years of IT experience with enterprise data integration.
• Hands-on Oracle Database expertise and PL/SQL.
• Experience with Informatica Data Hub and batch scheduling.
• Proficient in Shell scripting and AutoSys scheduling.
• Bachelor's degree in CS or related field.

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

Analytical thinking

Troubleshooting skills

Production support

Team collaboration

Education

Bachelor's degree in CS or related field

Tools

Oracle Database

Informatica Data Hub

Shell scripting (Unix/Linux)

AutoSys

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.