ETL Developer Resume

SUMMARY

Involved and worked in data integration, Microsoft business intelligence, data warehousing, SSAS, SSIS, ETL solutions, and more. Plan and lead projects and oversee requirements gathering. Supervise project teams. Carried out ETL development, process maintenance, flow documenting, and management, plus T - SQL tuning and SSIS.

TECHNICAL SKILLS

Visual Studio | C# | VBA for Access | SQL Server | SSIS | SSAS | SSRS | PowerBI | MS Access
Database Development | BI Solutions | Data Warehousing & Integration |Object & Dimensional Modeling OLAP & OLTP Data Modeling | Scripting, Coding & Documentation

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

Participated in several projects and interacted with peers
Conduct meetings with stakeholders throughout ETL solution development to gather system requirements from users and ensure user acceptance testing was performed
Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer 8.6 to extract the data from multiple source systems that comprise databases like MySQL Server, SQL Server 7.2, Share Point, Salesforce, JSON files to the Staging area, EDW and then to the Data Marts.
Created database design documentation at architectural and functional level.
Designed and developed the SSIS packages to extract, transform, and load the data into Target
Developed new and customized existing databases using a variety of technologies, languages and programming tools.
Worked on team and individual development projects to deliver secure, robust and scalable DBMS/BI solutions that helped improve efficiency, information security, data integrity and customer satisfaction.
Partnered with Web developers to create database-backed Web site that accelerated scheduled maintenance request and validation process.

Confidential

SQL Developer

Responsibilities:

Designed, developed and maintained relational databases.
Developed and Optimized Stored Procedures and Functions using T-SQL
Gathered business requirements, converted it into technical requirement and SQL stored procedures for database specific projects
Developed physical data models and created DDL scripts to create database schema and database objects
Created Queries in T-SQL, Stored Procedures and Views to store the data of clients, advisors using SQL Server Management Studio and created indexes to the tables that have least updates to improve the query performance.
Tune SQL queries and database performance by improving overall table design, indexing, query plan analysis and refactoring.