Madhura Sail

System Engineer

Infosys Ltd

Pune, Maharashtra

06.2021 - Current

ETL: Designed and Implement automated ETL processes to streamline data workflows, ensuring efficient and reliable data ingestion, transformation, and loading.
Business Insights: Delivered well-structured and optimized datasets to business analysts, ensuring data integrity and enabling accurate and actionable insights.
Solving Data Issues: Enhanced business reporting timelines by 70-80% through effective root cause analysis of data issues, significantly reducing turnaround time for taking further actions.
Data Lineage: Maintained comprehensive data lineage to track and document data flow from source to destination, ensuring transparency and supporting data governance.
Performance enhancements: Enhanced performance of data pipelines by migrating them from Pentaho Data Integration to Spark framework and achieve 5x faster processing.
Data Quality checks: Ensured data quality through comprehensive checks and supported business analyst with required data checks using SQL, especially during the time of BAU.
Data flow orchestration: Implemented Control-M data orchestration to streamline data flow, enhancing efficiency and ensuring seamless data processing, reducing 99% manual effort for data refreshes throughout the data lake pipeline.
Data View Planning: Increased data analysis effectiveness by harnessing IBM TM1 to create and control data views and build calculations, ultimately optimizing structuring of data and empowering informed business decisions.
Impact and Requirement Analysis: Performed Impact Analysis and led the team to analyse business requirements for any new changes to be promoted in the existing system, thereby reducing the turnaround time by 50-60%.
Agile Collaboration: Worked in cross-functional teams in an agile framework to collect requirements, leading to successful solution implementation and improved business results.
Documenting Processes: Documented processes, data flows and pipeline architecture for easy reference and team collaboration.