Mohammad Farhan Shaikh
SDET Engineer
+917********* ************@*****.*** DOB -22-06-1995
ABOUT ME
SDET Engineer with 3.6+ years of experience in validating complex data pipelines and ensuring data quality across Data Warehouse systems. Proficient in SQL, Informatica, and cloud platforms like Snowflake and Azure. Currently expanding into test automation with a focus on building robust automation frameworks and validating data at scale. EDUCATION
2013 - 2017 B.E. from Mahakal Institute of Technology - Ujjain 2017 - 2020 M.Tech from Shri Vaishnav Institute of Technology and Science - Indore EXPERIENCE
Infosys Ltd (Feb 2022 - Present) - Indore (M.P)
Client: CareFirst BlueCross BlueShield
Project Name: Ebill (Aso Shared Savings & ITS Finance) Feb 2025 - Present Validating monthly and annual claims invoices loaded from multiple workstreams into ETL and detail tables, with final approvals through Optum, L2 Admin, and Employer portals.
Under ITS project Validated complex ETL flows, consolidating data from 17 mainframe files into a single source and common target table, leading to accurate CSV report generation. Project Name: Facets Upgrade Sep 2024 - Jan 2025
Validated upstream Facets tables impacted by datatype change (smallint to int), performing ETL and job-level validations to ensure data integrity and successful migration.
Project Name: Funnel Jun 2024 - Aug 2024
Tested end-to-end flow of marketing data collected from websites, loaded via Funnel IO into Azure SQL using ADF pipelines, and then into Power BI reports for dashboarding.
Project Name: Facets IICS Mar 2023 - Mar 2022
Done Testing of Data Migration from on premise Server e.g.- SQL, Oracle to Cloud Technology e.g.-snowflake, Azure SQL. This Project is of migration of Facets Group_nbr from legacy to new system G6. Project : Ebill Projects Feb 2022 - Feb 2023
CI and D2D projects mostly validation of claims invoices and admin invoices Validation of MSTR reports and Optum, L2Admin and Employer portal
CERTIFICATES
Microsoft Azure Data Fundamentals (DP-900) Microsoft Azure Fundamentals (AZ-900) SKILLS
ETL Testing, SQL,Data Warehouse Testing,Data Migration Testing,Cloud Testing, Power BI Reports Testing,MSTR Testing, Python, SnowFlake,Oracle SQL Developer, IICS
LANGUAGES
English,Hindi, Arabic