Data Engineer / 6-10 years / Bengaluru

2coms; Bengaluru; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Aon, Bengaluru-based, seeks a highly skilled Data Engineer to join a motivated team working on a flagship application. This hybrid-first role offers exposure to risk, retirement, and health solutions within a global services context.

You will build integrations and data pipelines to connect internal and third-party sources to the MDM platform, optimize data structures, and implement APIs to expose golden records, ensuring high-quality, scalable outcomes.

Qualifications

• Experience as a Data Engineer.
• Strong data storage and retrieval knowledge.
• Hands-on with Oracle, SQL Server and Databricks in production.
• Proficiency in Python, PySpark and SQL.
• Knowledge of Master Data Management and Reltio.
• Familiar with Workato or similar visual pipelines.

Responsibilities

• Build integrations and pipelines linking data catalog to the MDM platform.
• Review quality standards, supervise integration work, and address issues proactively.
• Optimize indexes, partitions, and storage formats for performance.
• Implement API endpoints or message-based integrations for golden records.
• Implement data reconciliation checks between sources and MDM.
• Deliver timely, innovative, accurate, best-in-class solutions.

Skills

Data Engineering

Data Modeling

SQL Databases

Python

PySpark

ETL

MDM Tools

Reltio

API/Integration

Performance Tuning

Tools

Databricks

Oracle

SQL Server

Workato

Reltio

Job description

SUMMARY

Our Client is a global professional services firm with roughly 60,000 colleagues across 120+ countries, focusing on risk, retirement, and health solutions. The company fosters an "United" culture, emphasizing collaborative, data-driven work and a hybrid-first model.

GENERAL DESCRIPTION OF ROLE:

We are looking for a highly skilled data engineer to join a highly motivated and hardworking team, working on one of Aon flagship applications. The ideal candidate can support the team and requirement through its life cycle, from analysis, architecture, and design, to development, testing and implementation. This is a position where you will have a visible impact on the product and its success.

Requirements

JOB RESPONSIBILITIES

• The talent in this role will build integrations and pipelines that enable efficient joining across our internal and 3rd party data catalogue to the MDM platform


• They are responsible for ensuring quality standards, reviewing, and organising technical team’s work, supervising performance of integrations and responding to system issues proactively.
  


• Optimize physical data structures (indexes, partitions, storage formats) for performance and scalability.
  


• Implement API endpoints or message-based integrations so consuming systems can access golden records


• Implement data reconciliation checks between sources & MDM.
  


• Ensure delivery of timely, innovative, accurate, and best in class solutions.
  

Benefits

SKILLS/COMPETENCIES REQUIRED

• Experience in previous roles as a Data Engineer
  


• High proficiency of knowledge in data storage and retrieval
  


• Experience with a relational database such as Oracle, SQL Server and Databricks including data design in a production environment
  


• Proficiency in data processing languages such as Python, Pyspark, SQL
  


• ETL experience including data cleansing and preparation for modelling
  


• Knowledge of Master Data Management, and hands on experience working on MDM tools like Reltio.


• Experience using tools such as Workato or other visual pipeline development environment and advantage.