Data Conversion Architect

Experion Technologies Pvt. Ltd.; Ernakulam; On-site; INR 1,800,000 - 3,000,000; Full time

Job summary

Experion Technologies Pvt. Ltd. seeks a DB / Data Conversion Architect to lead the design and execution of migration strategies from legacy systems to cloud-native multi-tenant SaaS.

The role requires expertise in SQL Server/Azure SQL, ETL/ELT pipelines, data mapping, and data quality with experience in Azure Data Factory and SSIS. You will drive cutover plans, security considerations, and validation at scale.

Qualifications

• Expert in database architecture and data engineering with SQL Server/Azure SQL (TSQL).
• Experience in large-scale data migration/conversion projects and cloud-native data models.
• Proficient with ETL/ELT design, data mapping, and source-to-target transformation logic.
• Ability to design validation, reconciliation and data lineage for regulatory sign-off.

Responsibilities

• Lead end-to-end conversion lifecycle: source analysis, mapping, transformation, validation, mock runs, and go-live cutover.
• Collaborate with product and engineering teams to define technical requirements and timelines.
• Define rollback, dry-run, and phased cutover strategies to minimize downtime.
• Mentor data engineers and drive best practices for scalable data pipelines.

Skills

SQL Server/Azure SQL

Data migration

ETL/ELT pipelines

Data mapping

Data quality

Data security/compliance

CI/CD for DB deployments

Performance tuning

Tools

SSIS

Azure Data Factory

Flyway

Liquibase

PowerShell

Python

Job description

DB / Data Conversion Architect to lead the design and execution of the data migration and conversion strategy for legacy system to cloud-native multitenant SaaS platform.

Job Description

• Expert in database architecture and data engineering, with deep expertise in SQL Server/Azure SQL (TSQL) and large-scale data migration/conversion projects.
• Design, architect, and implement robust ETL/ELT pipelines for converting legacy into cloud-native data model.
• Strong expertise in data mapping, source-to-target transformation logic, and reconciliation frameworks for multi-terabyte dealer datasets.
• Collaborate with cross-functional teams including application architects, business analysts, QA, and clients to define conversion scope and cutover plans.
• Hands-on experience designing and optimizing SQL Server stored procedures, indexes, and partitioning strategies for high-volume OLTP/OLAP workloads.
• Proficiency with ETL tooling such as SSIS, Azure Data Factory, or equivalent, along with scriptin(PowerShell/Python) for data validation and automation.
• Deep understanding of data quality, de-duplication, cleansing, and validation techniques for legacy-to-cloud migrations.
• Experience with cloud data platforms (Azure SQL, ADF) and hybrid on-prem-to-cloud migration patterns.
• Strong knowledge of data security, PII masking, and compliance considerations during migration, including encryption at rest/in transit and access controls.
• Experience defining rollback, dry-run, and phased/parallel-run cutover strategies to minimize downtime.
• Ability to build and maintain data lineage, mapping documentation, and audit trails for regulatory and client sign-off purposes.
• Strong debugging and performance-tuning skills, with experience resolving bottlenecks in large batch conversion jobs.
• Proficiency in writing unit/integration tests and validation scripts for data reconciliation (row counts, checksums, referential integrity).
• Experience with version-controlled database change management (Flyway, Liquibase, or equivalent) and CI/CD for database deployments.
• Experience presenting conversion readiness, risk, and cutover-plan status to client and internal delivery leadership.

Job Specification

• Understand client requirements and translate them into a comprehensive data migration and conversion architecture.
• Ensure compliance with organizational guidelines by enforcing best practices in data modeling, ETL development, and code/data reviews.
• Lead and participate in the end-to-end conversion lifecycle: source analysis, mapping design transformation build, validation, mock runs, and go-live cutover.
• Collaborate with Product Management and application engineering teams to define technical requirements and align conversion timelines with release plans.
• Work closely with legacy system owners to define extraction logic and resolve data quality and structural gaps.
• Drive rigorous data validation and reconciliation practices, ensuring zero data loss and referential integrity across converted datasets.
• Provide technical leadership by mentoring data engineers, reviewing conversion scripts, and guiding best practices for scalable data pipelines.
• Troubleshoot and optimize conversion jobs for performance, ensuring migration windows meet business SLAs.
• Stay updated on modern data engineering and cloud data platform capabilities, introducing improvements to the conversion framework.
• Implement CI/CD pipelines and automated testing for database changes and conversion scripts.
• Act as a strategic advisor for data architecture, planning and supporting current and future dealer onboarding and migration waves.
• Make timely decisions in ambiguous data-quality situations, escalating risks without compromising conversion accuracy.
• Define and implement the overall data conversion strategy, shaping standards and reusable frameworks across rollouts.
• Utilize monitoring and logging tools to track conversion job health, identify failures, and optimize throughput.
• To adhere to ISMS policies and procedures