Senior Test Analyst (ETL Tester)

Role Purpose

Develop and executed automated/manual test suites using TSQL and other custom tools (Ex, MS Excel); Integrate test suites into the test management system and custom test harnesses; and, Perform other testing-related duties as required.

Principal Accountabilities

Key Responsibilities and Duties:

Technical:

• Experience in using tools like TSQL scrips, Visual Studio Tests, Azure DevOps
• Experience in SSIS or Azure Data Factory pipeline testing
• Experience in testing Cloud (preferably Azure) systems
• Review requirements, specifications, user documentation, help files, and other project documentation to assure quality of the products and tests to be developed; i.e., perform manual static testing.
• Select and develop appropriate test automation tools, applying the latest techniques in test automation; e.g., data-driven testing.
• Work with the Development team to capture and reuse automated Unit Test Cases, Test Stubs and Drivers, and other Development test objects.
• Participate in Scrum meetings to identify the quality implications of known bugs and the impact of proposed changes to product definition on the testing process.
• Work with the Release Engineering team to create and maintain an automated nightly build verification (“smoke”) test.
• Ensure proper version control and configuration management of all test objects developed and test environments used.
• Research and document bug reports following agreed-upon processes immediately upon discovery of a quality problem.
• Update test execution status following agreed-upon processes as part of regularly-scheduled test status updates.
• Trace test cases and results back to specific quality risks.

Assist the Project Manager in the creation of test project status reports and metrics (e.g., Test Dashboard).

Requirements

Essential Competencies

Education:

• First class and above grade in BE/BTECH/MCA equivalent degree from a university of UGC accreted.

Competencies:

• Fluent in spoken English and able to take part in meetings and discussions.
• Proactive personality and able to work autonomously.
• Exceptional oral and written communication skills.
• Good team player.
• The ability to work to agreed deadlines.
• Ability to work at detailed and abstract levels.
• Ability to guide junior team members.
• Self-learner.
• Track record of delivering commitments on time and qualit

Skills:

• Experience in TSQL & Queries
• Experience in Microsoft Technologies like, MS SQL Server, SSIS package writing or testing DevOps, etc
• Experience in Report testing (PBI & MS Excel)
• Mathematical aptitude and strong problem-solving skills
• Excellent organisational and time management skills·
• Accuracy and attention to detail
• An understanding of the latest trends and their role in a commercial environment
• Teamwork skills (Offshore and Onshore models)
• Experienced in an Agile Scrum/Kanban environment
• Self-development skills to keep up to date with fast-changing trends

Mandatory Skills

Microsoft SQL Server, TSQL

SSIS

DevOps or JIRA

Postman

Agile

Visual or Front end Testing

Tableu/PBI

JMeter

Cloud Databases

Excel

Azure