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

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.

SQL Server Integration Services (SSIS), SQL (Structured Query Language), SQL Server Integration Services (SSIS), SQL (Structured Query Language), IBM z-OS Operating System, Warehousing, Data Warehousing, Database Extract Transform and Load (ETL), IBM DB2, Reconciliation, * 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.