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.
Rate:
Not specified
Location:
Remote
IR35 Status:
Outside
Remote Status:
Remote
Industry:
Data & Analytics
Seniority Level:
Senior