Data Migration ETL Developer
About The Position
At Accenture Federal Services, nothing matters more than helping the US federal government make the nation stronger and safer and life better for people. Our 13,000+ people are united in a shared purpose to pursue the limitless potential of technology and ingenuity for clients across defense, national security, public safety, civilian, and military health organizations. Join Accenture Federal Services, a technology company within global Accenture. Recognized as a Glassdoor Top 100 Best Place to Work, we offer a collaborative and caring community where you feel like you belong and are empowered to grow, learn and thrive through hands-on experience, certifications, industry training and more. Join us to drive positive, lasting change that moves missions and the government forward! 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 source‑to‑target 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 on‑prem to cloud. Participate in Agile development cycles and collaborate with cross‑functional teams. Communicate technical progress, issues, and solutions clearly to stakeholders. Use critical thinking and problem‑solving skills to resolve data migration challenges.
Requirements
- US Citizen (Public Trust Eligible)
- BS degree and 5+ years relevant experience
- Advanced proficiency in T‑SQL and SQL using Microsoft SQL Server
- Intermediate experience with performance engineering
- Intermediate experience with data pipeline solutioning and development
- Hands‑on 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 cloud‑based ETL orchestration tools.
- Strong problem‑solving skills, attention to detail, and quality assurance mindset.
- Ability to work within Agile development methodologies.
Nice To Haves
- 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 large‑scale or multi‑wave data migration programs.
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 source‑to‑target 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 on‑prem to cloud.
- Participate in Agile development cycles and collaborate with cross‑functional teams.
- Communicate technical progress, issues, and solutions clearly to stakeholders.
- Use critical thinking and problem‑solving skills to resolve data migration challenges.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
