Data Engineer Sr (Databricks)

NTT DATA, Inc.

Bengaluru

On-site

INR 1,800,000 - 2,500,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

NTT DATA, Inc. in Bengaluru is looking for an experienced engineer to develop and optimize Databricks workflows for data transformation and integration of legacy systems. The role requires strong expertise in Databricks, DB2, and Guidewire, with a focus on implementing data governance practices.

The ideal candidate will have over 8 years of experience and a deep understanding of ETL processes and Delta Lake architecture. Join us to drive impactful data solutions in cloud environments.

Qualifications

  • 8+ years of experience in Databricks, handling complex legacy data.
  • Experience with legacy databases like DB2 and Guidewire.
  • Strong understanding of ETL/ELT processes and data modeling.

Responsibilities

  • Develop Databricks notebooks and workflows to enhance data pipelines.
  • Optimize Databricks clusters and jobs for performance.
  • Implement strict data governance and data quality frameworks.

Skills

Databricks
Databases (DB2, Guidewire)
AWS/S3
Azure ADLS
ETL/ELT processes
SQL (including Spark SQL)
Change Data Capture (CDC)
Data Modeling
Data Governance
Git/Azure DevOps

Tools

Apache Spark
Delta Lake
Databricks Auto Loader

Job description

Roles & Responsibilities
  • Develop Databricks notebooks, jobs, and workflows to replicate and enhance DB2/Guidewire-based pipelines and transformations.
  • Implement Delta Lake tables and patterns (bronze/silver/gold, ACID, time travel, schema evolution) for migrated data.
  • Integrate Databricks with AWS/S3 or Azure ADLS, ADF/Synapse, Key Vault, and Snowflake as required.
  • Optimize Databricks clusters, jobs, and queries for performance and cost.
  • Implement incremental loads, CDC patterns, and batch schedules for large datasets.
  • Collaborate with Snowflake and dbt teams to ensure consistent data models and data contracts.
  • Participate in data validation and reconciliation between DB2 400 / Guiderwire and Databricks outputs.
  • Follow coding standards, version control, and CI/CD practices using Git/Azure DevOps.
  • Provide defect fixes and support during SIT/UAT and post go-live stabilization.
Experience

Legacy Demystification & Ingestion (DB2/400 & Guidewire)

8+ years of experience in Databricks with understanding complex legacy data models and getting that data into the cloud:

  • Extracting DB2/AS400: Experience with Change Data Capture (CDC) or scheduled batch extractions from DB2 into cloud storage. Involves working through JDBC connections, mapping table dependencies, and re-platforming legacy SQL to distributed computing standards.
  • Handling Guidewire Data: Integrating with Guidewire Cloud Data Access (CDA) or InsuranceSuite to replicate complex P&C (Property & Casualty) insurance schemas. Senior engineers parse these highly normalized operational databases and transform them into analytical-friendly schemas in the cloud.
Architecture & Pipeline Development

The core of the experience involves transitioning these legacy, row-based stores into a scalable Medallion Architecture (Bronze, Silver, Gold layers):

  • Delta Lake Optimization: Using Databricks and Apache Spark to build ETL/ELT data pipelines with ACID transactions. Senior engineers handle schema evolution, upserts, and slowly changing dimensions (SCD Type 2).
  • Business Logic Refactoring: Translating rigid legacy procedural code (e.g., RPG/COBOL background logic, stored procedures) into scalable distributed patterns (PySpark, Spark SQL, and Scala).
Data Governance & Observability
  • Unity Catalog: Implementing strict data governance, lineage tracing, and table-level security.
  • Data Quality: Automating data validation frameworks to ensure a seamless transition from legacy to modern systems without data loss or corruption.
Integration with the Databricks Platform Ecosystem
  • Serverless Compute: Managing Databricks serverless resources, ensuring optimal cluster sizing, and reducing compute costs.
  • Streaming and Batch Workflows: Building event-driven pipelines using features like Databricks Auto Loader to ingest flat files and streaming records directly into Delta tables.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer Sr (Databricks)
Data Engineer Sr (Databricks)

NTT DATA, Inc. • Bengaluru Urban

On-site
INR 1,200,000 - 1,800,000
Technical Lead
Technical Lead

Carelon Global Solutions • Gurugram District, Bengaluru

Hybrid
INR 3,000,000 - 5,500,000
Senior Data Engineer
Senior Data Engineer

Bridgestone Americas, Inc. • Bengaluru Urban

On-site
INR 1,500,000 - 2,300,000
Solution Architect - Data Platform Modernization
Solution Architect - Data Platform Modernization

NTT DATA, Inc. • Bengaluru Urban

On-site
INR 3,500,000 - 9,000,000
Senior Databricks Platform Engineer
Senior Databricks Platform Engineer

Wipro Ltd. • Bengaluru, Mumbai, Chennai

On-site
INR 4,000,000 - 7,000,000
Data Engineer - CB2
Data Engineer - CB2

Bridgestone Americas, Inc. • Bengaluru

On-site
INR 1,400,000 - 2,800,000
Aws Data Engineer
Aws Data Engineer

Wipro Ltd. • Hyderabad, Pune District, Bengaluru

Hybrid
INR 4,500,000 - 7,500,000
Senior DevOps Engineer
Senior DevOps Engineer

NXP Semiconductors • Bengaluru Urban

On-site
INR 1,500,000 - 2,000,000
Databricks Engineer
Databricks Engineer

Infosys • Bengaluru

On-site
INR 2,800,000 - 4,400,000
Senior Databrics Architect
Senior Databrics Architect

dnA Consulting • Mysuru

On-site
INR 4,000,000 - 7,000,000