Data Engineer

Fidelity International

2 - 5 years

4 - 7 Lacs

Bengaluru

Posted:7 hours ago| Platform:

Apply

Skills Required

python data processing database design agile development methodology oracle server continuous integration github aws iam ci/cd power bi sql plsql git unix shell scripting lambda expressions shell scripting agile etl aws informatica unix

Work Mode

Work from Office

Job Type

Full Time

Job Description

Design, develop, and optimize complex SQL queries, stored procedures, and data models for Oracle-based systems
Create and maintain efficient data pipelines for extract, transform, and load (ETL) processes using Informatica or Python
Implement data quality controls and validation processes to ensure data integrity
Collaborate with cross-functional teams to understand business requirements and translate them into technical specifications
Document database designs, procedures, and configurations to support knowledge sharing and system maintenance
Troubleshoot and resolve database performance issues through query optimization and indexing strategies
Integrate Oracle systems with cloud services, particularly AWS S3 and related technologies
Participate in code reviews and contribute to best practices for database development
Support migration of data and processes from legacy systems to modern cloud-based solutions
Work within an Agile framework, participating in sprint planning, refinement, and retrospectives
Required Qualifications
3+ years of experience with Oracle databases, including advanced SQL & PLSQL development
Strong knowledge of data modelling principles and database design
Proficiency with Python for data processing and automation
Experience implementing and maintaining data quality controls
Experience with AI-assisted development (GH copilot, etc..)
Ability to reverse engineer existing database schemas and understand complex data relationships
Experience with version control systems, preferably Git/GitHub
Excellent written communication skills for technical documentation
Demonstrated ability to work within Agile development methodologies
Knowledge of concepts, particularly security reference data, fund reference data, transactions, orders, holdings, and fund accounting
Additional Qualifications
Experience with ETL tools like Informatica and Control-M
Unix shell scripting skills for data processing and automation
Familiarity with CI/CD pipelines for database code
Experience with AWS services, particularly S3, Lambda, and Step Functions
Knowledge of database security best practices
Experience with data visualization tools (Power BI)
Familiarity with domains (Security Reference, Trades, Orders Holdings, Funds, Accounting, Index etc)

More Jobs at Fidelity International

Associate - Reconciliations - GPS Delivery

Gurgaon, Haryana, India

Experience: Not specified

Salary: Not disclosed

Assistant Manager - Cash & Control

Gurgaon, Haryana, India

2 - 5 yrs

Salary: Not disclosed

Senior Associate - Product Management - GPS Delivery

Gurgaon, Haryana, India

2 - 5 yrs

Salary: Not disclosed

Associate - Reconciliations - GPS Delivery

Gurugram, Haryana

Experience: Not specified

Salary: Not disclosed

PI & Advisory Operations Associate

Gurugram, Haryana

Experience: Not specified

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview Now

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.