Job Title- Data Engineer Position type- Full Time Work Location- Bangalore/Nodia/Gurgoan Working style- Hybrid Cab Facility- Yes Shift Time - 8am-5pm (Fliexible with the Line Manager) People Manager role: No Required education and certifications critical for the role- Any Graduate or Post-Graduate (full time) Required years of experience – 6-9 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 committed as one firm to our purpose, united through trust as one inclusive, diverse team and we are passionate about helping our colleagues and clients succeed. INFORMATION ABOUT THE BUSINESS As part of scaling technology talent within Aon IT Scale team is application development practice which cuts across multiple different solution lines. GENERAL DESCRIPTION OF ROLE: Professionals in this group design and implement high-performance, scalable and optimized data solutions for large enterprise-wide data mining and processing. They are responsible for design and development of data flows and Big Data Platform deployment and implementation. Incumbents usually require expert knowledge in Apache, Hadoop, NoSQL databases, Spark, Hive etc. JOB 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 + Design and implement 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 SKILLS/COMPETENCIES REQUIRED + 5+ Years of Total Experience working with Data integration teams. + 4+ years of in-depth experience developing data pipelines within a Hadoop-based or Apache Spark environment (solution stack is preferably Databricks but similar stacks considered). + 2+ years of in-depth experience in working with a relational database system (eg. MSSQL, PostgreSQL) + Highly knowledgeable in ETL/ELT processes, both design and implementation via SSIS or some other ELT/ETL tool. + 2+ years of in-depth experience in working with a data warehouse and knowledge of data warehouse modelling techniques. + Good experience in building data pipelines that ingest 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 performance tuning and database performance tuning + Have experience in building and designing 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 a quick eager learner as knowledge about new technologies will need to be acquired on the spot. Nice to haves: + Some experience developing data solutions using native IaaS and PaaS solutions on AWS (Redshift, RDS, S3) will be an advantage. + Experience in any object oriented or functional programming language is a plus. + Experience in any BI tools Tableau or Power BI is a plus. HOW WE SUPPORT OUR COLLEAGUES In addition to our comprehensive benefits package, we are proud to be an equal opportunity workforce. At Aon, we believe a diverse workforce is an innovative workforce. Our agile, inclusive environment allows colleagues to manage their wellbeing and work/life balance while empowering you to be your authentic self. Furthermore, all colleagues enjoy two “Global Wellbeing Days” each year, encouraging them to take time to focus on themselves. We offer a variety of workstyle options through our Smart Working model, but we also recognize that flexibility goes beyond just the place of work... and we are all for it! Our continuous learning culture inspires and equips colleagues to learn, share and grow, helping them achieve their fullest potential. As a result, Aon colleagues are more connected, more relevant and more valued. #LI-SN1 2542499 Job Title- Data Engineer Position type- Full Time Work Location- Bangalore/Nodia/Gurgoan Working style- Hybrid Cab Facility- Yes Shift Time - 8am-5pm (Fliexible with the Line Manager) People Manager role: No Required education and certifications critical for the role- Any Graduate or Post-Graduate (full time) Required years of experience – 6-9 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 committed as one firm to our purpose, united through trust as one inclusive, diverse team and we are passionate about helping our colleagues and clients succeed. INFORMATION ABOUT THE BUSINESS As part of scaling technology talent within Aon IT Scale team is application development practice which cuts across multiple different solution lines. GENERAL DESCRIPTION OF ROLE: Professionals in this group design and implement high-performance, scalable and optimized data solutions for large enterprise-wide data mining and processing. They are responsible for design and development of data flows and Big Data Platform deployment and implementation. Incumbents usually require expert knowledge in Apache, Hadoop, NoSQL databases, Spark, Hive etc. JOB 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 + Design and implement 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 SKILLS/COMPETENCIES REQUIRED + 5+ Years of Total Experience working with Data integration teams. + 4+ years of in-depth experience developing data pipelines within a Hadoop-based or Apache Spark environment (solution stack is preferably Databricks but similar stacks considered). + 2+ years of in-depth experience in working with a relational database system (eg. MSSQL, PostgreSQL) + Highly knowledgeable in ETL/ELT processes, both design and implementation via SSIS or some other ELT/ETL tool. + 2+ years of in-depth experience in working with a data warehouse and knowledge of data warehouse modelling techniques. + Good experience in building data pipelines that ingest 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 performance tuning and database performance tuning + Have experience in building and designing 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 a quick eager learner as knowledge about new technologies will need to be acquired on the spot. Nice to haves: + Some experience developing data solutions using native IaaS and PaaS solutions on AWS (Redshift, RDS, S3) will be an advantage. + Experience in any object oriented or functional programming language is a plus. + Experience in any BI tools Tableau or Power BI is a plus. HOW WE SUPPORT OUR COLLEAGUES In addition to our comprehensive benefits package, we are proud to be an equal opportunity workforce. At Aon, we believe a diverse workforce is an innovative workforce. Our agile, inclusive environment allows colleagues to manage their wellbeing and work/life balance while empowering you to be your authentic self. Furthermore, all colleagues enjoy two “Global Wellbeing Days” each year, encouraging them to take time to focus on themselves. We offer a variety of workstyle options through our Smart Working model, but we also recognize that flexibility goes beyond just the place of work... and we are all for it! Our continuous learning culture inspires and equips colleagues to learn, share and grow, helping them achieve their fullest potential. As a result, Aon colleagues are more connected, more relevant and more valued. #LI-SN1