Title Senior Analyst Programmer
Department WPFH
Location Gurgaon
Level 3
We’re proud to have been helping our clients build better financial futures for over 50 years. How have we achieved this? By working together - and supporting each other - all over the world. So, join our [insert name of team/ business area] team and feel like you’re part of something bigger.
About your team
The successful candidate would join the Data team . Candidate would be responsible for building data integration and distribution experience to work within the Distribution Data and Reporting team and its consumers. The team is responsible for developing new, and supporting existing, middle tier integration services and business services, and is committed to driving forwards the development of leading edge solutions.
About your role
This role would be responsible for liaising with the technical leads, business analysts, and various product teams to design, develop & trouble shoot the ETL jobs for various Operational data stores. The role will involve understanding the technical design, development and implementation of ETL and EAI architecture using Informatica / ETL tools. The successful candidate will be able to demonstrate an innovative and enthusiastic approach to technology and problem solving, will display good interpersonal skills and show confidence and ability to interact professionally with people at all levels and exhibit a high level of ownership within a demanding working environment.
Key Responsibilities
- Work with Technical leads, Business Analysts and other subject matter experts.
- Understand the data model / design and develop the ETL jobs
- Sound technical knowledge on Informatica to take ownership of allocated development activities in terms of working independently
- Working knowledge on Oracle database to take ownership of the underlying SQLs for the ETL jobs (under guidance of the technical leads)
- Providing the development estimates
- Implement standards, procedures and best practices for data maintenance, reconciliation and exception management.
- Interact with cross functional teams for coordinating dependencies and deliverables.
Essential Skills
- Technical
- Strong SQL or Pl/SQL experience with a minimum of 2 years’ experience
- Deep knowledge and Experience of using the Informatica Power Centre tool set min 3 yrs.
- Experience of Source Control Tools such as GIT/SVN
- Experience of using job scheduling tools such as Control-M
- Experience in UNIX scripting
- Experience in Data Warehouse, Datamart and ODS concepts
- Knowledge of data normalisation/OLAP and Oracle performance optimisation techniques
- 4 + Yrs Experience of either Oracle or SQL Server and its utilities coupled with experience of UNIX/Windows
- Functional
- 4 + years’ experience of working within financial 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
- Business facing and ability to work alongside data stewards in systems and the business
- Strong interpersonal, communication and client facing skills
- Ability to work closely with cross functional teams
Essential Skills / Experience
- Deep knowledge and Experience of using the Informatica Power Centre tool set
- Deep knowledge of Oracle and SQL query writing
- Experience of Source Control Tools such as Clear Case / SVN
- Experience of using job scheduling tools such as Control-M
- Experience in UNIX scripting
- Understanding of Software Development Lifecycle
Desirable Skills / Experience
- Diagnostic and analytical skills
- Good communication skills – both verbal and written.
- Display a flexible attitude, be able to thrive in an ever-changing environment
Personal Characteristics
- Good interpersonal and communication skills.
- Strong team player
- Ability to work at a strategic and tactical level
- Ability to convey strong messages in a polite but firm manner
- Self-motivation is essential, should demonstrate commitment to high quality design and development.
- Ability to develop & maintain working relationships with a number of stakeholders.
- Flexibility and an open attitude to change.
- Problem solving skills with the ability to think laterally, and to think with a medium term and long term perspective
- Ability to learn and quickly get familiar with a complex business and technology environment.
About you
B.E./B.Tech/MBA/M.C.A/Any other bachelors Degree. At least 4+years of experience in Data Integration and Distribution Experience in building web services and APIs Knowledge of Agile software development life-cycle methodologies
Feel rewarded
For starters, we’ll 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.
Skills Required
- Minimum 4 years experience in Data Integration and Distribution
- Strong SQL or PL/SQL experience with a minimum of 2 years
- Deep knowledge in Informatica Power Centre tool set, minimum 3 years
- Experience in UNIX scripting
- Experience with Source Control Tools such as GIT/SVN
- 4+ years experience of working within financial organizations
Fidelity International Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Fidelity International and has not been reviewed or approved by Fidelity International.
-
Parental & Family Support — Family leave and carers’ support are emphasized via equalized paid parental leave globally and enhanced maternity/adoption policies. Inclusive provisions also cover carers’ leave and compassionate leave to support diverse family needs.
-
Healthcare Strength — Healthcare benefits and private medical insurance are consistently highlighted as part of the core package across locations. Wellbeing resources, including an Employee Assistance Programme and menopause support, reinforce the depth of health coverage.
-
Retirement Support — Pension and retirement savings are positioned as a strong element of the total package in multiple markets. Retirement design is frequently cited alongside paid time off and flexibility as part of a solid overall offer.
Fidelity International Insights
What We Do
Fidelity 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. *Data as of 31 March 2021
