About the Role

What You Will Do

• 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 formatspecifications, 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 sourcefiles, 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 extractpreparation, BSA/AML data pulls, CRA reporting, Federal Reserve submissions, and NCUA/FDIC compliance extracts
• Map core bankingdata fields to regulatory reporting schemas — handlingcases 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 pipelinedesign for ingestingXGEN outputs — addressing formatvalidation, error detection, reconciliation, and load monitoring requirements
• Work with integration middleware teams whereXGEN-sourced data feedsnear-real-time or API- driven services, advising on extract frequency, format, and latency constraints

• Partner with BI and analyticsteams 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 sourcedata fields to target platformdata models — identifying gaps, mismatches, and transformation requirements that must be resolved before migration
• Perform data equivalency validation between sourceXGEN extracts and target platform outputs
  • ensuringcompleteness, 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 reportand extract requirements, explain technical constraints, and deliver solutions that meet business needs
• Conduct knowledge transfersessions and hands-ontraining 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 logicalfile structures acrosscore 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 bankingplatform 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 extendbeyond 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/ELTtooling and moderndata pipeline designas applied to core bankingdata
• Familiarity with data governance, data quality, and data lineageframeworks in regulatedfinancial 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 bankingcompliance areas

Education

• Bachelor’s degree in computer science, Information Systems, Finance Technology, or a related field or equivalent practical experience in a bankingtechnology environment.
• IBM i, data engineering, or banking technology certifications are a plus but not required in the presence of strong demonstrated experience.