FIND_THE_RIGHTJOB.
Azure Data Factory Engineer
Remote, United States
Centurion is looking for an Azure Data Factory Engineer for a long-term federal government project. This position is 100% remote. It is open to US Citizens that hold an Active Secret Clearance.
Requirements Gathering
- Collaborate with business analysts, data architects, and stakeholders to gather requirements and ensure data integrity throughout the migration lifecycle.
- Ability to create Data mapping documents (Source to Target) by understanding business rules.
Data Understanding/Profiling
- Perform data profiling, cleansing, and quality checks to ensure accuracy and completeness of migrated data.
- Analyze and map source Oracle database schemas to target Dataverse tables/entities, defining transformation and cleansing logic as required.
Technical Requirements for Development
- Write and optimize SQL queries, stored procedures, and scripts for Oracle databases to support data migration and validation.
- Implement data transformation processes to ensure data compatibility with Dataverse data types, relationships, and constraints.
- Experience with Dataverse data types and CRUD operations
- Experience configuring data pipelines in ADF (to extract, transform, load). Experience using .csv files as sources of data for the ADF pipelines
- Experience using Oracle CDCs as sources of data for the ADF pipelines. Experience logging errors (audit framework) from an ADF pipeline to a Dataverse table
- Experience pushing data to Dataverse table(s) including necessary transformations to match target field types (i.e. Dataverse lookups, choices, date/time, etc.)
- Experience configuring setting for pipelines to improve concurrency/performance (i.e., ADF cores, memory, etc.)
- Experience with additional Azure services (e.g., Logic Apps, Data Lake, Azure Functions, Azure SQL).
- Experience/exposure in python/shell scripting is a plus
Data Validation Post migration
- Ability to generate a reconcile report of the migrated data using SQL or scripts
Code Migration
- Must be familiar with Git or source code repository & CI/CD process.
REF: JOB-5406
Similar jobs
DevOps Engineer (Cloud & AI Enablement)
Mogel
Scottsdale, United States
11 days ago
Easy Apply
Software Development Engineer III, Device OS
Amazon.com
Austin, United States
5 days ago
Site Reliability Engineer, Infrastructure Engineering
Amazon.com
Seattle, United States
5 days ago
Senior Software Engineer - Infrastructure
Amazon.com
San Francisco, United States
5 days ago
Senior Manager Data Engineer
Marriott International
Bethesda, United States
5 days ago
ML Data Platform Engineer
AGCO Corporation
Tremont, United States
5 days ago
Data Integration Lead
Hexaware Technologies
United States
5 days ago
© 2025 Qureos. All rights reserved.