Novartis has flagged the Senior LSH Programmer job as unavailable. Let’s keep looking.

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
Confirmed 8 hours ago. Posted 23 days ago.

Discover Similar Jobs

Suggested Articles