Software Developer - ETL - Senior

• Requires a Senior Software Developer - ETL to validate the data migration from the existing OPGT legacy applications to the new Dynamics 365 OPGT solution.

• Demonstrated experience with data migration from legacy applications to Dynamics 365 Client as ETL developer.
• Demonstrated experience with ETL development, data pipelines, workflow orchestration and data ingestion, transformation, and movement.
• Demonstrated experience in integrating various data sources and systems, both on-premises and in the cloud, using Azure ETL services.
• Demonstrated experience working with Azure Synapse workspaces, including knowledge of pipeline creation, data flows, integration runtimes, triggers, and monitoring.

• Deep knowledge of data manipulation languages (T-SQL), data modelling, query performance analysis & tuning.
• Demonstrated experience with SQL Server, Azure SQL Databases and Dataverse.
• Demonstrated experience with designing, implementing, and supporting solutions to automate data migration testing to Dynamics 365

• Strong understanding of the Dynamics 365 data model, entities, and relationships.
• Experience conducting application data migration testing or data quality testing for model-driven apps in Dynamics 365.
• Familiarity with Dataverse and Power Platform application development.

• Demonstrated experience with Azure DevOps, test plans.

• 5+ years of proven working experience in an ETL role; strong understanding of ETL principles, including data extraction, transformation, and loading processes.
• Strong SQL skills and experience working with Azure SQL Databases and Dataverse.
• Knowledge of Microsoft Dynamics 365 Customer Engagement (Client).
• Nice to have:
• Azure cloud certifications (e.g. Azure fundamentals, Azure Data Engineer associate, Azure Database Administrator associate)

LanceSoft