Senior Database & Azure Migration Specialist

Papigen; India; On-site; INR 3,500,000 - 5,500,000; Full time

Job summary

Papigen is seeking a Senior Data Engineer with 15+ years of experience to own complex data migrations and Azure‑based data pipelines. You will reverse‑engineer legacy PL/SQL, design end‑to‑end data movements, and ensure data integrity and traceability across heterogeneous environments.

You will collaborate with data modelers and architects, create design documents, and guide testing and production rollout while upholding governance and cloud best practices.

Qualifications

• 15+ years of enterprise data migration, modernization and integration experience.
• 8–10 years in Data Modelling, Metadata Management, Data Governance and Data Quality.
• Deep Oracle PL/SQL knowledge and ability to reverse‑engineer legacy code.
• Extensive hands‑on experience with Azure data stack: Data Factory, Synapse, Databricks, ADLS, Delta Lake.

Responsibilities

• Reverse‑engineer existing PL/SQL code and legacy database objects.
• Design and implement Azure‑based data pipelines, ensuring functional equivalence and data integrity.
• Lead data migration and integration workstreams with minimal supervision.
• Define source‑to‑target mappings, transformations and validation.
• Collaborate with modelers/architects to align data models with migration needs.
• Produce migration design documents, LLDs, mappings, tests and validation reports.
• Support testing and UAT with data validation across systems.
• Troubleshoot migration data issues and ensure governance and security guidelines.

Skills

Azure Synapse

Azure Data Factory

Data Quality

Python

PL/SQL

Azure Databricks

Azure Functions

APIM

SQL

Data Modelling

Delta Lake

Oracle PL/SQL

Data Warehouse

Metadata Management

Azure Automation

Logic Apps

SSIS

ELT

Azure PowerShell

Azure DevOps

ETL

Informatica

Data Architecture

Tools

Virtual Machines

Informatica

SSIS

Azure Data Factory

Azure Databricks

Azure Synapse

Delta Lake

Job description

Role Overview

We are looking for a Senior Data Engineer (15+ years) with deep hands‑on experience in database development, Oracle PL/SQL, and large‑scale Azure cloud migration to independently own and deliver complex migration and integration workstreams with minimal supervision. The role covers reverse‑engineering legacy database logic, designing and implementing Azure‑based data pipelines, and ensuring functional equivalence, data integrity, and traceability throughout the migration lifecycle.

Role Overview

We are looking for a Senior Data Engineer (15+ years) with deep hands‑on experience in database development, Oracle PL/SQL, and large‑scale Azure cloud migration to independently own and deliver complex migration and integration workstreams with minimal supervision. The role covers reverse‑engineering legacy database logic, designing and implementing Azure‑based data pipelines, and ensuring functional equivalence, data integrity, and traceability throughout the migration lifecycle.

Scope of Work

• Independently analyze, interpret, and reverse‑engineer existing PL/SQL code, database objects, and data processing logic from legacy systems.
• Adapt, refactor, or rewrite extracted logic to support Azure‑based data migration and integration workflows, ensuring functional equivalence, data integrity, and traceability.
• Design and implement data movement, transformation, and orchestration pipelines using Azure Data Factory and related Azure services.
• Perform detailed source‑to‑target mapping, data transformation analysis, reconciliation, and validation as part of large‑scale data migration initiatives.
• Collaborate with data modelers and architects to align conceptual, logical, and physical data models with migration and integration requirements.
• Produce and maintain migration design documents, Low‑Level Design (LLD), mapping specifications, unit test plans, and validation reports.
• Provide technical guidance to testing, integration, and downstream teams on migration logic, data validation strategies, and testing expectations.
• Support integration testing and UAT by validating data consistency and correctness across upstream and downstream systems.
• Perform in‑depth troubleshooting, root cause analysis, and resolution of migration‑related data issues across environments.
• Ensure adherence to data governance standards, security controls, performance guidelines, and cloud best practices.
• Proactively manage work items, timelines, dependencies, and risks; communicate issues and trade‑offs to technical and business stakeholders.
• Participate in SCRUM ceremonies; work closely with onsite and offshore teams while maintaining ownership of assigned deliverables.
• Assist with documentation and artifacts for security clearance, release readiness, and production deployment.

Skills & Experience Required

• 15+ years of overall professional experience with strong focus on enterprise data migration, system modernization, and integration initiatives.
• 8–10 years of experience in Data Modelling, Data/Information Architecture, Metadata Management, Master Data Management, Data Governance, and Data Quality.
• Deep understanding of Oracle PL/SQL logic and database behavior; demonstrated ability to analyze and reverse‑engineer complex legacy implementations.
• Expertise in Azure platforms — Azure Databricks, ADLS, Delta Lake, and their various components.
• In‑depth hands‑on experience with the Microsoft Azure data stack: Azure Data Factory, Azure Synapse, Azure SQL Database, Azure Functions, Logic Apps, Event Hubs, Function Apps, APIM, and Web Apps.
• Strong experience designing ETL/ELT pipelines and data flows using Azure Data Factory (primary); SSIS and Informatica as additional skills.
• In‑depth knowledge of designing ETL pipelines for batch and real‑time processing in Azure Data Factory.
• Thorough understanding of data lakes, Delta Lakes, and raw/enriched/curated layer concepts and ETL within the Azure framework; experience executing end‑to‑end projects focusing on Azure Synapse and Delta Lake.
• Proficiency in Python, SQL, Spark notebooks, and Scala; strong development and design skills in MS SQL Server and Oracle.
• Experience with Big Data architecture concepts, data sourcing, ingestion, curation, and storage mechanisms; real‑time and near‑real‑time data warehousing concepts.
• Experience leveraging Azure Automation, Azure PowerShell scripting, AzCopy, Azure DevOps, and ARM Templates.
• Experience handling large‑volume data migrations, reconciliation, validation, and cross‑system data consistency checks.
• Strong understanding of data modelling concepts — relational structures, surrogate and composite keys, cross‑reference tables, and migration‑friendly data designs.
• Experience with Salesforce migration is a plus.
• Demonstrated ability to work as a senior individual contributor, independently owning complex migration workstreams.
• Strong analytical and root cause analysis skills; excellent written and verbal communication with technical and non‑technical stakeholders.
• Highly organized with strong ownership of deliverables, documentation, and timelines.

Skills: azure synapse,azure data factory,data quality,python,pl/sql,azure databricks,azcopy,azure functions,apim,sql,data modelling,delta lake,oracle pl/sql,data warehouse,metadata management,azure automation,logic apps,ssis,elt,azure powershell,azure devops,etl,informatica,data architecture,function apps,data governance,ms sql server,adls,azure sql