Data Migration Technical Architect / Lead Engineer

Synectics APAC; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Synectics APAC in Bengaluru is seeking a Senior Data Migration & Integration Architect to lead data migration, integration and cloud-based solutions for CRM and SaaS platforms.

You will design scalable architectures, guide client engagements, mentor engineers, and ensure secure, reliable data handling across AWS, PostgreSQL, MySQL, and Aurora. Ideal candidates have 6+ years of hands-on data migration and API integration experience.

Qualifications

• At least 6+ years in Data Migration, Data Engineering, Backend Engineering, Integration Development, or Solution Architecture.
• Hands-on end-to-end data migration and transformation experience.
• Mandatory experience with CRM, SaaS, Customer Service, or Enterprise Service Management platforms.
• Strong experience in platform integration using REST APIs, Web Services, and third-party integrations.
• Hands-on expertise in Python 3 and SQL.
• Experience with Zendesk APIs and data migration/integration.
• Strong knowledge of relational databases, database design, data modelling, and ORMs.
• Experience developing ETL pipelines and deploying on AWS.

Responsibilities

• Lead Technical Architecture & Solution Design activities for data migration and integration projects.
• Lead end-to-end data migration activities including assessment, mapping, transformation, validation, and reconciliation.
• Develop and maintain ETL pipelines and reusable migration frameworks.
• Design scalable migrations and integrations with CRM, SaaS, and ERP platforms.
• Implement containerized deployment solutions using Docker; work in Linux environments.
• Provide technical estimates, migration plans, and delivery roadmaps; mentor engineers.

Skills

Data Migration

Data Engineering

Backend Engineering

Integration Development

Solution Architecture

Python

SQL

Zendesk APIs

ORMs

AWS

Linux

Education

Bachelor's degree in Computer Science/Engineering/IT

Tools

PostgreSQL

MySQL

Amazon Aurora

Docker

Job description

• Technical Architecture & Solution Design
• Lead technical discovery sessions to understand customer requirements for data migration and integration.
• Assess source and target systems, data structures, volumes, APIs, and dependencies.
• Design scalable migration architectures, data models, mapping strategies, and integration solutions.
• Translate business requirements into technical solutions and implementation plans.
• Data Migration & Transformation
• Lead end-to-end data migration activities, including data assessment, mapping, transformation, import/export, validation, and reconciliation.
• Develop and maintain ETL pipelines and reusable migration frameworks.
• Transform large datasets into formats compatible with target CRM and SaaS platforms.
• Ensure data accuracy, integrity, quality, and consistency throughout the migration lifecycle.
• Troubleshoot complex data migration and transformation issues.
• API & Platform Integration
• Design and implement integrations using REST APIs, web services, and backend services.
• Integrate CRM, SaaS, and customer service platforms with third-party enterprise applications.
• Work with Zendesk APIs, imports, exports, and platform integration capabilities.
• Develop secure and scalable integration solutions across multiple platforms.
• Design and deploy cloud-based migration and integration solutions using AWS.
• Work with relational databases such as PostgreSQL, MySQL, and Amazon Aurora.
• Develop and optimize SQL queries and database structures.
• Implement containerized deployment solutions using Docker or similar technologies.
• Work in Linux-based development and deployment environments.
• Technical Leadership & Delivery
• Provide technical estimates, recommendations, migration plans, and delivery roadmaps.
• Manage multiple customer-facing projects and competing priorities.
• Troubleshoot complex API, database, integration, and performance issues.
• Conduct architecture reviews, code reviews, and technical design discussions.
• Mentor junior engineers and continuously improve migration frameworks and engineering practices.

Key Responsibilities

• Technical Architecture & Solution Design
• Lead technical discovery sessions to understand customer requirements for data migration and integration.
• Assess source and target systems, data structures, volumes, APIs, and dependencies.
• Design scalable migration architectures, data models, mapping strategies, and integration solutions.
• Translate business requirements into technical solutions and implementation plans.
• Data Migration & Transformation
• Lead end-to-end data migration activities, including data assessment, mapping, transformation, import/export, validation, and reconciliation.
• Develop and maintain ETL pipelines and reusable migration frameworks.
• Transform large datasets into formats compatible with target CRM and SaaS platforms.
• Ensure data accuracy, integrity, quality, and consistency throughout the migration lifecycle.
• Troubleshoot complex data migration and transformation issues.
• API & Platform Integration
• Design and implement integrations using REST APIs, web services, and backend services.
• Integrate CRM, SaaS, and customer service platforms with third-party enterprise applications.
• Work with Zendesk APIs, imports, exports, and platform integration capabilities.
• Develop secure and scalable integration solutions across multiple platforms.
• Design and deploy cloud-based migration and integration solutions using AWS.
• Work with relational databases such as PostgreSQL, MySQL, and Amazon Aurora.
• Develop and optimize SQL queries and database structures.
• Implement containerized deployment solutions using Docker or similar technologies.
• Work in Linux-based development and deployment environments.
• Technical Leadership & Delivery
• Provide technical estimates, recommendations, migration plans, and delivery roadmaps.
• Manage multiple customer-facing projects and competing priorities.
• Troubleshoot complex API, database, integration, and performance issues.
• Conduct architecture reviews, code reviews, and technical design discussions.
• Mentor junior engineers and continuously improve migration frameworks and engineering practices.

Mandatory Skills & Qualifications

• Minimum 6+ years of experience in Data Migration, Data Engineering, Backend Engineering, Integration Development, or Solution Architecture.
• Strong hands-on experience in end-to-end data migration and transformation.
• Mandatory experience with CRM, SaaS, Customer Service, or Enterprise Service Management platforms.
• Strong experience in platform integration using REST APIs, Web Services, and third-party integrations.
• Hands-on expertise in Python 3 and SQL.
• Experience with Zendesk APIs and data migration/integration.
• Strong knowledge of relational databases, database design, data modelling, and ORMs.
• Experience with PostgreSQL, MySQL, Amazon Aurora, or similar databases.
• Experience developing ETL pipelines and handling large datasets.
• Hands-on experience designing and deploying solutions on AWS.
• Understanding of data security, privacy, access controls, and secure data handling.
• Experience working with Linux-based environments.
• Excellent customer-facing communication and problem-solving skills.
• Ability to manage multiple projects and coordinate with cross-functional teams.

Preferred Skills

• Experience with Zendesk, Freshdesk, Zoho, Salesforce, ServiceNow, or Microsoft Dynamics 365.
• Strong exposure to Zendesk APIs, imports, exports, integrations, and application frameworks.
• Experience in Professional Services or delivering external customer projects.
• Knowledge of Docker and containerization technologies.
• Experience with automated testing and software development best practices.
• Ability to estimate migration and integration efforts and define technical delivery plans.
• Experience mentoring engineers or leading small technical teams.
• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline.