Pratish Ranjan
Angestellt, Senior Consultant, Capgemini Services India Pvt.Ltd
Bangalore, Indien
Über mich
Working as a Senior Consultant at Capgemini India. I possess a deep understanding of Data warehouse , Data Integration &Transformation (ETL) Informatica Power center / Talend and SQL in different platforms (Oracle, MS SQL Server, Azure Datalake) with strong knowledge in Business Intelligence areas such as: Reporting Application using Qliksense, PowerBI, Tableau and Database development & support, Azure Databriks/MySQL ,Azure Deveops
Werdegang
Berufserfahrung von Pratish Ranjan
Bis heute 3 Jahre und 7 Monate, seit Dez. 2020
Senior Consultant
Capgemini Services India Pvt.Ltd
Test scenario and test case preparation with SQL queries based on Technical design and requirement and mapping sheet /document Test case and test script preparation for Power BI dashboard and Report validation Building SQL scripts to validate Report in backend to frontend application Data validation in staging layer to DWH than RDM Power Bi Dashboard and report validation front end to back end Running the workflow in Informatica RDM to load the data respective layer in database
4 Jahre und 7 Monate, Sep. 2018 - März 2023
ETL Tester Data Analyst
IBM India Pvt. Ltd
Test Case preparation with SQL queries based on Technical design and requirements Test Scenario and Test Data preparation. Review test cases and execute SQL queries. Validate data from Source to Target through various transformation logics Coordination with Developers, Business Analysts Participated in regular project standup status meetings related to testing. Participating agile meeting like, Scrum, Retro, Refinement.
1 Jahr und 2 Monate, Apr. 2019 - Mai 2020
Consultant
SIRVA Worldwide, Inc
Validate data from Source to Target through various transformation logics Prepared status summary reports with details of executed, passed and failed test cases Coordination with Developers, Business Analysts and Testers. Participated in regular project status meetings related to testing. Reporting daily testing status report. Prepare document for signoff
5 Jahre und 1 Monat, Aug. 2013 - Aug. 2018
Software Engineer
IZMO Ltd
Prepared Test Reports and submitted the bug findings to the defect tracking system. Mobile and tablet device testing Involved in cross browsing testing of the application on various browsers to ensure it functions. Interact with Developers and Business Analysts to perform various types of testing throughout Software Testing Life Cycle (STLC) Interacted with developers, Business & Management Teams and End Users.
Sprachen
Englisch
Fließend
Hindi
Fließend
Odiya
Fließend