Testing-ETL-

At EY, youll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And were counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all. EY_ Consulting _Data Analytics Testing_Staff
The opportunity
As a Data Analytics Test Engineer, you will be responsible for testing Business Intelligence Data warehousing Solutions both in on premise and cloud platform and should ensure Quality of deliverables. You will work closely with Test Lead for the Projects under Test. Testing proficiency in ETL, data-warehousing, and Business Intelligence area are required for this position. Added advantage to have experience in testing Big Data/unstructured data using Hadoop/Spark framework, cloud platform knowledge either in AWS/Azure, knowledge in predictive analytics, Machine Learning and Artificial intelligence. Skills and attributes for success

Delivery of Testing needs for BI DWH Projects.

Ability to effectively communicate with team members across geographies effectively

Perform unstructured data / big data testing both in on-premise and cloud platform.

Thorough understanding of Requirements and provide feedback on the requirements.

Develop Test Strategy for Testing BI DWH Projects for various aspects like ETL testing Reports testing (Front end and Backend Testing), Integration Testing and UAT as needed. Provide inputs for Test Planning aligned with Test Strategy.

Perform Test Case design, identify opportunity for Test Automation. Develop Test Cases both Manual and Automation Scripts as required.

Ensure Test readiness (Test Environment, Test Data, Tools Licenses etc)

Perform Test execution and report the progress. Report defects and liaise with development other relevant team for defect resolution.

Prepare Test Report and provide inputs to Test Lead for Test Sign off/ Closure

Provide support in Project meetings/ calls with Client for status reporting.

Provide inputs on Test Metrics to Test Lead. Support in Analysis of Metric trends and implementing improvement actions as necessary.

Handling changes and conducting Regression Testing

Generate Test Summary Reports

Co-coordinating Test team members and Development team

Interacting with client-side people to solve issues and update status

Actively take part in providing Analytics and Advanced Analytics Testing trainings in the company

To qualify for the role, you must have

BE/BTech/MCA/M.Sc

Overall 2 to 9years of experience in Testing Data warehousing / Business Intelligence solutions, minimum 2 years of experience in Testing BI DWH technologies and Analytics applications.

Experience in Bigdata testing with Hadoop/Spark framework and exposure to predictive analytics testing.

Very good understanding of business intelligence concepts, architecture building blocks in areas ETL processing, Datawarehouse, dashboards and analytics.

Experience in cloud AWS/Azure infrastructure testing is desirable.

Knowledge on python data processing is desirable.

Testing experience in more than one of these areas- Data Quality, ETL, OLAP, Reports

Good working experience with SQL server or Oracle database and proficiency with SQL scripting.

Experience in backend Testing of Enterprise Applications/ Systems built on different platforms including Microsoft .Net and Sharepoint technologies

Experience in ETL Testing using commercial ETL tools is desirable. Knowledge/ experience in SSRS, Spotfire (SQL Server Reporting Services) and SSIS is desirable.

Experience/ Knowledge in Data Transformation Projects, database design concepts white-box testing is desirable.

Ideally, youll also have

Able to contribute as an individual contributor and when required Lead a small Team

Able to create Test Strategy Test Plan for Testing BI DWH applications/ solutions that are moderate to complex / high risk Systems

Design Test Cases, Test Data and perform Test Execution Reporting. Should be able to perform Test Management for small Projects as and when required

Participate in Defect Triaging and track the defects for resolution/ conclusion

Experience/ exposure to Test Automation and scripting experience in perl shell is desirable

Experience with Test Management and Defect Management tools preferably HP ALM

Good communication skills (both written verbal)

Good understanding of SDLC, test process in particular

Good analytical problem solving or troubleshooting skills

Good understanding of Project Life Cycle and Test Life Cycle. Exposure to CMMi and Process improvement Frameworks is a plus. Should have excellent communication skills should be able to articulate concisely clearly

Should be ready to do an individual contributor as well as Team Leader role