Lead Software Engineer

Colombo - Sri Lanka

Monthly Salary: Not Disclosed

Posted on: 16 hours ago

Vacancies: 1 Vacancy

Job Summary

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

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
57 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

Define end-to-end technical approaches for data migration and integration deliveryEstablish standards for data modeling SQL development ETL design and Azure-based integrationsReview ERDs source-to-target mappings ETL designs and data transformation logicEnsure solutions meet performance scalability ...

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

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
57 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