Sr. Etl Developer

Job Description
The Senior ETL / Data Integration Developer will be part of a Data Migration Team on a larger Case Management System Modernization Program being implemented on Azure using MS Dynamics 365 (PowerApps). The role will design and builddata integration routines for moving data from multiple source systems to a new target system with a different data model. Responsibilities include:
Design and develop Cloud ETL processes and workflows using Azure Data Factory and SQL Server Integration Services (SSIS).
Develop Extract, transform, and load (ETL) processes to transmit data from legacy on-premises source system to Azure SQL Databases and Dataverse data repository on Azure.
Create necessary data structures or data models to support data at all stages.
Use Azure Data Factory/SSIS platform to extract, transform, and load data from legacy source system data extracts to multiple staging area AzureSQL Databases.
Use KingswaySoft to move data from AzureSQL Database to Common Data Service (CDS) data reporting.
Communicate analysis, results and ideas to key decision makers including business and technical stakeholders.
Projected compensation range for this position is $135K - $155K. The final salary offered will generally fall within this range and is determined by various factors, including but not limited to the individual's particular combination of education, knowledge, skills, competencies, and experience, as well as internal pay equity, location, contract-specific affordability and other organizational requirements.
Required Skills
At least 8 years of IT systems development experience, primarily in data integration roles
More than 4years of development experience with Microsoft SQL Server
More than 5 years of experience in SQL scripting (extremely strong SQL skills required, including writing T-SQL stored procedures)
More than 5 years of experience in ETL development with SQL Server Integration Services (SSIS)
More than 2 years of experiencewith Azure Data Factory.
More than 5 years of experience performing data reconciliation, data validation, ETL testing, deploying ETL packages and automating ETL jobs, developing reconciliation reports.
Strong analytical skills applied to business software solutions maintenance and/or development
Must be able to work with a team to write code, review code, and work on system operations.
Past project experience with Data Conversion and Data Migration
Experience with Data Quality, Data Quality Rules/ Metrics/Dashboards .
DevOpsexperience using GIT, developing, deploying code to production
Eligible for a Government issued Public Trust Clearance
Desirable Skills
Experience with MS Power Platform, especially Power BI
Microsoft certifications
Active federal government public trust clearance