Data Architect

Indium Software India; Bengaluru Urban; On-site; INR 400,000 - 800,000; Full time

Job summary

Indium Software India is seeking a Senior Data Architect to design hybrid data platforms leveraging IBM DB2/Mainframe and Microsoft Azure. You will define ODS strategies, implement DB2-to-Azure ingestion via CDC and replication, and architect Azure-to-DB2 write-backs.

You will build data pipelines with ADF, Databricks, Synapse, and Event Hub while ensuring governance and security. The role requires 10+ years in data architecture, strong SQL skills, and hands-on experience with DataStage or

Qualifications

• 10+ years in Data Architecture/Data Engineering.
• Strong expertise in IBM DB2/Mainframe and PostgreSQL.
• Strong Azure data platform experience: ADF, ADLS Gen2, Databricks, Synapse, Event Hub/Service Bus.
• Hands-on knowledge of CDC and replication technologies such as Q Replication, Kafka, or Debezium.
• Experience with ODS, hybrid architecture, data modeling, and bi-directional data flows.
• Strong SQL and data consistency/reconciliation knowledge.
• Programming experience in Python/Java.
• Experience with DataStage or similar integration tools.
• Snowflake and data governance experience is an added advantage.

Responsibilities

• Design DB2 Azure integration and hybrid data architectures.
• Define cloud-based Operational Data Store (ODS) strategy and data models.
• Implement DB2-to-Azure ingestion using CDC, replication, streaming, and batch.
• Design Azure-to-DB2 write-back/mirroring solutions.
• Design data pipelines using ADF, Databricks, Synapse, Event Hub, and Azure Functions.
• Define real-time and near-real-time data synchronization patterns.
• Establish data governance, lineage, security, reconciliation, and audit frameworks.
• Drive target-state architecture, modernization roadmap, and cost optimization.
• Provide technical leadership, architecture reviews, and guidance to engineering teams.

Skills

Data Architecture

SQL

Python/Java

Azure Data Platform

CDC/Replication

Mainframe DB2

ETL/Data Integration

Data Governance

Tools

IBM DB2/Mainframe

PostgreSQL

Azure Databricks

Azure Synapse

Event Hub

Service Bus

DataStage

Q Replication

Kafka

Debezium

Job description

Data Architect Job Description – Data Architect Job Summary: We are looking for a highly skilled Data Architect with strong expertise in IBM DB2/Mainframe and Microsoft Azure to design hybrid data platforms, cloud-based ODS solutions, and bi-directional data synchronization.

Key Responsibilities

• Design DB2 Azure integration and hybrid data architectures.
• Define cloud-based Operational Data Store (ODS) strategy and data models.
• Implement DB2-to-Azure ingestion using CDC, replication, streaming, and batch .
• Design Azure-to-DB2 write-back/mirroring solutions.
• Design data pipelines using ADF, Databricks, Synapse, Event Hub, and Azure Functions.
• Define real-time and near-real-time data synchronization patterns.
• Establish data governance, lineage, security, reconciliation, and audit frameworks.
• Drive target-state architecture, modernization roadmap, and cost optimization.
• Provide technical leadership, architecture reviews, and guidance to engineering teams.

Required Skills

• 10+ years in Data Architecture/Data Engineering.
• Strong expertise in IBM DB2/Mainframe and PostgreSQL .
• Strong Azure data platform experience: ADF, ADLS Gen2, Databricks, Synapse, Event Hub/Service Bus .
• Hands-on knowledge of CDC and replication technologies such as Q Replication, Kafka, or Debezium.
• Experience with ODS, hybrid architecture, data modeling, and bi-directional data flows .
• Strong SQL and data consistency/reconciliation knowledge.
• Programming experience in Python/Java .
• Experience with DataStage or similar integration tools.
• Snowflake and data governance experience is an added advantage.

Experience Level Senior Level