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

We are seeking skilled Software Engineers / Senior Software Engineers on a 1-year contract to support a CRM transformation initiative involving data migration and integration between enterprise platforms. This role focuses on building ETL pipelines, designing scalable data models, developing Azure-based integrations, and ensuring data quality, performance, and reliability across systems. Depending on experience level, the engineer may take ownership of complex components and provide mentoring and technical guidance within the team.

Key Responsibilities

  • Analyze source CRM data models and map structures to target enterprise systems.
  • Design and implement ETL pipelines and integration workflows using SSIS and Azure services.
  • Develop complex SQL scripts, stored procedures, and database components to support migration activities.
  • Build and maintain Azure-based data orchestration and transformation workflows.
  • Implement incremental data loads, validation rules, and reconciliation processes.
  • Ensure high standards of data quality, integrity, and consistency throughout migration phases.
  • Troubleshoot and resolve ETL, integration, and data pipeline issues.
  • Optimize performance across SQL queries, SSIS packages, and data processing workflows.
  • Document technical designs, mappings, and data transformation logic.
  • Participate in code reviews, CI/CD workflows, and version control practices.
  • Collaborate with engineering, QA, and business stakeholders to ensure successful delivery.
  • Mentor junior engineers and contribute to engineering best practices (Senior Engineer level).

Core Technical Skills

Data Analysis & Modeling

  • Analyze CRM data models and custom objects.
  • Design ERDs, define PK–FK relationships, and cardinalities.
  • Develop schemas, views, stored procedures, and functions.
  • Apply indexing strategies for performance optimization.

SQL & Data Transformation

  • Write advanced SQL queries including joins, CTEs, and window functions.
  • Implement data cleansing, deduplication, and validation logic.
  • Perform source-to-target reconciliation and audit checks.
  • Optimize queries for large-scale data processing.

Data Warehousing

  • Design and maintain fact and dimension models.
  • Implement incremental loads and change data capture.
  • Support reporting datasets and metadata-driven ETL processes.

ETL & Integration (SSIS)

  • Develop SSIS packages with complex data flows and transformations.
  • Implement logging, monitoring, and error handling.
  • Schedule and optimize ETL workflows for high-volume data loads.

Azure & Cloud Services

  • Use Azure Data Lake (ADLS) for staging and storage.
  • Develop Azure Logic Apps and Function Apps for orchestration and transformation.
  • Integrate systems using REST APIs and event-based patterns.

Data Ingestion

  • Process structured and semi-structured data formats such as CSV, TXT, JSON, XML, and Parquet.
  • Normalize, validate, and transform multi-source datasets.

Version Control & DevOps

  • Use GitHub for source control and branching workflows.
  • Participate in pull requests and code reviews.
  • Support CI/CD processes and multi-environment deployments.

Experience & Qualifications

  • 3–5+ years (Software Engineer) or 5–8+ years (Senior Software Engineer) in data engineering, ETL development, or system integration roles.
  • Strong SQL and relational database expertise.
  • Hands-on experience with SSIS and ETL pipeline development.
  • Experience working with Azure data and integration services.
  • Exposure to CRM platforms such as Salesforce or MS Dynamics is an advantage.
  • Strong analytical thinking, troubleshooting ability, and communication skills.
  • Ability to work collaboratively in cross-functional project environments.

Contract Duration: 12 Months
Working hours – 1 pm to 10 pm IST

    Scroll to Top