Data Engineer

Job Title- Data Engineer

Position type- Full Time

Work Location- Bangalore, Noida, Gurgaon

Working style- Hybrid

Shift Time - 10AM - 7PM / 12 PM. to 9 PM

People Manager role: No

Required education and certifications critical for the role- Btech or Master's degree in computer science

Required years of experience -

3-5 years of relevant experience

Aon is in the business of better decisions

At Aon, we shape decisions for the better to protect and enrich the lives of people around the world. As an organization, we are united through trust as one inclusive, diverse team, and we are passionate about helping our colleagues and clients succeed.

Responsibilities:

• Collaborate with teams of experienced actuaries, developers and business experts to deliver projects
• Design and propose end-to-end data pipelines ((ingestion to storage to consumption) for data projects as well as databases to support web-based applications
• Implementation of data warehouses and data marts to serve data consumers
• Execute implementation of the designs and bring it from design stages to implementation followed by operationalization to maintenance
• Database design and modelling. To be able to organize data at both macro and micro level and provide logical data models for the consumers
• Database performance tuning and data lifecycle management
• Assist in support and enhancements of existing data pipelines and databases

Requirements:

• 3+ years of total experience working with data integration teams.
• 1+ years of in-depth experience developing data pipelines within an Apache Spark environment (preferably Databricks).
• 1+ years of active hands-on work with Databricks, demonstrating in-depth experience.
• Good experience in building data pipelines that ingests various types of data sources into a database or data lake and populating a structured warehouse or data mart that fuels the data consumer.
• Fluent in both complex SQL query, Spark performance tuning
• Good knowledge of database technologies, data warehousing.
• Have experience in building data warehouses/data marts
• Understand the importance of performance and able to implement best practices in ensuring performance and maintainability for data-centric projects
• This person is required to be dynamic and be a quick eager learner as knowledge about new technologies will need to be acquired on the spot

Nice to haves:

• Experience integrating AI into data engineering.
• Certifications in Databricks, cloud computing or database management.
• Experience developing data solutions using native IaaS and PaaS solutions on AWS (RDS, S3).
• Experience in any object-oriented programming language.
• Experience with BI and analytics tools like Power BI or Tableau.