Deepak Mohan

Background

About Deepak Mohan

Having 12+ years of experience in Data Warehousing (ETL) Testing and Big Data Testing. Well-versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC). Having very good knowledge in Data warehouse Testing, ETL Testing, BI Reports Testing, Database Testing and Functional Scenario validations. Hands on experience Big Data project, having worked in Netezza to Hive DB migration project. Good knowledge in preparing Hive QL /Oracle SQL/Neteeza SQL queries based on Business-Functional requirements and execute them using Hive/SQL developer/Aginity Workbench. Well -versed in Hadoop and its ecosystem like HDFS, Hive, Oozie, Sqoop, etc. Knowledge in SSIS/BI and reporting tools. Ability to write basic coding in Python. Sound Knowledge in Data lake, Snowflake data warehouse and understanding of cloud technologies. Wrote queries in Teradata SQL assistant to check the data from Source and Target. Extensive experience in Manual testing including Integration testing,System Integration Testing, Functional Testing, Regression Testing,GUI Testing and API Testing. Having Hands On experience in Automation testing and Mobile Application Testing. Having Good domain knowledge in Banking and Health Care Applications Highly experienced in Test Case Design, Test Case Review, Test Case Execution and strong exposure to Test management tools Quality Center and Quick Test Professional and defect tracking tools like Star Team and QC/ALM. Having Good knowledge in Agile Methodology and usage of Rational Team Concert (RTC) and Jira. Vastly experienced in Health care, Banking and Insurance domain. Experienced in mentoring new team members into the project and providing guidelines on test development and execution process. Good Interaction with Onsite Counterpart and Clients having worked in Onsite. Generating defect reports and Interacting with development team to resolve the defects. Excellent interpersonal, communication and organizational skills with the ability to interact effectively with colleagues at all levels