Job Summary

We are looking for an Enterprise Data Migration Architect with deep, hands-on expertise in large-scale data migrations and up-to-date cloud data platforms. This is a senior technical leadership role within our Insurance P&C; data transformation program, responsible for architecting and owning the end-to-end migration of legacy data systems to a modern cloud-native ecosystem on AWS.

You will work at the intersection of architecture, delivery, and governance - defining migration strategies, leading technical execution, and driving outcomes that directly impact business operations. This is a production delivery role, not advisory or POC-only.

What You Will Do

- Own end-to-end design and execution of enterprise data migrations from legacy platforms (Oracle, SQL Server, DB2, AS400/Mainframe, PostgreSQL, MySQL) to modern cloud targets on AWS
- Define and govern migration strategy including data mapping, transformation logic, reconciliation frameworks, cutover planning, rollback procedures, and performance tuning
- Lead large-scale incremental and CDC-based migration pipelines ensuring zero-loss data fidelity
- Drive validation, quality assurance, and sign-off processes across source and target systems
- Design and implement scalable data architectures on AWS - leveraging Databricks or Snowflake as the primary analytical platform
- Build and optimize ETL/ELT pipelines using AWS-native services: S3, Glue, DMS, Lambda, Redshift, EMR
- Architect Lakehouse, Data Vault, Star Schema, and Dimensional models aligned to Insurance P&C; business domains
- Optimize Spark workloads for cost, performance, and reliability in production environments
- Implement data lineage, observability, and data quality frameworks throughout the migration lifecycle
- Define and enforce data security, access controls,



and compliance standards aligned with Insurance regulatory requirements
- Drive cloud cost optimization strategies across data services
- Partner with business, product, and engineering stakeholders to define scope, priorities, and delivery milestones
- Communicate architecture decisions, risks, and migration status to senior leadership and client stakeholders
- Lead and mentor cross-functional engineering teams through complex delivery programs

Non-Negotiable Requirements

- Experience 10+ years in enterprise data architecture and large-scale data migration programs
- Vertical Insurance P&C; domain experience - mandatory
- Migration Depth Proven E2E migrations: mapping, reconciliation, validation, cutover, rollback, and performance tuning
- Modern Platform Strong hands-on expertise in Databricks or Snowflake
- Cloud Strong exposure to Amazon Web Services and its database/analytics services
- Production Delivery Real production migration experience - not only POC or support roles

Technical Skills

- Languages & Frameworks: Strong SQL, Python or Scala, PySpark; Spark optimization for production-scale workloads
- ETL/ELT & Pipelines: AWS Glue, ADF, Informatica, dbt, or equivalent; CDC / incremental load patterns, reconciliation and validation frameworks
- AWS Services: S3, Glue, DMS, Lambda, Redshift, EMR - hands-on experience preferred
- Legacy Databases: Oracle, SQL Server, DB2, PostgreSQL,



MySQL - working knowledge required; AS400 / Mainframe familiarity preferred
- Data Architecture Patterns: Star Schema, Dimensional Modeling, Data Vault; Lakehouse / Medallion Architecture; Cutover planning, rollback strategy, data validation at scale
- Governance & Security: Data lineage, metadata management, observability tooling; Cloud cost optimization, security controls, and access governance

Nice to Have

- Experience with Purview, Collibra, or equivalent data catalog / governance tooling
- Familiarity with Insurance regulatory data requirements (IRDAI or equivalent)
- CI/CD and DataOps practices - Azure DevOps, Jenkins, or similar
- Experience managing large transformation programs across multiple business units

AI Fluency Expected

At Myridius, we expect AI fluency across all roles. This means the ability to effectively and responsibly use AI-enabled tools to improve productivity, quality, analysis, decision-making, documentation, testing, delivery, and problem-solving within ones function. All candidates should be comfortable working with AI as a day-to-day enabler while applying sound judgment, critical thinking, and accountability for outcomes.

Good to Have

- AS400/Mainframe migration experience.
- Informatica, dbt, ADF experience.
- Purview, Collibra, or other Data Governance tools.
- Insurance regulatory compliance knowledge (IRDAI or equivalent).
- CI/CD and DataOps experience (Azure DevOps, Jenkins).
- Experience managing large transformation programs across multiple business units.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.

📌 Enterprise Data Migration Architect (Chennai)
🏢 RCG Global Services
📍 Chennai