WeAreDevelopers Logo WeAreDevelopers
Sign in
For You LIVE
Back

SQL/SSIS Lead (Data Engineer) - DE 26-16417

Compu-Vision Consulting Inc.
Jefferson City, MO, United States
3 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Working hours
Regular working hours
Job source
www.dice.com

Tech stack

Data Analysis Unit Testing Microsoft Azure Batch Processing C Sharp (Programming Language) COBOL (Programming Language) Extract Transform Load (ETL) Data Warehousing IBM DB2 DB2 SQL Document-Oriented Databases Job Control Language (JCL)
+11 more
Systems Development Life Cycle Software Engineering SQL Databases SQL Server Integration Services System Testing Transact-SQL Virtual Storage Access Methods Z/OS Azure Data Factory Data Layers Build Management

Job description

Owns the data layer of a data warehouse modernization program: source-to-target mapping, ETL/SSIS build, data loads, and reconciliation of financial, HR, and payroll data from DB2 z/OS into the target warehouse., * Analyze data warehouse sources (DB2 z/OS tables, VSAM, and flat-file extracts) and document data lineage.

  • Design and build SSIS packages and T-SQL for extract, transform, and load into the target warehouse.
  • Write source-to-target mappings and data-quality rules with the Business Analyst and Solution Architect.
  • Build reconciliation and balancing controls that prove legacy and new outputs match.
  • Tune SQL and load performance; support batch schedules and restart/recovery.
  • Own unit and system testing of data components, tracked in Azure DevOps.
  • Support SIT, UAT, and parallel runs; fix data defects.

Requirements

  • 7+ years of full SDLC application development, with 7+ years of QA testing.
  • 7+ years of SQL (T-SQL and DB2 SQL), including system/unit testing and batch processing.
  • 7+ years of DB2 z/OS with performance knowledge (reading, extracting, and tuning queries).
  • Working knowledge of COBOL and JCL (7+ years), enough to read extract programs and job streams.
  • Exposure to C# .NET.
  • Azure DevOps (ADO).
  • 5+ years of hands-on SSIS and data warehouse ETL.

Preferred Qualifications:

  • State or local government data warehouse experience (finance, HR, payroll).
  • Experience with CGI Advantage or another public sector ERP.
  • Accounting or payroll data domain knowledge; VSAM.
  • Azure Data Factory or Synapse, if the target is cloud.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Loading talks and stories from around this role…