Dharmesh Pandey

Background

About Dharmesh Pandey

11+ years of IT industry experience in Data warehousing and Business Intelligence(DW-BI), Financial Sector Services (FSS) and Pharmaceutical Industry->Extensive experience on various tools and technologies like Informatica BDM, Cloudera, Hadoop, Oracle, SQL Server, Unix, Hive, Stonebranch including exposure working on different SDLC phases->Working experience on Apache Hadoop Architecture using Cloudera Distribution 5.x,6.x,7.x, along with Hive, Beeline, Impala, Sqoop and Kafka->Strong Experience in Informatica - Design, Work Flow Manager, Repository Manager, Monitor and other tools used in the Transformation and Mapping, Migration, Transaction and Batch processing->Experience in using Stonebranch and Informatica Scheduler for scheduling Workflows->Created shell scripts for creating schedules, taking backup of informatica objects and connections,migrating informatica objects from one environment to another environment which helps in maintaining the same code versions on multiple environments->Extensively worked with implementation of the Star schema model, Facts and Slowly Changing Dimensions->Have worked as a QC-Analayst in ETL testing domain for a leading Insurance and Banking client using Ab-Initio ETL tool->Involved in the complete Software Testing Life Cycle right from preparing test case, execution to Test Result reporting and obtaining the required sign-off from client->Have implemented automation scripts wherever required to save time, effort and cost Execution of End-end ETL process right from Source to Metric->Handled responsibilities like design & development, unit testing, technical documentation, system testing and providing post go-live support->Profound knowledge in complete life cycle development of Data Warehouse: Data Analysis, Design, Development, Implementation and Testing using Data Extraction, Transformation and Loading (ETL)->Proficient in analyzing and translating business requirements to technical requirements->Good communication skills, interpersonal skills, self-motivated, quick learner, team player.