SQL/hadoop Developer - Hybrid

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.