ROLE : SR. SDET
Job Overview:
We are seeking a Senior Quality Assurance Engineer. Our ideal candidate will be responsible for designing and executing tests manually (15%) and automatically (85%) to identify and resolve all data related issues to meet quality standards. Our tight-knit team combines a Scrum process with a strong testing culture.
Responsibilities:
* Build and perform End to End QA effort on Data Warehouse/ETL/BI Platforms
* Review requirements, specifications and technical design documents to provide timely and meaningful feedback
* Understand data flow and test strategy for ETL, Data warehouse and Business Intelligence testing
* ETL testing of mapping, transformations and data pipelines.
* Data warehouse testing involving the testing of stored procedures, SSIS packages, slowly changing dimension tables, Change Data capture etc.
* Business Intelligence testing involving the validation of DataMart, ODS, Data models and SSRS reports.
* Create detailed, comprehensive and well-structured test plans and test cases
* Identify, document and track software defects
* Work closely with development teams to perform root cause analysis of issues
* Manage multiple tasks and adjust to shifting priorities, as necessary
* Write advanced SQL queries for ETL/data warehousing/Business Intelligence testing
* Identify test cases which has to be automated. Prepare test automation strategy.
* Design and develop test automation for backend. Work with the team to continually improve test processes and practices based on inspection/adaption of previous iterations and to ensure adherence to process, tools and metrics standards within the project team.
* Show initiatives and accountability with strong time management skills with project teams.
* Exhibit strong collaboration/interpersonal skills
* Be a self-starter and possess the ability to research issues and improve processes.
We want strong collaborators who can deliver a world-class client experience. We are looking for people who thrive in a fast-paced environment, are client-focused, team oriented, and are able to execute in a way that encourages creativity and continuous improvement.
Requirements:
* Bachelor’s Degree, Computer Science or similar, plus 6+ years of experience OR master’s degree, Computer Science or similar, plus 5+ years of experience OR no degree, plus 10+ years of experience working as a Developer or QA Engineer or SDET working in Agile scrum teams.
* 5 – 10 years of experience with Software Quality Assurance- QA project life cycle, test plan, test strategies, test scenarios, test cases, traceability matrix.
* 3 - 5+ years of experience in Database/Data Warehouse/ETL Testing.
* 3 - 5+ years of Strong experience in advanced SQL scripting.
* Experience in MS SQL server, SSIS and SSRS.
* 3+ years’ experience of Data Lake/Hadoop platform implementation.
* 3+ years of hands-on experience in implementation and performance tuning Hadoop/Spark implementations.
Core Competencies:
* Experience in ETL testing techniques
* Good understanding of Data Warehousing and business intelligence concepts and testing techniques
* Experience in Working with Star Schema, ODS, multi-dimensional models, slowly changing dimensions
* Experience in working with ETL framework, Change Data capture, DataMart, Data models etc.
* Working knowledge of test automation for backend using Java and associated frameworks
* Experience in continuous testing practices in a CI/CD development pipeline, and deploying test automation
* Solid experience in strategizing and planning all testing activities including automation.
* Ability to review and analyze business requirements in order to produce test strategy and test cases.
* Expertise working in Cloud data environment
* Familiarity with one or more SQL-on-Hadoop technology (Hive, Impala, Spark SQL, Presto) • Experience in Agile projects (Scrum, Kanban etc.).
* Working Knowledge in Test Management software (JIRA,qTest).
* Solid experience with Defect Management Process.
* Quick learner and self-starter who requires minimal supervision to excel in a dynamic environment. • Excellent analytical and problem-solving skills.
* Strong verbal and written communications skills.
* Experience in Banking or Financial services domain is preferred.
* Experience in working with financial platforms
* Experience in Cluster, Containers/VMs, On Premise, On Cloud
* Strong knowledge on Data Lake, Azure, ELT & ETL, Data Warehouse, BI, Data Factory Tools
* Strong in SQL preparation in Oracle/SQL Server/NoSQL/RDMS/Big Data
Preferences:
* Awareness of Agile QA Software development life cycle –backlog, sprints, standups, burndowns.
|
Sender notified by
Mailtrack
| 09/11/23, 06:54:04 AM |
|