Lead Datastage Consultant

**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 cross-domain 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 user-defined 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,