Employment History 

• ETL developer

  Colaberry Inc.

  May 2020 - Present

   Integration and migration of data from various types of sources (excel, XML, JSON files, CSV, flat file, OLE DB) in SSIS.
   Clean and transformed data from staging tables base on business requirements using various transformations and load them into a data warehouse.
   Proficient knowledge in data marts, Operational Data Store (ODS), Star Schema, snowflake schema using Fact and Dimension tables.
   SQL Query Optimization and Performance Tuning, Optimizing Stored Procedures and long running queries using indexing strategies and query optimization techniques.
   Served as a collaborative team member within both project management and software development life cycles (SDLC) including analysis of business functions, design, development, testing and documentation as required by end-users.
   Complete understanding of subset SQL such as Data Definition Language (DDL), Data Manipulation Language (DML), Data Control Language (DCL).
   Implemented different Slowly Changing Dimension methodologies and Merge Statements to maintain and update data corresponding to Dimension tables in the Data warehouse.
   Troubleshoot problems that may come up with database environments like performance issues.
   Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
   Used SSRS to generate Sub-Reports, Drilldown, Drill-through, and Parameterized reports.
   Proficient in creating SQL objects such as Tables, Complex Stored Procedures, User- defined Functions, Views, Indexes, Triggers, Joins and CTEs.