SDVOSB, Systems Integrator to Federal Civilian Agencies, the Intelligence Community, and Department. of Defense.

Senior ETL Developer

Analytics EngineerAnalytics EngineerContractRemoteTeam 11-50Since 2006H1B No SponsorCompany Site LinkedIn

Location

Virginia

Posted

38 days ago

Salary

Not specified

Bachelor Degree7 yrs expEnglishETLOraclePostgresSQLSSIS

Job Description

• 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

Job 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.