Senior Analyst Programmer

About the Opportunity Job Type: Permanent Application Deadline: 16 August 2026 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.

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)