Senior Analyst Programmer - PL/SQL

Core Requirement for the role is Pl/SQL

Job Description - Role Overview

This is a challenging opportunity for developers to work in Central Finance Technology team alongside system/business analysts, database administrators and business project teams to contribute to this central service.

Key Responsibilities

• Work with Delivery Managers and System/Business Analysts and other subject matter experts to understand the requirements.
• Implement mappings between inbound and target data model.
• Own and deliver technically sound solutions for the assigned components(s)
• Low level technical design of the assigned components and produce technical specifications, unit test cases for the components under development.
• Communicate with business analysts to discuss various business requirements.
• Develop, maintain, and troubleshoot issues; and take a leading role in the ongoing support and enhancements of the applications.
• Help in maintaining the standards, procedures, and best practices in the team.

Experience and Qualifications

• B.E./ B.Tech. or M.C.A. in Computer Science from a reputed University
• Total 5 to 7 years of experience with application development on Oracle RDBMS, SQL, PL/SQL
• Must have technical skills.
• Strong Experience with Oracle Database
• Good understanding of RDBMS Concepts
• Hands on Experience in writing complex SQL queries.
• Good Understanding of Oracle Architecture
• Good experience and hands-on knowledge of PL/SQL (Packages/Functions/Ref cursors)
• Experience in development & low-level design of Warehouse solutions
• Familiarity with Data Warehouse, Datamart and ODS concepts
• Knowledge of data normalisation and Oracle performance optimisation techniques
• Strong knowledge of Data security concepts in Oracle
• Hands on experience in frequent code deployment into multiple environments
• Good to have technical skills:
• Hands on experience in Python Scripting and Cloud Technologies like AWS
• Experience in Advanced performance aspects of large databases would be added advantage.
• Experience of Source Control Tools (GitHub preferred)
• Experience of using job scheduling tools (Control-M preferred)
• Experience in UNIX and Shell scripting
• Hands on experience in unit testing and automation framework
• Exposure of continuous integration toolsets like Jenkins, Urban Deploy
• Exposure to Agile (Scrum) development practices
• Functional
• Experience of working within Finance domain (Investment Management, Wealth Management, or Investment Banking organisations) and broad base business process, application and technology architecture experience
• Experience with data distribution and access concepts with ability to utilise these concepts in realising a proper physical model from a conceptual one.
• Openness to work as a part of a team engaged in development as well as production support activities.

Personal Characteristics

Core and soft skills - Practised abilities, capabilities, and behaviours

• Ability to take new responsibilities.
• Excellent communication and organisational skills
• Analytical capabilities to think out of box solution.
• Ability to work on own initiative and as a team member in a high-pressure environment.
• Strong interest in Technology and its applications
• Ability to work closely with cross functional teams.

Feel rewarded

For starters, well offer you a comprehensive benefits package. We’ll value your wellbeing and support your development. And we’ll be as flexible as we can about where and when you work – finding a balance that works for all of us. It’s all part of our commitment to making you feel motivated by the work you do and happy to be part of our team. For more about our work, our approach to dynamic working and how you could build your future here, visit careers.fidelityinternational.com.

For more about our work, our approach to dynamic working and how you could build your future here, visit careers.fidelityinternational.com.