Lead Datastage Consultant - Sydney, Australia - Carecone Pty. Ltd.

Carecone Pty. Ltd.

Verified Company

Sydney, Australia

1 week ago

Posted by:

Olivia Brown

beBee Recruiter

Description

Primary Skills:

10 + years of experience in implementing full life cycle of data warehousing projects.
5+ years of experience in UNIX.
IBM Infosphere Server DataStage, WebSphere Information Server DataStage, Quality Stage, Information Analyzer, IBM Initiate MDS, IBM Optima, Test Data Management (TDM), Data Masking (DM), Metadata Workbench, Infosphere Meta data Asset Management(IMAM), Informatica, Cognos Framework and Report Studios, PL/SQL,UNIX (AIX, HP-UX,SOLARIES,LINUX), MS-DOS, Windows Server, Dimensional Modeling ERWin, UNIX Shell Scripting, Teradata, DB2, Oracle, ANSI SQL, SQL Server, Toad, SQL Visual studio, SQL Developer, DataStage Director, Control-M, AutoSys, JIRA, and HP Quality Center.

Secondary Skills:

Strong knowledge of Star schema and Snowflake schemas, involved in designing DW concepts like conformed dimensions, conformed facts and Data Warehouse bus architecture for ETL development
Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing projects
Experience in being in constant interaction with Data Modelers and Architects, and involved in the process of giving and taking feedback as a part of improving the Data Model so that the Data Model supports the structures needed for ETL development
10 plus years of experience in Analysis/Design/Development/Implementation of ETL processes for Data Warehousing/Data Mart using DataStage with multiple database.
Experience in designing the DataStage Master Design Document for the project and Detail Design Document for a release to guide ETL (Extract, Transform and Load) development
Expert in establishing DataStage patterns for the project/release in order to allow maximum reusability of the DataStage modules and processes
Expert knowledge in DataStage best practices and in designing jobs for optimal performance, reusability and restart ability
Expert in configuring database connections for Oracle, DB2, Sybase and SQL Server from DataStage
Expert in setting up parallel configuration files depending upon Client's hardware architecture
Strong experience in making DataStage processes as repeatable as possible to ensure there are significantly less man hours used, less defect ratio, and ability to deliver a task in less time; and as a result, be more cost effective
Strong and proven experience in making DataStage ETL processes function as a well oiled machine with lesser development time required as the project progresses
Strong working experience in mentoring, training, guiding and leading teams of three to four DataStage developers, experienced and beginners both onsite and offsite
Data Warehousing implementation experience using DataStage PX (DataStage Designer, DataStage Director, DataStage Manager, DataStage Administrator), DataStage Information Server
Expertise in implementing DataStage PX, Sequencer, Shared Container jobs
Strong experience in coding using SQL, PL/SQL Procedures/Functions, Triggers and Packages
Strong experience in Unix scripting and running DataStage jobs using Unix scripts
Strong working experience in designing DataStage job scheduling outside the DataStage tool and also within the tool as required by Client/Customer company standards
Expert in configuring and setting up DataStage PX on AIX, DB2 UDB, Teradata, Oracle and other environments
Expert in maintaining Metadata at the database level using a combination of DS PX jobs
Expert in designing the DataStage configuration files for optimal performance and best resource usage
Worked extensively on different types of stages like Filter, Join, Merge, Lookup, Funnel, Aggregator, Transformer, Sort, CDC stages, Surrogate Key Generator, Modify, Remove Duplicates, Sequential File, Dataset, File set, Copy, Head, Tail, Connector stages for Databases (Teradata, Oracle, DB2), ODBC Connector, Real Time, Shared Containers, Column Import, Column Export, Switch, MQ Connector for developing jobs.
Worked on several Real Time Stages such as MQ, XML input and XML output etc.
Worked extensively on sequence Stages
Job Activity, Execute Command, End Loop Activity, Exception Handler, Nested Condition, Notification Activity, Routine Activity, Sequencer, Start Loop Activity, Terminator Activity, User Variables Activity
Worked IBM Information analyzer for columns analysis, primary key analysis, foreign key analysis and crossdomain analysis
Install and configure IBM Information server.
Performed administration tasks like role setup, connectivity, security, configuration of projects, user registries, create or update users and groups, mapping credentials, configuring DSN and TNS entries, parallel, compiler, reporting, operator and userdefined environment variables.
Configuration of XMETA repository, Node Agents and DS Engine.
Worked extensively on Teradata BTEQ Scripts to implement CDC process and Table load.
Working experience in Teradata RDBMS using Fast Load, Multiload,