About the roleAs a Banking Conversion Programmer, you will be responsible for designing, developing, and executing data conversion solutions for financial institutions implementing the Fiserv DNA core banking platform. We are looking for two experts: one in the deposit area, and the other in the loans area. Other areas of skills will be reviewed as well.
Working closely with Project Managers, Business Data Analysts, and clients, you will develop conversion routines, validate data integrity, troubleshoot complex issues, and ensure successful implementation of critical banking data. This is a highly collaborative role that combines software development, database programming, data analysis, and client-facing consulting.
What you'll do- Design, develop, and maintain data conversion programs using Oracle SQL and PL/SQL.
- Convert and validate banking data, including:
- Customer Information Files (CIF)
- Consumer and commercial deposit accounts
- Consumer and commercial loan accounts
- Person and organization records
- Ownership relationships
- Cards
- Electronic agreements
- Other core banking data
- Analyze donor system data and develop SQL-based transformation and conversion logic for migration to the Fiserv DNA platform.
- Perform data validation, reconciliation, and quality assurance testing throughout the implementation lifecycle.
- Troubleshoot conversion issues and develop effective technical solutions.
- Produce conversion reports and assist with data cleanup activities.
- Collaborate with Consultants, Data Analysts, Project Managers, and client teams to ensure successful project delivery.
- Participate in implementation milestones, including occasional evening or weekend conversion activities.
- Contribute to continuous improvement of conversion tools, processes, and documentation.
QualificationsRequired- Experience developing Oracle SQL and PL/SQL solutions.
- Strong experience working with Oracle databases and relational database concepts.
- Experience with Fiserv DNA implementations, with a thorough knowledge of the back end data tables.
- Experience writing complex SQL queries, stored procedures, packages, and performance tuning.
- Strong analytical and problem-solving skills.
- Excellent verbal and written communication skills.
- Ability to manage multiple priorities in a fast-paced consulting environment.
- Experience working independently in a fully remote environment.
Preferred- Understanding of banking operations, including:
- Deposits
- Loans
- Customer Information Files (CIF)
- General Ledger
- Debit and credit cards
- Experience with ETL processes and large-scale data migrations.
- Knowledge of banking regulations, data privacy requirements, and data governance.
The pay range for this role is:
100,000 - 129,375 CAD per year (CA)
