Senior Data Migration Consultant

Innovyatech; India; On-site; INR 1,000,000 - 1,500,000; Full time

Job summary

A leading data consulting firm in India is seeking an experienced Consultant to integrate and map customer data into its advanced platform. You will lead data migrations using your strong organizational, technical, and analytical skills. Ideal candidates should have over five years of relevant experience, particularly in ETL methodologies and strong SQL scripting. The role involves collaborating closely with clients and stakeholders to ensure data is converted efficiently and meets business objectives.

Qualifications

• 5+ years of experience assessing data and analytic requirements.
• Working knowledge of ETL methodologies and tools.
• Strong SQL scripting experience.

Responsibilities

• Ensure client data is converted accurately and efficiently.
• Perform ETL activities for timely data conversions.
• Collaborate with clients throughout the data integration process.

Skills

Data migration

ETL methodologies

SQL scripting

Problem-solving

Communication

Tools

Informatica

DataStage

Dell Boomi

Oracle SQL

Excel

Job description

About the Role

The Consultant will integrate and map customer data from client source system(s) to our industry‑leading platform.

Responsibilities

• Using strong technical data migration, scripting, and organizational skills to ensure the client data is converted efficiently and accurately to the organization’s platform.
• Performing extract, transform, load (ETL) activities to ensure accurate and timely data conversions.
• Providing in‑depth research and analysis of complex scenarios to develop innovative solutions to meet customer needs whilst remaining within project governance.
• Mapping and maintaining business requirements to the solution design using tools such as requirements traceability matrices (RTM).
• Presenting findings, requirements, and problem statements for ratification by stakeholders and working groups.
• Identifying and documenting data gaps to allow change impact and downstream impact analysis to be conducted.

Shift Timings

5 PM to 2 AM IST

Qualifications

• 5+ years of experience assessing data and analytic requirements to establish mapping rules from source to target systems to meet business objectives.
• Experience with real‑time, batch, and ETL for complex data conversions.
• Working knowledge of extract, transform, load (ETL) methodologies and tools such as Informatica, DataStage, Dell Boomi, etc.
• Utilize data mapping tools to prepare data for data loads based on target system specifications.
• Working experience using various data applications/systems such as Oracle SQL, Excel, .csv files, etc.
• Strong SQL scripting experience.
• Communicate with clients and/or Project Manager to scope, develop, test, and implement conversion/integration.
• Effectively communicate with Project Managers and customers to keep project on target.
• Continually drive improvements in the data migration process.
• Collaborate via phone and email with clients and/or Project Manager throughout the conversion/integration process.
• Demonstrated collaboration and problem‑solving skills.
• Working knowledge of software development lifecycle (SDLC) methodologies including, but not limited to: Agile, Waterfall, and others.
• Clear understanding of cloud and application integrations.
• Ability to work independently, prioritize tasks, and manage multiple tasks simultaneously.
• Ensure client’s data is converted/integrated accurately and within deadlines established by Project Manager.
• Experience in customer SIT, UAT, migration and go live support.

Company Notice

Committed to give wings to your innovative vision.

US Office

India Office

Innovya Technologies, 4th Floor, City Vista, Tower A, Fountain Road, Kharadi, Pune - 411014