Highlights
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.
Numbers & Facts
| Location | Irvine, CA |
| Industry | Staffing/Employment Agencies |
| Company Size | 100 to 499 employees |
| Website | https://skillsetgroup.com/ |
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
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.