Ankur Rajput

Background

About Ankur Rajput

Results-driven Test Lead with over 10 years of progressive experience in ETL testing, data validation, automation and quality assurance across the Pharmaceutical and eLearning domains. Adept at leading end-to-end testing efforts on large-scale data platforms involving cloud-based data lakes, data warehouses (Redshift, Snowflake), and data integration tools like Informatica, Matillion and Airflow. Currently spearheading QA efforts at Axtria Pvt. Ltd, delivering high-quality solutions for global life sciences clients such as Takeda, Eisai, and Novartis. Proficient in developing automation frameworks using Python, Visual Studio and Axtria's in house Robot Framework, significantly reducing manual effort and accelerating delivery cycles. Skilled in complex SQL scripting, data reconciliation at scale, and KPI validation across multiple reporting layers. Experienced in Agile delivery models, team leadership, stakeholder communication, and production support, ensuring consistent delivery of accurate and compliant data solutions. Core Competencies ETL Testing Leadership – Leading and managing ETL testing teams, establishing best practices, and ensuring consistent delivery of high-quality outcomes. Manual ETL Validation – Hands-on expertise in validating data extraction, transformation, and load processes for complex data pipelines. Data Quality & Reconciliation – Conducting in-depth data verification and reconciliation between source, staging, and target systems. Advanced SQL Skills – Developing and executing complex SQL queries for data validation, profiling, and analysis. Test Planning & Strategy – Creating comprehensive test strategies, estimation models, and risk mitigation plans. Defect Management – Driving defect lifecycle management using tools like JIRA and HP ALM, facilitating triage, and ensuring timely resolution. Stakeholder Collaboration – Partnering closely with developers, data architects, business analysts, and project managers to meet project objectives. Team Development & Mentoring – Training, coaching, and supervising junior testers to build high-performing teams. Agile & Waterfall Methodologies – Working effectively in both Agile and traditional environments to align testing activities with delivery timelines.