Analyst Programmer - Database

Job Description

About the opportunityDepartment DescriptionThe Institutional business comprises of Fidelity s Institutional Business Units in the UK, EMEA and Asia Pac and is a strategic area targeted for growth over the coming years. The Technology Department has been acting as the key enablers for the business in achieving their goals. The Institutional portfolio of projects will include a large collection of strategic initiatives as well as tactical ones to support day-to-day operations and strengthen the technical environment.Primary technologies used in these applications are: Oracle, OBIEE, Informatica, Vermillion, J2EE etc.Purpose of the RoleInstitutional Technology needs a highly motivated Analyst Programmer (AP). The role involves supporting key Institutional applications and reporting data marts involving strong PL/SQL and complex Informatica mappings on Oracle database platform and should be able to support legacy application on SYBASE Infra. The candidate should have high expertise and core skills of PL/SQL, Informatica Powercenter and UNIX shell script and Control-M. Understanding of reporting tools sets like OBIEE or Vermilion is required . The successful candidate will be responsible for support and maintenance of database that provides data for consumption by reporting applications. This would also involve intensive interaction with the business team, development team and other systems groups, so good communications skills and the ability to work under pressure are absolute mustKey Responsibilities

• Providing first line of technical support for business critical applications (Principal technologies / applications used include Oracle PL/SQL, Informatica Powercenter /B2B, OBIEE, Control-M and UNIX).
• Work in the support team alongside data analysts, business analysts, database administrators and business project teams in enhancing and supporting the production services.
• Help maintain PL/SQL codes, Informatica mapping and Control-M schedules.
• Conduct analysis and do bug fixes for production incidents. Carry out technical enhancements as desired.
• Carry out daily health-check activities involving application checks, system checks, and database checks and related on production systems / servers.
• The scope of responsibility also covers monitoring business critical batch workloads, real-time / interactive processing, data transfer services, application on-boarding and upgrades, and recovery procedures.
• Report root cause of the incidents and present ideas on how to prevent the incidents from occurring in future.
• Ensure adherence to incident and change management processes. Regular engagement with Business & Systems Teams looking to adopt and apply the best practice of Service Support.
• Prepares and maintains documentation related application support like SOM, Service Card, Support Rota, Knowledge base, etc.
• Demonstrates continuous effort to improve operations, decrease turnaround times, streamline work processes, and work cooperatively and jointly to provide quality seamless customer service.
• Responsible for servicing 24x7 support as per support rosters
• Flexibility to work in shifts ( on-demand & short-term basis), and/or on weekends
• Suggest improvements in system development process / application areas

Experience and Qualifications Required

• Around 3 4 years of technical experience in Software / IT industry in Development and Support functions
• Minimum 2 3 years of support experience in Production Support roles in database and data integration intensive projects
• At least 4 years of Oracle experience with strong focus on PL/SQL stored procedures
• At least 3 years of experience in Informatica Powecenter.
• At least 3 years of experience in writing UNIX shell script
• At least 2 years of experience of using scheduling tools like Control-M.
• Experience with a reporting tool esp OBIEE and Vermilions
• Experience of SVN as source control tool
• Good Operating Systems knowledge and associated commands (UNIX [AIX/Linux], MS Windows)
• Good familiarity in Data Warehousing concepts
• Knowledge of ITIL practices
• Excellent written and verbal communication skills
• Proven ability to work well under pressure and in a team environment
• Self-motivated, flexible, responsible, and a penchant for quality
• Ability to work closely with cross-functional teams.
• Ability to prioritise own activities, work under hard deadlines.

About youAbout Fidelity InternationalFidelity International offers investment solutions and services and retirement expertise to more than 2.5 million customers globally. As a privately held, purpose-driven company with a 50-year heritage, we think generationally and invest for the long term. Operating in more than 25 countries and with $739.9 billion in total assets, our clients range from central banks, sovereign wealth funds, large corporates, financial institutions, insurers and wealth managers, to private individuals.Our Workplace & Personal Financial Health business provides individuals, advisers and employers with access to world-class investment choices, third-party solutions, administration services and pension guidance. Together with our Investment Solutions & Services business, we invest $567 billion on behalf of our clients. By combining our asset management expertise with our solutions for workplace and personal investing, we work together to build better financial futures.Our clients come from all walks of life and so do we. We are proud of our inclusive culture and encourage applications from the widest mix of talent, whatever your age, gender, ethnicity, sexual orientation, gender identity, social background and more.As a flexible employer, we trust our people to perform their role in the way that works best for them, our clients and our business. We are a disability-friendly company and would welcome a conversation with you if you feel you might benefit from any reasonable adjustments to perform to the best of your ability during the recruitment process and beyond. Data as at 31 March 2021. Read more at https://www.fidelityinternational.com/ Applying to this Job Role: Please note you are only required to upload your CV/Resume to the application screen.,

Keyskills :
knowledge basefinanceshell scriptroot causebusiness unitsoracle databasereporting toolscheduling toolsproject teamssqldata martsdata warehousingasset managementdata integrationcustomer relationswork processeserpcentral banksreporting too