Samta Wankhede
Calgary,Canada
Summary
Experienced data integration specialist well-prepared for this role. Demonstrates expertise in ETL processes using Informatica, SQL, and data warehousing. Strong focus on team collaboration, reliability, and adaptability to changing needs. Known for problem-solving, analytical skills, and delivering impactful results.
Worked on unix scripting, Data Analysis, Design, Implementation, Administration, and Support of Business Intelligence, OLTP (Batch Processing, Online Processing), OLAP, ETL, Data warehousing, Data mining, DBMS, and Data Modeling using Confidential SQL Server Experience in Migrating SQL database to Azure Data Lake, Azure Data Lake Analytics, Azure SQL Database, Data Bricks, and Azure SQL Data Warehouse.
Experienced in all facets of the Software Development Life Cycle (Analysis, Design, Development, Testing, and maintenance) using Waterfall and Agile methodologies. Excellent communication skills with excellent work ethics and a proactive team player with a positive attitude.
Overview
15
15
years of professional experience
1
1
Certification
Work History
ETL Informatica Developer
Rogers Telecommunications
07.2023 - Current
- Successfully migrated legacy ETL processes to Informatica PowerCenter, resulting in increased efficiency and reduced maintenance effort.
- Enhanced data integration by designing and developing efficient ETL processes using Informatica PowerCenter.
- Developed reusable templates for common tasks that reduced development time across multiple projects.
- Efficiently resolved each inquiry within the timeframe
- Supported fellow teammates by providing training related to the products and processes
- Identified, troubleshot and corrected bugs and bottlenecks.
- Documented each customer interaction by following the authentication processes and creating cases using Salesforce
ETL Consultant
Shaw Telecommunication
04.2021 - 07.2023
- Championed data-driven decision making within the organization by promoting the use of Business Intelligence solutions at all levels.
- Successfully migrated legacy ETL processes to Informatica PowerCenter, resulting in increased efficiency and reduced maintenance effort.
- Developed efficient stored procedures for complex business logic, reducing processing time and improving system stability.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Resolved every inquiry with utmost attention to detail and provided resolution promptly
- Provided technical support for end-users by addressing SQL-related issues, enhancing overall user satisfaction with the application.
ETL Consultant
Shaw Telecommunication
01.2021 - 03.2021
- Assisted database administrators in optimizing SQL queries for faster response times during data extraction tasks.
- Provided support during production deployments by troubleshooting issues and ensuring seamless transitions between environments.
- Optimized performance by identifying bottlenecks in ETL processes and implementing solutions to resolve them.
- Created Unix scripts to run the Informatica jobs using Tidal tool to execute the jobs
- Supported the application and troubleshooted the issues or errors during the execution and resolved the incidents successfully.
Senior Software Engineer
HSBC Software Development India
06.2018 - 05.2020
- Experienced professional in Data Analysis with expertise in Data management implementation projects powered by Markit EDM & reporting using Tableau
- Adept in identifying business's pain points, performing data analysis, and reporting experience for buy & sell side asset management space
- Experience in working with Agile methodologies
- Developed the packages to populate the data into the Enterprise Data Warehouse from various sources like Flat File, Excel spreadsheet, and access into OLEDB Destination (SQL Server)
- Involved in consulting team, providing solutions, debugging code, developing solutions, validating derived logics for attributes & testing Solvency II reporting (D1, D2O, D4 collectives, D2T, etc.) & publishing daily positions reports for Strategic/Tactical stream (for investment/insurance clients)
- Excellent knowledge of STLC, SDLC, and Defect management processes
IT Analyst
Tata Consultancy Services India
05.2017 - 05.2018
- Gathered user business requirements, and translated them as technical specifications and design documents for development
- Actively involved in requirements gathering/analysis meetings with businesses and provide descriptions about the analysis and approach
- Worked as an SQL developer to write complex queries like Stored Procedures, Triggers, Functions, Indexes, Tables, Views, and other T-SQL code and SQL joins for applications
- Evaluated technical designs and data mapping documents, in partnership with designers and developers, based on user requirements and suggested any changes required
- Created ETL flows using Informatica to load data from various sources like flat files, and CSV files and load into SQL Server
- Analyzed customer reports daily and provided feedback wherever required to pinpoint the corrections needed to maintain the accuracy of information
- Implemented timestamp-based CDC and SCD type1 and type2 using Informatica mappings to capture delta in SQL Server
- Provided support during the migration of the project to the production environment and helped support application making sure the deliverables were reported on a timely basis to the client
- Analyzed recurring issues to provide permanent fixes for the problems in the application
- Created documents for tracking all the problems, incidents, and changes raised in the production support application
Associate Projects
Cognizant Technology Solutions India
08.2010 - 03.2017
- Worked as an SQL developer to write complex queries like Stored Procedures, Triggers, Functions, Indexes, Tables, Views, and other T-SQL code and SQL joins for applications
- Gathered user business requirements and translated them into technical specs and design docs for development
- Actively involved in requirements gathering/analysis meetings with Business and described the analysis and approach
- Created and developed Informatica jobs to automate the execution of the packages at a particular time depending on requirements
- Extensively used Informatica to move data from text files to SQL Server
- Developed clutter-free Tableau dashboards for various product lines and departments
- Effectively utilized Tableau features like parameters, calculated fields, and filters to provide efficient data visualization solutions to the customer
- Created Complex ETL Packages using Informatica to extract data from staging tables to partitioned tables with incremental load
- Created logging for ETL load at package level and task level to log a number of records processed by each package and each task in a package using Informatica
- Experience in building Informatica packages involving ETL process, extracting data from various flat files, Excel files, legacy systems, and loading into SQL server
- Hands-on experience working with Informatica, for the ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions, and package configurations
- Designed ETL packages dealing with different data sources (SQL Server, Flat Files, XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using Informatica Power center
- Imported various heterogeneous files using Informatica Power Center 8
- X Source Analyzer
- Involved in SQL testing to meet business deadlines
- Coordinated and attended everyday standups/scrum/agile meetings and weekly sprint meetings to evaluate completed work
- Worked on Agile Methodology
Education
Bachelor of Technology - Computer Engineering
Babasaheb Ambedkar Technological University
05.2010
Skills
- SQL Server proficiency
- MS Access
- Oracle software proficiency
- SQL proficiency
- DB2
- Informatica ETL proficiency
- Proficient in Azure Data Factory
- Proficient in Power BI
- Proficient in Tableau
- Expertise in Excel functions
- Experienced with Python programming
- Pandas
- Shell scripting proficiency
- Database querying
- Proficient in PL/SQL development
- MS Visio
- MS Project
- Jira issue tracking
- Experienced in Confluence management
- Windows Server 2012 R2
- Windows Server 2008
- Proficient in Windows 10
- Windows 8
- Windows 7
- Windows XP
- Linux troubleshooting expertise
Timeline
ETL Informatica Developer
Rogers Telecommunications
07.2023 - Current
ETL Consultant
Shaw Telecommunication
04.2021 - 07.2023
ETL Consultant
Shaw Telecommunication
01.2021 - 03.2021
Senior Software Engineer
HSBC Software Development India
06.2018 - 05.2020
IT Analyst
Tata Consultancy Services India
05.2017 - 05.2018
Associate Projects
Cognizant Technology Solutions India
08.2010 - 03.2017
Bachelor of Technology - Computer Engineering
Babasaheb Ambedkar Technological University
Certification
Career Services for Foreign Trained Professionals, Calgary Immigrant Women’s Association, Calgary, AB, 10/01/20, 12/31/20
Similar Profiles
AMAN SATIJAAMAN SATIJA
Business Sales Consultant at Rogers TelecommunicationsBusiness Sales Consultant at Rogers Telecommunications
Kimberly GauvinKimberly Gauvin
Customer Service Representative at Rogers TelecommunicationsCustomer Service Representative at Rogers Telecommunications
Ankur SaxenaAnkur Saxena
Sales Associate at Rogers TelecommunicationsSales Associate at Rogers Telecommunications
BARRY COTTOYBARRY COTTOY
Furniture Mover at Two Small Men with Big Hearts Moving CompanyFurniture Mover at Two Small Men with Big Hearts Moving Company
Kim SteeleKim Steele
National Director, Government Relations & Advocacy at Cystic Fibrosis CanadaNational Director, Government Relations & Advocacy at Cystic Fibrosis Canada