Senior Oracle Etl Specialist

Description:

Lumenaxis, a forward-thinking enterprise data solutions provider, is seeking a Senior Oracle ETL/Data Warehouse Specialist for a long-term, high-impact remote engagement with a prominent client. This is an exciting opportunity for a US-based IT consultant who thrives in fast-paced environments and has a strong command over Oracle data platforms and enterprise integration.

As a Senior Oracle ETL Specialist, you will lead the design, development, and implementation of scalable data pipelines and warehouse solutions. This role demands deep technical expertise in Oracle Data Integrator (ODI), SQL, and cloud-based ecosystems like OCI, AWS, GCP, or Azure. You’ll collaborate directly with both technical and business stakeholders to build strategic data assets that drive decision-making across the organization.

Key Responsibilities:

• Lead the end-to-end ETL development lifecycle using Oracle ODI and SQL

• Architect and optimize enterprise data warehouse solutions for performance and scalability

• Integrate and manage data pipelines on cloud platforms including Oracle Cloud Infrastructure (OCI), AWS, GCP, or Azure

• Work closely with business analysts, data engineers, and stakeholders to gather requirements and translate them into technical specifications

• Ensure data integrity, consistency, and alignment with governance and compliance standards

• Troubleshoot complex ETL jobs, improve data flow performance, and implement automation

Must-Have Skills:

• ✅ 12+ years of overall experience in IT and enterprise data systems

• ✅ 5+ years of experience with Oracle Data Integrator (ODI) and advanced SQL development

• ✅ Proven expertise in data warehousing and ETL architecture

• ✅ Hands-on experience with cloud technologies including OCI, AWS, GCP, or Azure

• ✅ Strong communication skills and ability to interface with both technical and business teams

Nice-to-Have Skills:

• Familiarity with Oracle Analytics Cloud (OAC), Autonomous Data Warehouse (ADW), Fusion Data Intelligence (FDI) or Fusion Analytics Warehouse (FAW)

• Experience working in hybrid or multi-cloud environments

Why Join Lumenaxis?

• Work remotely on mission-critical enterprise projects

• Collaborate with industry-leading data professionals

• Exposure to cutting-edge technologies in a cloud-first environment

• Be part of a culture that values innovation, autonomy, and impact