Sonam Patkar

Software Engineer

Cannington, Western Australia, Australia13 yrs 2 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

Led successful migration from Oracle to Snowflake.
Expert in building scalable data models and pipelines.
Strong advocate for mentorship in technology.

Stackforce AI infers this person is a Data Engineering expert in Fintech and Telecom sectors.

Contact

Skills

Core Skills

Data MigrationData WarehousingEtlCi/cdDevops

Other Skills

Agile MethodologiesAmazon Web Services (AWS)Azure DevOps ServicesCICDCognosContinuous Integration and Continuous Delivery (CI/CD)DBeaverData ModelingDataStageDatabase AdministrationExadataGitInformaticaJIRAJavaScript

Experience

Fidelity investments

2 roles

Principal Software Engineer

Promoted

Mar 2022 – Present · 4 yrs · Bengaluru, Karnataka, India · Hybrid

Work and Responsibilities:
Provide technical direction, drive architecture and design decisions, and mentor engineers to ensure scalable and high-quality solution delivery.
Defined strategies for seamless DB object migration, data migration, validation, and unit testing.
Led end-to-end delivery of the marketing data component within an analytics platform by integrating multi-channel data and enabling ROI-driven decision-making
Played a technical lead role in Oracle to Snowflake migration, replacing legacy systems with scalable, cost-effective solutions
Built scalable data models and pipelines for seamless integration into enterprise platforms
Translated business requirements into reliable, production-ready data solutions
Ensured data security, governance, cost optimization, and adherence to best practices
Worked in Agile environment, including sprint planning and cross-functional collaboration
Mentored engineers and supported their technical growth
Contributed to the WitLeads program supporting mentorship and growth for women in technology

PlsqlMicrosoft Power BITableauDatabase AdministrationContinuous Integration and Continuous Delivery (CI/CD)Data Modeling+29

Lead Software Engineer

Dec 2017 – Apr 2021 · 3 yrs 4 mos · Bangalore · On-site

Work and Responsibilities:
Worked as a senior team member to migrate legacy system from Oracle to Snowflake, focusing on performance, scalability, and modernization.
Converted Oracle code to Snowflake, ensured functionality and data validation
Automated data feeds and deployments using shell scripts and Jenkins
Managed CI/CD and Git for DevOps support
Created migration plan, design docs, estimates, and approach docs
Handled prod issues, job failures, and ticket resolution based on priority
Worked on enhancements, fixes, and new development
Used monitoring tools for data tracking and performance
Maintained code quality with SonarQube, followed Agile process

PlsqlOracleSnowflakeShell ScriptingJenkinsGit+2

Mindtree

Technical Lead

Apr 2021 – Mar 2022 · 11 mos · Bengaluru, Karnataka, India · Remote

Work and Responsibilities:
Worked on a large-scale data engineering project for one of the UK’s leading investment and wealth management firms, focused on modernizing deployment and ETL processes.
Led solution design, code reviews, and development best practices
Coordinated with cross-functional teams to ensure timely and quality delivery
Built and customized CI/CD pipelines using SNOWCHANGE for automated deployments
Wrote complex JavaScript procedures for platform control and automation
Designed and developed ETL processes with unit testing, QA, and deployment
Contributed to Snowflake admin automation: DB/schema creation, RBAC setup, cloning, and cleanup

PlsqlContinuous Integration and Continuous Delivery (CI/CD)ETLJavaScriptSnowflakeCI/CD

Tata consultancy services

2 roles

IT Analyst

Promoted

May 2016 – Nov 2017 · 1 yr 6 mos · On-site

Work and Responsibilities:
Worked on modernizing data infrastructure and policy data integration for a leading insurance provider in Ireland.
Migrated legacy systems and policy data feeds to a new platform via data warehouse
Handled end-to-end data warehouse changes and enabled reporting for motor and health policies
Developed automation scripts and shell scripts to extract, transform, and load data from Oracle and Mainframe
Created complex reports, managed daily batch processes, and resolved production issues
Designed ETL logic, conducted code reviews, maintained documentation, and ensured data governance compliance

Data WarehousingETLShell Scripting

Software Engineer

Dec 2012 – Apr 2016 · 3 yrs 4 mos · On-site

Work and Responsibilities:
Worked on Alternate Technology Migration for a major telecom provider, moving systems from centralized to decentralized architecture.
Migrated regional data from Oracle 11g to Exadata across multiple zones
Handled end-to-end data conversion and platform migration across regions
Generated audit reports for validating successful migrations
Developed automation tool for database object migration across platforms
Created SQL and PL/SQL scripts for data extraction, cleansing, transformation, and synchronization

OracleExadataSQLPL/SQLData Migration