Sr.ETL Developer, Resume CINCINNATI, OH - Hire IT People

SUMMARY

Proficient in Extracting, Transforming and Loading (ETL) Data from different type of Sources such as Excel, Oracle, and Flat Files using SQL Server Integration Services (SSIS) from OLTP to OLAP
Experience in generating on - demand and scheduled Reports for Business Analysis or Management Decisions using (SSRS).
Created weekly and Monthly Reports as per requirement using SSRS and Scheduled Reports to be delivered to User on-demand Basis or run on daily, weekly and monthly basis in SSRS report Manager.
Worked on Power BI Desktop by extracting data from different sources, by writing queries according to business needs in query editor.
Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.

TECHNICAL SKILLS

C++,Python, SQL Server 2014/16,SSIS,SSRS,SSAS,Power BI

PROFESSIONAL EXPERIENCE

Sr.ETL Developer,

Confidential, CINCINNATI, OH

Responsibilities:

Loading data from source to destination using ssis.
Wrote Stored Procedures to insert the data to the staging table using ssis from staging to production we moved through Stored Procedures.
Created Triggers for the automatic event in the audit tables so that if any changes occur in the base table it automatically triggers in the audit table
Worked on Incremental load to load the data from various sources to destination for the past 6 hour data to load in the target.
Created packages by checking the destination tables if they are getting loaded or not into Datawarehouse.
Deployed SSIS packages to SQL server agent for the automatic schedule of jobs.
Created tables to pull the data from the Datawarehouse and load it to the destinations by applying different types of transformations.
Documented the Data Lineage for the future reference for the business and to keep track of the packages and Jobs whether they are loading the data into the tables according to the scheduled job.

Environment: MySQL, SSMS (SQL Server Management studio), Microsoft Visual Studio 2017, Pervasive, SQL Server agent, Confluence, SVN, TFS.

ETL/BI Developer

Confidential, Charlotte, NC

Responsibilities:

Loading data from source to target using SSIS which involves tasks, containers and transformations depends on requirement.
Designed complex ETL strategies to pull data from different sources, like SQL server, and flat files and load it to the destination database using API files after using multiple transformations.
Participated in agile and Retrospective ceremonies to discuss about the requirements.
Created database objects like Tables, DML, DDL, Views, Stored Procedures, Functions, Joins, and Indexes in T- SQL based upon the functional specifications
Extensively worked on developing database objects like Stored Procedures, Views, Indexes, Triggers and Functions using T- SQL and performance tuning of SQL Queries.

Environment: SQL Server 2014, SQL Server Data Tools, Microsoft Visual Studio 2017, GIT, Oracle SQL developer 18c, Linux, Version One, SQL Server Agent, Tortoise, Power BI, MS Excel.

ETL / SQL BI Developer

Confidential, Cincinnati, OH

Responsibilities:

Involved in Technical discussions about business gathering requirements with Product Owner, Client Team.
Analyzed Informatica Mapping and COBOL code which was the ETL framework for ODW to identify sources and transformations to re-build that in SQL server for the EDW.
Developed the code in SQL Server using SSIS with different type of Transformations like Audit, Look-up, aggregate, Data conversion, Multi-cast.
Responsible for understanding the complex SSIS packages and make understandable to the team
Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart
Ensures adherence to Data Management/Data Governance Policies
Create and maintain Documentation for existing architecture, and data lineage of the source and target.

Environment: SQL Server 2008, SQL Server 2012/2016, SQL Server Data Tools, Microsoft Visual Studio 2015, TFS, MS Office 2010, UC4, Service Now, JIRA, Informatica PowerCenter 8.6.1, Beyond compare, SSMS,Python

SQL Server Developer

Confidential

Responsibilities:

Developed, maintained and executed SQL queries and validated completeness, integrity, and accuracy of data.
Designed, developed, and tested stored procedures, views and complex queries for the creation of Reports.
Involved in Designing and developing ETL packages using Heterogonous Sources to Destination (SQL Server).
Successfully created SSIS packages using Sequence Container, Data Flow, Execute SQL, Bulk Insert, Send Confidential Etc.
Used SQL Server Agent for job scheduling.
Used advanced features of T-SQL in-order to design and tune T-SQL to interface with the database and other applications in the most efficient management.

Environment: MS SQL Server 2005/2008, SSIS, SSRS, SQL Server Studio Management, Visual Studio, MS Excel, SQL Server Agent

We provide IT Staff Augmentation Services!

Sr.etl Developer, Resume

Cincinnati, OH

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship