We provide IT Staff Augmentation Services!

Datastage Administrator Developer Resume

NJ

SUMMARY

  • Over 11+ years of experience in IT industry having extensively involved in analysis and design, testing, implementation, maintenance, production support and knowledge transfer.
  • Over 8+ years of emphasis on Data warehousing/MDM using ETL tool Informatica Power Center9.x/8.x and Datastage 8.x/7.x, Business Objects XI3/4 WEBI, PL/SQL, MSSQL
  • Involved in Administering and development of DataStage Jobs with required Transformations like Aggregator, Filter, Funnel, Join, Lookup, Merge, Remove Duplicates, Sort, Transformer etc.
  • Experienced in Datastage Administering, UAT, Production Environment
  • Used Parallel Extender (Datastage 7.x) for splitting the data into subsets and flowing of data concurrently across all available processors to achieve job performance
  • Used DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse
  • Used the DataStage Director to schedule running the solutions
  • Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements
  • Implemented procedures for maintenance, monitoring, backup, and recovery operations for the Datastagenvironment. Includes regular reporting (daily, weekly, and monthly) on health and performance of the ETL environment and jobs.
  • Experience in following domains: Health Care, Supply Chain, Investment/Banking, Infrastructure Support.
  • Strong experience in designing and developing Business Intelligence solutions in Data Warehousing/Decision Support Systems using Informatica 9.x/8.x and Datastage 8.x/7.x
  • Expertise in Data modeling techniques - Star/Snowflake modeling, FACT/ Dimensional Tables, Physical and Logical Data Modeling using ERWIN
  • Implemented data warehousing methodologies for Extraction, Transformation and Loading using Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, Repository Server Administration Console.
  • Involved in using the OLAP tool Business Objects XI 3/4 including Deployment, Administration of both Full-Client Modules Business Objects Reporting Tool, Designer, Supervisor and Server-Side Modules Web Intelligence and Broadcast Agent
  • Strong experience with Oracle (SQL & PL/SQL), in writing SQL queries, stored procedures, stored functions, packages, database triggers, exception handlers, referenced cursors.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/, SQL SERVER 20xx, MYSQL and MS Access.

Data Warehousing: Informatica Powercenter 9.x/8.x, DataStage 8.x/7.x, Business Objects XI3/4 WEBi

Database Utilities: TOAD 7.3, PL/SQL, SQL*Plus, SQL*Reports, SQL*Loader

Operating System: Windows XP/NT/2000, AS 400, Sun solaris

Languages: Basic, C/C++. Java, Shell Script, PHP, ASP, HTML and DHTML, CSS

PROFESSIONAL EXPERIENCE

Confidential, NJ

Datastage Administrator Developer

Responsibilities:

  • Collect the specified data, analyze the specifications and data structure for integration
  • Extract, Cleanse, Transform and Load the data into Target Oracle database using DataStage Source, mapping, target designer with transformations-Connected-Unconnected Lookup, Filter, Expression, Router, Normalizer, Joiner, Update, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator
  • Carried out R and D for improving reporting and analytics by using the right technology in a mixed Oracle and Business Objects BI DW environment.
  • Implemented procedures for maintenance, monitoring, backup, and recovery operations for the Datastagenvironment.
  • Includes regular reporting (daily, weekly, and monthly) on health and performance of the ETL environment and jobs.
  • Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements

Environment: Oracle 11g/10g/9i, SQL SERVER 20XX, Informatica Power Center 9/8.6, Business Objects XI 3/4, Windows XP/2000, Erwin, Toad

Confidential, NY

Datastage Administrator Developer

Responsibilities:

  • Assisted the CEO/Directors by creating complex reports stating revenue generation per year using cascading and user objects like measure objects by using aggregate aware function to create the summarized reports
  • Assisted in carrying the architectural works in data warehouses
  • Responsible for engaging and executing the training programs for the fresher BO hires.
  • Extract, Cleanse, Transform and Load the data into Target Oracle database using Datastage Source, mapping, target designer with transformations-Connected - Unconnected Lookup, Filter, Expression, Router, Normalizer, Joiner, Update, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator
  • Oracle and Business Objects BI DW environment.
  • Implemented procedures for maintenance, monitoring, backup, and recovery operations for the Datastagenvironment. Includes regular reporting (daily, weekly, and monthly) on health and performance of the ETL environment and jobs.
  • Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements

Environment: Oracle 11g/10g/9i, Informatica Power Center 9/8.6, Business Objects XI 3/4, Windows XP/2000, Erwin, Toad

Confidential, NY

Datastage Administrator Developer

Responsibilities:

  • Used DataStage Designer to develop jobs for extracting, transforming, integrating and loading data to targets.
  • Involved in development of DataStage Jobs with required Transformations like Aggregator, Filter, Funnel, Join, Lookup, Merge, Remove Duplicates, Sort, Transformer etc.
  • Used Parallel Extender (Datastage 7.x) for splitting the data into subsets and flowing of data concurrently across all available processors to achieve job performance
  • Designed the mappings between sources (external files & databases) to operational staging targets, designed Star & Snow Flake schemas
  • Set Up ODBC Connections, Import Relational Metadata, Extract And Load Relational Data

Environment: Oracle 11g/10g/9i, Windows XP/2000, AS 400, DataStage 8.x/7.x Parallel Extender / Server, Director, Manger, Administrator, Erwin, Toad.

Confidential, NY

ETL Datastage Administrator Developer

Responsibilities:

  • Implemented procedures for maintenance, monitoring, backup, and recovery operations for the Datastagenvironment. Includes regular reporting (daily, weekly, and monthly) on health and performance of the ETL environment and jobs.
  • Involved in Administering and development of DataStage Jobs with required Transformations like Aggregator, Filter, Funnel, Join, Lookup, Merge, Remove Duplicates, Sort, Transformer etc.
  • Experienced in Datastage Administering, UAT, Production Environment
  • Used Parallel Extender (Datastage 7.x) for splitting the data into subsets and flowing of data concurrently across all available processors to achieve job performance
  • Used DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse
  • Used the DataStage Director to schedule running the solutions
  • Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements
  • Involved in development of DataStage Jobs with required Transformations like Aggregator, Filter, Funnel, Join, Lookup, Merge, Remove Duplicates, Sort, Transformer etc.
  • Used Parallel Extender (Datastage 7.x) for splitting the data into subsets and flowing of data concurrently across all available processors to achieve job performance
  • Designed the mappings between sources (external files & databases) to operational staging targets, designed Star & Snow Flake schemas. Set Up ODBC Connections, Import Relational Metadata, Extract And Load Relational Data
  • Collect the specified data, analyze the specifications and data structure for integration
  • Extract, Cleanse, Transform and Load the data into Target Oracle database using Informatica Source, mapping, target designer with transformations-Connected - Unconnected Lookup, Filter, Expression, Router, Normalizer, Joiner, Update, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator
  • Use Datstage Server manager/monitor to create sessions, batches to run jobs.
  • Build the new Business Object universes as per the user requirements.
  • Create complex reports stating revenue generation per year using cascading and user objects like measure object using @aggregate.
  • Involved in creation of Oracle Tables using storage parameters and clusters.
  • Involved in writing PL/SQL Database procedures, Functions, Packages and Database Triggers.
  • Conducted training sessions to end-users.
  • Involved in System Analysis, Design, Coding, Testing, Development and Implementation.
  • Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.
  • Written many Stored procedures, Stored functions, Packages and used in many Forms and Reports.

Environment: Oracle 11g/10g/9i, MS SQL 20XX, Windows XP/2000, AS 400, DataStage 8.x/7.x Parallel Extender / Server, Director, Manger, Administrator, Erwin, Toad.

Hire Now