Lead Consultant ETL Tester

Job Description

With a startup spirit and 115,000 + curious and courageous minds, we have the expertise to go deep with the world&rsquos biggest brands&mdashand we have fun doing it! We dream in digital, dare in reality, and reinvent the ways companies work to make an impact far bigger than just our bottom line. We&rsquore harnessing the power of technology and humanity to create meaningful transformation that moves us forward in our pursuit of a world that works better for people. Now, we&rsquore calling upon the thinkers and doers, those with a natural curiosity and a hunger to keep learning, keep growing. People who thrive on fearlessly experimenting, seizing opportunities, and pushing boundaries to turn our vision into reality. And as you help us create a better world, we will help you build your own intellectual firepower.

Welcome to the relentless pursuit of better.

Inviting applications for the role of Lead Consultant - ETL Tester

In this role, you would be responsible for providing Enhancement & testing services in a ETL Talend environment. Candidate will be working with SMEs, Scrum Master, Product Owner & Users to complete end-to-end SDLC for a fintech client.

Responsibilities

.Additional responsibilities shall include contributing to designing and documenting of the software architecture based on existing architecture and inputs received from Client from time to time.

.Perform unit testing, integration testing and UAT as and when required.

.Also, engage with Client in requirement gathering, Status update on work, UAT and be the key partner in the overall engagement.

.Writing complex SQL queries, ability to determine the type of Data & Regression.

.Responsible to track defects using i.e., Jira

Qualifications we seek in you!

Minimum qualifications

.BE/B Tech/MCA with relevant work experience

.Relevant work experience as ETL Testing

Preferred qualifications/ skills

.It is essential that you have experience in creation of necessary infrastructure for ETL jobs using MSBI (SSIS, SSRS, SQL server (SQL and stored procedures, functions, triggers mandatory skills) and Talend from a wide range of data sources.

.Relevant years of Software Quality Assurance experience on enterprise level applications which includes Data Warehouse Testing.

.Experience in writing complex SQL queries, ability to determine the types of testing that must be conducted (i.e., data validation, regression, etc.), including evaluating the testability of requirements and create a comprehensive test plan that supports the business and technological solutions being delivered.

.Should have experience testing multiple test phases in medium to large projects.

.Should have adequate experience and clear understanding of data warehouse and data mart testing.

.Identification and Test Data Preparation Techniques. Thorough knowledge of Software Test Life Cycle, Test Case Life Cycle, Defect Life Cycle etc. Proficiency with Test Case Preparation and Execution.

.QA Automation Test tools expertise in Selenium, Test Ng, Cucumber, Appium, etc. Extensive exposure to Back-end/ETL Testing with high-level of SQL skills is required.

.Possess experience in using Informatica suite of tools. Must have Talend Open Studio Experience

.Should have exposure to large data sets and understand Data Quality Framework.

.Experience in data analysis, including profiling, auditing, balancing, and reconciliation, in an information technology operating environment.

.Knowledge of data models and entity relationship diagrams