Saranya Bakkiyanathan
Chennai
Summary
Data Engineer with over 7 years of expertise in Snowflake, PLSQL, and Python, executed complex ETL process migrations. Proven ability to solve complex problems, collaborate with teams, and drive successful project outcomes. Dedicated to ongoing learning and growth.
Overview
7
7
years of professional experience
Work History
PLSQL Developer
Capgemini India Pvt. Ltd.
Chennai, Tamil Nadu
11.2024 - Current
- Developed stored procedures to process real-time and batch data for BI projects.
- Coordinated with data modelers to ensure seamless integration of analytics requirements.
- Modified existing code based on evolving business needs for improved functionality.
- Executed new developments requested by analytics and product owner to enhance project outcomes.
Snowflake Developer
Capgemini India Pvt. Ltd.
Chennai
02.2023 - 12.2023
- Migrated guest data and other domains, including Casino and Hotel, to Snowflake.
- Developed SQL procedures, scripts, tasks, and streams as a Snowflake developer.
- Addressed Airflow DAG issues to ensure smooth project operations.
- Utilized CI/CD pipeline within Agile project framework to enhance development efficiency.
Snowflake Developer
Capgemini India Pvt. Ltd.
Chennai, Tamil Nadu
01.2022 - 01.2023
- This project Integrated consumer products and licensing across various domain - Retail, Finance, Product
- Migrated ETL processes from DB2 using Informatica to Snowflake.
- Gathered requirements and developed jobs in UC4 based on Informatica mappings for data loading into Snowflake.
- Designed and developed fact and dimension tables essential for visualization.
- Enabled UC4 jobs in production, UAT, and staging environments, monitoring results through reports.
- Facilitated discussions with clients to analyze development requirements and manage incidents via Jira.
- Converted shell scripts into SnowSQL with modifications as per client specifications.
- Developed SnowSQL scripts while validating data between DB2 and Snowflake.
Snowflake Python Developer
Capgemini India Pvt. Ltd.
Chennai, Tamil Nadu
10.2021 - 12.2021
- This project is a Snowflake migration project to replace the Application developed Using Java Spring Framework
- Wrote configuration files for Snowflake Stage integration and SQL scripts for data loading.
- Used AWS DynamoDb for avoiding reprocessing file.
Python Developer
Infosys Ltd
02.2020 - 05.2021
- Worked as a python developer for a python CLI(command line interface) tool. The objective of the tool is to Automate the validation of stored procedures.
- Tool is developed based on python and Django framework for enabling automated way of functional testing.
- User will provide the information in excel sheet as input and with the help of pandas will read the data and process it in python script and send the required data to Django using REST API’s.
- For debugging purpose, implemented logs with different logginglevels (debug, info, warning, error and exception).
- Followed Agile scrum in creating and picking up the user stories.
- Technology used in project: Python – Django (Backend)
- Environment: Database Related: DB2
Python Developer
Infosys Ltd
06.2019 - 01.2020
- Project is a web based Automation tool which is used to perform data validations in ETL, migration and big data projects.
- The features of a tool includes comparison, DB Connection, query playground, Sanity Checks, Batch mode and Test cases
- Worked on Sanity Checks module which is used for performing different data checks such as null, duplicate checks.
- Worked on DB Connection module for connecting to different database servers.
- Worked on testcase modules to add, delete, display saved testcases.
- Technology used in project: Python, SQL
- Environment: Database Related: MSSQL, MYSQL, DB2, Sybase, Operating System: Windows 8
Pyspark Developer
Infosys Ltd
11.2018 - 06.2019
- This project is a Cloud migration of real time data from AWS S3 to Redshift DB using pyspark
- The project involves processing the large data stored in S3 object(xml, , csv) in parallel using spark standalone clusters.
- Created different parsers to copy the processed data into Redshift using the copy command. Created different functionalities as an alternative to stored procedures.
- Migrated Historical Data from SQL server to AWS S3 by analyzing stored procedures and tables.
- Technology used in project: Pyspark
- Environment: Database Related: AWS Redshift, ETL: Pyspark, AWS S3
Education
Bachelor of Engineering - Electronics and telecommunication
Vel Tech Multi Tech Dr. Rangarajan Dr. Sakunthala Engineering College
Tamil Nadu, India06.2018
Skills
- programming: Python, PL/SQL
- Operating systems: Windows, Ubuntu
- Database management: MySQL, DB2, MSSQL Server, Oracle
- Cloud computing: AWS S3,EC2,Redshift,SNS
- Data warehousing: Snowflake
Integrated development environments: Eclipse, Spyder, PyCharm, Visual Studio
- Web development: HTML and CSS
Contact Information
+91-9566293258, saranyabprofession96@gmail.com
Languages
- English
- Tamil
- Hindi
Personal Information
- Date of Birth: 08/04/96
- Gender: Female
- Nationality: Indian
- Marital Status: Married
Residence
Chennai, Tamil Nadu, India
Timeline
PLSQL Developer
Capgemini India Pvt. Ltd.
11.2024 - Current
Snowflake Developer
Capgemini India Pvt. Ltd.
02.2023 - 12.2023
Snowflake Developer
Capgemini India Pvt. Ltd.
01.2022 - 01.2023
Snowflake Python Developer
Capgemini India Pvt. Ltd.
10.2021 - 12.2021
Python Developer
Infosys Ltd
02.2020 - 05.2021
Python Developer
Infosys Ltd
06.2019 - 01.2020
Pyspark Developer
Infosys Ltd
11.2018 - 06.2019
Bachelor of Engineering - Electronics and telecommunication
Vel Tech Multi Tech Dr. Rangarajan Dr. Sakunthala Engineering College