Lead Test Engineer / Test Engineer

Role	Experience Level	Skill Sets	Budget	Location	Notice Period
Test Engineer( 2 Positions)	5 + years	Hands-on Azure experience as a Test Engineer, BIG DATA TESTING, SQL, TEST STRATEGY, ETL, DATAWAREHOUSE, TEST PLANNING, BUG REPORTING, SYSTEM TEST	15-25 LPA	ALL EXL, Pref- Noida and Gurugram	Immediate only
Lead Test Engineer ( 2 Positions)	8+ years	BIG DATA TESTING, SQL, TEST STRATEGY, ETL, DATAWAREHOUSE, TEST PLANNING, BUG REPORTING, SYSTEM TEST, TEST LEAD, TEST MANAGER	24-30 LPA	ALL EXL, Pref- Noida and Gurugram	Immediate only

PFB JD

Job Title: Test Engineer

Job Summary

Test Engineers are responsible for assessing the quality of specifications and technical design documents in order to ensure timely, relevant and meaningful feedback. They are involved in planning and implementing strategies for quality management and testing. 

Test Engineers will be responsible for the design, development, testing, maintenance, and support data assets including; Azure Data Lake and data warehouse development, modeling, package creation, SQL script creation, stored procedure development, integration services support among other responsibilities.

Candidate have at least 3-5 years hands-on Azure experience as a Test Engineer, must be an expert in SQL and have extensive expertise building data pipelines. Candidate will be accountable for meeting deliverable commitments including schedule and quality compliance. This Candidate must have skills to plan and schedule own work activities, coordinate activities with other cross-functional team members to meet project goals.

Basic understanding of:

• Excel and visualization tool & working experience in PowerBI or Tableau or Similar
• Batch and Real time data processing
• Agile Process (Scrum cadences, Roles, deliverables) & working experience in either Azure DevOps, JIRA or Similar

Strong In/should have:

• End to End data warehousing systems from Data modelling to Reporting
• Hands-on experience with Database and reporting testing
• Hands-on experience on at least one of the Scripting/Programming languages like Unit or Python
• Writing complex SQL queries & working experience in Oracle, MS SQL, PostgreSQL, Redshift or Similar
• Automation testing using Java, Python etc.
• Understanding and writing functional specifications/technical specifications/Business rules/Data rules.
• Responsible for turning gathered requirements into test cases and scripts in both ETL & Reporting areas.
• Author test strategy, test plans, test cases, and/or test scripts required to validate requirements.
• Understand the existing report design, build test scripts and write SQL statements to validate reports
• Understanding and Analyzing Test Requirements, Tracking changes and maintenance of test Requirements
• Strong analytical and problem solving skills
• Ability to function in a high volume setting with tight deadlines
• Excellent verbal and written communication skills, problem solving skills, and interpersonal skills
• Reports test results and enter problems and issues into the bug database. Monitors and updates bug reports as needed including bug report closure.
• Writes UAT for release and interact with customers to get it passed.
• Strong in reading Logical/Physical model on Big Data sets or modern data warehouse
• Strong Communication (read & write in English), Collaboration & Presentation skills & working experience in team player or Similar
• Identify, record, document thoroughly and track bugs
• Perform thorough regression testing when bugs are resolved
• Develop and apply testing processes for new and existing products to meet client needs
• Liaise with internal teams (e.g. developers and product managers) to identify system requirements
• Monitor debugging process results
• Investigate the causes of non-conforming software and train users to implement solutions
• Track quality assurance metrics, like defect densities and open defect counts
• Stay up-to-date with new testing tools and test strategies

KEYWORDS: BIG DATA TESTING, SQL, TEST STRATEGY, ETL, DATAWAREHOUSE, TEST PLANNING, BUG REPORTING, SYSTEM TEST

Job Title: Lead Test Engineer

Job Summary

Lead Test Engineers is responsible for developing test strategy, plan, assessing the quality of specifications and technical design documents in order to ensure timely, relevant and meaningful feedback. They are involved in planning and implementing strategies, leading a team, managing defect uncovered, reporting on progress and obtaining sign-off for quality management and testing. 

Basic understanding of:

• Excel and visualization tool & working experience in PowerBI or Tableau or Similar
• Batch and Real time data processing
• Agile Process (Scrum cadences, Roles, deliverables) & working experience in either Azure DevOps, JIRA or Similar

Strong In/should have:

• Understanding the testing effort by analyzing the requirements of project.
• Estimating and obtaining management support for the time, resources and budget required to perform the testing.
• Organizing the testing kick-off meeting
• Defining the Test Strategy
• Building a testing team of professionals with appropriate skills, attitudes and motivation.
• Identifying Training requirements and forward it to the Project Manager (Technical and Soft skills).
• Developed the test plan for the tasks, dependencies and participants required to mitigate the risks to system quality and obtain stakeholder support for this plan.
• Arranging the Hardware and software requirement for the Test Setup.
• Assigning task to all Testing Team members and ensure that all of them have sufficient work in the project.
• End to End data warehousing systems from Data modelling to Reporting
• Hands-on experience with Database and reporting testing
• Hands-on experience on at least one of the Scripting/Programming languages like Unit or Python
• Writing complex SQL queries & working experience in Oracle, MS SQL, PostgreSQL, Redshift or Similar
• Automation testing using Java, Python etc.
• Understanding and writing functional specifications/technical specifications/Business rules/Data rules.
• Responsible for turning gathered requirements into test cases and scripts in both ETL & Reporting areas.
• Author test strategy, test plans, test cases, and/or test scripts required to validate requirements.
• Understanding and working experience in AWS Services (S3, Lambda, Athena, EMR etc)
• Ensuring content and structure of all Testing documents / artifacts is documented and maintained.
• Documenting, implementing, monitoring, and enforce all processes for testing as per standards defined by the organization.
• Reviewing the Test Cases documents.
• Keeping track of the new requirements / change in requirements of the Project.
• Escalating the issues about project requirements (Software, Hardware, Resources) to Project Manager / Sr. Test Manager.
• Organizing the status meetings and send the Status Report (Daily, Weekly etc.) to the Client
• Attend the regular client call and discuss the weekly status with the client.
• Strong Communication with the Client.
• Act as the single point of contact between Development and Testers.
• Tracking and preparing the report of testing activities like test testing results, test case coverage, required resources, defects discovered and their status, performance baselines etc.
• Reviewed various reports prepared by Test engineers.
• Ensuring the timely delivery of different testing milestones.
• Preparing / updating the metrics dashboard at the end of a phase or at the completion of project.

KEYWORDS: BIG DATA TESTING, SQL, TEST STRATEGY, ETL, DATAWAREHOUSE, TEST PLANNING, BUG REPORTING, SYSTEM TEST, TEST LEAD, TEST MANAGER