Data Warehouse Developer Resume Profile

SUMMARY

Tools/Methods:

Web Sphere 8.7/8.5/8.1/8.01,
Data stage, Information Server Quality stage, Metadata Server Ascential DataStage7.5,
Quality Stage 7.x, 8.0,
Oracle 11g/10g/9i/8i, DB2,
TeraData,
SQL Server2000/2005, PL SQL
Shell Scripts, C Shell,
K-Shell Scripts, AWK, VI-editor
Perl Scripting, COBOL,
SQL, PL/SQL, Linux/Unix
IBM AIX 4.3,
Win XP/NT,
FrontPage 98/2000,
Excel, Power Point ,
Visual Interdev 6.5/6.0,
Visual Age 3.5,
MS VISIO,
AUTOSYS.

CONFIDENTAIL

relevant Experience:

CONFIDENTAIL Certified Professional with 7 years of IT experience, with special expertise in Development, Analysis and Design of ETL methodologies in all the phases of the Data Warehousing life cycle. He has extensive experience IBM Web Sphere 8.7/8.5/8.1.0/8.0.1 Data stage, Information Server, Quality Stage, Information Analyzer, Metadata Server and experience in Ascential DataStage 7.5 using components like DataStage Designer, DataStage Manager, DataStage Director, DataStage Administrator and Parallel Extender. Expert in all the stages of Software Development Life Cycle.

Skills Inventory:

Excellent knowledge in Extraction, cleansing and modification of data from/to various Data sources.
Experienced converting the Business Logic into Technical Specifications.
Involved in business meetings to gather the business requirement to define the Data Modeling.
Extensively worked on Parallel Jobs using various stages like Join, Lookup, Transformer, Lookup File Set, Change Capture, Filter, Funnel, Copy, Surrogate Key Generator, Sort, File set, Sequential File, Dataset, Oracle Enterprise, Merge, Aggregator, Remove Duplicate Stages.
Strong working experience on DataStage, SQL, PL/SQL, Store Procedures, Triggers and Packages. Performed debugging, troubleshooting and performance tuning.
Designed and developed jobs using Parallel Extender for splitting bulk data into subsets and distribute dynamically to all available nodes to achieve best job performance.
Extensively Worked on Job Sequences to Control the Execution of the job flow using Various Activities Triggers like Job Activity, Email Notification, Sequencer, Routine activity and Exec Command Activities.
Implementation of full lifecycle in Data warehouses and Business Data marts with Star Schemas and Snowflake Schemas.
Created and implemented common UNIX shell scripts to FTP the files from/to different servers, validate, and process the Flat Files for different projects.
Having good experience in the preparation of JIL scripts to schedule the jobs through Autosys.
Good experience in various databases like Oracle 11g/10g/9i/8i, DB2 and SQL Server.
Experienced in all phases of development lifecycle including production support and performance tuning.
Provided 24X7 support to the users and having good experience in resolving high priority production issues within the time.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship