Title DWH Python Developer

As an IT Technology & Services Management MNC, you are dedicated to bringing digital innovations to every aspect of the insurance landscape. You are a part of a major insurance group based out of Germany and Europe, represented in around 26 countries worldwide. With over 37,000 people globally, your focus is mainly on Europe and Asia, offering a comprehensive range of insurances, pensions, investments, and services by leveraging cutting-edge technologies such as Cloud, Digital, Robotics Automation, IoT, Voice Recognition, Big Data science, and advanced mobile solutions to meet the future needs of customers worldwide. In the role of DWH+Python, your responsibilities will include: - Design and maintain scalable data warehouse schemas (Star/Snowflake) and Dimensional Modeling to support BI tools and advanced analytics. - Build and optimize end-to-end ETL/ELT pipelines using Python (Pandas, PySpark) to ingest data from diverse sources like APIs, RDBMS, NoSQL, and Cloud Storage. - Write and refine complex SQL queries, stored procedures, and indexing strategies to ensure sub-second response times for large-scale datasets. - Implement and manage workflow orchestration tools (e.g., Apache Airflow, Prefect, or Dagster) for reliable data delivery. - Develop automated data validation frameworks to ensure data integrity, accuracy, and security across the warehouse. - Manage and optimize cloud-based data warehouses like Snowflake, AWS Redshift, Google BigQuery, or Azure Synapse. - Conduct code reviews and provide technical guidance to junior engineers on best practices for clean code and data architecture. You will be located at Hiranandani Garden, Powai. Candidates willing to relocate to Mumbai are encouraged to apply for this role. As an IT Technology & Services Management MNC, you are dedicated to bringing digital innovations to every aspect of the insurance landscape. You are a part of a major insurance group based out of Germany and Europe, represented in around 26 countries worldwide. With over 37,000 people globally, your focus is mainly on Europe and Asia, offering a comprehensive range of insurances, pensions, investments, and services by leveraging cutting-edge technologies such as Cloud, Digital, Robotics Automation, IoT, Voice Recognition, Big Data science, and advanced mobile solutions to meet the future needs of customers worldwide. In the role of DWH+Python, your responsibilities will include: - Design and maintain scalable data warehouse schemas (Star/Snowflake) and Dimensional Modeling to support BI tools and advanced analytics. - Build and optimize end-to-end ETL/ELT pipelines using Python (Pandas, PySpark) to ingest data from diverse sources like APIs, RDBMS, NoSQL, and Cloud Storage. - Write and refine complex SQL queries, stored procedures, and indexing strategies to ensure sub-second response times for large-scale datasets. - Implement and manage workflow orchestration tools (e.g., Apache Airflow, Prefect, or Dagster) for reliable data delivery. - Develop automated data validation frameworks to ensure data integrity, accuracy, and security across the warehouse. - Manage and optimize cloud-based data warehouses like Snowflake, AWS Redshift, Google BigQuery, or Azure Synapse. - Conduct code reviews and provide technical guidance to junior engineers on best practices for clean code and data architecture. You will be located at Hiranandani Garden, Powai. Candidates willing to relocate to Mumbai are encouraged to apply for this role.