SQL​/hadoop Developer - Hybrid

Detailed Job Description

We are looking for SQL / Hadoop QA Experts for

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.

• Strong working experience with MS SQL Server
• Highly proficient with complex SQL scripting to validate source/target data load and transformation
• Experience in any automation tool
• Experience in Big Data data pipeline testing with Hadoop / Spark framework in private cloud infrastructure
• Hands‑on experience and strong understanding of SDLC and 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 of 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) and involved in Load Testing, Performance Testing & Stress Testing as needed
• 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

• 3+ years of Python, Sparks
• 7+ years of MS SQL
• 7+ years of a scripting language (Power Shell, Python, etc.)
• Experience with an enterprise scheduler such as Auto Sys
• 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 private identifying information in a sensitive dataset
• Experience with reading and creating entity relationship diagrams, data flow diagrams, and data architecture diagrams

• 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

• Python / Sparks
• MS SQL
• Python, Power Shell, Etc.

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.