Senior Software Engineer (Data Migration & Integration)

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 Requirements 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 Nice to Have 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