NCS

140 E 45th Street, Suite 16B
New York, NY 10017

CAREERS @ NCS

 

ETL data quality analyst

LOCATION: Oldsmar, FL

ABOUT THE ROLE:
The ETL (Extract, Transform and Load) Data Quality Analyst will be responsible for performing testing of our applications, ensuring accurate reporting is completed, and revisions and recommendations are made for improvements based on test results.

RESPONSIBILITIES:

  • Performs quality control and quality assurance testing of applications using a set of testing tools, testing framework, processes and methodologies
  • Create Test Plans to ensure the delivery of test data to data warehouses used in downstream systems
  • Reviews requirements and other project documentation and provides feedback, with an emphasis on testability
  • Creating or modifying test scripts and use cases based on requirements.
  • Validate and analyze data loaded into the data warehouses
  • Participates in technical design reviews, component/code reviews, and testing reviews
  • Provides feedback as to the testability and ensures that business requirements are met
  • Executes detailed test cases/scripts and associated data employing manual testing using Unix scripting
  • Documents test procedures and findings
  • Researches, documents, assesses, and facilitates the resolution of incidents
  • Assess and revise test sequence and scope based upon test results and or changes in product design
  • Makes recommendations based on assessed risks to quality by applying various verification and validation techniques in coordination with the Development Team (QA Lead, Project Managers, and Development Managers)
  • Work closely within other NCS teams for various needs:
  • The QA Lead to design and ensure the overall integrity of the testing strategy
    Application Development teams preparing data for their testing/validation needs.
  • Operations Team for data support questions and tasks
  • DBA Team to test data load processes
  • Data analysis / Tracking down sources of unexpected results or unusual data

REQUIRED EXPERIENCE: 

  • Minimum of 7 or more years of IT experience with 4 years in manual testing data load processes, focusing on complex SQL queries
  • Experience interpreting and understanding data models and ER diagrams
  • Data warehouse testing experience
  • Knowledge and experience with scripting languages

DESIRED EXPERIENCE: 

  • Experience in CPG or Media research
  • Knowledgeable in RDBMS systems such as Yellowbrick and Oracle with ‘nice to have experience in AWS and Snowflake systems.
  • Experience in SQL

POSITION QUALIFICATIONS: 

  • Bachelor’s degree in computer science or related
  • Highly developed analytical, problem-solving, and communication skills with a strong focus on detail
  • Understanding relational database objects and views
  • Understanding database load strategies
  • Expert in Relational Database testing with excellent PL SQL skills and queries
  • Ability to multi-task and remain flexible when priorities or work direction change
 
 Position Name: Infrastructure ETL QA