Lead - Data Engineer

Job Description:

Job Title – Lead Data Engineer [FDA India]

The Purpose of This Role

At Fidelity, we use data and analytics to personalize incredible customer experiences and develop solutions that help our customers live the lives they want. As part of our digital transformation, we have significant investments to create innovative big data capabilities and platforms. One of them is to build various enterprise data lakes by gathering data across Business Units. We are looking for a hands-on data engineer who can help us design and develop our next generation, cloud enabled data capabilities.

The Value You Deliver

You will be participating in end to end development which includes design, development, testing and deployment.

You will be working closely with Technical Lead/Architects to ensure that solutions are consistent with IT Roadmap.

You will be participating in technical life cycle processes, which include impact analysis, design review, code review, and peer testing.

You will be participating in hands on development of Enterprise data lake on Snowflake (AWS) , Python, NiFi, , along with Control-M and UNIX shell scripts.

You will be troubleshooting and fixing any issues reported on data issues and performance.

You will be presenting the findings and outcome to Senior Leadership teams and provide insights from the data to the business.

You will be helping business teams optimize their current tasks and increase their productivity.

The Skills that are Key to this role

Technical / Behavioral

You must have proven track record of working in collaborative teams to deliver high quality data solutions in a multi-developer agile environment following design & coding best practices.

You must be an expert in using SQL queries with UNIX shell /Python scripting skills.

You should have experience of using AWS services like EC2, S3, EMR to move data onto cloud platform and experience with Enterprise data lake strategy and use of Snowflake (AWS) is a big plus.

You must have knowledge to develop ELT/ETL pipelines to move data to and from Snowflake data store using combination of Python and Snowflake SnowSQL is a big plus.

You should have experience in SQL performance optimization for large data volumes.

You should have proven analytical and problem-solving skills

You should be strong in Database and Data Warehousing concepts.

You must be able to work independently in a globally distributed environment

You must have superior SQL and Data Modeling skills and experience performing deep data analysis on multiple database platforms like Oracle, Netezza or Snowflake.

You should have experience in working with devops tools for code migrations.

Nice to have working experience in Control-M or similar scheduling tools.

Nice to have adequate knowledge on DevOps, JIRA and Agile practices.

The Skills that is good to have for this role

Experience in performance tuning and optimization techniques on SQL (Oracle and Netezza) and Informatica Power Center.

Having strong inter-personal and communication skills including written, verbal, and technology illustrations.

Having adequate knowledge on Snowflake, DevOps, JIRA and Agile practices.

How Your Work Impacts the Organization

Cloud Enablement and Data Model ready for Analytics.

Fidelity Data architecture provides data and architecture solutions to enterprise wide business functions including, Enterprise Cyber Security, Records Management, Compliance, Legal, Risk and Security and Finance Management Technology. Information Management and Analytics are at the center of IT Strategy to enable business capabilities delivered by this group for Managerial Finance, Compliance, Fraud Detection, and Human Capital Management.

Your work at Fidelity Data & Architecture domain will help to deliver elegant and innovative data and analytics solutions for Enterprise Technology Global Services and Fidelity faster using modern data engineering & management practices.

The Expertise we’re looking for

• 6+ [Lead] years of experience
• Graduate / Post Graduate

Location: Chennai - TRIL

Shift timings: 11:00 am - 8:00pm

Certifications:

Company Overview

At Fidelity, we are focused on making our financial expertise broadly accessible and effective in helping people live the lives they want. We are a privately held company that places a high degree of value in creating and nurturing a work environment that attracts the best talent and reflects our commitment to our associates. We are proud of our diverse and inclusive workplace where we respect and value our associates for their unique perspectives and experiences. Fidelity India has been the Global Inhouse Center of Fidelity Investments since 2003 with offices in Bangalore and Chennai. For information about working at Fidelity, visit India.Fidelity.com.

Fidelity Investments is an equal opportunity employer.