Database developer at Citigroup in Pune, Maharashtra, India

Database developer Location: Pune Maharashtra India 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: Bachelor’s 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. View Citi’s EEO Policy Statement and the Know Your Rights poster.