Software Engineer (Data Migration & Integration)

Sri Lanka·Colombomid

Software EngineerSoftware Engineering

0 views0 saves0 applied

Technical Tools

Software EngineerSoftware Engineering

Review existing CRM and legacy data structures and assist in designing target data models aligned with enterprise systems
Develop and support ETL pipelines using SSIS and Azure services for data extraction, transformation, and loading
Implement incremental data synchronization and change tracking processes
Assist with data migration execution, validation, reconciliation, and post-migration stabilization
Create and optimize SQL queries, stored procedures, and database objects
Ensure data accuracy, consistency, and integrity throughout migration activities
Prepare structured datasets for reporting and analytics teams
Support integrations between enterprise systems and downstream platforms using APIs and event-driven workflows
Participate in performance tuning and troubleshooting of data pipelines and databases
Follow established best practices for version control, documentation, and deployment processes

~1 min read

3–6+ years of experience in database development, data engineering, or data migration projects
Solid understanding of data modeling concepts including ERDs, relationships, indexes, views, stored procedures, and functions
Strong SQL development skills with basic performance optimization knowledge
Hands-on experience with SSIS including data flows, packages, and scheduling
Experience working with structured and semi-structured data formats such as CSV, XML, JSON, TXT, Parquet, and relational tables
Knowledge of data warehousing concepts such as dimensions, facts, and metadata
Exposure to Azure services including Data Lake, Function Apps, and Logic Apps
Familiarity with APIs and scripting for data processing and automation
Experience using GitHub or similar version control tools
Strong analytical skills and ability to work collaboratively within technical teams