SANTHOSH KUMAR V

Client: Franklin Templeton

Project Title: FTI WEALTHX SEI Migration

Tools: Bitbucket and GitBash

Platforms: Snowflake and Azure

Languages: Python and PL/SQL

Description:

FTI WEALTHX is a Wealth management system and has been pursuing its objective to implement modern data platform on Snowflake for Fiduciary & Penn Trust wealth. The WealthX Data Platform solution with SEI migration will help in reaping the benefits of a modern data platform such as improved data ingestion/transformation operations, data management, governance, and consumption. FTI WEALTHX empowers wealth management businesses to optimize operations, drive innovation, and deliver data-driven insights for better decision-making.

Job description:

• Developed efficient and scalable ELT processes using Python with Snowflake Connector, Snowflake tasks and procedures to automate data pipelines and ensure timely data processing.
• Utilized Snowflake Scripting to dynamically generate SQL and execute complex workflows, enabling conditional data processes aligned with business requirements.
• Designed and implemented comprehensive audit logging mechanisms using the Python logging module and Snowflake Scripting for debugging, monitoring, and troubleshooting ELT processes.
• Designed and implemented fact tables, dimension tables, and Slowly Changing Dimensions (SCDs) for data marts.
• Leveraged Azure Data Factory (ADF) to efficiently integrate and orchestrate data workflows, moving and transforming data between sources such as Azure Blob Storage and Snowflake.
• Skilled in using Git commands for effective branching and merging strategies, and proficient in managing Git repositories on Bitbucket via Git Bash for version control, including creating and maintaining feature branches.