Hi,
Good Morning
Available Sr Datastage Lead/Developer-Open to Relocate
Name: SND
Rate: $open/hr C2C
Availability: Immediate
Relocation: Yes
Current Loc: NJ
I appreciate if you have any requirements today, please forward to
<javascript:top.opencompose('[email protected]','','','')> [email protected]
. Please add me in your daily requirements distribution list
BACKGROUND SUMMARY:
* Over 8years of IT experience in analysis, design and development of
data warehouse and oracle related applications and ETL processings.
* 6+ years of solid experience in building data warehouse/Data marts
especially with ETL tools like IBM Websphere Datastage 8.1x/7.x/6.x/5.x ,
Quality Stage.
* Extensive knowledge of Software Development Life Cycle (SDLC),
having thorough understanding of various phases like Requirements,
Analysis/Design, Development and Deployment.
* Proficient in Extraction, Transformation and Loading (ETL) processes
using Ascential DataStage Enterprise edition and Sever Edition
(8.0/7.5.1/7.5/7.1/7.0).
* Installation, configuration, setup and administration of Datastage
Server.
* Worked with Ascential Profile Stage and involved in coding and
cleansing in Ascential Quality Stage, Information Analyzer. PX is used for
huge loads (Round Robin logic for partitioning Datasets and nodes 4).
* Experience in Database programming Load Data Warehouses (Star
Schemas). Developed Strategies for Extraction Transformation Loading (ETL)
mechanism
* Report creation using OLAP data source (such as MSAS cubes) and
having knowledge in OLAP universe.
* 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.
* Performed Debugging, Troubleshooting and performance tuning of
Datastage Jobs.
* Used complex flat file stage in complex logic handling from the
mainframe data source.
* Handled huge data in various kinds of formats like EBDIC/Binary,
data containing unusual characters using Complex flat file stage.
* Expert in Dimensional Data Modeling, Star Schema modeling, Snowflake
Schema modeling, fact and dimension table design, physical and logical Data
modeling using ERwin 4.2/4.1/3.x.
* Worked extensively with Data migration, Data Cleansing, ETL
Processes.
* Good Knowledge of MDM (Siperian ).
* Extensive experience in designing and working with Oracle 8i/9i/10g
and writing SQL queries and PL/SQL Procedures, Functions, Packages,
Database Triggers, Exception Handlers, Ref Cursors, Database Objects using
PL/SQL. Proficient in writing Unix Shell scripts.
* Developed reports using SQL server reporting service.
* Expertise in Testing phase planning, preparation and execution.
* Have the knowledge of install and configuration in Datastage
* Fine tuned the SQL in Mainframe systems
* Expertise in creating schema objects, Performance Tuning of SQL
statements
* Able to work within an aggressive and demanding project schedule and
environment.
* Strengths include excellent communication skills and interpersonal
skills, good analytical skills and logical approach to problem solving.
TECHNICAL SKILLS
Languages : SQL, PL/SQL, C,C++,
Unix-shell scripting, HTML.
Database Tools : Oracle SQL*Plus, SQL*Loader, DB2, TOAD,
oracle Discoverer,
Erwin, Oracle
Designer, SQL server, XML Publisher, EDI, MQ series, MS Office
ETL Tools : IBM Information Server
8.1, IBM Information Analyzer 8.0 ,Server programming,
DataStage.8.0/7.5.1/7.1/7.0/6.0, Quality Stage, MetaStage, ProfileStage.
Autosys, Unix Cron.
OLAP tools : Cognos powerplay 6.0/7.0/7.1, Hyperion
Essbase 7.x, EAS 7.x,
RDBMS Servers : Oracle 7.x/8i/9i/10g, MS Access,
MS SQL Server 7.0,
Oracle9iAS, Apache Tomcat
4.0.1, IIS.
Operating Systems : UNIX (Solaris 8/2.x, Red Hat
Linux 7.x/6.x Mainframe OSz/390, Windows NT
Available Consultants: SQL,Java flex, informatica, Oracle dev/DBA,BO,Cognos,
.Net,QA,SAS, Data modeler, Teradata, OBIEE,ETL Arch, Datastage and etc.,
Thanks & Regards,
Sri Mathew
Zuven Technologies Inc
555 Republic Drive || PLANO, TX 75074
Cell: 469-361-2279
Mail to: <mailto:[email protected]> [email protected]
<http://www.linkedin.com/pub/sri-sri/13/b59/379> View my profile on
LinkedIn
Note: We respect your on-line privacy. This is not an unsolicited mail.
Under Bill 1618 Title III passed by the 105th US Congress this mail cannot
be considered Spam as long as we include contact information and a method to
be removed from our mailing list. If you are not interested in receiving our
e-mails then please reply with a "REMOVE" in the subject line. I am sorry
for the inconvenience caused to you
--
To unsubscribe, reply using "remove me" as the subject.
<<image001.gif>>
