Senior Data Engineer I(Oracle plsql, Python and AWS)

Title Data EngineerDepartment ISSLocation BengaluruReports To Data Engineers LeadLevel 5We 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 our (name of team/business area) team and feel like you are making progress
• About your teamISS Data Engineering Chapter is an engineering group comprised of three sub-chapters - Data Engineers, Data Platform and Data Visualisation that supports the ISS Department
• Fidelity is embarking on several strategic programmes of work that will create a data platform to support the next evolutionary stage of our Investment Process
• These programmes span across asset classes and include Portfolio and Risk Management, Fundamental and Quantitative Research and Trading
• About your roleThis role sits within the ISS Data Engineering
• The Data Engineering team is responsible for building and maintaining the data applications and platform that enables the ISS business to operate
• This role is appropriate for a senior data engineer capable of taking ownership and a delivering a subsection of the wider data platform or data applications
• Strategic ImpactAs a Senior Data Engineer, you will directly contribute to our key organizational objectives: Cost Efficiency Improve productivity through automating routine maintenance tasks Decrease time to deliver continuous improvement initiatives Optimize infrastructure costs through efficient database design Risk Mitigation Improve system documentation and knowledge transfer Increase automated testing coverage Enhance system and location resiliency

Key Responsibilities

• Develop and optimize SQL queries, stored procedures, and data models for Oracle-based systems Maintain data pipelines for extract, transform, and load (ETL) processes Execute data quality controls and validation processes to ensure data integrity
• Work with team members to understand business requirements and implement technical solutions Create and update documentation for database procedures and configurations Identify and resolve database performance issues through query optimization Support integration between Oracle systems and cloud services, particularly AWS S3 Participate in code reviews and follow best practices for database development Assist in migrating data and processes from legacy systems to modern cloud-based solutions Work within an Agile framework, participating in sprint activities and team ceremoniesAbout youRequired Qualifications: 5-8 years of experience with Oracle databases, SQL, and PL/SQL development Good understanding of data modelling principles and database design Working knowledge of Python for data processing Experience with data quality validation and controls Ability to understand existing database schemas and data relationships
• Experience with version control systems, preferably Git/GitHub Good written communication skills for technical documentation Understanding of Agile development methodologies Familiarity with investment management industry concepts, particularly security reference data, fund reference data, and basic fund accountingAdditional Qualifications: Knowledge of SQL Server development Experience with ETL tools like Informatica or Control-M Unix shell scripting capabilities Understanding of CI/CD principles Familiarity with AWS services, particularly S3, Lambda, and Step Functions Knowledge of database security principles Experience with data visualization tools (Tableau, Power BI) Experience collaborating with team membersFeel rewardedFor starters, well offer you a comprehensive benefits package
• Well value your wellbeing and support your development
• And well be as flexible as we can about where and when you work finding a balance that works for all of us
• Its all part of our commitment to making you feel motivated by the work you do and happy to be part of our team