ETL Developer Resume

SUMMARY

Having 4.7 years of experience in Development, Customization, Maintenance, Implementation and Deployment of database Applications using SQL Server and on Data warehousing using MSBI tools SQL Server Integration Services (SSIS)
Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T - SQL statements for various applications.
Experience in Tuning SQL Queries & improving the performance of the Database.
Good knowledge on Sub-queries, Joins and stored procedures and Triggers and Troubleshooting SQL Code.
Implemented Data integrity, Error Handling through TRY-CATCH-THROW statement.
Having experience in developing SSIS packages.
Expertise in Data Warehouse applications, directly responsible for the Extraction, Transform and Load from different sources into Data Warehouse.
Extensively worked on creating packages by implementing transformations, containers in Integration Services.
Well versed with package configurations, logging, deploying and Scheduling.
Highly motivated, quick learner and extremely versatile.
Accepts responsibilities and job duties eagerly with minimal supervision required.

TECHNICAL SKILLS

Operating systems: MS - Windows

Programming Languages: SQL, T-SQL

RDBM: Microsoft SQL Server 2008 R2, 2012, 2014, 2016

ETL Tool: SQL Server Integration Services (SSIS)

Utilities: SQL Server Management Studio

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Technology: SQL Server 2016, SSIS 2017.

Responsibilities:

Interacting with Onsite people, taking clarifications regarding applications.
Analyzing the requirements and discussed with managers and leads on the functionality.
Participate in Walk-through sessions with onsite people.
Modifying the Stored Procedure after discussions with BA, to implement business logics.
I worked with deferent types of sources like (Excel files, CSV files, and database tables)
Validated existed ETL packages. And Validating source records and target records database.
Experience in developing SSIS packages for integrating data from different sources into a data warehouse.
Creating SSIS packages based on the schemas for loading data.
Analyzed and established mapping between source and target databases for data migration.
Monitored the performance of the database and checked on the execution time.
Created knowledge share documents and created inventory process documents shared with team.

Confidential

MSBI Developer

Technology: SQL Server 2016, SSIS.

Responsibilities:

Interacting with Onsite people, taking clarifications regarding applications.
Analyzing the requirements and discussed with managers and leads on the functionality.
Participate in Walk-through sessions with onsite people.
Creating tables, indexes, Functions and Stored Procedures in SQL Server 2016.
Writing complex SQL queries involving multiple tables inner and outer joins. Creating various clustered, non-clustered indexes.
Modifying the Stored Procedure after discussions with BA, to implement business logics.
Validated existed ETL packages. And Validating source records and target records database.
Creating SSIS packages based on the schemas for loading data.
Analyzed and established mapping between source and target databases for data migration.
Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown and Sub-reports based on the requirements.
Monitored the performance of the database and checked on the execution time.
Created knowledge share documents and created inventory process documents shared with team.