ETL Developer (Data stage developer) Resume

SUMMARY:

A Highly motivated IT professional with above 11+ years of proven experience in design, development and integration of various solutions in heterogeneous software environments. Appreciates challenges, steep learning curves, and high - pressure deadlines. Outstanding ability to analyze, develop, and implement technology solutions. Reliable team player with effective troubleshooting and debugging experience.
Implementation of Data Warehousing Systems using IBM Information Server ETL tools -IBM Info Sphere Data Stage 7.5, 8.1, 9.1 and 11.5 on Server and Parallel Extender.
Gather requirements from business teams and functional specialists; Prepare source to target mapping documents and flow diagrams in Visio listing functional and non-functional requirements for technical design.
Close interactions with application teams Confidential different phases to clear out any ambiguities and find ways for continuous improvement in functional processes.
Reviewed and suggested suitable improvements in data models; enforced data modelling standards, best practices in the design; enabled partitioning and data compression to improve performance.
Preparing HLD and LLD documents for understanding of the requirements and job flow and code the jobs based on these documents.
Extensively involved in the development of Data stage ETL process for extracting and loading the data from heterogeneous data sources like Oracle, DB2, XML, delimited files etc.
Designed sequences to implement the job dependencies, restart ability along with this developed and implemented efficient Error handling methods.
Created shared containers and parameter sets to increase the reusability. Customizing the jobs for better performance and faster execution to shrink the batch windows.
Experience in writing ETL routines for scheduling the jobs and writing UNIX scripts for executing jobs.
Experience in integration of various data sources (DB2-UDB, DB2-z/OS

SKILLS:

Collection

Data Mapping

Team Player

Uat Testing

Capacity Planning

Ods, Data Warehouse

Root Cause Analysis

Mdm, Datamart, Life Cycle

Business Intelligence, Master Data Management

Production Environment,Data Integration

Unix Shell, Project Lifecycle

Deployment

Uat

Operational Data Store

Datasets

Oracle 10g

Oracle

Data Sources

System Testing Analyzer

Data Validation, Shared Memory

Shell Scripts Scripting

Trouble-Shooting, Data Mart, Metrics

Data Staging Scheduling

Stored Procedure Data Analytics

Sdm, ODBC

Gather Requirements, aix

RDBMS

Data Warehousing, Finance

Visio, Test Cases, SQL Server, Metadata

Edw, Windows XP

Unit Test, SQA

ETL, Data Analysis, Dimensional Data, Coding

Customer Relationship Management

Technical Design

Relationship Management

Data Models

Continuous Improvement, unix

GCP, db2

Transactional Data

PL/SQL

Marketing Analysis

Data Profiling

Unit Testing, database

Big Data

Data Collection

Data Structure

Database Modeling, Mapping

MS SQL Server, SQL, UDB, OS 10

Shell Scripting, XML, CVS

SCRUM, Clear Case

UDP, Web Sphere, CRM, MS-DOS, Marketing

Loans, Best Practices maintenance, Estimation, TOPO, Laboratory

DAC Offshore, Switch Capacity, Problem-Solving

EXPERIENCE:

Confidential

ETL Developer (Data stage developer)

Confidential

ETL Developer(Data stage developer)

Confidential

ETL Analyst and Designer (Data stage developer)

Confidential

Data Specialist (Data stage developer)

Responsibilities:

Implementation of Data Warehousing Systems using IBM Information Server ETL tools -IBM Info Sphere Data Stage 7.5, 8.1, 9.1 and 11.5 on Server and Parallel Extender.
Gather requirements from business teams and functional specialists; Prepare source to target mapping documents and flow diagrams in Visio listing functional and non-functional requirements for technical design.
Close interactions with application teams Confidential different phases to clear out any ambiguities and find ways for continuous improvement in functional processes.
Reviewed and suggested suitable improvements in data models; enforced data modelling standards, best practices in the design; enabled partitioning and data compression to improve performance.
Preparing HLD and LLD documents for understanding of the requirements and job flow and code the jobs based on these documents.
Extensively involved in the development of Data stage ETL process for extracting and loading the data from heterogeneous data sources like Oracle, DB2, XML, delimited files etc.
Designed sequences to implement the job dependencies, restart ability along with this developed and implemented efficient Error handling methods.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship