Hi,
Our client is seeking a XGEN IBM core banking engineer contractor to bridge the gap between model development and production. Kindly find the detailed job description below, if interested apply with your updated resume and contact info.
Job Description: Senior Core Banking Engineer — XGEN & IBM i Data Specialist
Function: Core Banking Engineering
Location: Remote / Hybrid (US-based) Employment
Type: 6+Contract
Experience Level: Senior (7+ years)
About the Role
We are looking for a seasoned Core Banking Engineer with deep, hands-on expertise in XGEN — the enterprise report writing, data extraction, and output generation platform used within IBM i / AS400 based core banking environments. This role sits at the intersection of core banking operations, data engineering, and regulatory compliance — partnering directly with business stakeholders, compliance teams, and downstream integration consumers to design, build, and optimize XGEN-driven solutions that power critical banking, regulatory, and analytics functions. You will serve as the primary XGEN subject-matter expert within the engagement, translating complex banking data requirements into reliable, performant, and auditable extracts and reports from the core banking platform. Your work will directly support regulatory reporting, business intelligence, operational analytics, and core modernization initiatives.
What You Will Do
XGEN Report & Extract Development • Design, build, and maintain complex XGEN report definitions and data extracts against IBM i / AS400 physical and logical file structures in a core banking environment
• Develop multi-level hierarchical XGEN reports with advanced selection criteria, field-level conditional logic, grouping, sorting, sequencing, and output formatting
• Build and schedule batch extracts for downstream consumption — producing fixed-width, pipe delimited, comma-delimited, and custom-format output files for BI platforms, data warehouses, and third-party integrations
• Optimize XGEN extract performance on high-volume banking databases applying logical file key sequencing, selection criteria tuning, and batch window awareness to ensure extracts complete reliably within operational constraints
• Maintain complete documentation for all XGEN report and extract definitions including field mappings, selection logic, scheduling parameters, output format specifications, and data lineage
IBM i Data Architecture & File Management
• Demonstrate deep working knowledge of IBM i / AS400 physical file (PF) and logical file (LF) structures as they apply to core banking data domains — accounts, transactions, general ledger, customer information, loans, deposits, and payments
• Navigate multi-file core banking data models — identifying the correct source files, understanding key structures, and constructing logical access paths that support accurate and complete XGEN outputs
• Advice on IBM i data access patterns, file locking behavior, and batch cycle constraints that directly affect extract design, scheduling, and reliability
• Apply IBM i DB2 query and SQL skills as a complement to XGEN where native IBM i querying provides performance or flexibility advantages
• Manage IBM i job scheduling — defining job queue priorities, managing dependencies between extract jobs, and aligning extract schedules with core banking batch processing windows to prevent conflicts
Regulatory & Compliance Reporting
• Build and maintain XGEN-driven outputs for regulatory reporting obligations including but not limited to Call Report data feeds, HMDA extract preparation, BSA/AML data pulls, CRA reporting, Federal Reserve submissions, and NCUA/FDIC compliance extracts
• Map core banking data fields to regulatory reporting schemas — handling cases where regulatory requirements span multiple source files or require derived and calculated fields • Validate field-level accuracy of regulatory extracts against compliance requirements and audit standards
• Produce ad hoc data extracts and supporting documentation for internal audit, external examination, and regulatory inquiry responses
• Proactively update XGEN extract logic and field mappings as regulatory reporting requirements evolve
Integration & Data Engineering
• Design XGEN-produced output files that feed downstream systems — data warehouses, BI platforms, core modernization middleware, payment systems, and third-party fintech vendors
• Collaborate with data engineering teams to define transformation logic between raw XGEN extract formats and target data models in modern analytics and integration platforms
• Support ETL/ELT pipeline design for ingesting XGEN outputs — addressing format validation, error detection, reconciliation, and load monitoring requirements
• Work with integration middleware teams where XGEN-sourced data feeds near-real-time or API driven services, advising on extract frequency, format, and latency constraints
• Partner with BI and analytics teams consuming XGEN data — supporting data model design, field definition, and data quality validation in downstream platforms such as Power BI, Tableau, or MicroStrategy
Core Modernization & Migration Support
• Support core banking modernization and platform migration engagements by inventorying, documenting, and mapping all existing XGEN reports and scheduled extracts in scope
• For each XGEN extract in scope, document business purpose, data sources, scheduling cadence, output format, recipients, and all downstream system dependencies — creating a complete migration reference artefact
• Map XGEN source data fields to target platform data models — identifying gaps, mismatches, and transformation requirements that must be resolved before migration
• Perform data equivalency validation between source XGEN extracts and target platform outputs — ensuring completeness, accuracy, and format consistency before cut-over • Advise on data cleansing, deduplication, and format normalization requirements discovered during source data profiling using XGEN
Client & Stakeholder Engagement
• Work directly with bank operations staff, compliance officers, finance teams, and IT leadership to gather XGEN report and extract requirements, explain technical constraints, and deliver solutions that meet business needs
• Conduct knowledge transfer sessions and hands-on training for client staff covering XGEN report usage, scheduling, output interpretation, and basic maintenance
• Participate in agile ceremonies — sprint planning, backlog grooming, sprint reviews — as the XGEN and IBM i data SME
• Produce clear, maintainable technical documentation including data dictionaries, extract specifications, field mapping registers, scheduling runbooks, and operational guides for client teams
Must-Have Experience
• 7+ years of hands-on experience in IBM i / AS400-based core banking environments in a technical data or engineering capacity
• 5+ years of direct, production-grade XGEN experience — designing and building complex report definitions and data extracts from scratch, not merely running or maintaining existing reports built by others
• Deep working knowledge of IBM i physical file and logical file structures across core banking data domains — accounts, transactions, GL, customer, loans, and deposits
• Demonstrated experience building XGEN outputs for regulatory reporting — Call Report, HMDA, BSA/AML, CRA, or equivalent US banking regulatory obligations
• Hands-on experience with IBM i job scheduling, batch window management, and the operational discipline required to run large extracts in a live banking production environment
• Proven ability to design XGEN selection criteria and logical file access paths that optimize performance on large banking databases
• Experience producing XGEN output files consumed by downstream data warehouses, BI platforms, or integration middleware
• Strong working knowledge of community or regional bank operations — deposit and loan products, payment processing workflows, and the regulatory environment governing US commercial banking
Strong Preference
• Experience supporting a core banking platform migration — specifically the work of inventorying, mapping, and validating XGEN-driven extracts against a target platform
• Proficiency in IBM i / RPG, CL, or SQL for data access needs that extend beyond what XGEN natively provides
• Experience delivering XGEN outputs into modern BI platforms such as Power BI, Tableau, or MicroStrategy — including the transformation and data modelling layer
• Exposure to ETL/ELT tooling and modern data pipeline design as applied to core banking data
• Familiarity with data governance, data quality, and data lineage frameworks in regulated financial services environments
• Experience working in an agile product engineering delivery model with sprint-based accountability
• Domain knowledge in BSA/AML, CRA, HMDA, or other US community banking compliance areas
Education
• Bachelor’s degree in computer science, Information Systems, Finance Technology, or a related field — or equivalent practical experience in a banking technology environment
• IBM i, data engineering, or banking technology certifications are a plus but not required in the presence of strong demonstrated experience
We are an Equal Opportunity Employer