At Citi we’re not just building technology, we’re building the future of banking. Encompassing a broad range of specialties, roles, and cultures, our teams are creating innovations used across the globe. Citi is constantly growing and progressing through our technology, with laser focused on evolving the ways of doing things. As one of the world’s most global banks we’re changing how the world does business
Shape your Career with Citi
We’re currently looking for a high caliber professional to join our team as based in Pune/Chennai, India. Being part of our team means that we’ll provide you with the resources to meet your unique needs, empower you to make healthy decision and manage your financial well-being to help plan for your future. For instance:
We provide programs and services for your physical and mental well-being including access to telehealth options, health advocates, confidential counseling and more. Coverage varies by country.
We empower our employees to manage their financial well-being and help them plan for the future.
We provide access to an array of learning and development resources to help broaden and deepen your skills and knowledge as your career progresses.
Responsibilities & Qualifications:
2-4 years of relevant Strong experience in SQL and new technologioes
- DataBridge (UAL) Application: Expected to Develop/Modify/Test/Migrate Subscriptions using DataBridge (UAL) Application.
- SDLC: Contribute to full development life cycle, including requirements analysis, functional design, technical design, programming, testing, documentation, implementation, and on-going technical support
- Analyze and Optimize SQL: Identify high-impact, suboptimal UAL Subscription SQL statements and PL/SQL code, generate and interpret execution plans, and rewrite queries to ensure optimal performance.
- Ability and willingness to learn newer tools and technologies in cloud-based data analytics/Artificial intelligence arena and successfully deliver projects utilizing the same.
- Performance Monitoring: Proactively monitor database performance using tools such as Oracle Enterprise Manager (OEM), AWR (Automatic Workload Repository), and ASH (Active Session History) reports to diagnose and resolve bottlenecks.
Required Skills and Qualifications
- 5+ year of Industry experience working in Finance reporting applications/warehouses.
- Technical Expertise: Deep understanding of Oracle Database architecture, RDBMS concepts, memory usage, wait events, and the Cost-Based Optimizer (CBO).
- SQL and PL/SQL Proficiency: Expert-level skills in writing, optimizing, and debugging complex SQL queries and PL/SQL code (procedures, functions, packages, triggers).
- Tools Experience: Hands-on experience with performance monitoring and tuning tools, including SQL*Plus, SQL Developer, AWR/ASH reports, and the SQL Tuning Advisor. Strong knowledge of Oracle Database, SQL tuning, understanding of the Relational Data Modal.
- Operating Systems and Scripting: Proficiency in Linux/Unix environments and strong shell scripting skills are often required.
- Problem-Solving: Strong analytical thinking and problem-solving abilities to identify the root causes of performance degradation.
- Communication: Excellent verbal and written communication skills to collaborate with cross-functional teams and non-technical stakeholders.
- Education/Experience: A Bachelor's degree in Computer Science or a related field, plus significant relevant work experience (typically 5+ years) in database performance analysis and SQL tuning.
- Certifications: Relevant Oracle certifications (e.g., Oracle Certified Professional DBA) are often a plus.
- DevOps Tools knowledge/Experience : git/bitbucket , Jenkins, Lightspeed/RLM and service now.
- Prior experience with Citi tool – DataBridge (UAL) is a big PLUS
- Prior working experience with Citi Financial system (Specially General Ledgers) is a Big PLUS
- Implement Tuning Recommendations: Utilize the Oracle SQL Tuning Advisor and other utilities to implement corrective actions such as gathering statistics, creating new indexes, or generating SQL profiles.
- Database Design Collaboration: Work closely with application developers and data architects to ensure efficient database design, data modeling, and the use of appropriate indexing and partitioning strategies.
- Troubleshooting: Diagnose and resolve complex, mission-critical performance problems in various environments (development, testing, production).
- Documentation and Standards: Create and maintain technical documentation, including data standards, procedures, and definitions for the data dictionary, and ensure coding guidelines are followed.
- Capacity Planning: Assist in capacity planning and growth management to ensure the database environment can handle future workloads.
Education:
Bachelor’s degree/University degree or equivalent experience
------------------------------------------------------
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
- 2-4 years of relevant experience in SQL and new technologies
- 5+ year of Industry experience working in Finance reporting applications/warehouses
- Bachelor's degree in Computer Science or a related field
- Expert-level skills in writing, optimizing, and debugging complex SQL queries and PL/SQL
- Proficiency in Linux/Unix environments and strong shell scripting
- Relevant Oracle certifications (e.g., Oracle Certified Professional DBA)
- Hands-on experience with performance monitoring and tuning tools (e.g., SQL Developer, AWR/ASH reports)
- Prior experience with Citi tool - DataBridge (UAL)
- Prior working experience with Citi Financial system (Especially General Ledgers)
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.
