Oracle Engineer

Cloud Analytics Technologies, LLC; Dallas (TX); In loco; USD 120.000 - 150.000; Tempo pieno

Descrizione del lavoro

Cloud Analytics Technologies, LLC is seeking an experienced Oracle & Informatica Engineer in Dallas to design, develop, and maintain enterprise data integration solutions. You will optimize Oracle SQL/PLSQL objects, build ETL workflows, and automate batch processes using Shell scripts and AutoSys.

The role requires 8–10 years of IT experience with hands-on Oracle Database and Informatica Data Hub, plus strong troubleshooting and production support capabilities.

Competenze

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

Mansioni

• 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, and reliability across integrated systems.
• Monitor daily batch processing and resolve production incidents within SLAs.
• Collaborate with application, database, and data engineering teams to deliver reliable data solutions.

Conoscenze

Oracle Database

Informatica Data Hub

Shell Scripting

AutoSys

Formazione

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

Strumenti

Unix/Linux

Descrizione del lavoro

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.

Some of our Business Ventures - Knowledge Analytics

Do restrictive necessities, your capability for advanced analytics or your business model need custom-made applications and infrastructure configurations? opt for our hosted managed services to urge comprehensive analytics solutions supported industry-leading Cloud Analytics Technologies, LLC code - delivered by the Cloud Analytics Technologies, LLC consultants UN agency understand these solutions best. Through a mix of with-it technology and dedicated service and support, Cloud Analytics Technologies, LLC hosted managed services will facilitate you: