b
babssirwani

Reshma S

@babssirwani

ETL Developer

India
English, Hindi, Marathi, Sindhi
About me
I am an experienced ETL Developer and Database professional with a strong background in SQL Server, SSIS, and data analysis. I have a proven track record in both corporate environments and academia, having served as a Lecturer in Management and Computer Engineering. Currently, I am expanding my technical expertise into Full Stack Web Development to drive innovation and growth.... Read more

Skills

b
babssirwani
Reshma S
Offline • 

See my services

Data Formatting
I will clean, format, and organize excel spreadsheets
From$15 / projectMore details

Portfolio

Work experience

Trellance

ETL Developer

Trellance

Dec 2021 - Feb 2023 • 1 yr 2 mos

• Write complex queries ,dynamic queries, subqueries,complex joins for generating complex Stored procedures, triggers,user defined functions,views, cursors and stored procedures to analyse and extract data..Packages to ensure compliance with business requirements and clearly document testing method used. • Used ETL(SSIS) to develop jobs for extracting, cleaning, transforming and loading data in data warehouse.Involved in the development of the ETL process for extracting data from different file sources like csv, txt.Performed transformation and validation processes. • Involved in creating multiple parameterized stored procedures which were used by packages to get the data. • Implemented fixes and enhancements to existing modules and new modules. • Worked on formatting SSIS packages using Global variables and expressions. • Designed SSIS packages to transfer data from flat files to SQL Server . • Extensively used SSIS transformations such as Lookup, Derived column,Data conversion,Aggregate, conditional split,SQL task,script task, send mail task . • Actively participated in daily meetings. • DBMS like SQL Server and knowledge of the same to perform automated task. .