Sql server developer h1.location_city

Detailed Job Description

We are looking for *SQL / Hadoop QA Experts* for

Enterprise Complaints Reporting & Analytics India Team.

• Job Description : *

The resource will be primarily working on

requests like- AdHocs, QAQC, Transcription and Validation and other data mining

work within Enterprise Complaints Reporting & Analytics Team.

QA Tester will work together with incumbent data

engineers, batch operations analysts, application SMEs, and DBAs. This person

may also need to work with technical resources at third-party partner

organizations in order to gather specifications for data sent by or sent to

said partner. Finally, they will closely partner with QA and UAT teams in order

to tie together test cycles and to make sure that the test cases being run are

in service towards the new features being built.

Day to Day Responsibilities

• Strong working experience with *MS SQL Server*

Databases and highly proficient with *complex SQL scripting* to validate

source / target data load and transformation.

• Experience in Any Automation tool
• Experience in Bigdata data pipeline testing

with *Hadoop / Spark framework* in private cloud infrastructure.

• Hands-on experience and strong understanding

of Software Development Life Cycle (SDLC) and Software Testing Life Cycle

STLC) on Agile Scrum environments

• Exposure to Data Warehousing and Dimensional

Modelling Concepts

• Experience in understanding of *ETL* Source to

Target Mapping Document

• Knowledge of applying the Spark Data Frame API

concepts using *PySpark *to complete data manipulation tasks

• Very good understanding of business

intelligence concepts, architecture &building blocks in areas ETL

processing, Data warehouse, dashboards and analytics.

• Good to have knowledge in scripting languages

like Python to create automated Test Scripts

• Experience on different types of testing that

includes Black Box testing, Smoke testing, Functional testing, System

Integration testing, End-to-End Testing, Regression testing & User

Acceptance Testing (UAT) & Involved in Load Testing, Performance Testing &

Stress Testing as needed.

• Hands-on experience and strong understanding

of Software Development Life Cycle (SDLC) and Software Testing Life Cycle

STLC) on Agile Scrum environments.

• Expertise in using JIRA / Excel for writing

the Test Cases and tracking the Defects.

• Participate in Defect Triaging during Major

releases and track the defects for resolution / conclusion

• An effective communicator with strong

analytical abilities combined with skills to plan, implement & presentation

of projects

• Required Skills : *
• 3+ year of Python, Sparks
• 7+ years of MS SQL
• 7+ years of a scripting language (PowerShell,

Python, etc.)

• Experience with an enterprise scheduler such

as AutoSys

• Experience with an ETL toolset such as

Informatica or SSIS

• Experience creating automated regression

testbeds, including creating meaningful input test data

• Experience with scrubbing or anonymizing of

private identifying information in a sensitive dataset

• Experience with reading and creating entity

relationship diagrams, data flow diagrams, and data architecture diagrams

• Preferred Skills : *
• Experience working with third-party teams,

such as on a partner integration project

• Experience with ticketing systems like HP

Mercury, JIRA

• Experience with Splunk
• Experience on a QA team or with Test First

Development may help quite a bit

• Top 3 MUST Have : *
• 1. Python / Sparks*
• 2. MS SQL*
• 3. Python, Powershell, Etc.*

About TEKsystems :

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.