Senior tester (Bengaluru)

Senior tester (Bengaluru)

17 Nov
|
Sonata Software
|
Bengaluru

17 Nov

Sonata Software

Bengaluru

Job Title- Data Migration Engineer

Location- Bangalore / Hyderabad /Chennai

Exp: 6-12Years

Notice Period: Immediate

Key Responsibilities

Required Skills: Data Migration, MS SQL to PostgreSQL Data Mig ration, Data parity, Kafka.

Nice to have Skill: AI DLC

Job Title: Data Migration Engineer –

- Legacy System ( Que ) to Modern Platform (Prism) Migration

Role Overview

We are seeking a highly skilled Data Migration Engineer with 5 to 10 years of experience to lead the end-to-end data transition from our legacy application ( Que ) to our up-to-date platform (Prism). In this critical modernization role, you will architect, execute, and validate the migration of complex legacy datasets while ensuring zero data loss. You will leverage AI-assisted Development Life Cycle (AI DLC) tools to accelerate the writing of robust data migration scripts.

The ideal candidate possesses deep expertise in data management, backup and recovery strategies, and rigorous pre- and post-migration reconciliation to identify and resolve any missing data elements.

Key Responsibilities

- End-to-End Migration Strategy: Design and execute the complete data migration lifecycle from the legacy "
- Que " application to the new "Prism" architecture.
- AI-Assisted Script Development: Utilize AI DLC tools (e.g., GitHub Copilot, ChatGPT Enterprise, or proprietary GenAI coding assistants) to rapidly write, optimize , and debug complex ETL and data migration scripts.
- Backup &
- Disaster Recovery: Establish and manage stringent backup protocols before any migration event. Ensure robust rollback mechanisms and recovery plans are fully tested and functional.
- Data Reconciliation &
- Validation: Perform comprehensive pre-migration data profiling and post-migration validation.



Design automated reconciliation reports to instantly identify orphaned records, truncated fields, or missing elements between Que and Prism.
- Data Mapping &
- Transformation: Collaborate with application architects and business stakeholders to map legacy data structures in Que to the modernized schema in Prism.
- Performance Tuning: Optimize migration queries and scripts to handle large volumes of data within tight cutover windows, minimizing system downtime.
- Documentation &
- Compliance: Maintain detailed documentation of data lineage, transformation rules, migration logs, and AI-generated script audits for compliance and historical tracking.

Required Skills &

- Competencies

Core Data &

- Migration Expertise

- Data Migration &
- ETL: 5– 10 years of proven experience leading large-scale data migrations, specifically in legacy modernization projects.
- Data Reconciliation: Deep expertise in writing validation scripts to compare source and target databases, ensuring 100% data fidelity pre- and post-migration.
- Database Management: Advanced proficiency in SQL and relational database architecture.

Experience working with major enterprise databases (e.g., SQL Server, PostgreSQL).

- Backup &

- Recovery: Strong practical knowledge of database backup mechanisms, state-point restores,



and creating fail-safe rollback procedures.

AI &
- Automation Skills

- AI DLC Integration: Demonstrated experience using AI coding assistants to write, document, and test data migration scripts (Python, SQL, Bash).
- Scripting &
- Programming: Proficiency in Python, shell scripting, or similar languages for automating extraction, transformation, and load processes.

Analytical &

- Problem-Solving

- Data Profiling: Ability to deeply analyze legacy data in "
- Que " to identify anomalies, bad formatting, or historical corruption prior to moving it to "Prism".
- Troubleshooting: Rapid identification and resolution of bottlenecks, data drops, or schema mismatches during dry runs and live cutovers.
- Communication: Strong ability to translate complex data mappings and migration risks to non-technical project managers and business leaders.

A BOUT SONATA SOFTWARE Sonata Software is an AI-first modernization engineering company that helps enterprises transform legacy systems into intelligent, scalable business platforms. Powered by its Platformation ™ framework and Harmoni.AI platform, Sonata delivers AI-led modernization across cloud, data, AI, Dynamics, test automation, and managed services.

Headquartered in Bengaluru, India, Sonata has more than $1.2 billion in revenue and 6,400+ AI engineers supporting global delivery across regions including the US, UK, India, Malaysia, Mexico, Australia, DACH, and the Nordics.

With deep partnerships across Microsoft, AWS, Salesforce, and Snowflake, Sonata helps Fortune 500 enterprises accelerate innovation, improve efficiency, and drive sustainable growth.

For more information, please visit www.sonata-software.com

📌 Senior tester (Bengaluru)
🏢 Sonata Software
📍 Bengaluru

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: senior tester (bengaluru) / bengaluru

Subscribe to this job alert:

Get the latest job offers by email for: senior tester (bengaluru) / bengaluru