About the Opportunity

Job Description

Title                 Senior Analyst Programmer

Department      FIL India Technology - Retail Technology

Location          Gurugram , India

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 team and feel like you’re part of something bigger.

About your team

You'll be joining the Sonata Product Development team, which focuses on enhancing our platform capabilities to support our growing direct and intermediated businesses in the region.

About your role

This role is for an experienced ETL Developer and Database Expert to work within the Sonata Product Development team. The successful candidate will be responsible for developing, optimizing, and maintaining enterprise-scale data integration solutions, gaining deep knowledge of Sonata services and platform data architecture, and contributing to strategic data engineering initiatives.

The role requires strong expertise in ETL/ELT development, data warehousing, database design, SQL optimization, and data integration frameworks. The candidate will be responsible for designing scalable and high-performance data pipelines, ensuring data quality and governance, and driving database performance improvements across critical business applications. The individual should be capable of providing technical leadership, mentoring development teams, and collaborating with application, analytics, cloud, and DevOps teams to deliver reliable and data-driven solutions.

As part of this role, the candidate may be required to support and resolve critical production issues, placing them in a front-line position with significant interaction with business stakeholders. This demands a high level of ownership, flexibility, and the ability to perform effectively under pressure.

Excellent written and verbal communication skills are essential to clearly and confidently interact with business users, product owners, and technical teams at all levels of the organization.

The role requires close working with colleagues in the UK offices, and as such the candidate may be required to work UK business hours sometimes.On occasions the candidate may also be required to work extended hours/weekends to cover changes and release implementations, for example.This demanding role would perfectly suit a dynamic individual looking to work in a fast-paced environment to ensure the smooth running of business critical systems.

About You 

Key Responsibilities

• Work with delivery architects to review the best solution to problems
• Ensure development quality standards are met
• Own and deliver technically sound solutions for the assigned project (s)
• Provide regular updates and reporting to project managers
• Highlight risks and issues in a prompt and timely manner and give clear and concise details of resolutions
• Interact with customers to understand their problems, provide solutions or workarounds
• Produce technical documentation to assist team members
• Ownership of problems from first notification through to resolution
• Ensure performance of Sonata platform is optimised
• Impact Analysis for any changes required
• Identify problem areas and escalate where necessary

Essential Skills / Experience

ð Hands-on experience in writing complex SQL queries, query optimization, indexing, and database tuning
ð Strong experience with relational databases (Oracle / PostgreSQL / MySQL) and data modeling concepts
ð Exposure to DevOps practices, including CI/CD pipelines, build and release automation
ð Experience in Java (Core Java, Spring / Spring Boot, RESTful services)
ð Hands-on experience integrating Generative AI / LLMs (OpenAI, Azure OpenAI, Amazon Bedrock, etc.) into full stack applications using APIs
ð Understanding of prompt engineering, embeddings, vector databases, and retrieval augmented generation (RAG) patterns
ð Experience with containerization and orchestration tools such as Docker and Kubernetes
ð Hands-on experience with cloud platforms (AWS / Azure / GCP) and cloud-native services
ð Experience using source code management tools such as Git, GitHub, Bitbucket, or GitLab
ð Knowledge of infrastructure as code tools (Terraform, CloudFormation – preferred)
ð Understanding of microservices architecture, API gateways, and service-to-service communication
ð Experience with logging, monitoring, and observability tools (ELK, Prometheus, Grafana, etc.)
ð Familiarity with NoSQL databases (MongoDB, Redis, Cassandra) and big data concepts
ð Good understanding of application security, authentication/authorization (OAuth, JWT)
ð Ability to work under pressure, manage priorities, and meet tight deadlines
ð Ability to think laterally with an enquiring mind and strong analytical skills
ð Strong communication skills and ability to collaborate effectively in cross-functional teams
ð Flexible attitude with the ability to thrive in a fast-paced, ever-changing environment

Desirable Skills / Experience

• Good knowledge of UNIX, Python, Shell Scripting, u-deploy (or similar) and experience of continuous integration
• Large scale software product engineering experience with contemporary tools and delivery methods in a complex environment, i.e. Agile/SAFe, Test Modernization, CI/CD, Cloud Solutions, and DevOps practices.
• End to end understanding of distribution data and its lifecycle
• Exposure to the Finance/Mutual Fund industry would be an advantage
• Expose to big data technologies like Hadoop, Spark, Kafka.

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.