Senior ETL Test Engineer

Sr. Test Engineer - ETL Testing Job

YASH Technologies is a leading technology integrator specializing in helping clients reimagine operating models, enhance competitiveness, optimize costs, foster exceptional stakeholder experiences, and drive business transformation.

 

At YASH, we’re a cluster of the brightest stars working with cutting-edge technologies. Our purpose is anchored in a single truth – bringing real positive changes in an increasingly virtual world and it drives us beyond generational gaps and disruptions of the future.

 

We are looking forward to hire ETL Testing Professionals in the following areas :

 

Experience

4-6 Years

Job Description

Key Responsibilities:
-Analyze and validate data for accuracy, completeness, and integrity.
-Develop and implement data quality standards, rules, and processes.
-Identify, assess, Perform data profiling and resolve data quality issues across systems.
-Monitor and report on data quality metrics and KPIs. -Collaborate with data engineers, database developers, and business stakeholders.
-Support data governance initiatives and ensure compliance with data policies. 
-Conduct root cause analysis of data issues. -Document procedures and maintain accurate records of data quality activities. 
-Validate data extraction, transformation, and loading from source to target systems. -Perform data profiling, data validation, and reconciliation.
- Review data models, mappings, and architecture documents to derive test scenarios.

Required Qualifications:
-Bachelor’s degree in Computer Science, Statistics, Information Management, or related field. 
-4-6 years of experience in ETL, data testing, data analysis or data quality roles.

-Strong SQL skills and experience with ETL tools (e.g., Informatica, Talend, SSIS).
-Proficiency in SQL and data manipulation tools.
-Familiarity with data quality tools and frameworks.
-Excellent analytical, problem-solving, and communication skills.

Preferred Skills:
-Familiarity with data warehousing concepts (e.g., star/snowflake schemas, dimensions, facts).
-Experience with test management tools (e.g., JIRA,Test Rail).
-Experience with data visualization tools (e.g., Power BI).
-Excellent analytical and problem-solving skills.
-Experience working in cross-functional teams and agile environments.

Nice to have:
-Cloud experience (Microsoft Azure, AWS, Snowflake).
-Data Governance experience.

Required Technical/ Functional Competencies

Requirement Gathering and Analysis:

• Good understanding of requirement gathering and analysis concepts and terminology.
• Able to independently identify, describe, and document requirements, and have experience in creating and reviewing requirements.
• Able to conduct basic analysis of requirements, such as identifying gaps and inconsistencies.

Testing Design:

• Has knowledge of test design techniques, framework, and approach.
• Can design test cases based on requirements and specifications.
• Can create test plans and strategies, identify and manage risks in the testing process, and perform exploratory testing.

Test Planning:

• Has a deeper understanding of test planning concepts and can create a comprehensive test plan.
• Can design and execute complex test cases based on multiple scenarios and variables.
• Can prioritize and report defects based on their severity and impact on the system.

Estimation and Resource Planning:

• Basic understanding of estimation and resource planning techniques, such as the WBS model.
• Ability: Identify required resources and utilize suitable estimation models for low-medium complete scenarios based on project scope.

Product/ Technology Knowledge:

• Has a solid understanding of testing processes and techniques.
• Has a good understanding of the technology and products been tested.
• Can execute tests independently and analyze results.

Test Development:

• Demonstrates a good understanding of test development principles and concepts.
• Can perform a variety of item-writing tasks with minimal supervision.
• May require some guidance in developing more complex test forms.

Customer Management:

• Has working knowledge of customer's business domain and technology suite.
• Use latest technology, proactively suggest solutions to increase business, and understand customer's business.

Knowledge Management:

• Working knowledge of Knowledge Management principles and practices.
• Able to apply the principles and practices in practical situations and use the tools and techniques effectively.
• Write technical and user understanding documents.

Domain/ Industry Knowledge:

• Basic knowledge of customer's business processes and relevant technology platform or product.
• Able to prepare process maps, workflows, business cases, test cases, and test data for simple to medium requirements with the assistance of SME.

Test Execution:

• Has intermediate understanding of test execution concepts and practices.
• Can work independently, identify and prioritize test cases, execute complex test scenarios, perform regression testing, and provide clear and concise defect reports.
• May need occasional guidance and supervision for complex tasks.

Test Automation Technology/Product Knowledge:

• Working knowledge of Automation tools.
• Able to independently create and execute medium to complex automation scripts for functional testing.
• Develop automation frameworks with guidance.

Required Behavioral Competencies

Accountability:

• Takes responsibility for and ensures accuracy of own work, as well as the work and deadlines of the team.

Collaboration:

• Participates in team activities and reaches out to others in team to achieve common goals.

Agility:

• Demonstrates a willingness to accept and embrace differing ideas or perceptions which are beneficial to the organization.

Customer Focus:

• Displays awareness of customers stated needs and gives priority to meeting and exceeding customer expectations at or above expected quality within stipulated time.

Communication:

• Targets communications for the appropriate audience, clearly articulating and presenting his/her position or decision.

Drives Results:

• Sets realistic stretch goals for self & others to achieve and exceed defined goals/targets.

Certifications

Basic Tool CertificationsSeU Certified Selenium Engineer with Java

 

At YASH, you are empowered to create a career that will take you to where you want to go while working in an inclusive team environment. We leverage career-oriented skilling models and optimize our collective intelligence aided with technology for continuous learning, unlearning, and relearning at a rapid pace and scale.

 

Our Hyperlearning workplace is grounded upon four principles

• Flexible work arrangements, Free spirit, and emotional positivity
• Agile self-determination, trust, transparency, and open collaboration
• All Support needed for the realization of business goals,
• Stable employment with a great atmosphere and ethical corporate culture

Experience Level

Senior Level