Talent.com
SQL/hadoop Developer - Hybrid
SQL/hadoop Developer - HybridTEKsystems • Harrisburg, NC, USA
SQL / hadoop Developer - Hybrid

SQL / hadoop Developer - Hybrid

TEKsystems • Harrisburg, NC, USA
[job_card.30_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
[job_card.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.

    [job_alerts.create_a_job]

    Developer Hybrid • Harrisburg, NC, USA

    [internal_linking.similar_jobs]
    Data Analyst

    Data Analyst

    SteerBridge • Cherry, NC, US
    [job_card.full_time]
    SteerBridge Strategies is a CVE-Verified Service-Disabled, Veteran-Owned Small Business (SDVOSB) delivering a broad spectrum of professional services to the U. Backed by decades of hands-on experien...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Damper Engineer - IndyCar

    Damper Engineer - IndyCar

    Penske Racing South • Mooresville, NC, US
    [job_card.full_time]
    This role involves working closely with a small team of engineers and technicians while also collaborating with the broader engineering group. The successful candidate will contribute to damper asse...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Senior Java Developer

    Senior Java Developer

    Two95 International Inc. • Mooresville, NC, US
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Java 6 and above and knowledge of latest Java (8 / 9) features.Spring Boot / Spring Batch experience.Neo4J, GCP (google cloud platform) & Kafka experience are a plus. Working experience with data pl...[show_more]
    [last_updated.last_updated_30]
    Tulip App Developer

    Tulip App Developer

    Ascii Group, LLC • Concord, NC, United States
    [job_card.full_time]
    Responsible for Tulip app Design and development.Responsible for Design and documenting of Mendix App.Work with the different teams on interfaces. Assist or drive status meetings to communicate and ...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Android Developer

    Android Developer

    Adidev Technologies Inc • Matthews, NC, US
    [job_card.full_time]
    Adidev Technologies is looking for entry and mid-level Android developers with at least 1 - 2 years of experience.Must be open to working onsite, no. Must be a driven self-starter and must be willin...[show_more]
    [last_updated.last_updated_30] • [promoted]
    CDL-A OTR Company Driver - Affordable Benefits Package + $98,280 Per Year Per Driver

    CDL-A OTR Company Driver - Affordable Benefits Package + $98,280 Per Year Per Driver

    Forward • Stallings, NC
    [job_card.full_time]
    Searching for a company that values team drivers and rewards your miles? Forward is actively hiring.When driving with Forward, you can expect consistent miles, industry-leading benefits and a compe...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    CDL A OTR Company Driver Competitive Pay with Lease Purchase Available

    CDL A OTR Company Driver Competitive Pay with Lease Purchase Available

    Hirschbach Motor Lines • Mooresville, NC
    [job_card.full_time]
    CDL A OTR Truck Drivers Company and Lease Purchase Options.Hirschbach Motor Lines has immediate lease opportunities for independent contractors and company driver positions.Monthly Safety & Perfo...[show_more]
    [last_updated.last_updated_30] • [promoted]
    iOS Developer

    iOS Developer

    Adidev Technologies Inc • Matthews, NC, US
    [job_card.full_time]
    Adidev Technologies is looking for entry-level and mid-level iOS developers with 1 year - to 3 years of experience.Must be open to relocation and working onsite following the lifting of Covid-19 re...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Remote Senior SQL Engineer - AI Trainer

    Remote Senior SQL Engineer - AI Trainer

    SuperAnnotate • Kannapolis, North Carolina, US
    [filters.remote]
    [job_card.full_time]
    As a Senior SQL Engineer, you will work remotely on an hourly paid basis to review AI-generated SQL queries, database designs, and data-processing logic, as well as generate high-quality reference ...[show_more]
    [last_updated.last_updated_variable_days]
    Senior Software Engineer, Core Experiences - Concord, USA

    Senior Software Engineer, Core Experiences - Concord, USA

    Speechify • Concord, NC, US
    [job_card.full_time]
    Speechify is the easiest way to listen to the world's information.Articles on the web, documents in the cloud, books on your phone. We absorb it all and let you listen to it at your desk, on the...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Tech Lead, Android Core Product - Concord, USA

    Tech Lead, Android Core Product - Concord, USA

    Speechify • Concord, NC, US
    [job_card.full_time]
    The mission of Speechify is to make sure that reading is never a barrier to learning.Over 50 million people use Speechify's text-to-speech products to turn whatever they're reading – ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Senior Engineer

    Senior Engineer

    Qvest US • Concord, NC, US
    [job_card.full_time]
    Qvest US is the global leader in technology and business consulting for the Media & Entertainment and Consumer Packaged Goods & Retail industries. We strategize, advise, design, develop...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Data Analyst (Remote)

    Data Analyst (Remote)

    Quality Talent Group • Matthews, NC, US
    [filters.remote]
    [job_card.full_time]
    Our client is a leading force in advancing safer, smarter AI technology.Their work has been featured in.They have built a global community of expert contributors and have paid more than.No contract...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Need Business Analyst with Azure DevOps experience

    Need Business Analyst with Azure DevOps experience

    ICS Global Soft INC • Matthews, NC, US
    [job_card.full_time]
    We are looking for a Business Analystwho will be the vital link between our information technology capacity and ourbusiness objectives by supporting and ensuring the successful completion ofanalyti...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Remote Side Hustle Developer

    Remote Side Hustle Developer

    Finance Buzz • Mooresville, North Carolina, US
    [filters.remote]
    [job_card.full_time] +1
    This position is for individuals who want to develop a side income stream while still working full time.You will test different small-scale remote opportunities, learn what works, and grow what pro...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Database Administrator

    Database Administrator

    McGee Corporation • Matthews, NC, US
    [job_card.full_time]
    Applicants must be local to Matthews, NC.Continuous Improvement Manager.We are seeking a skilled Database Administrator (DBA) with expertise in Oracle (particularly older versions) and Microsoft SQ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Sr. Java Developer (Microservices)

    Sr. Java Developer (Microservices)

    Two95 International Inc. • Mooresville, NC, US
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Java 6 and above and knowledge of latest Java (8 / 9) features.Spring Boot / Spring Batch experience.Neo4J, GCP (google cloud platform) & Kafka experience are a plus. Working experience with data pl...[show_more]
    [last_updated.last_updated_30]
    CNA Hiring | $16-$18 / hr

    CNA Hiring | $16-$18 / hr

    2nd Family • Waxhaw, NC, US
    [job_card.full_time]
    Be a key player in shaping our company culture and building a successful brand from the beginning.We encourage entrepreneurial thinking, always seeking to enhance the care experience for our client...[show_more]
    [last_updated.last_updated_1_day]