Onyx Government Services

Senior ETL Developer

Onyx Government Services

contract

Posted on:

Location Type: Remote

Location: VirginiaUnited States

Visit company website

Explore more

AI Apply
Apply

Job Level

About the role

  • Design and develop ETL processes
  • Convert existing PL/SQL procedures into SSIS packages
  • Troubleshoot existing ETL solutions
  • Query Oracle databases for data analysis and data quality assurance

Requirements

  • Bachelor’s degree with 7 years of database (specifically ETL) development, or data processing/analytical experience or combination thereof.
  • Strong SQL and PL/SQL skills
  • Expertise with data warehouse designs and the Kimball dimensional model.
  • Experience with writing complex SSIS transformations, reverse engineering from Oracle PL/SQL
  • Experience with Oracle and PostgreSQL databases
  • Strong conceptual, analytical, and decision-making skills
  • Ability to work as a collaborative team, mentoring and training the client on the various tools and techniques to build a complete data warehouse solution
  • Experience with Jira in managing tasks and good understanding of Agile process
  • Must be comfortable working in a fast-paced, flexible environment, and take the initiative to learn new tools quickly.
  • Familiarity with Gilab CI/CD Pipelines.
  • Familiarity with SQL Server Agent orchestration framework.
Benefits
  • Security Clearance: Must possess active BI or NACLC Public Trust security clearance.
  • Must have good communication and writing skills.
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
ETL processesPL/SQLSQLSSISdata warehouse designKimball dimensional modelOracle databasesPostgreSQLcomplex SSIS transformationsdata quality assurance
Soft Skills
conceptual skillsanalytical skillsdecision-making skillscollaborative team workmentoringtraininginitiativeadaptabilityfast-paced environmentflexibility