Data Migration ETL Developer
Arlington, TX - USA
Job Summary
The work:
Key Responsibilities:
- Collaborate with the Data Migration Team to deliver data integration solutions for a Case Management System Modernization Program on Azure using MS Dynamics CRM (PowerApps).
- Analyze and interpret data migration requirements to design effective ETL solutions.
- Design develop and optimize cloud-based ETL processes and workflows for migrating data from multiple legacy systems to modern Azure-based targets.
- Create and maintain data structures or models needed throughout all stages of the data migration.
- Perform detailed sourcetotarget mapping data validation cleansing and quality assurance.
- Conduct unit testing and ensure data quality and integrity during migration.
- Apply performance engineering techniques to optimize pipelines especially for scaling future migration waves.
- Use Azure Data Factory and SSIS to orchestrate complex data flows from onprem to cloud.
- Participate in Agile development cycles and collaborate with crossfunctional teams.
- Communicate technical progress issues and solutions clearly to stakeholders.
- Use critical thinking and problemsolving skills to resolve data migration challenges.
Here is what you need:
- US Citizen (Public Trust Eligible)
- BS degree and 5 years relevant experience
- Advanced proficiency in TSQL and SQL using Microsoft SQL Server
- Intermediate experience with performance engineering
- Intermediate experience with data pipeline solutioning and development
- Handson experience designing and implementing ETL processes in cloud environments such as Azure.
- Experience with data migration activities: extraction transformation loading mapping validation and cleansing.
- Familiarity with Azure Data Factory or similar cloudbased ETL orchestration tools.
- Strong problemsolving skills attention to detail and quality assurance mindset.
- Ability to work within Agile development methodologies.
Preferred experience:
- T4 Public trust (Dept of Justice) highly desired
- Intermediate proficiency with SQL Server Integration Services (SSIS).
- Intermediate skill in requirement analysis and interpretation.
- Familiarity with Agile delivery practices
- Experience working with MS Dynamics CRM / PowerApps and Dataverse.
- Experience supporting largescale or multiwave data migration programs.
***This role is fully remote within Contiguous US***
As required by local law Accenture Federal Services provides reasonable ranges of compensation for hired roles based on labor costs in the states ofCalifornia Colorado Hawaii Illinois Maryland Massachusetts Minnesota New Jersey New York Washington Vermont the District of Columbia and the city of Cleveland. The base pay range for this position in these locations is shown below. Compensation for roles at Accenture Federal Services varies depending on a wide array of factors including but not limited to office location role skill set and level of experience. Accenture Federal Services offers a wide variety of benefits. You can find more information on benefits here. We accept applications on an on-going basis and there is no fixed deadline to apply.
The pay range for the states of California Colorado Hawaii Illinois Maryland Massachusetts Minnesota New Jersey New York Washington Vermont the District of Columbia and the city of Cleveland is:
$86400 - $176200 USD
Required Experience:
IC
About Company
Visit our Investor Relations section to view prior earnings releases, earnings call replays, transcripts and more.