Priyanka Bharti

- Designed and implemented big data ETL processes to improve data quality and accessibility using Snowflake, dbt, AWS. - Optimized Airflow data pipelines to accelerate data processing. - Refactored legacy SQL into modular dbt models. - Developed and supported key data models to drive company KPIs, creating modeling standards to guide team practices. - Designed and implemented role-based access control(RBAC) and data masking for GDPR compliance, using terraform.

- Migrated on-prem data from Exasol to Snowflake, using dbt, AWS, and Airflow, enhancing data infrastructure. - Built and improved end-to-end data pipelines from several sources e.g., MariaDB, Google BigQuery, MySQL etc. into snowflake data warehouse. - Monitored Airflow Dags, applying strong attention to detail to fix daily ETL issues, ensure seamless data pipeline operations, and maintain clear communication with stakeholders.

- Engineered Python-based ETL workflows to clean, and validate SAP datasets, ensuring high-quality inputs for data analytics. - Built asset reports in TIBCO Spotfire, transforming data into actionable insights for strategic decision-making.

- Built and maintained robust ETL pipelines for the HR data warehouse using Informatica and Oracle. - Optimized SQL queries to improve performance. - Provided validated datasets for Tableau report development, ensuring accuracy and reliability of business insights.

- Developed and maintained ETL workflows for Insurance and Re-Insurance Data Warehouse, using Informatica and SQL, including analysis and debugging of complex SQL queries. - Migrated ETL processes from SSIS to Informatica, enhancing pipeline standardization and maintainability. - Contributed in full development lifecycle — code creation, unit/system testing, and code deployment.