PL/SQL Developer focusing on Oracle SQL and ODI with experience in relational databases and data warehousing. Collaborating on project delivery with strong data modeling and integration skills.
Responsibilities
Develop and maintain PL/SQL code and ODI mappings.
Handle flat files and other file-based sources through ODI.
Monitor and analyze database performance and reliability.
Collaborate with architects and teams for project delivery and knowledge sharing.
Requirements
Strong design and development experience in Oracle SQL, PL/SQL, and Oracle Data Integrator (ODI) 11g & 12c.
Experience in Oracle database design and data modeling.
Good understanding of OLTP transaction processing and how operational data is modeled and handled in relational databases.
Good understanding of financial data, metrics, and reporting requirements.
Strong experience in creating ODI mappings, interfaces, and ODI procedures.
Experience handling flat files and other file-based sources/targets through ODI, including file ingestion, transformations, and error handling.
Understanding of OLAP concepts and processes.
Experience monitoring, analyzing, and tuning reliability and performance for databases and ETL processes.
Ability to develop strategies to resolve issues and implement preventive measures to avoid future occurrences.
Data warehouse lifecycle management experience from design to implementation, including dimensional data modeling.
Experience with normalized OLTP, MDM, and dimensional modeling techniques, including Star and Snowflake schemas, slowly changing dimensions, dimensional hierarchies, and data classifications.
Experience maintaining, scaling, supporting, and expanding data persistence platforms using data integration tools and processes to populate and enhance reporting in distributed environments.
Working knowledge and understanding of the OBIEE Suite (OBI Server, Dashboards, and Analytics).
Knowledge of data modeling tools such as Oracle Designer, ERwin, TOAD, and DB Artisan.
Experience working closely with architects, team members, and management to increase delivery capacity for existing and upcoming projects, enable knowledge sharing, and provide depth in data warehousing, data integration, and BI solutions.
Exposure to the full software development lifecycle and AGILE/Scrum practices.
Effective verbal and written communication skills with both technical and non-technical stakeholders.
Senior iOS Engineer building scalable mobile products for EarnIn, an earned wage access company. Leading architecture, feature development, performance, APIs, testing, and data - informed improvements.
Dynamics Developer building Microsoft Dynamics and Power Platform applications for Capco’s financial - services clients. Supporting architecture, integrations, testing, DevOps, and production deployments.
Junior BA/BSA needed for 12 - month contract, 4 days onsite in Toronto. Must have 6+ years BA/BSA experience, Agile, and mobile/online banking/loyalty project experience.
Join a growing financial services organization as a Java Engineer on their Payments Technology team, building and enhancing critical payment platforms supporting ACH, Wires, RTP, and FedNow. You'll design, develop, and maintain backend applications using Java and Spring Boot, collaborating with cross - functional teams in a hybrid work environment.
Développeur principal concevant et intégrant des applications web pour la Ville de Montréal. Utilisation de Node.js, TypeScript, microservices, APIs et déploiements infonuagiques en environnement agile et DevOps.
Certinia Developer owning Softchoice’s customized PSA platform and Salesforce components. Designing SAP, SAP Concur, and MuleSoft integrations for this IT solutions provider.
Hotfix Developer resolving urgent production issues for Paystone, a North American payments and software company. Investigating transactional data, coding fixes, and deploying reliable client solutions.
Execute and support EFTR regulatory reporting activities, including data remediation and compliance. Ideal for professionals with AML reporting experience and strong data skills.
Seeking a skilled ETL Tester to independently lead testing efforts for a banking client, managing functional and automation testing in an Agile environment.