Jr. ETL Developer Resume

SUMMARY

Good knowledge on Microsoft Business Intelligence Tools including Integration Services (SSIS), Reporting Services (SSRS).
Academic knowledge on C/C++.
Good knowledge in developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Joins and indexes with T - SQL.
Possess knowledge in performing ETL operations using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert.
Possess knowledge in designing, developing, monitoring and deploying SSIS packages.
Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
Sound knowledge of software development life cycle (SDLC) with substantial experience with object oriented analysis and design methodologies.
Good knowledge in migrating DTS packages to Integration Services Packages.
Knowledge on creating Web Forms using ASP.NET, C#, XML, HTML, CSS and JavaScript.
Knowledge on building master pages, user controls, implementing client-side validations using ASP.NET validation controls.
Knowledge on developing windows and web based application and web services using c#.NET and VB.NET with Microsoft Visual Studio and methods to call web services using C#.NET SOAP.
Knowledge on AJAX to allow partial page post back, enhance UI pages for the web applications using AJAX controls.

TECHNICAL SKILLS

Tools: BIDS, Visual Studio 2010, SQL Server Management Studio.

ETL & Reporting Tools: SSIS, SSRS, Excel

Databases: SQL Server 2012/2008R 2/2008/2005/2000 , Oracle9i10g11g

Programming Languages: SQL, T-SQL, PL/SQL, C, C++, C#, VB

Web technologies: HTML, XML, VBScript, C#, ASP.NET.

PROFESSIONAL EXPERIENCE

Jr. ETL Developer

Confidential

Responsibilities:

Developed SSIS Packages and Stored Procedures to load/transform/cleanse data from SQL Server, and Excel Files to Facts and Dimension Tables in the Data Warehouse.
Created complex T-SQL Queries, Stored Procedures, Functions, Indexes, CTE’s, Views, Joins and Triggers.
Created script tasks and components with C# and VB.NET in SSIS as part of ETL load.
Created SSRS reports such as tabular, matrix, charts, dashboard and sub-reports using SSRS 2012/2008 R2.
Created complex SQL queries, stored procedures, functions, triggers, joins and SSIS/DTS packages.
Developed SSIS 2008 Packages to migrate data from Excel, AS/400, iSeries and Flat file and Access into SQL server 2008 for further Data Analysis and Reporting by using multiple transformations.
Performed complex SSIS ETL operations to validate, cleanse, transform and load data to data warehouses.
Developed SSIS code using parameter files to update the SSIS package to a delta process from a bulk load process.
Worked with SSIS Variables, Scripting, event-handlers, package configurations and deployment.
Configured Database Mail for sending automatic emails when a SSIS package is failed or succeeded.
Developed, deployed and monitored SSIS Packages.
Involved in web development using C#, VB.NET, ASP.NET, XML, ADO.NET, HTML, VB script and Ajax.
Designed user interface screens and implemented application logic under Microsoft.NET framework using ASP.NET.
Created Web Forms using ASP.NET, MS Visual Studio .NET, C#, VB.NET, XML, VBScript, HTML, DHTML, CSS, JavaScript.

Environment: - SQL Server 2012/2008 R2/2008, SQL Server Data Tools, T-SQL, SSIS, SSRS, Excel, DTS, C#, VB.NET, SVN, Windows Server 2008, .NET 3.5, Active Batch Scheduler.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship