Lead Software Engineer (Data Migration & Integration)

Sri Lanka·Colombolead

OtherLead Software Engineer

0 views0 saves0 applied

Apply Now

Quick Summary

Overview

Define end-to-end technical approaches for data migration and integration delivery Establish standards for data modeling, SQL development, ETL design, and Azure-based integrations Review ERDs,

Technical Tools

OtherLead Software Engineer

Define end-to-end technical approaches for data migration and integration delivery
Establish standards for data modeling, SQL development, ETL design, and Azure-based integrations
Review ERDs, source-to-target mappings, ETL designs, and data transformation logic
Ensure solutions meet performance, scalability, reliability, and security requirements
Lead technical design discussions and act as the primary escalation point for complex technical issues
Lead execution of CRM data migration and integration strategies
Define entity mappings, relationships, and incremental migration approaches
Oversee API-driven and event-based integrations between enterprise platforms
Support cutover planning, parallel runs, and post-migration stabilization activities
Drive reconciliation, validation, and data quality assurance processes
Design and implement data ingestion and staging workflows using Azure Data Lake (ADLS)
Define logical data layers for ingestion, transformation, and consumption
Implement orchestration workflows using Azure Logic Apps
Develop and govern Azure Function Apps for data processing and system integrations
Ensure monitoring, logging, and operational alerting mechanisms are implemented
Guide dimensional modeling approaches for reporting and analytics
Define SSIS architecture standards, package design, and scheduling practices
Review and optimize SQL queries and high-volume data processing workflows
Troubleshoot complex performance, reconciliation, and data integrity issues
Ensure migration and integration processes meet operational SLAs
Define GitHub workflows, branching strategies, and code review standards
Support CI/CD pipeline implementation and environment promotion processes
Enforce documentation standards and maintain technical design artifacts
Ensure governance, auditability, and compliance requirements are embedded into solutions
Support UAT readiness and production deployment activities
Mentor engineers and support capability development within the team
Lead technical reviews, design sessions, and solution walkthroughs
Collaborate with business analysts, QA teams, CRM specialists, and infrastructure teams
Communicate technical risks, dependencies, and mitigation strategies to stakeholders

Requirements

~1 min read

Strong expertise in data modeling including ERDs, primary and foreign key relationships, and cardinality concepts
Advanced SQL development skills with performance optimization experience
Proven experience in enterprise ETL design and development using SSIS
Experience working with multiple data formats including CSV, JSON, XML, and Parquet
Strong understanding of data warehousing concepts and reporting data structures
Hands-on experience with Azure Data Lake (ADLS) and data staging architectures
Experience developing solutions using Azure Logic Apps and Azure Function Apps
Experience with API-based integrations and event-driven data processing patterns
Understanding of cloud performance, monitoring, and security best practices
Experience with GitHub version control workflows and code review practices
Experience implementing CI/CD pipelines and environment promotion strategies
Experience with production support, monitoring, and incident management
5–7+ years of experience in data engineering, ETL development, or system integration roles
Proven experience leading technical delivery in medium to large-scale data migration initiatives
Strong hands-on development background combined with team leadership experience
Ability to balance technical execution with coordination and stakeholder engagement
Excellent analytical, problem-solving, and communication skills
Experience working in CRM transformation or enterprise integration programs is highly desirable