Wadea George

• Lead the technical design and delivery of enterprise-grade data integration and DWH solutions supporting the bank's Finacle core banking platform.
• Act as the solution architect for data platform initiatives, defining scalable, maintainable architectures and integration patterns across key channels ( MIB, RIP, ATM, Cards, POS ).
• Drive end-to-end data modelling for transactional and analytical use cases, including normalization , star/snowflake schemas , and performance optimization , translating business requirements into robust technical designs.
• Design and implement ETL/ELT pipelines to load the enterprise star schema , incorporating CDC and SCD Types strategies aligned with business rules and reporting needs.

· Business Analyst: Gathered and analyzed requirements from stakeholders at NCVC, centralizing data needs for key environmental projects and preparing Business Requirements Documents (BRDs) for effective data integration.

· DWH Modeler: Designed a scalable Data Warehouse model using Oracle Developer Modeler, ensuring alignment with Data Management Office (DMO) compliance standards and creating data marts to support various reporting needs.

· ETL Developer: Developed efficient ETL processes using Informatica PowerCenter and IDQ to extract, transform, and load data from diverse sources, enabling seamless data integration and accuracy.

· BI & Reporting: Implemented real-time dashboards in Power BI for NCVC to provide actionable insights, enhance decision-making, and support strategic environmental initiatives.

· ETL developer and modeller of the development of a new Oracle Financial Services Analytical Applications ( OFSAA ) model, integrating it with the enterprise Data Warehouse (DWH).

· Designed and implemented comprehensive data models within the OFSAA suite to support financial reporting and analytics.

· Collaborated with business analysts and stakeholders to gather requirements and translate them into data model specifications.

· Provided ongoing support for active ETL workflows, ensuring operational efficiency and reliability.

· Building Profitability Project for OFSAA Engine from Scratch.

· Enhancing the systems performance by optimizing complex PL/SQL procedures for high-efficiency data processing.

· Designed and maintained robust ETL/ELT pipelines using Snowflake, utilizing Snowpipe, Streams, and Staging objects to support real-time and batch ingestion of HR and environmental data.

· Implemented advanced Snowflake capabilities including Time Travel, Zero Copy Cloning, and Slowly Changing Dimensions (SCDs) to enable data recovery, efficient testing, and historical tracking.

· Built and orchestrated batch and streaming data pipelines on Google Cloud Platform (GCP) using DataFusion and Google Cloud Storage (GCS) to load and transform data into BigQuery.

· Developed interactive, real-time dashboards in Looker to provide self-service analytics and data-driven insights for strategic decision-making across environmental initiatives.

· Engineered and managed large-scale data workflows on Cloudera CDP 7.x using Apache Spark, Hive, Airflow, Kafka and Apache Iceberg, ensuring efficient batch processing, scalable job orchestration, and optimized data lake storage with advanced table formats.

Senior DWH Data Modeler

January 2021 - June 2022

· Developed a versatile modelling tool capable of:

· Editing and use in various environments.

· Connecting to multiple database types including Teradata, DB2, Oracle, and SQL Server.

· Automatically generating modelling designs from source systems to target systems.

· Creating DDL scripts and mapping sheet tailored to specific systems.

· Managing metadata and archiving system designs for future revisions.

· Constructed dimensional models for analytical layers (BV and Imart), enhancing data accessibility across multiple business lines.

· Developed Entity-Relationship Diagrams (ERD) and Data Vault models (including HUBs, LINKs, and SATs) for raw data layers.

Senior Informatica Developer

January 2020 - December 2020

· Led data migration projects for critical banking systems including CRM, BPM, Smart Wallet, and AXA.

· Contributed to a major upgrade project for T24 core banking system.

· Developed information layers including Business Vault and Imart to streamline SAP reporting processes.

· Implemented data conversion tools, transforming large Excel files into CSV using Java and Python.

· Created automation scripts using shell scripting to enhance data mapping and reduce manual workload.

· Design, develop, and deploy data governance and data quality solutions using Informatica EDC (Enterprise Data Catalog), AXON, and IDQ (Informatica Data Quality).

· Utilize Informatica EDC to create, manage, and maintain a comprehensive data catalog that provides visibility into our data assets and their lineage.

· Implement and enforce data governance policies and standards using Informatica AXON, ensuring compliance with regulatory requirements and industry best practices.

· Design and execute data quality rules, scorecards, and monitoring processes using Informatica IDQ to ensure high-quality, reliable data.

Senior Informatica ETL Developer

January 2018 - December 2019

· Developed and maintained ETL workflows from heterogeneous source systems to the Data Vault layer of the Enterprise Data Warehouse (EDW).

· Implemented Change Data Capture (CDC) using PowerExchange and Informatica Data Replication tools for real-time data updates.

· Conducted comprehensive testing and data validation to ensure accurate data loading, effectively resolving data issues such as duplication and overlaps.

· Employed complex SQL queries to manage data inconsistencies and cleanse the system of erroneous or garbage data.

· Utilized XML Schema Definition (XSD) files for parsing complex data structures into readable formats.

· T24 Core Banking System : Analyzed and translated requirements for Retail, Corporate, and Treasury operations, creating detailed specifications that enabled data modelers to design streamlined, compliant banking workflows.

· CRM System : Collaborated with business units to define requirements for customer engagement and relationship management, translating business needs into structured data models to support an effective, scalable CRM system.

· Power Cards Platform : Defined and documented requirements for managing debit, credit, prepaid, and virtual cards , ensuring secure, real- time transactions. Provided specifications for card issuance, transaction processing, and fraud prevention, supporting a comprehensive and integrated payment solution.