About the Opportunity
Job Type: Permanent
Application Deadline: 31 March 2024
Title: Senior Analyst Programmer
Department: CPS Technology
Location: Gurgaon, India
Reports To: Project Manager
Type: Permanent
Grade: 3
We share a commitment to making things better for clients and each other. We continually explore new technology and different ways of working to put our clients first. So bring your boldest ideas to CPS Technology team and feel like you’re making progress
Department Overview
Based in Gurgaon, Dalian and the UK, the CPS Technology team is part of Corporate Enablers Technology. The team supports business initiatives across Travel, BCM, Workplace Experience, Physical Security and Real Estate.
About your role
The vacancy is for a highly motivated ETL developer who will be responsible for analysis and end to end delivery of various application integrations for use by FIL’s Corporate property Services (CPS).
Essential Skills
- Strong hands-on experience (6-8 years) in PL-SQL, demonstrating strong SQL knowledge.
- Thorough understanding and experience in functionalities such as - group by, set operators, Correlated query, analytical functions, aggregation and conversion functons
- Performance Tuning, Reading/Analysing Explain Plans, Partitioning ,Indexing , Bulk Collect and exception handling.
- ETL - Handling Different sources - XML , Rest API's , flatfiles & RDBMS
- Mapping parameters/Variables and working with Parameter files and Performance tuning
- OLTP / Data warehousing Concepts : ODS /OLTP concepts and Normal Form - INF,2NF, 3NF etc
- Good Understanding to how to run complex job stack using scheduler (Control M Preferered)
- Good knowledge of Data Modelling Concepts - is able to convert businese problem statement to logical/ physical data model
- Data Security & Encryption
- Python - Functions, tuples,dictionaries & data Processing, should be able to work with Data Frames and create basic pipeline and Understanding of Basic libraries
- Knowledge on Data Quality and Reconciliation Concepts
- Should be able to define Unit Testing strategy , execute unit tests and capture test results
Experience and Qualification:
- B.E./ B.Tech. or M.C.A. in Computer Science from a reputed University
- Total 6 to 8 years of strong hands-on experience in PL/SQL as an ETL Programmer
- Experience in data warehousing / data preparation
- Hands-on experience with ETL, ELT, data ingestion.
- Experience of various data platforms, such as Oracle, MS SQL server, cloud services.
- Experience in SQL and Javascript
- Must have an excellent understanding of relational databases and should be able to read/create Entity Relationship Diagrams
- Excellent communication skills and ability to communicate with senior stakeholders in English
- Must be able to work independently without much oversight.
Skills – nice to have:
- Unix - Basic Shell Commands
- Experience in CI/CD, TDD, DevOps
- Basic understanding of Java
Personal Characteristics
- Excellent communication skills both verbal and written
- Strong interest in Technology and its applications
- Self-motivated and Team Player
- Ability to work under pressure and meet deadlines
- Able to pariticipate in Tech feasibility and Proof of Concept analysis
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.
Read Full Description