We provide IT Staff Augmentation Services!

Etl Developer Resume Profile

NJ

Role

ETL Developer

Total Years of Experience

10 Years

Skills Summary

Primary Skills

SSIS ETL , Datastage, SSAS, SSRS SQL Server, Oracle

Other Skills

Asp.Net, C .Net

Industry Domain Experience

Banking, Finance Healthcare

Educational Qualification

Work Summary

Confidential

EXPERIENCE SUMMARY

  • Having 10 Years of experience in Software Development Support services using Microsoft SSIS ETL SSDT 2008, 2012, IBM Info sphere DataStage 8.5 9.1, Data bases like SQL Server, Oracle and Sybase .Net technology along with Leadership experience as Onsite Team Leader.
  • Experience in Analysis of client requirements, Design Development of SSIS packages using SSDTand DataStage applications using IBM DataStage 8.1, 8.5
  • Extensively utilized SQL Server Integration Services SSIS to build Data Integration and Workflow Solutions, Extract, Transform and Load ETL solutions for Data warehousing application.
  • Having strong knowledge on Data ware house concepts to create enhanced applications along with Data Management.
  • Having strong knowledge on writing Stored Procedures, triggers and complex SQL queries.
  • Having experience in preparing the FRD, Technical Design Documents TDD , approach documents and review documentation.
  • Having Good Knowledge on SSAS SSRS development.
  • Specialization in DataStage design by creating the parallel jobs using various stages like Transformer stage, Aggregator stage, Sybase enterprise stage, Copy Stage and Sort stage etc with standard rules.
  • Performed Unit Level Testing and Integration Testing of SSIS packages.
  • Having good leadership qualities for handling Coordination between Onsite and Offshore.
  • Have very good knowledge and exposure in Oracle and Sybase database development Relational Database concepts.
  • Extensively used data stage components like Data stage Designer, Director, Administrator in Data warehouse development.
  • Having knowledge on creating Data dictionaries for relevant applications.
  • Involving in activities of Unit Testing of developed jobs of myself and team members along with preparing review documents for the same.
  • Working knowledge in UNIX Operating System exposure to shell scripting.
  • Creation and execution of multi tired Web Enabled applications using ASP. Net 2.0, C . Net, VB. Net and ADO.NET.
  • Possess strong communication, collaboration always appreciated for active team player with team building skills good supporter of other team members

TECHNICAL EXPERTISE

ETL Tools

MS SQL Server SSDT 2008, 2012, Data Stage 8.1, 8.5 9.1

Microsoft Technologies

ASP.Net, C .Net, VB.Net ADO.Net

Scripting Languages

Java Script

RDBMS

SQL Server 2008/2010, Oracle 9i, Sybase 15

Source Control Systems

Team Foundation Server, VSS

Database Tools

Rapid SQL, Toad

IDE

Visual Studio 2003/2005/2008/2010

Tracking Tools

PPM HP , IBM Rational Clear Quest, Clarify tool

Web Servers

IIS

Confidential

Role

ETL Developer

Environment: SQL Server BIDS 2008, SQL Server 2008 R2, VS 2008, TFS, APPWORX scheduling tool, Asp.net, C , SSRS.

Responsibilities:

  • Working with Business team for finalizing the requirement analysis.
  • Creating the Functional requirement documents and Technical design documents as per the Business requirements.
  • Extensively utilized SQL Server Integration Services SSIS to build Data Integration and Workflow Solutions, Extract, Transform and Load ETL solutions for Data warehousing application.
  • As per analysis will make data mapping between staging and destination tables.
  • Involving in creating Data dictionaries for specified requirements.
  • Coordinating between business and off shore to accomplish the client requirements.
  • Responsible for maintaining data quality standards.
  • Involving in business meetings for requirement updates and development progress.
  • Running the QA Batch jobs as per defined timeline.
  • Preparing the Deployment Rollback plans for QA PROD migration.
  • SQL Performance tuning by modifying SQL or adding/changing indexes.
  • Creating stored procedures, Functions Views as per the required basis.
  • Implemented SSIS packages for the exchange of data between different data sources Excel Files, SQL Database and load to SQL Server 2008.
  • Creating SSIS packages using different Transformations as per FRD TDD.
  • Reviewing of existing jobs to enhance the performance.
  • Involving in enhancements of the existing jobs as per new changes.
  • Involving in Unit testing and QA testing.
  • Involving in Data Management to process from different sources of client system with following standard rules.
  • Responsible for PROD Support for smooth running of daily Jobs.

Confidential

Role

ETL Developer Team Lead

Environment: Data stage 8.1, Sybase 15, SQL server 2010, UNIX, Rapid SQL tool

Responsibilities:

  • Understanding the business requirements and provide the solution to the client.
  • As per analysis will make data mapping between source and destination tables.
  • Involving in creating Data dictionaries for specified requirement.
  • Designing the parallel Jobs using Data-stage Designer by creating required data repository with standard naming conventions.
  • Developing jobs using various stages like Transformer stage, Aggregator stage, Copy Stage, Sort stage.
  • Reviewing of existing jobs to enhance the performance.
  • Writing SQL queries in data base stages.
  • Involving in creating test plan and unit testing of the jobs developed by self and the peer.
  • Preparing Approach document, Data validation and Review documents.
  • Preparing Release notes for Production migration.
  • Responsible for maintaining data quality standards.
  • Monitoring the task completion and communicating the team schedule status to Client
  • Involving in weekly status meetings with onsite counterpart and maintaining relevant documents.

.

Confidential

Role

ETL Developer

Environment: SQL Server SSIS 2005, SQL Server 2005, APPWORX scheduling tool, Asp.Net 2.0/1.1,

VB. Net

Responsibilities:

  • Understanding the client requirements and designing, developing the application of modules in SSIS packages.
  • Accepting the requests and will modify the SSIS packages as required by the business.
  • Creating stored procedures, Functions Views as per the required basis.
  • Involving in business meetings for requirement updates and development progress.
  • Responsible for maintaining data quality standards.
  • Reviewing of existing jobs to enhance the performance.
  • Involving in enhancements of the existing jobs as per new changes.
  • Involving in Unit testing and QA testing.
  • Involving in Data Management to process from different sources of client system with following standard rules.
  • Responsible for PROD Support for smooth running of daily Jobs.

Confidential

Role

.Net Developer

Environment: Asp.Net 2.0, C . Net, Oracle 9i, Crystal Reports

Key Responsibilities:

  • Successfully analyzing and handling the problems faced by the clients. Suggesting any procedural changes if required.
  • Responsible for preparing Consolidated reports on regular activities on monthly basis.
  • Design and developing the web application of modules and creating Reports.

Confidential

Role

.Net Developer

Environment:

Asp.Net 1.1, C .Net, SQL Server 2000, Clear Quest tool.

Key Responsibilities:

  • Successfully handling the tickets raised by client resolving their issues on time.
  • Generating presentation on tickets raised vs. resolved.
  • Responsible for preparing consolidated reports on regular activates.
  • Understanding the client requirements as per SRS designing and developing the web application.

Hire Now