Ankur Yadav Email & Phone Number

Bengaluru, Karnataka, India

Led the migration of financial data from Intuit’s on-premise servers to a Data Lake, using Spark SQLto design and implement efficient ETL pipelines, optimizing data processing and ensuring seamlesstransition.• Optimized SQL queries and triggers for RDBMS, improving data manipulation and retrieval acrossplatforms.• Analyzed and backtracked Informatica mappings and business rules, ensuring accurate and reliabledata transformations.• Designed complex SQL queries with joins, subqueries, and window functions to support businessintelligence and reporting.• Reduced query execution time by 30%-40%, boosting reporting speed and system performance.• Developed and implemented data validation frameworks and quality checks to ensure 100% dataaccuracy throughout migration.• Collaborated cross-functionally to streamline data validation, improving accuracy and efficiency by100%.• Utilized S3 Data Lake for scalable, cost-effective data storage, improving data accessibility andmanagement.• Automated ETL jobs with Tidal, enhancing operational efficiency and reducing manual intervention.• Created logical and physical data flow models, ensuring data transformation clarity and accuracy.

Bengaluru, Karnataka, India

• Engineered comprehensive logical and physical data flow models for ETL applications, streamliningdata integration processes and ensuring seamless data transformation and loading with optimizedworkflows.• Diagnosed and resolved invalid data mappings within the ETL pipeline, troubleshooting complexdatabase issues and improving data accuracy, integrity, and system reliability.• Leveraged relational SQL to optimize query performance, reducing unnecessary data transfer andminimizing network latency, leading to a significant improvement in processing efficiency and fasterdata operations

New Delhi, Delhi

Analyzed ML-generated data to detect fraudulent activities and anomalies, identifying criticalpatterns for improved fraud detection algorithms.• Prepared detailed reports on data insights and findings, enabling data-driven strategicdecision-making.• Conducted in-depth analysis to uncover trends, enhancing the effectiveness of fraud detectionmodels.