Compu-Vision Consulting, Inc.
Compu-Vision Consulting, Inc.

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

Remote • Posted 47 minutes ago • Updated 42 minutes ago
Contract Corp To Corp
Contract Independent
Contract W2
12 Months
No Travel Required
Remote
50+
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • z/OS
  • System Integration Testing
  • System Testing
  • Transact-SQL
  • Software Development Methodology
  • Unit Testing
  • Quality Assurance
  • SQL
  • Streaming
  • Microsoft SSIS
  • Payroll
  • Public Sector
  • Mapping
  • Marketing Operations
  • Microsoft Azure
  • Finance
  • Flat File
  • IBM DB2
  • JCL
  • Enterprise Resource Planning
  • Extract
  • Transform
  • Load
  • Data Quality
  • Data Warehouse
  • CGI
  • COBOL
  • Cloud Computing
  • Application Development
  • Batch Processing
  • .NET
  • ADO
  • Acceptance Testing
  • Recovery
  • VSAM
  • Warehouse
  • Accounting
  • C#
  • Data Domain
  • DevOps

Summary

Title: SQL/SSIS Lead (Data Engineer)
Duration: 9-12 Months - CONTRACT [NO BENEFITS]
Location: Remote (some onsite in Jefferson City, MO)

Job Summary:
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.

Responsibilities:

  • 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.

Required Qualifications:

  • 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.
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.
  • Dice Id: 10468931
  • Position Id: 26-16417
  • Posted 47 minutes ago
Contact the job poster
noni sharma

noni sharma

Compu-Vision Consulting, Inc. Sourcing Specialist @ Compu-Vision Consulting, Inc.

View Profile
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.
Remote jobs at Compu-Vision Consulting, Inc.