Mananjay Kumar Email & Phone Number

• 6+ Years of experience in ETL/ DWH, Bigdata & BI Testing• 3+ Years of experience in BI Development as a Data Analyst• Being well-versed in Data Warehouse (DWH) concepts like Star schema, Snowflake schema, Fact and Dimension table is an essential skill for a BI analyst.• Hands on experience in automating the SQL validation scripts by using Python Pandas library, ATF (Autosys Testing Framework) and Pytest• Extensively used ETL Automation tools like QuerySurge, DataGaps ETL Validator, Informatica data validation option, and Denodo • Extensively used Looker, Data Studio, MS Power BI, and Tableau BI tools• Automated data validation and quality checks to ensure accuracy and reliability of reports.• Created different visualizations in the reports using custom visuals like Bar Charts, Pie Charts, Line Charts, Cards, Slicers etc.• Extensively used snowflake as a Cloud based DWH. • Hands on experience in AWS Amazon Storage AS3.• Comprehensive understanding of software testing including creation of Test Scenarios, Test Plan, writing Test Cases and Test Reports.• Well acquainted with SDLC and exposure to all phases of STLC.• Extensive work experience in GUI, Functional, Unit, System Integration, Regression, Retesting, Performance testing And supporting UAT.• Experience into writing Complex SQL Test Scripts by using SQL Developer, Toad, Snowflake etc• Defect reporting and tracking using defect tracking tool Rally, Polarion, HP ALM & JIRA.• Prepared Test Scripts Inventory, Execution Results Inventory, Test deliverables and defect log and making sure everything goes in line with customer requirement.

• 

  Biju Patnaik University Of Technology, Odisha

  Computer Science