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

Fähigkeiten und Kenntnisse

Project Management
MS Office
Team work
Quality Management
Technology
Reporting
ETL (Extract, transform, load)
SQL
BI Reporting
Informatica PowerCenter
DWH
AWS Atheana
UNIX
DWH/ETL Testing
Database Testing
Bi Testing
Informatica Power Center
Talend Open studio
Microsoft Azure Data bricks
Apache Hive
AWS Athena
PowerBI
Tableau
Qliksense
BIRST
Informatica powercenter
Data Warehouse

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

Interessen

Photography
Cooking
Music
Travel

21 Mio. XING Mitglieder, von A bis Z