
at Citi
Bulge Bracket Investment BanksPosted 5 days ago
No clicks
**Database Developer (On-Site) in Pune, India** Develop, maintain, and optimize Oracle databases for Citi's applications. Key responsibilities include creating functional specs, writing performance-optimized PL/SQL codes, and tuning SQL queries.Requires 4+ years experience in enterprise Web app development with Oracle and Java. Must have strong SQL skills, understanding of SDLC, and be self-motivated. Full-time position; Bachelor's degree in science, computers, or related field required. Willingness to work late evenings India time as needed.
- Compensation
- Not specified
- City
- Not specified
- Country
- India
Currency: Not specified
Full Job Description
Database Developer
Discover your future at Citi
Working at Citi is far more than just a job. A career with us means joining a team of more than 230,000 dedicated people from around the globe. At Citi, youll have the opportunity to grow your career, give back to your community and make a real impact.
Job Overview
The Applications Development Programmer Analyst 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.
Job Purpose:
- Developer with strong analytical and technical ability with over 3 years of experience in enterprise Web application development with Oracle as backend database. Ability to work independently, good communication skills, has experience in working on complex and medium to large projects. Should have strong knowledge of SQL and PLSQL programming on Unix/Solaris/Aix environments. Person should have good understanding of SDLC and flair to follow the processes.
Job Background/context:
- The position is based in India and is required to review the day to day delivery work, ensuring a robust process implementation, identifying project/program delivery risks and work on risk mitigation. This role will report to the Front office Technology Team lead in NY, and have a dotted line to the enclave lead.
- Candidate will work independently and is highly self motivated. He will be asked to represent the organization to third parties
- Applies skills and knowledge of the business to develop creative solutions to meet client and business needs
- The candidate will work with complex and variable issues with substantial potential impact, weighing various alternatives and balancing potentially conflicting needs
- Requires good analytical skills in order to filter, prioritize and validate potentially complex material from multiple sources
Key Responsibilities:
- A seasoned SME and technical specialist in On boarding/AML/KYC domain
- Technical hands on experience
- Needs to be able to react and provide quick turnaround to business requirements and management requests
- Should able to develop functional specification and technical design document.
- Support day-to-day BAU activities for Citi Private Bank On boarding/AML/KYC platform
- Well versed in Software Development Life Cycle
Knowledge/Experience:
- Over 4+ years of experience in enterprise Web application development with Oracle as backend database and Java/J2EE technologies services.
- Ability to work independently, good communication skills, has experience in working on complex and medium to large projects.
- Person should have good understanding of SDLC and flair to follow the processes.
- Strong in Fine-tuned SQL queries in Oracle Database.
- Should have ability to write performance optimized PL/SQL codes using Collection, Pipelined functions, GTT etc.
- Good hands on in query performance tuning.
- Well versed in tolls like SQL Developer.
- Must have basic knowledge of Explain Plan and other performance tuning tools.
- Should possess knowledge of Indexes, IOT, Partitions, Joins, Index Access methods.
- Basic Knowledge of Data Modelling.
- Knowledge of Core Java, J2EE and WebLogic will be a plus.
- Should possess basic Unix knowledge to be able to write and understand basic shell scripts and basic Unix commands
- Good architectural skills on Java/J2EE and Oracle based solutions
- Financial markets background is preferable but is not a must
Qualifications:
- Bachelors degree (in science, computers, information technology or engineering)
Candidate should be willing to work late in the evening India time on need basis in order to interact with US onshore team and to meet urgent requests by Clients.
------------------------------------------------------
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 (opens in new window).
View Citis EEO Policy Statement (opens in new window) and the Know Your Rights (opens in new window) poster.




