Job Description
Title Technical Lead - DataWarehouse
Department Enterprise Service-Canada Delivery
Location Dalian/India
Reports To Technical Manager
Level 4
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
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
- 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
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.
For more about our work, our approach to dynamic working and how you could build your future here, visit careers.fidelityinternational.com.
Skills Required
- University Degree in Computer Science
- 3+ years of ETL Informatica development IPAAS experience
- 2+ years with Snowflake data warehouse
- 3+ years of SQL and Procedure development
- 3+ years of Oracle database development
- 1+ years of AWS experience
- 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
Fidelity International Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Fidelity International and has not been reviewed or approved by Fidelity International.
-
Parental & Family Support — Family leave and carers’ support are emphasized via equalized paid parental leave globally and enhanced maternity/adoption policies. Inclusive provisions also cover carers’ leave and compassionate leave to support diverse family needs.
-
Healthcare Strength — Healthcare benefits and private medical insurance are consistently highlighted as part of the core package across locations. Wellbeing resources, including an Employee Assistance Programme and menopause support, reinforce the depth of health coverage.
-
Retirement Support — Pension and retirement savings are positioned as a strong element of the total package in multiple markets. Retirement design is frequently cited alongside paid time off and flexibility as part of a solid overall offer.
Fidelity International Insights
What We Do
Fidelity International offers investment solutions and services and retirement expertise to more than 2.5 million customers globally. As a privately held, purpose-driven company with a 50-year heritage, we think generationally and invest for the long term. Operating in more than 25 countries and with $739.9 billion* in total assets, our clients range from central banks, sovereign wealth funds, large corporates, financial institutions, insurers and wealth managers, to private individuals. Our Workplace & Personal Financial Health business provides individuals, advisers and employers with access to world-class investment choices, third-party solutions, administration services and pension guidance. Together with our Investment Solutions & Services business, we invest $567 billion on behalf of our clients. By combining our asset management expertise with our solutions for workplace and personal investing, we work together to build better financial futures. *Data as of 31 March 2021
