Serverj jobs in datastage 7.5 generator#
Serverj jobs in datastage 7.5 software#
Serverj jobs in datastage 7.5 windows#

Operating Systems: Windows 2003/NT/XP, MVS Os/390, UNIX AIX/SOLARIS/LINUX Other Tools: TOAD0, Autosys, Control-M, CA SCM, MS Access, Putty Languages: SQL, PL/SQL, C, C++, Unix shell scripting, COBOL OLAP Tools: Business Objects, Cognos, Web focus

x, DataStage PX(Parallel Extender), Quality Stage, Fast Track, Business Glossary, Metadata Workbench, Information Analyzer Excellent inDocumentation,End-User Trainingand Knowledge Transfer.Д®TL Tool: IBM Infosphere Information Server 8.5/8.0/7.5/7.Experienced in Database Design/Development inTeradata, Oracle 11g/ 10g/9i/8i, DB2 8.x/7.x, SQL Server 2005/2008, Sybase 11/10, VSAM and MS-Access 97/200x.Experienced in writing Database Stored Procedures, Functions, Packages and Triggers using PL/SQL.Extensively worked coordinating with offshore team distributing the work, keep tracking development status and monitor day to day activities.Experience in Scheduling Jobs using various third party tool like Autosys.Created various parameters and parameter sets for multi-instance jobs and environment variables to be used across the project.Experience in working on operating systems like UNIX and Windows.Used DataStage Director extensively to run, schedule, monitor, debug and test the application on development and to obtain the performance statistics.Experience in designing Sequences, Exception handling and have used various stages like exception handler, sequencer, terminator stage.Experience in Metadata Workbench and Information Analyzer.Created Mapping Specifications using FAST TRACK tool.

Serverj jobs in datastage 7.5 generator#

Used Enterprise Edition/Parallel Edition stages like Datasets, Aggregator, Merge, Join, Lookup, Sort, Pivot, Transformer stage, Filter stage, Modify, Copy, Change Capture, Row Generator and many other stages in accomplishing the ETL Coding.

Worked with Data modeling(Star and Snowflake Schema), Conceptual, Logical, Physical mode, fact tables, dimension tables, Data migration, Data Profiling, Data cleansing, Slowly Changing Dimension, Surrogate key assignments, ETL Processes for data warehouses.

Experienced in using DataStage Client components like DataStage Administrator, Manager, Designer and Director in Data Warehousing development.

Experience in developingParallel Jobs, Mainframe Jobs, Shared Containers, Server jobs,Sequence JobsandQuality Stage Jobsusing DataStage.

Around 7 Years of ETL experience in populating and maintaining Data warehouse and Data marts using DataStage 9.1/8.5 /8.0/7.5/7.1/7.0 (Parallel Extender).

Serverj jobs in datastage 7.5 software#

More than 8 Years of IT experience in complete Software Development Life - Cycle(SDLC) of various projects including requirement gathering, system designing, data modeling, application development, enhancement development and support.