Software / Senior Software Engineer – Data Migration & Integration (Contract)

Role Purpose We are seeking a highly skilled Data Migration & Integration Engineer (available at both Engineer and Senior levels) to lead complex data transitions between legacy CRMs and modern enterprise systems. This role is focused on the architecture and execution of robust ETL pipelines, utilizing SSIS and Azure cloud services to ensure seamless, high-integrity data movement. You will be responsible for the entire migration lifecycle—from source-to-target mapping and schema design to performance tuning and final reconciliation.

Key Responsibilities

Migration Architecture & ETL Development

Data Modeling: Analyze source CRM data models (e.g., Salesforce, MS Dynamics) and design complex ERDs, defining primary-foreign key relationships and cardinalities for target systems.
Pipeline Engineering: Design and implement end-to-end ETL pipelines and integration workflows using SQL Server Integration Services (SSIS) and Azure orchestration tools.
Advanced Scripting: Develop complex SQL scripts, stored procedures, CTEs, and window functions to support sophisticated data transformation and cleansing logic.
Orchestration: Build and maintain cloud-based data workflows using Azure Logic Apps and Azure Functions for event-based integration and transformation.

Data Integrity & Performance

Validation & Reconciliation: Implement incremental data loads, rigorous validation rules, and automated reconciliation processes to ensure 100% data consistency.
Quality Control: Address deduplication, normalization, and data cleansing across structured and semi-structured formats including JSON, XML, and Parquet.
Optimization: Profile and tune SQL queries, SSIS packages, and data processing workflows to handle high-volume datasets efficiently.
Troubleshooting: Act as the lead for resolving L2/L3 ETL failures and data pipeline bottlenecks during critical migration phases.

DevOps & Leadership

CI/CD Integration: Participate in GitHub-based version control, branching workflows, and automated deployment processes.
Documentation: Create comprehensive technical designs, source-to-target mappings, and transformation logic documentation.
Mentorship (Senior Level): Provide technical guidance to junior engineers, lead code reviews, and drive the adoption of engineering best practices within the data team.

Core Technical Skills

Database Expertise: Deep relational database knowledge, including indexing strategies, views, and metadata-driven ETL processes.
ETL Tooling: Expert-level command of SSIS (complex data flows, logging, and error handling).
Cloud Services: Hands-on experience with Azure Data Lake (ADLS) for staging and storage, alongside Azure integration patterns (REST APIs).
Data Warehousing: Experience designing fact/dimension models and implementing Change Data Capture (CDC).
DevOps: Proficiency in GitHub and familiarity with multi-environment deployment strategies.

Experience & Qualifications

Tenure: * Software Engineer: 3–5+ years of experience in data engineering or ETL development.
- Senior Software Engineer: 5–8+ years of experience with a proven track record of leading large-scale integration projects.
Education: Bachelor’s degree in Computer Science, Data Engineering, or a related technical field.
Domain Knowledge: Exposure to CRM platforms like Salesforce or Microsoft Dynamics is highly advantageous.
Soft Skills: Strong analytical thinking, exceptional troubleshooting ability, and the communication skills required to collaborate with QA and business stakeholders.

Why This Contract?

High-Impact Projects: Work on mission-critical data migrations that form the backbone of enterprise digital transformation.
Cloud-First Environment: Deepen your expertise in the Azure data ecosystem and modern integration patterns.
Collaborative Culture: Join a cross-functional team that values technical rigor, clean code, and proactive problem-solving.

More information

Job Location : Colombo, Sri Lanka
City : Colombo
Company Name : Zone24x7 (Pvt) Ltd

More Jobs