About the Opportunity

Job Type: Permanent

Job Description

- Title: Technical Consultant - DataWarehouse
- Department: Enterprise Service-Canada Delivery
- Location: Gurgaon
- Reports To: Technical Manager
- Level: 5

Were proud to have been helping our clients build better financial futures for over 50 years. How have we achieved thisBy working together - and supporting each other - all over the world. So, join our team and feel like youre 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, youre 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 solid logical thinking, the successful candidate for this position is expect to contribute in below areas:

Responsibilities

- Strong experience in working with various source and target systems (Snowflake, Oracle, Sales Force, API,



flat 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 teams 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

- University Degree, preferably in Computer Science
- 3+ years of experience with ETL informatica development IPAAS
- 2+ years of experience with Snowflake data warehouse environment
- 3+ years of experience with SQL, SnowScripting and Procedure development
- 3+ years of 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

📌 Technical Consultant - DataWarehouse (Gurugram)
🏢 Fidelity International
📍 Gurugram