Saurabh Kumar Singh

Dynamic Data Engineering and Governance professional with extensive experience at Accenture Solution. Proven expertise in DWH/ETL testing and BI report validation, leveraging tools like Informatica and SQL. Recognized for enhancing data quality and driving efficiency through innovative solutions. Strong analytical skills combined with a collaborative approach ensure project success.

I hereby declare that the above-mentioned information is true to the best of my knowledge and belief.

NextEra Energy, Energy Data Warehouse, HIVE, AWS, SQL, Redshift, Quality Assurance, NextEra Energy, Inc It is an American energy company with about 58 GW of generating capacity, revenues of over $18 billion in 2020, and about 14,900 employees throughout the U.S. In Canada, it is the largest electric utility holding company by market capitalization, and I served as a Test Engineer for Energy, which is a central repository of integrated data from different sources Data is used for risk and regulatory compliance reporting. I prepared and ran SQL queries to verify dimensional and fact tables. I verified the data in the target database after the ETL process. I performed column data mapping between the source and target databases. I prepared test cases for validating the data. I prepared test data for testing. I verified the data that was loaded into the target database. I developed, reviewed, and executed test scripts and designed test data. I was involved in defect raising and closing the bugs. 

PROJECT 2

SIRVA Moving and Reallocation System, SIRVA, US Chicago, Microsoft SQL Server 18.1, BIRST, SAP BO Reporting, IPM, Quality Assurance, SIRVA Worldwide Relocation and Moving is a global leader in moving and relocation services, offering solutions for mobility programs to companies of every size capacity, With 75 owned locations and more than 1,000 franchised and agent locations in 177 countries., BI Report Testing, BIRST Report Testing., Understanding the business requirement., Client handling with daily basis., Involved in functional study of the application., Prepared and ran SQL queries to verify dimensional and Fact tables., Verifying the data in target database after ETL process., Performed column data mapping between source & target database., Prepared Test Cases for the Validating the data., Prepared test data for testing., Verifying the data which is loaded into target database., Reporting daily testing status report., BO Report Testing., Data Base Testing., Developed, Reviewed & Executed Test Scripts and Designed test data., Involving in defect raising and closing the bugs.