Skills and Knowledge : Candidate must also possess: Demonstrated Expertise (“DE”) analyzing, architecting, modelling, designing, and developing Oracle database applications, data warehouses, and operational data stores within a UNIX environment using SQL Loader, SQL, and PL/SQL; creating design flows and Entity-Relationship (ER) diagrams, using Visio, Python (Dash), and SQL Developer Data Modeler; writing Oracle stored procedures, triggers, pipeline functions, and bulk processing, using bulk collect and composite datatypes; replicating, filtering, and transforming data from one database to another using Golden Gate Replication; developing workflows to integrate data across Oracle, SQL server, and Sybase; and creating batch jobs to process real-time high frequency, low latency locates for hedge fund clients using Advanced UNIX Shell and Python scripting. DE performing application build and deployment using Continuous Integration/Continuous Deployment (CI/CD) tools -- Jenkins, GIT and uDeploy; performing Agile programming, and Scrum and Test Driven Development (TDD), using JIRA and Artifactory; developing Machine Learning (ML) models using Python’s NumPy and Matplotlib; designing and developing prime brokerage rule-based compliance reports using SQL Server Report Definition Language (RDL) and Geneva Rule Script Language (RSL); developing secure file transfer using AXWAY and Amazon Web Services (AWS) Transfer Family with lambda functions for event driven processing; and building real-time data exchange pipelines using messaging frameworks -- Oracle Advance Queue, Tibco Rendezvous, IBM MQ, and Kafka.