ETL Tester

Overview

On Site
$50 - $60
Full Time

Skills

Automated Testing
Data Security
ETL QA
Data Warehouse
SQL
Test Cases
JIRA
JSON
VBScript
Shell Scripting
.NET
SSIS
Microsoft SSIS
Snow Flake Schema
Functional Testing
System Testing

Job Details

Job Description Data ETL Tester

Client / Project

The New York City Public Schools is the largest school system in the United States, with over 1.1 million students taught in more than 1,800 separate schools. They have over 80,000 employees and hundreds of thousands of vendors that interact with NYC DOE on a yearly basis.

Project Overview

* Develop a Next Generation Student Information System (NGSIS) to modernize DOE s legacy student information systems and data applications.

* Build a single online interface that presents school users and parents with biographical, academic, and programmatic data for students.

* Consolidate all data workflows in the systems that currently hold student information.

* Establish new workflows to help school administrators and teachers manage student record-keeping and other school-based academic tasks.

* Decommission legacy systems as functions are successfully deployed within the new environment

* Maintain the highest standards for data security when information accessed through the browser and when information is stored to the database.

* Provide a configurable system that allows authorized users to update important aspects of the implemented solution i.e. manage lookups, workflow, rules, role-based access levels, etc.

Role and Responsibilities:

  • Data Validation & Integrity Ensure data is correctly extracted, transformed, and loaded into target systems.
  • Test Case Design Develop and execute test cases for ETL processes.
  • ETL Functional Testing Write and run complex SQL queries and stored procedures to verify data correctness. Test the ETL packages for full load and incremental. Verify the data between SQL Server Source to Target; Flat files to SQL Server; JSON to SQL Server and vice versa.
  • Performance Testing Identify performance bottlenecks and help ETL developers in optimizing the ETL workflows.
  • Defect Tracking & Resolution Log and resolve data discrepancies using JIRA.
  • Automation Implement automated testing frameworks for ETL validation.
  • Collaboration Work with data engineers, analysts, and ETL developers to ensure smooth data operations.

Skill Sets:

Required

2 / 2

  • BS or MS in Computer Science, Information Technology or related field
  • Strong SQL and database knowledge.
  • Strong experience with SQL Server and SSIS.
  • Familiarity with data warehousing concepts (star schema, snowflake schema).
  • Knowledge of Power Shell scripting/.NET/Python/VB Scripting for creating automation frameworks for ETL testing.
  • Understanding of data governance and compliance.

Nice to Have

* New York city area (NYC, New Jersey, Conn)

* Government experience (Federal, state, city)

* Education experience building applications for higher ed or department of education

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.