Oracle PLSQL Database Data Engineer – Assistant Vice President is an intermediate level position responsible for participation in the establishment and implementation of new or revised application systems and programs in coordination with the Technology team. The overall objective of this role is to contribute to applications systems analysis and programming activities.
Recommended Qualifications:
- 8+ years of relevant experience
- Very good understanding in Oracle architecture
- Strong exposure to Python, Spark, Agentic workflows - Devin, Copilot
- Extensively worked on PL/SQL Packages, Procedures, Functions, Triggers, Views, MViews, External tables, partitions and Exception handling for retrieving, manipulating, checking and migrating complex data sets in Oracle
- Must have experience in advance PL/SQL, Hints, Cursors to process huge volumes of data, bulk collect for performance improvement process
- Must have experience Data Modeling and Warehousing concepts such as Star Schema, OLAP, OLTP, Snowflake schema, Fact Tables for Measurements, Dimension Tables for Descriptive Context, Periodic Snapshot Fact Tables, Junk Dimensions etc.
- Hands on experience on SCD Type 1,Type 2,Type 3,Type 4,Type 5,Type 6
- Must have very good understanding of Snapshot tables, staging tables, History tables, Audit tables, Granularity, Single Granularity for Facts, Dimension Granularity and Hierarchies, Date Dimension, Degenerate Dimensions, Surrogate Keys, Generalization and Normalization of data, Ragged Hierarchies etc.
- Highly proficient in writing complex yet efficient SQL
- Knowledge of any data modeling tool
- Ability to understand data very quickly
- Worked on migration projects
- Ability to prioritize and manage schedules under tight, fixed deadlines
- Strong writing, communication, time-management, decision-making, and basic task organization skills
- Should be able to own and manage the database deliverables.
- Should be able to maintain the data dictionaries for large databases
- Experience in systems analysis and programming of software applications
- Experience in managing and implementing successful projects
- Working knowledge of consulting/project management techniques/methods
- Ability to work under pressure and manage deadlines or unexpected changes in expectations or requirements
Education:
- Bachelor’s degree/University degree or equivalent experience
This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.
------------------------------------------------------
Job Family Group: Technology------------------------------------------------------
Job Family:Applications Development------------------------------------------------------
Time Type:Full time------------------------------------------------------
Most Relevant Skills Please see the requirements listed above.------------------------------------------------------
Other Relevant Skills For complementary skills, please see above and/or contact the recruiter.------------------------------------------------------
Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.
If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi.
View Citi’s EEO Policy Statement and the Know Your Rights poster.
Skills Required
- 8+ years of relevant experience
- Very good understanding in Oracle architecture
- Strong exposure to Python and Spark
- Extensively worked on PL/SQL Packages and Procedures
- Must have experience in Data Modeling and Warehousing concepts
- Hands on experience on SCD Type 1, 2, 3, 4, 5, 6
- Highly proficient in writing complex SQL
- Experience in managing and implementing successful projects
- Bachelor's degree or equivalent experience
Citi Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Citi and has not been reviewed or approved by Citi.
-
Healthcare Strength — Benefits coverage is positioned as comprehensive, including health, dental, and vision insurance plus on-site clinics, prescription drug support, and disability coverage. Family-building support such as fertility assistance is described as a notable differentiator within the overall package.
-
Retirement Support — Retirement benefits are framed as strong, highlighted by a 401(k) with matching and additional plan options like a Roth 401(k). Financial support is reinforced through discounts and broader financial guidance resources tied to the benefits ecosystem.
-
Wellbeing & Lifestyle Benefits — Wellbeing support extends beyond insurance through programs like an Employee Assistance Program, counseling/legal resources, and gym or wellness reimbursement. These offerings increase the perceived total rewards value even when cash compensation sentiment varies by role.
Citi Insights
What We Do
Citi's mission is to serve as a trusted partner to our clients by responsibly providing financial services that enable growth and economic progress. Our core activities are safeguarding assets, lending money, making payments and accessing the capital markets on behalf of our clients. We have 200 years of experience helping our clients meet the world's toughest challenges and embrace its greatest opportunities. We are Citi, the global bank – an institution connecting millions of people across hundreds of countries and cities.
