Sr. ETL Developer (Kingswaysoft/Dynamics 365) Job at Procentrix, Inc., Herndon, VA

  • Procentrix, Inc.
  • Herndon, VA

Job Description

We offer professional services and innovative solutions that streamline business and government. 

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 build data 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 4 years 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 experience with 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 .
  • DevOps experience 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

Additional Information

Procentrix is an Equal Opportunity employer and does not discriminate on the basis of race, color, religion, gender, national origin, age, marital or veteran status, the presence of a non-job related medical condition or handicap, or any other legally protected status.

Job Tags

Full time, Contract work,

Similar Jobs

Window Genie

Part Time - Window Cleaner Job at Window Genie

 ...advancement opportunity that allows you to work outdoors and help others while making a great income, this is the perfect fit for you. We'll train you on every step of our Window Genie Way. You'll also learn how to do pressure washing, holiday lighting, gutter cleaning, or... 

Nesco Resource

Buyer - Hybrid Job at Nesco Resource

Hybrid Schedule 3 days onsite/2 days remote a week. MUST be US Citizen Interview Process - MS Teams then Onsite Interview Top MUST HAVE SKILLS: - 5 years Buyer experience - Buying experience in Electronics and Mechanical - Defense or Space Buying experience... 

Gardner & Mendoza Immigration Law

Paralegal - Immigration Job at Gardner & Mendoza Immigration Law

HEALTH & RETIREMENT BENEFITS! REMOTE WORK AVAILABLE!! GENEROUS PAID TIME OFF!! Do you want to work on immigration cases where you get to be a key part of making a massive positive impact on people, families and businesses? You could be our next Paralegal!... 

LaSalle Network

Remote Software Developer (Java, C++) Job at LaSalle Network

 ...developing front-facing user APIs~ Proficient in writing applications and tools in a general-purpose programming language such as Java/C++~ Strong understanding of data structures and algorithms, specifically regarding time complexity and general performance~... 

South Shore Health

RN Registered Nurse Interventional Radiology Per Diem Job at South Shore Health

 ...Manages individualized, outcome oriented nursing care through the use of the nursing process...  ...minimum of 16 hours over two (2) shifts per 4 week schedule. Also works 1 day before...  ...Required Licenses/Certifications RN - Registered Nurse Depending on department Basic...