Logo of Huzzle

Home

Matches

Explore

Manage

Testing-ETL-Staff

image

EY

1mo ago

  • Job
    Full-time
    Junior, Mid & Senior Level
  • Consulting
    Data
  • Bangalore

AI generated summary

  • You must have a BE/BTech/MCA/M.Sc, 2-6 years in BI/DWH testing, experience with Hadoop/Spark, SQL proficiency, ETL tools, and good communication skills. Leadership and testing strategy experience preferred.
  • You will manage BI & DWH testing, develop strategies, design test cases, execute tests, report defects, coordinate teams, and provide training on Analytics Testing.

Requirements

  • To qualify for the role, you must have
  • BE/BTech/MCA/M.Sc
  • Overall 2 to 6 years 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, you’ll 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

Responsibilities

  • 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

FAQs

What is the main focus of the Testing-ETL-Staff role at EY?

The main focus of the Testing-ETL-Staff role is to test Business Intelligence and Data Warehousing solutions both on-premise and in cloud platforms, ensuring the quality of deliverables through various testing methodologies, including ETL, data quality, and report testing.

What are the qualifications required for this position?

The qualifications required for this position include a BE/BTech/MCA/M.Sc degree, 2 to 6 years of experience in testing data warehousing and Business Intelligence solutions, and at least 2 years of experience specifically in BI & DWH technologies and analytics applications.

Is experience with Big Data technologies important for this role?

Yes, experience in Big Data testing using Hadoop/Spark frameworks and exposure to predictive analytics testing is considered an added advantage for this role.

What cloud platforms should candidates be familiar with?

Candidates should have knowledge of cloud platforms, particularly AWS and Azure, as testing experience in these environments is desirable.

What kind of testing experience should applicants have?

Applicants should have testing experience in areas such as Data Quality, ETL, OLAP, and Reports, as well as backend testing of enterprise applications/systems.

Are there opportunities for growth and development in this position?

Yes, EY focuses on employee growth and development, offering training, coaching, and opportunities to progress your career through practical experience and individual progression plans.

What kind of work environment can employees expect at EY?

Employees can expect a supportive and collaborative work environment that emphasizes high quality and knowledge exchange, allowing for both individual contributions and collaboration within teams.

Is there a requirement for knowledge in programming languages?

Yes, knowledge of Python for data processing is desirable, along with potential exposure to test automation and scripting in Perl and shell.

What is the expected communication level in this role?

Strong communication skills, both written and verbal, are essential as the role involves interacting with team members across geographies, providing status reports, and addressing client concerns.

How does EY emphasize flexibility in work arrangements?

EY offers the freedom and flexibility for employees to handle their roles in a way that suits them best, promoting a balanced work-life approach.

image

EY

Accounting
Industry
1-10
Employees

Mission & Purpose

EY exists to build a better working world, helping create long-term value for clients, people and society and build trust in the capital markets. Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate. Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today. Find out more about the EY global network http://ey.com/en_gl/legal-statement