
Senior ETL Developer
Onyx Government Services
contract
Posted on:
Location Type: Remote
Location: Virginia • United States
Visit company websiteExplore more
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