Shivani A.

Azure Data Engineer @LTIMindtree

Calgary, AB, CA

Designed and optimized MySQL database schemas to support platform scalability, efficient data ingestion, and BI/reporting requirements.• Implemented and maintained ETL processes for data ingestion and transformation, leveraging Python scripts and SQL automation.• Created Python automation scripts to streamline reporting, data ingestion, and reconciliation processes.• Troubleshot and resolved data pipeline and system issues, performing root cause analysis and recovery procedures to avoid data loss.• Collaborated cross-functionally in an Agile environment, ensuring delivery of scalable BI solutions aligned with business objectives.• Designed and optimized MySQL database schemas to support platform scalability, efficient data ingestion, and BI/reporting requirements.• Integrated Apache Airflow for orchestration of complex multi-source workflows, ensuring seamless execution and monitoring.• Troubleshot and resolved data pipeline and system issues, performing root cause analysis and recovery procedures to avoid data loss.