Avijit Dhar

Background

About Avijit Dhar

Data Warehouse/ETL/BI/Big Data Testing Associate, ready to relocate, ready to work with pure agility.• Having 6 years IT industry experience with expertise in BigData-Hadoop Testing, ETL Testing & ETL Data Analyst, MDM Testing with thorough understanding of transformations and KPI related to downstream. • 4 years of experience in ETL Testing & ETL Analyst in various databases, ETL and BI Reporting platforms Database platforms: Apache Hive, Apache Phoenix, Oracle 10g, Teradata • Efficient with Control-M jobs handling for data loads to test environments and analysis of relevant data in test bed. • Performed analysis for a wide range of requirements using data in different formats and from various platforms • Have developed strategies and documented testing approaches for BO Reporting and universe level testing with efficiency. • Have successfully framed queries and tested major KPIs relating to major customer requirements from source and intermediate data levels using SQL. • Developed automation scripts using SQL to validate data irrespective of the sources and having complex transformation logics. • Successfully handled leadership roles and managed part of test team performing a test lead position. • Performed project management activities like creating test reports, project steering committee status reports, burn down charts, test metrics and driving defect triage calls. Also have handled test data creations and mockups and managed test environment. • Root cause analysis of issues and planning action items for future enhancement of Test Methodology • Involved in understanding Business requirements and work with the development architect to translate requirements into testing architecture designs. Review requirements and seeks clarity as required, participate in product design reviews and works with the development architect and development team to make any design improvements and refinement as needed. In addition, help incorporate Testability requirements into design • Quality and Compliance activities for Banking projects. • Have a vision to quickly identify and understand the business benefits of new technologies with strong computational, analytical problem-solving knowledge.