A NYS agency located in Queens, NY is looking for an ETL Developer for a 12 month contract.

Please note that this position may initially allow for work to be performed remotely. However, consultant will be required to work on-site/in-office once COVID restrictions are lifted. Qualified candidates should be made aware before applying.

Requirements and skills

• A deep understanding of relational database technologies, dimensional Modeling, Operational Data Stores, Enterprise Data Warehouses and Data Marts.

• Significant experience with data modeling (conceptual, logical and physical model design), architecture, and performance optimization.

• Expert level understanding of ETL fundamentals and building efficient data pipelines using Extract Transform Load (ETL) tools such as SSIS.

• Experience with cloud data movement and compute technologies including Azure Data Factory, Logic App, Data Bricks and storage technologies including Azure Managed instance, Azure Data Lake, Azure synapse analytics.

• Experience with major database platforms including Oracle, SQL Server as well as Cloud databases. NOSQL experience is a plus.

• Advanced data processing, programming skills using SQL-based technologies, as well as other languages like Python.

• Experience in modern DevOps practices (including Git, CI/CD)

• Experience designing, enhancing, and/or modifying data warehouses

• Functional knowledge of Microsoft Power BI

• Knowledge of: ETL (Extract Transform Load), Analyzing and synthesizing qualitative data, Azure, Oracle, PLSQL, SQL, Current Database Technology, Data Analysis, Data Cleansing Techniques, Python Scripting

Responsibilities

• Develop ETL jobs to move data between source systems and data warehouse to meet the data requirements.

• Build into the pipelines, the required data transformations. Rewrite Oracle Warehouse builder package code in currently supported set of tools including SSIS, Azure Data factory, Python in the effort to migrate on-prem Oracle based data warehouse to Azure SQL Managed instance/Synapse Analytics.

About us: QED National is a leading IT consulting, solutions and staff augmentation firm, serving both the public and private sectors for over 28 years. Headquartered in midtown Manhattan, QED National's team is comprised of the brightest minds in the industry with the skills to solve the most complex technological problems.