SUMMARY |
• Over 8+ years of experience in System Analysis, DataStage, Design Development in Data Warehousing, Data Integration, Data Migration, Quality Stage, Oracle, PL/SQL, Teradata and DBD2 UDB. • Around 5years in-depth experience in Extraction Transformation and Loading (ETL) processes using Ascential Data Stage 7.x/6.x (Parallel Extender). Worked on Data Stage client tools Data Stage Designer, Data Stage Director, Data Stage Manager and Data Stage Administrator. • Excellent experience in using Stages like Complex Flat File, Dataset, Copy, Fileset, Oracle Enterprise, Join, Sequencer, Aggregator, Merge, Filter, Transformer, Lookup, Funnel, Compress etc., • Experience in Designing, Compiling, Testing, Scheduling, and Running Data Stage jobs. • Experience in Creating and administering tables in Teradata. • Expertise in OLTP/OLAP System Study, Analysis and Dimensional Modeling, E-R modeling. Involved in Designing Dimensional Model (Star schema and Snowflake schema), database administration, Multi Dimensional Model, Fact and Dimensional Tables, Slowly Changing Dimensions. Worked with CDC (Change Data Capture). • Used to various databases Oracle 9i/8i, DB2, MS Access, SQL Server and Sybase. • Extensive Experience working with Database tool TOAD, SQL Loader etc • Experience working with Parallel Extender for Parallel processing to improve job performance while working with bulk data sources. Worked with most of the parallel stages applying different partitioning techniques. • Strong working knowledge with Oracle database Design and SQL Scripting, DB2, PL/SQL and TOAD. • Developed Test Scripts, Test Cases, and SQL QA Scripts to perform Unit Testing, System Testing and Load Testing. Seamlessly migrated the Code from Development to Testing, UAT and Production. • Involved in Performance Fine Tuning of ETL programs. Tuned DataStage and Stored procedures Code. • Successfully interacted with end-users, developers and top management. • Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels. |
--
Sandeep
Suite 706 Suwanee , GA 30024
Fax: 678-584-5640
Web : www.infosmarttech.com
"Certified Minority Business Enterprise firm"
P please consider the environment before printing this e-mail
--
You received this message because you are subscribed to the Google Groups "CONTRACT JOBS ONLY" group.
To post to this group, send email to contract-jobs-only@googlegroups.com.
To unsubscribe from this group, send email to contract-jobs-only+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/contract-jobs-only?hl=en.
No comments:
Post a Comment