SkillSetGroup logo

Enterprise Data Pipeline Engineer (Oracle/Cloud)

SkillSetGroup
  • Irvine, CA
    7 days ago

    Job Description

    What a Day Looks Like

    Your morning begins by scanning orchestration dashboards and pipeline health checks. A validation alert flags a mismatch—your automated data-quality suite catches it early. You dig in with advanced SQL and PL/SQL, tune a query against Oracle Database, and restore freshness SLAs. By midday, you’re pairing with Analytics and BI partners to translate evolving business requirements into scalable technical designs. In the afternoon, you refactor an ETL workflow—shifting a legacy step into an Informatica or Talend job—and set up lineage tracking so governance and audit teams see end-to-end traceability. You close the day with a pull request, CI/CD checks green, and a quick mentoring session to help a teammate optimize a Spark job.

    What You’ll Build

    • Robust enterprise ETL pipelines that move and transform data reliably at scale
    • Complex SQL and PL/SQL logic optimized for performance on Oracle Database
    • Cloud-ready data flows across Oracle Cloud, AWS, Azure, or Google Cloud
    • Automated validation frameworks that enforce data-quality rules and checks
    • Governance assets: metadata capture, lineage mapping, and access controls
    • High-reliability pipelines with proactive monitoring and tuning
    • Translation of analytics/BI requirements into production-grade solutions
    • Modernized patterns leveraging new data technologies and platforms
    • Team capability through technical guidance and mentoring

    Tech You’ll Use

    • SQL, PL/SQL; Oracle Database (advanced)
    • ETL tools such as Informatica, Talend, Fivetran, or OCI Data Integration
    • Cloud services on Oracle Cloud, AWS, Azure, or Google Cloud
    • Python and/or Shell scripting for tooling and automation
    • Airflow (or similar) for orchestration and workflow management
    • Spark/Hadoop for large-scale data processing
    • Git with CI/CD pipelines for versioning and delivery
    • Data modeling, including dimensional modeling techniques

    What You Bring

    • 4+ years in Data Engineering, Data Architecture, or closely related roles
    • Proven enterprise ETL and data-pipeline expertise
    • Advanced SQL and PL/SQL proficiency
    • Deep Oracle Database experience
    • Hands-on use of leading ETL tools (Informatica, Talend, Fivetran, OCI Data Integration, or similar)
    • Cloud exposure across Oracle Cloud and/or AWS/Azure/GCP
    • Python and/or Shell scripting capabilities
    • Airflow (or equivalent) orchestration experience
    • Spark/Hadoop familiarity for big data
    • Strong data and dimensional modeling skills
    • Comfort with Git and CI/CD practices
    • Bachelor’s in CS, Data/Information Systems, or related; equivalent experience considered
    • Excellent communication, problem-solving, and collaboration

    Numbers & Facts

    LocationIrvine, CA
    IndustryStaffing/Employment Agencies
    Company Size100 to 499 employees
    Websitehttps://skillsetgroup.com/

    About Company

    SkillsetGroup was founded on the mission of creating a culture that supports long term retention, both internally, as well as for our candidates and our customers. By providing our customers with the highest levels of customer service, our reputation as a leader in the staffing industry continues to grow. Today, SkillsetGroup is the #1 fastest growing staffing company in California and #3 in the United States.

    SkillsetGroup together with its subsidiaries, provides workforce solutions to various industries within the United States. The company offers trained employees for Accounting & Finance, Administrative & Clerical, Engineering, Manufacturing, Technology, Aerospace & Defense, Automotive, Food & Beverage, Government, Information Technology, Manufacturing, Medical Device, Pharmaceutical, Plastics, Warehouse and Distribution for temporary, full-time and senior-level project professionals. SkillsetGroup also provides scientists, and scientific and clinical research workforce solutions; engineering professionals and information technology specialists across various disciplines. Further, the company provides integrated talent management solutions, including contingent workforce outsourcing, business process outsourcing, recruitment process outsourcing, independent contractor, payroll process outsourcing, and career transition and executive coaching and development solutions. SkillsetGroup was founded in 2013 and is headquartered in Santa Ana, CA.

    Skills

    • Access Controlunmatched
    • Amazon Web Services (AWS)unmatched
    • Apache Hadoopunmatched
    • Apache Sparkunmatched
    • Automationunmatched
    • Big Dataunmatched
    • Business Intelligenceunmatched
    • Cloud Computingunmatched
    • Communication Skillsunmatched
    • Continuous Deployment/Deliveryunmatched
    • Continuous Integrationunmatched
    • Data Managementunmatched
    • Data Modelingunmatched
    • Data Processingunmatched
    • Data Qualityunmatched
    • Database Extract Transform and Load (ETL)unmatched
    • Database Technologyunmatched
    • Dimensional Modelingunmatched
    • GCP (Good Clinical Practices)unmatched
    • Gitunmatched
    • High Reliabilityunmatched
    • Informaticaunmatched
    • Information Technology & Information Systemsunmatched
    • Machine Toolunmatched
    • Mentoringunmatched
    • Metadataunmatched
    • Microsoft Windows Azureunmatched
    • Oracleunmatched
    • Oracle Databaseunmatched
    • Oracle PL-SQLunmatched
    • Performance Tuning/Optimizationunmatched
    • Problem Solving Skillsunmatched
    • Python Programming/Scripting Languageunmatched
    • Refactoringunmatched
    • Requirements Managementunmatched
    • SQL (Structured Query Language)unmatched
    • Software Engineeringunmatched
    • Technical Leadershipunmatched
    • Technical/Engineering Designunmatched
    • Traceabilityunmatched
    • Unix Shell Programmingunmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Free resume builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Free resume builder