Contract position, hybrid role!

Please apply only if you have hands on experience in following skillset.

Our public sector client requires a Senior Software Developer - ETL to perform activities for interfacing the new Dynamics 365 solution and data warehouse with internal (OPS) and external systems as a member of the integrations team made up of internal and vendor staff.

Assignment Deliverables

As a member of the integrations team, the ETL Developer will be responsible for integrating the new Dynamics 365 solution, the data warehouse, and various internal (OPS) and external systems. This team will comprise both internal staff and vendor resources.

A high-level list of deliverables for the ETL Developer includes:

• ETL Solution Design and Development:
• Design, develop, and implement robust ETL (Extract, Transform, Load) processes for data migration and ongoing integrations between diverse source systems (e.g., internal legacy systems, external vendor platforms) and Microsoft Dynamics 365 Customer Engagement (CE) and Finance & Operations (F&O).
• Develop and optimize data transformation logic to ensure data quality, consistency, and adherence to business rules and D365 data models.
• Utilize and recommend appropriate ETL tools and technologies (e.g., Azure Data Factory, SSIS, other cloud-based ETL services) to build efficient and scalable data pipelines. I
• Implement data cleansing, validation, and error handling mechanisms within ETL processes.
• Data Migration Planning and Execution:
• Lead and execute all phases of data migration activities from legacy systems to D365 CE and F&O, including data profiling, mapping, cleansing, transformation, and loading.
• Develop and maintain data migration strategies, cutover plans, and rollback procedures.
• Collaborate with data owners and business users to ensure data accuracy and completeness during migration.
• Testing and Quality Assurance:
• Design, develop, and execute comprehensive test plans, cases, scripts, and test data (e.g., manufactured, obfuscated) based on functional and technical specifications to validate ETL solutions and data integrity.
• Create and maintain a full test plan, testing procedures, and an associated library of reusable test cases and scripts, ensuring full traceability from requirements to test outcomes.
• Perform both manual and automated testing to validate system and integration functionality, data accuracy, performance, and scalability. This includes unit testing, integration testing, system testing, and performance testing for ETL processes.
• Collaboration and CI/CD Integration:
• Actively collaborate with stakeholders across business units, development teams, and external vendors to understand integration requirements and ensure proper data flow.
• Ensure proper integration of ETL processes and tests into the continuous integration/continuous delivery (CI/CD) pipeline to support automated deployments and efficient release cycles.
• Support and Documentation:
• Provide analytical, development, and testing support for ETL processes and data integrations throughout the project lifecycle.
• Develop and maintain detailed technical documentation for all ETL processes, data mappings, data dictionaries, and integration architectures.
• Assist in troubleshooting and resolving data integration issues, providing timely support and solutions.