• Us Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 23rd Sep 2021

·         The QE / Database / Datawarehouse /BI /ETL Test Engineer will be responsible for participating in all test activities.

·         In this role you will be responsible to develop test automation strategies and take lead role in Database Testing, BI/DW/ETL Testing.

·         Exceptionally Strong SQL skills is must have for this position.

·         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

·         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/ALM).

·         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 is preferred

·         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

·         Bachelor's degree in Computer Science or related field.

·         5+ years of experience with Software Quality Assurance- QA project life cycle, test plan, test strategies, test scenarios, test cases, traceability matrix.

·         3 + years of experience in Database/Data Warehouse/ETL Testing.

·         3 + 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, including 3+ years of hands-on experience in implementation and performance tuning Hadoop/Spark implementations.

·         Awareness of Agile QA Software development life cycle –backlog, sprints, standups, burndowns.