Technical Consultant - DataWarehouse

Fidelity International; Bengaluru; On-site; INR 4,000,000 - 7,000,000; Full time

Job summary

Fidelity International in Bengaluru is seeking a seasoned DataWarehouse Technical Consultant to drive ETL development using Informatica iPaaS, integrate Snowflake and Oracle data stores, and coordinate with Salesforce CRM and BI teams to meet business requirements.

The role requires 10+ years in data warehousing, strong SQL and data modeling skills, and a focus on data quality, performance, and customer service. On-call support and documentation duties are part of the responsibilities.

Qualifications

• 10+ years of experience in Datawarehouse development.
• Experience with ETL Informatica development IPAAS.
• Experience with Snowflake data warehouse environment.
• Experience with SQL, SnowScripting and Procedure development.
• Development experience with Oracle database.
• 1+ years of experience with AWS.
• Experience with data modelling tools.
• Strong technical and data analysis skills.
• Excellent problem solving skills.
• Good communication skills.
• Customer service oriented.
• Development experience in Mutual Funds industry is an asset.

Responsibilities

• Interact with Business teams to understand requirements and analyze data requirements.
• Create ETL Mappings, Mapplets, Workflows, Worklets using Informatica iPaaS.
• Develop stored procedures, SQL queries and tune/optimize SQL code.
• Perform administrative duties for IPAAS/IDMC application.
• Execute unit tests to ensure data integrity and performance requirements.
• Participate in on-call support schedule and incident/enhancement tickets.
• Create and maintain technical documents, including data models.
• Collaborate with Salesforce CRM and BI teams on integration tasks.

Skills

ETL

Informatica iPaaS

Snowflake

SQL

Data modelling

AWS

Oracle

Salesforce CRM

Communication

Problem solving

Education

Bachelor’s degree in a relevant field

Tools

Informatica iPaaS

Snowflake

Oracle

Salesforce CRM

AWS

Job description

# **About the Opportunity**Job Type: PermanentApplication Deadline: 14 September 2026**Job Description** Title Technical Consultant - DataWarehouse Department Enterprise Service-Canada Delivery Location Bangalore Reports To Technical Manager Level 5We’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** The technology service team provides IT services to the Fidelity International business, globally. These include the development and support of business applications that underpin our revenue, operational, compliance, finance, legal, and marketing and customer service functions.**About your role** As an experienced DataWarehouse Development talent, you’re expected to be able to Work as an integrated member of the Data Warehouse technology team and drive cross functional data initiatives from beginning to end with various business units, as well as interact with Business teams to better understand the technical functionality requirements and analyze data requirements and their impact to the existing systems.**About you** Fast learning and strong logical thinking, the successful candidate for this position is expect to contribute in below areas: • Strong experience in working with various source and target systems (Snowflake, Oracle, Sales Force, API, flat files) using informatica iPaaS. • Work with Salesforce CRM and BI team members to develop Informatica iPaaS ETL code to satisfy business requirements • Create ETL Mappings, Mapplets, Workflows, Worklets using Informatica iPaaS platform, particularly using Data Integration, Data Ingestion • Develop stored procedures, SQL queries and tune/optimize SQL code on Oracle and Snowflake databases • Perform administrative duties for IPAAS/IDMC application • Execute unit tests to ensure the accuracy of code changes, and to verify that data integrity and performance requirements are met • Participate in team’s on-call support schedule, works on incident and enhancement/maintenance tickets assignments and delivers excellent technical support • Create and maintains technical documents, including data models**Required Skills & Qualifications**• 10+ yrs of experience in Datawarehouse development • Experience with ETL informatica development IPAAS • Experience with Snowflake data warehouse environment • Experience with SQL, SnowScripting and Procedure development • Development experience with Oracle database • 1+ years of experience with AWS • Experience with data modelling tools • Strong technical and data analysis skills • Excellent problem solving skills • Good communication skills • Customer service oriented • Development experience in Mutual Funds industry is an asset**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.