Oracle Data Engineer — ETL, Data Warehousing & Tuning

Keypixel Software Solutions; United States; On-site; USD 120,000 - 160,000; Full time

Job summary

Keypixel Software Solutions seeks an Oracle Data Engineer to design, develop, and optimize Oracle SQL/PLSQL-based ETL pipelines and data warehousing solutions. The role includes performance tuning, data validation, and providing L2/L3 production support in a structured environment.

Applicants should have strong Oracle skills, scripting in Unix/Linux, and experience with scheduling tools like Control-M/Autosys. Familiarity with Snowflake/DBT is a plus, preferably in regulated banking environments.

Qualifications

• Strong proficiency in Oracle SQL/PLSQL.
• Experience with ETL and data warehousing concepts.
• Knowledge of Oracle database engineering.
• Ability to optimize queries and tune database performance.
• Familiarity with Unix/Linux and Bash scripting.
• Experience with Control-M or Autosys for job scheduling.
• Ability to provide L2/L3 production support.
• Skills in data validation and reconciliation.
• Proficiency in Git and CI/CD practices.

Responsibilities

• Develop and maintain Oracle SQL/PLSQL scripts for ETL processes.
• Design and implement ETL pipelines for data warehousing.
• Optimize queries and tune database performance.
• Implement indexing and partitioning strategies for faster data retrieval.
• Leverage Unix/Linux and Bash scripting for automation.
• Work with Control-M or Autosys for scheduling and monitoring.
• Provide L2/L3 production support to ensure data availability.
• Perform data validation and reconciliation to ensure data accuracy.
• Collaborate with teams to implement Git and CI/CD practices.
• Experience with Snowflake or DBT is a plus.
• Banking or regulated environments experience is a plus.

Skills

Oracle SQL/PLSQL

ETL & data warehousing

Oracle database engineering

Query optimization

Unix/Linux Bash scripting

Control-M/Autosys

L2/L3 production support

Git & CI/CD

Snowflake/DBT (preferred)

Tools

Snowflake

DBT

Job description

Keypixel Software Solutions seeks an Oracle Data Engineer to design, develop, and optimize Oracle SQL/PLSQL-based ETL pipelines and data warehousing solutions. The role includes performance tuning, data validation, and providing L2/L3 production support in a structured environment.

Applicants should have strong Oracle skills, scripting in Unix/Linux, and experience with scheduling tools like Control-M/Autosys. Familiarity with Snowflake/DBT is a plus, preferably in regulated banking environments.