CAIA's Career Center is an easy-to-use, comprehensive resource connecting job seekers with employers in the growing AI field. Use your knowledge and credibility to advance your career or build a talented team for your organization. Opportunities targeted to CAIA Charterholders are prioritized.
In order to search for jobs specifically for CAIA Charterholders or those pursuing the CAIA Charter please enter “CAIA” in the search panel.
This will enable you to search for CAIA specific roles globally.
Responsibilities: The candidate must have minimum 7 years and above of experience in Financial Services, IT or relevant industry. This role is for an Oracle/ETL developer with strong motivation to understand and work on developing and maintaining a complex in-house built DataWarehousing platform. Experience with development, and support / maintenance (L3/L4) of Oracle based systems, UINIX/Linux and PL/SQL a must. Experience on Oracle and any one or more of the ETL tools is mandatory. This role requires hands-on development/coding work as an individual contributor. The candidate must be willing to contribute towards team hiring activities like doing technical interviews, etc.
Mandatory: Minimum 7 years and above Good knowledge on Oracle database architecture and various components Excellent knowledge on Oracle database objects (especially indexes, Partitioning and Views) Knowledge of Data warehouse, Type of Schemas and Dimensional Modeling. Excellent knowledge in Oracle SQL, String, Number and Date functions and Analytical functions (RSUM, LEAD, LAG, RANK, DENSE, etc.) usage Experience in working on L3/L4 projects Excellent knowledge in Unix shell scripting and commands Basic knowledge on Core Java and XML Knowledge on PLSQL programming Experience in requirements analysis and system design Proven problem solving, communication, interpersonal and analytical skills. Ability to work both independently as well as within a team Knowledge of testing and quality assurance methodologies
Desirable Skills: Knowledge of data analysis and data profiling Experience in writing standards documentation as well as training documentation Experience in State street in-house products - ESP, MyStateStreet IRD and MyStateStreet IV
Tools: Toad RTC MS Office Tools - Excel, Access, Power Point, Project and Word SQL Developer Unix KSH and BASH