Data Conversion Specialist

Experion Technologies; Ernakulam; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

Experion Technologies in Kerala seeks a seasoned Data Integration Engineer to lead SQL Server migrations and ETL pipelines. You will design and optimize data movement, ensure data quality, and collaborate with architects, developers and QA to meet migration objectives.

The role requires 6–9 years of hands-on SQL Server, T-SQL, ETL tooling (SSIS, Azure Data Factory), scripting with Python/PowerShell, and cloud or hybrid migration patterns.

Qualifications

• 6–9 years of experience in SQL Server data migration.
• Strong SQL Server (T-SQL) and data migration experience.
• Design and build ETL/ELT pipelines for data conversion.
• Experience with data mapping and large dataset reconciliation.
• Hands-on with SSIS and Azure Data Factory.
• Scripting with PowerShell or Python for validation/automation.
• Knowledge of data quality, cleansing and validation.
• Experience with cloud data platforms (Azure/AWS).
• Familiarity with migration cutover planning and rollback.

Responsibilities

• Collaborate with architects, engineers, analysts and QA to implement conversion scope.
• Design, build and optimize ETL/ELT pipelines for data migration.
• Write and optimize SQL Server procedures, indexes, and queries for high-volume processes.
• Implement data validation, quality checks and reconciliations.
• Maintain data lineage, mapping docs and audit trails.

Skills

SQL Server

ETL/ELT

Data Migration

T-SQL

Python scripting

PowerShell

Data mapping

Cloud platforms

Tools

SSIS

Azure Data Factory

Flyway

Liquibase

Job description

Skills - Mandatory-SQL Server, ETL/Data Migration

Skills - Good to have -SSIS, Azure Data Factory

Total Experience: 6-9 years

• Strong hands-on expertise in SQL Server (T-SQL) and relational database design, with solid experience in data migration and conversion projects.
• Design and build ETL/ELT pipelines to convert data between source and target systems, following the mapping and transformation logic defined by the Architect.
• Good working knowledge of data mapping, source-to-target transformation logic, and reconciliation techniques for large datasets.
• Collaborate with application engineers, business analysts, and QA teams to implement conversion scope and cutover plans.
• Hands-on experience writing and optimizing SQL Server stored procedures, indexes, and queries for high-volume batch processing.
• Proficiency with ETL tooling such as SSIS, Azure Data Factory, or equivalent, along with scripting (PowerShell/Python) for data validation and automation.
• Good understanding of data quality, de-duplication, cleansing, and validation techniques.
• Working knowledge of cloud data platforms (Azure SQL, Azure Synapse, or AWS RDS/Redshift) and hybrid on-prem-to-cloud migration patterns.
• Awareness of data security and compliance considerations during migration, including encryption at rest/in transit and access controls.
• Ability to execute rollback, dry-run, and phased/parallel-run cutover activities under the guidance of the Architect.
• Ability to maintain data lineage, mapping documentation, and audit trails for validation and sign-off purposes.
• Strong debugging and troubleshooting skills, with experience resolving issues 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.