Senior ETL Consultant Resume Austin, TX - Hire IT People

SUMMARY

Over 9 years of experience in information technology as ETL developer.
Over 9 years of industry experience on analysis, design, development and team management
Hands on experience on different segments of teh data warehousing lifecycle dat includes business requirements gathering, data modeling, ETL and business reporting
Expertise in ETL (extraction, transformation & loading) design and development
Expertise in Informatica 9.0
Expertise in Unix shell scripting
Earlier worked on DataStage 7.5 Enterprise Edition (Server & Parallel Jobs)
Proven ability to balance a changing workload.
Willingness to innovate, experiment and take risks
Ability to be flexible and adaptable in an evolving environment.
Fast learner, Keen inclination towards learning new technologies and processes.
Team & Independent Player wif excellent communication, organizational and interpersonal Skills
Effective project reporting

TECHNICAL SKILLS

Tools: Informatica 9.0, Datastage 7.5 Enterprise Edition (Server & Parallel)Oracle Warehouse Builder

Technologies: Data Warehousing, ETL

Database: Teradata, DB2, Oracle

Scripting: Unix Shell Script

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Senior ETL Consultant

Responsibilities:

Understanding teh requirement and converting it into technical specification
Created transformations and mappings using Informatica v9 Power center to move data from multiple sources into targets
Integrated various data sources of Oracle, SQL server and sequential files into staging area
Performed analysis, design, and programming of ETL processes
Created source to target mappings, edit rules and validation, transformations, and business rules. Analyzed client requirements and designed teh ETL Informatica mapping
Development of Informatica mappings/workflows for Quest
Development of unix scripts for automating teh process
Design and Develop Client centric Master Data Management(MDM) solution for QUEST

Environment: Teradata, Informatica, Unix

Confidential, Memphis, TN

Senior ETL Consultant

Responsibilities:

Integrated various data sources
Performed analysis, design, and programming of ETL processes
Created source to target mappings, edit rules and validation, transformations, and business rules

Environment: Oracle, Oracle warehouse builder, Unix

Confidential, Austin, TX

ETL Developer

Responsibilities:

Analyzed and communicated ETL development issues, including problems wif data integrity, data design, and functional and technical issues.
Performed data quality analysis, gathered information to determine data sources, data targets, data definitions, data relationships, and documented business rules.
Investigated and identified various sources where teh ETL information/data lay scattered.
Resolving issues of Informatica mappings
Resolved defects pertaining to data migration

Environment: Teradata, Informatica, Unix

Confidential

Application Developer

Responsibilities:

Design, development and implementing DataStage jobs ranging from preprocessing shell-scripts, configuration files to scheduling in Job sequence
Developed solutions for complex logic by writing routines and transform functions
Parameterization of DataStage jobs through dynamic parameter file for Database connections
Sequence Jobs designed for entire set of jobs we developed
Automated teh processes through unix shell scripting
Scheduling and sequencing teh jobs according to teh requirement
Preparing UNIT-Test documents and tan transferring teh same to test environment
Supporting teh operations team in resolving user issues
Preparing ETL design documents

Environment: DataStage 7.5, DB2, Unix

Confidential

Application Developer

Responsibilities:

Translating various mapping (LLDs) docs and related Gap Analysis and developing application solutions for a complete business process.
Design, development and implementing DataStage jobs ranging from preprocessing shell-scripts, configuration files to scheduling in Job sequence.
Developed solutions for complex logic by writing routines and transform functions, modifying job control.
Parameterization of DataStage jobs through dynamic parameter file for Database connections.
Sequence Jobs designed for entire set of jobs we developed.
Involved in automating teh processes through unix shell scripting.
Scheduling and sequencing teh jobs according to teh requirement.
Preparing UNIT-Test documents and tan transferring teh same to test environment.
Supporting teh operations team in resolving user issues.
Preparing ETL design documents

Environment: DataStage 7.5, DB2, Unix