Senior Software Engineer (Data Migration & Integration)

Sri Lanka·Colombosenior

Software EngineerSoftware Engineering

0 views0 saves0 applied

Overview

Analyze CRM and legacy data models and design target schemas aligned with enterprise platforms Design, develop,

Technical Tools

Software EngineerSoftware Engineering

Analyze CRM and legacy data models and design target schemas aligned with enterprise platforms
Design, develop, and enhance ETL pipelines using SSIS and Azure integration services
Implement robust incremental data migration and change data capture mechanisms
Lead data migration execution, validation, reconciliation, and stabilization activities
Develop and optimize complex SQL queries, stored procedures, and database objects
Enforce data quality, consistency, and governance standards throughout migration processes
Support reporting and analytics teams with reliable and structured data sets
Design and manage API-based and event-driven integrations between enterprise systems
Perform advanced performance tuning and troubleshoot complex data and pipeline issues
Contribute to CI/CD, version control strategies, and deployment automation
Maintain technical documentation and support knowledge transfer activities
Provide guidance and mentoring to Software Engineers within the team

~1 min read

5–8+ years of experience in data engineering, ETL development, or large-scale data migration initiatives
Strong expertise in data modeling including ERDs, relationships, indexes, views, stored procedures, and functions
Advanced SQL development skills with strong performance tuning and optimization experience
Extensive hands-on experience with SSIS including package design, scheduling, and source-to-target mappings
Experience working with structured and semi-structured data formats such as CSV, XML, JSON, TXT, Parquet, and relational databases
Strong understanding of data warehousing concepts including dimensions, facts, metadata, and change data capture
Practical experience with Azure services such as Data Lake, Function Apps, Logic Apps, and event-based integrations
Experience with APIs and scripting for automation and enterprise integrations
Proficiency with GitHub and modern development workflows
Strong problem-solving skills and ability to work independently and lead technical tasks

~1 min read

Experience with enterprise CRM or ERP platforms
Exposure to Microsoft Dynamics or similar enterprise solutions
Experience supporting business intelligence, reporting, and analytics environments
Background in financial or regulated enterprise data environments