Consultant (QA)

Job Number: 10592
Location(s): Mumbai, Maharashtra

General Mills is reshaping the future of food. We believe food makes us better. It nourishes our bodies, brings us joy and connects us to each other. As one of the world’s leading food companies, General Mills operates in more than 100 countries and markets more than 100 consumer brands, including Cheerios, Nature Valley, Betty Crocker, Yoplait, Annie’s Homegrown, Old El Paso, Epic Provisions, Blue Buffalo and more. Are you passionate about the future of food? You’ve come to the right table. We want the very best talent to help lead something big.

Job Details

Overview & Responsibilities

7+yrs of experience as Test Consultant with proven expertise in Big Data test,ETL test & Data Migration test.

Primary responsibility involves understanding the data test needs of the Big Data /Connected Data projects and provide a robust, scalable & effective test solution. The role requires creation and implementation of test strategy , test execution & reporting for Connected Data projects. Ability to understand the technology roadmap for Data driven projects and exposure to wide spectrum of tools in Hadoop ecosystem. Contribute to inhouse Data test tool. Exposure to Python and machine learning is good to have. Additionally the role requires contribution to various Data Test CoE driven goals.

70 %

 

of Time

Requirement Analysis-

–   Ability to discuss with Business/Business Analysts/Data Architect to understand various data pipelines in Connected Data Lake and create detailed test strategy and scripts.

–   It is critical to understand the test data requirements specifically for connected data and devise the test strategy accordingly.

 

Test Design-

– Colaboarte with Techinal Architect/Developer/Analyst to build test scenarios.

– Ability to translate the business requirements into Data test scenarios & test cases.

–   Ability to understand Data flow diagrams and data processing

–   Interpret Physical Data Model & Logical data model and convert them into test scenarios , test cases.

–   Create test scenarios covering all V’s of Big data and assuring coverage across all data quality parameters.

–   Understand the usage of data ingestion techniques, data cleansing techniques, data modelling techniques for each data pipeline.

 

Test Execution and Reporting-

–       Plan the test execution manual and automated based on business priority

–       Execute test cases, test scripts, and report status to QA Lead and/or Project Manager.

–       Execute multiple automated test suites, have the ability to debug and resolve the challenges accordingly.

–       Ensure coverage across data quality parameters.

–       Analyze test results and defects prior to escalating to the development team for resolution

–       Maintenance of Test suites

–       Accurately record and clearly document all actual results compared to expected results.

–       Raise timely risk flags

 

Test Automation

–       Plan for Regression test suites and their execution through automated tools.

–       As per project needs work on various inhouse test automation tools.

 

Continuous Improvement-

–       Work closely with technology peers to understand the latest trends in Data Test world.

–       Help to continuously improve QA policies, procedure and guidelines.

20%

of Time

–       Provide consultation to business/project partners of test benefits also involving automation

–       Share best practices on efficient ways to transition knowledge from business analysts

–       Troubleshoot and analyze the test results.

–       Ability to define the impact of latest technologies on Data test

–       Interaction with vendors to understand the offerings and map to test needs

–       Strong Communication skills and past exposure of managing stakeholders

–       Understanding and advocating Data test needs to project stakeholders

–       Identify, resolve, and proactively communicate potential problems.

–       Document and maintain the Test Processes/scenarios/scripts

10%

of Time

–       Understanding of latest market trends and share its applicability to enhance existing data test strategy

–       Share the learnings with the team members and across teams

–       Mentor team members on Advance data test needs

–       Perform Knowledge Transition and ensure a back-up in the team.

Qualifications

Education

Minimum Degree Requirements:  

Bachelors

Preferred Degree Requirements:  

Bachelors

Preferred Major Area of Study:

Computer Information / Computer Science

 

Experience

Minimum years of related experience required:

7+yrs in ETL/Big data testing

Preferred years of related experience:

3yrs in Big data testing

Specific Job Experience or Skills Needed:

Must have experience in Connected Data projects.

  1. Must have worked on E2E testing lifecycle
  2. Strong knowledge of Impala/Hive queries
  3. Experience in ingestion technologies like Sqoop, Streamsets, Data Mover, Pynamic
  4. Knowledge of Kafka, Message Bus
  5. Knowledge of Scala,Spark,Kudu based framework
  6. Worked on varied data sources including RDBMS,JSON, XML,SAP etc.

Must have prior experience in BI testing

  1. Tableau report
  2. Custom reports

Prior ETL/DW project experience is must

  1. Schema Types
  2. Facts/Dimensional Modelling

Good Command over SQL

  1. Impala/Hive
  2. Oracle
  3. SQL server

Experience of working on Agile projects

  1. Ability to work on geographical spread Agile Product teams
  2. Status Reporting
  3. Good Communication skills
  4. Ability to work & communicate with Project Managers, Business Analyst & Developers

Exposure to different datasources

  1. SAP
  2. Oracle
  3. SQL Server etc.

Overview & Responsibilities

7+yrs of experience as Test Consultant with proven expertise in Big Data test,ETL test & Data Migration test.

Primary responsibility involves understanding the data test needs of the Big Data /Connected Data projects and provide a robust, scalable & effective test solution. The role requires creation and implementation of test strategy , test execution & reporting for Connected Data projects. Ability to understand the technology roadmap for Data driven projects and exposure to wide spectrum of tools in Hadoop ecosystem. Contribute to inhouse Data test tool. Exposure to Python and machine learning is good to have. Additionally the role requires contribution to various Data Test CoE driven goals.

70 %

 

of Time

Requirement Analysis-

–   Ability to discuss with Business/Business Analysts/Data Architect to understand various data pipelines in Connected Data Lake and create detailed test strategy and scripts.

–   It is critical to understand the test data requirements specifically for connected data and devise the test strategy accordingly.

 

Test Design-

– Colaboarte with Techinal Architect/Developer/Analyst to build test scenarios.

– Ability to translate the business requirements into Data test scenarios & test cases.

–   Ability to understand Data flow diagrams and data processing

–   Interpret Physical Data Model & Logical data model and convert them into test scenarios , test cases.

–   Create test scenarios covering all V’s of Big data and assuring coverage across all data quality parameters.

–   Understand the usage of data ingestion techniques, data cleansing techniques, data modelling techniques for each data pipeline.

 

Test Execution and Reporting-

–       Plan the test execution manual and automated based on business priority

–       Execute test cases, test scripts, and report status to QA Lead and/or Project Manager.

–       Execute multiple automated test suites, have the ability to debug and resolve the challenges accordingly.

–       Ensure coverage across data quality parameters.

–       Analyze test results and defects prior to escalating to the development team for resolution

–       Maintenance of Test suites

–       Accurately record and clearly document all actual results compared to expected results.

–       Raise timely risk flags

 

Test Automation

–       Plan for Regression test suites and their execution through automated tools.

–       As per project needs work on various inhouse test automation tools.

 

Continuous Improvement-

–       Work closely with technology peers to understand the latest trends in Data Test world.

–       Help to continuously improve QA policies, procedure and guidelines.

20%

of Time

–       Provide consultation to business/project partners of test benefits also involving automation

–       Share best practices on efficient ways to transition knowledge from business analysts

–       Troubleshoot and analyze the test results.

–       Ability to define the impact of latest technologies on Data test

–       Interaction with vendors to understand the offerings and map to test needs

–       Strong Communication skills and past exposure of managing stakeholders

–       Understanding and advocating Data test needs to project stakeholders

–       Identify, resolve, and proactively communicate potential problems.

–       Document and maintain the Test Processes/scenarios/scripts

10%

of Time

–       Understanding of latest market trends and share its applicability to enhance existing data test strategy

–       Share the learnings with the team members and across teams

–       Mentor team members on Advance data test needs

–       Perform Knowledge Transition and ensure a back-up in the team.

Qualifications

Education

Minimum Degree Requirements:  

Bachelors

Preferred Degree Requirements:  

Bachelors

Preferred Major Area of Study:

Computer Information / Computer Science

 

Experience

Minimum years of related experience required:

7+yrs in ETL/Big data testing

Preferred years of related experience:

3yrs in Big data testing

Specific Job Experience or Skills Needed:

Must have experience in Connected Data projects.

  1. Must have worked on E2E testing lifecycle
  2. Strong knowledge of Impala/Hive queries
  3. Experience in ingestion technologies like Sqoop, Streamsets, Data Mover, Pynamic
  4. Knowledge of Kafka, Message Bus
  5. Knowledge of Scala,Spark,Kudu based framework
  6. Worked on varied data sources including RDBMS,JSON, XML,SAP etc.

Must have prior experience in BI testing

  1. Tableau report
  2. Custom reports

Prior ETL/DW project experience is must

  1. Schema Types
  2. Facts/Dimensional Modelling

Good Command over SQL

  1. Impala/Hive
  2. Oracle
  3. SQL server

Experience of working on Agile projects

  1. Ability to work on geographical spread Agile Product teams
  2. Status Reporting
  3. Good Communication skills
  4. Ability to work & communicate with Project Managers, Business Analyst & Developers

Exposure to different datasources

  1. SAP
  2. Oracle
  3. SQL Server etc.

OTHER JOBS YOU MAY LIKE

OTHER JOBS YOU MAY LIKE

Tech Specialist
Mumbai, Maharashtra
Analyst
Mumbai, Maharashtra

Returning Candidates

Login or Create Profile Looking for an update to your application? Log into your profile to review your status.
Join our talent community