Job Title:
Senior Oracle Database Developer (PL/SQL) & Data Modeler GFT Product Control Pune AVP (R22037180)
Business:
GFT Product Control
Division:
CTO
Grade/Level:
C12
Reporting to:
Product Control Applications Development and Delivery Lead
Location:
Pune, India
Job Description
Job Purpose:
The primary purpose of this role is to work on the Database related development and data modelling changes required for Batch Processing development for the different workstream of Product Control Application. This will involve working closely with the business and SMEs on the Batch Processing development work slate, provide estimate efforts, ensure timely delivery on committed items and to provide solutions and deliverables as part of software development as according to the Software Development Lifecycle (SDLC).
Job Background/context:
The role forms part of GFT Product Control Development Team in Pune and supports the Product Control Department who have responsibility for controlling daily profit-and-loss reporting, price verification and new trading activity and works closely with many areas of the business, including the Trading desks, Middle Office, Risk Management, Operations and Finance.
Key Responsibilities:
Understanding Business Requirements and Functional Requirements provided by Business Analysts and working as part of the development team to produce Technical Design Documents and deliver solutions on those requirements.
Ensure Project deliverables are created, and PTS documentation is up to date.
Ability to Design, Develop, Deliver and Support Database related work to the best of capability and industry level design
Own the Data modelling work for new initiative and project and work on development.
Work closely with Cross Functional Teams e.g., Business Analysis, Product Assurance, Platforms and Infrastructure, Business Office, Controls and Production Support. Prepare handover documents, perform unit testing, SIT and assist with UAT and Production Implementation as required.
Identify and proactively resolve issues that could impact system performance, reliability, and usability.
Demonstrates knowledge and understanding of how the development function integrates within overall business/technology to achieve objectives; requires a good understanding of the industry.
Work proactively & independently to address development requirements and articulate issues/challenges with enough lead time to address risks
Ability to understand complex data problems, analyze and provide generic solutions compatible with existing Infrastructure.
Design, Implement, Integrate, and test new features.
Owns success – Takes responsibility for successful delivery of the solutions. Assisting other developers on their implementation as needed, and participate with review activities like design review, code review and technical document review etc. to ensure successful delivery.
Explore existing application systems, determines areas of complexity, potential risks to successful implementation.
Contribute to continual improvement by suggesting improvements to software architecture, software development process and new technologies etc.
Ability to build relationship with business and technology stakeholders.
Person Specification
Knowledge/Experience:
8+ years’ experience in software development with strong knowledge of RDBMS – Oracle (12c/19c and higher), with ability to write complex SQL needed to investigate and analyze data issues.
Data Professional with substantial experience in designing and executing solutions for complex business problems involving large scale OLTP and OLAP applications.
Experience in creating PL/SQL Packages, Procedures, Functions, Triggers, Views and Exception handling for retrieving, manipulating, checking, and migrating complex data sets in Oracle.
Experience in evaluating AWR reports and performance tuning queries, Explain Plans, Auto Trace, troubleshooting of production database systems, Applying Oracle Optimizer Hints, etc. .
Debugging and writing complex Pl/SQL code to implement enhancements
Experience in DB Infrastructure/Database design/Data modeling and Normalizing Concepts.
In-Depth understanding of concepts with Partitions, Autonomous Transactions, Bulk Collections, etc.
Experience in analyzing production issues from technical (database) and functional (application process) point of view and fixing them within defined SLAs.
Experience in application data migration, porting and version upgrades across different RDBMS using tools such as SQL *Loader, etc.
Experience in understanding and implementing policies and defined data security standards both from technical (RDBMS – database) and organizational point of view.
Strong experience in complex oracle subprograms and oracle inbuilt packages along with multiple partitioning strategies.
Working Experience on High Availability Systems that utilizes Replication/Mirroring standards/approach in Oracle database
Skills:
Strong analytic skills.
Good communication and internal customer management skills.
Good written and verbal communication skills.
Good facilitation skills.
Ability to build relationships at all levels.
Qualifications:
Competencies:
Strong work organization and prioritization capabilities.
Takes ownership and accountability for assigned work.
Ability to manage multiple activities.
Focused and determined in getting the job done right.
Ability to identify and manage key risks and issues.
Personal maturity and sense of responsibility.
Shows drive, integrity, sound judgment, adaptability, creativity, self-awareness and an ability to multitask and prioritize.
Sensitive to cultural and background differences and environments Confident and assertive.
Values diversity: Demonstrates an appreciation of a diverse workforce.
Appreciates differences in style or perspective.
Citigroup is an Equal Opportunities Employer
Job Family Group:
Technology
Job Family:
Applications Development
Time Type:
Full time
Citi is an equal opportunity and affirmative action employer.
Qualified applicants will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Citigroup Inc. and its subsidiaries (“Citi”) invite all qualified interested applicants to apply for career opportunities. 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 (https://www.citigroup.com/citi/accessibility/application-accessibility.htm) .
View the “EEO is the Law (https://www.dol.gov/sites/dolgov/files/ofccp/regs/compliance/posters/pdf/eeopost.pdf) ” poster. View the EEO is the Law Supplement (https://www.dol.gov/sites/dolgov/files/ofccp/regs/compliance/posters/pdf/OFCCP_EEO_Supplement_Final_JRF_QA_508c.pdf) .
View the EEO Policy Statement (http://citi.com/citi/diversity/assets/pdf/eeo_aa_policy.pdf) .
View the Pay Transparency Posting (https://www.dol.gov/sites/dolgov/files/ofccp/pdf/pay-transp_%20English_formattedESQA508c.pdf)
Citi is an equal opportunity and affirmative action employer.
Minority/Female/Veteran/Individuals with Disabilities/Sexual Orientation/Gender Identity.