We provide IT Staff Augmentation Services!

Datastage Admin Resume Profile

PROFESSIONAL SUMMARY:

  • Around 7 years of experience working with DataStage and many BI Tools with a dynamic career.
  • Experience with full project life cycle development process, involving analysis, planning, designing, development, implementation, support and administrative phases.
  • Strong experience in developing jobs using different stages in DataStage like link collector, join, merge, lookup, remove duplicates, XML Stage, filter, dataset, transformer, aggregator
  • High knowledge on Star, Snowflake Schema and Multidimensional Data Models
  • Experience creating process using various operational sources like Oracle, SQLServer, Flat Files, Excel Files, into a staging area.
  • High experience creating tables and databases in Oracle and SQL Server
  • Expertise in data warehousing techniques like surrogate keys
  • Expertise developing store procedures using Oracle.
  • Excellent skills in problem-solving and trouble-shooting capabilities, Quick Learner, highly motivated, result oriented and good team player.
  • Good interpersonal skills, experience in handling communication and interactions between different teams.
  • Wide experience in supporting very large databases.
  • Extensive experience in giving support to ETL processes.
  • Experience in solving performance issues on ETL Tools.
  • Analyzing and solving information load problems.
  • Experience in finding the root cause of data inconsistency incidents.
  • Creating the jobs execution Schedule and monitoring job executions.
  • Experience in creating new projects and setting the project properties.
  • Wide experience in importing and exporting projects.
  • Experience in managing and supporting application servers.
  • Great knowledge in creating and designing databases
  • Knowledge of programming languages, HTML, JAVA, PL SQL

TECHNICAL SKILLS:

ETL Tools

IBM InfoSphere Data stage 8.5, Ascential Data Stage 7.5, SSIS SQL Server 2008 R2

Business Intelligence Tools

MicroStategy 9, Qlikview 10

Development Tools and Languages

SQL, JAVA, HTML, PL/SQL, Oracle, Linux/Unix Scripting

DataBases

Oracle 10G, Oracle 11G, SQL Sever 2008R2

WORK EXPERIENCE:

Confidential

Title :DataStage Admin/Developer

Roles and Responsibilities:

  • Developed changes on existents DataStage Jobs and sequences regarding manager needs.
  • Created new DataStage Jobs and sequences for data validation to detect inconsistency on the data loaded by existence ETL processusing different stages in DataStage like link collector, join, merge, lookup, remove duplicates, filter, dataset, transformer, aggregator
  • Developing ETL processes using DataStage Designer to capture reject rows, to control figures and to data comparisons between source and target Data Bases like transactional data bases, staging area, transformation area, ODS and Datawarehouse.
  • Solve execution incidents on the processes developed in DataStage.
  • Find the root cause of data inconsistency loaded by ETL process developed in DataStage.
  • Completing information load by executing jobs manually if needed.
  • Unlock DataStage Jobs and run queries using DataStage Console
  • Analyze processes to suggest improvements thereof.
  • Administration of BI tools, DataStage 7.5 InfoSphere 8.5, Microstrategy 8.x 9.x, and QlikView 10 on production environment.
  • Manage production servers on the DSS area. Windows Server 2003 and Linux Suse
  • Administration of production database Oracle 10g and Oracle 11g.
  • Unlock DataStage Jobs and run queriesusingDataStage Console
  • Maintain, monitor and manage systems in productive use.
  • Maintain and update the knowledge database, technical documentation and user manuals.
  • Importing new ETL 's processes developed on DataStage 7.5 and 8.5 on productive environment using DataStage Manager
  • Create release jobs to use them on production environment.
  • Re-compile Jobs to improve the performance on process already done
  • Purge jobs log manually when the automatic purge component failed.
  • Create new projects, configure environment variables, set permissions and role user, do all the project setting using DataStageAdministrator.
  • Used the Datastage Director and the runtime engine to schedule job execution, testing and debugging its components and monitoring jobs.
  • Supporting migration from AscentialDataStage 7.5 to InfoSphereDataStage 8.1
  • Ensure information quality in the data warehouse.
  • Execute statistics to very large tables to improve performance on Oracle database.
  • Running scripts to create tables in the datawarehouse on production environment.
  • Create queries to compare information between many databases source and the Datawarehouse using Oracle.
  • Analyze DataStageprocesses to suggest improvements thereof.
  • Created new DataStage Jobs and sequences for data validation to detect inconsistency on the data loaded by existence ETL process using different stages in DataStage like link collector, join, merge, lookup, remove duplicates, filter, dataset, transformer, aggregator
  • Analyze data loaded by the ETL's process looking for data inconsistency
  • Used the DataStage Director and the runtime engine to schedule job execution, testing and debugging its components and monitoring jobs.
  • Setparameters in DataStage ETL Process
  • Do the ETL processes documentation

Environment: Microstrategy 9 9.3, DataStage 8.5, Oracle 10G 11G, Qlikview 10, Windows Server 2003, Linux Suse, Windows server 2008

Confidential

Roles and Responsibilities:

  • Installation and configuration of database on development environment SQL Server 2008 R2
  • Installation and configuration of BI Tools on development environment MicroStrategy, SSIS
  • Administration of BI application's servers Windows Server 2008 R2
  • Administration of BI Databases on development environment SQL Server
  • Administration of BI Tools on development environment MicroStrategy , SSIS
  • Used MS Visio to build the deployment map of BI applications
  • Design and develop ETL processesto get information from sources data bases and insert this information into BI data bases using SSIS
  • Developed Shell scripts to automate file manipulation from external paths to local paths.
  • Developing databases and tables using SQL Server Management Studio 2008 R2
  • Assess application performance and define business continuity plans.
  • Create the project technical documentation.

Environment: SQL Server 2008 R2, SSIS SQL Server Integration Services 2008 R2 , Windows 2008 R2, MicroStrategy 9.3

Confidential

Title :DataStage Admin/Developer

Roles and Responsibilities:

  • Analyze DataStageprocesses to suggest improvements thereof.
  • Created new DataStage Jobs and sequences for data validation to detect inconsistency on the data loaded by existence ETL process using different stages in DataStage like link collector, join, merge, lookup, remove duplicates, filter, dataset, transformer, aggregator
  • Analyze data loaded by the ETL's process looking for data inconsistency
  • Used the Datastage Director and the runtime engine to schedule job execution, testing and debugging its components and monitoring jobs.
  • Testing ofETL processes developed in DataStage.
  • Set Parameters into ETL's Process developed in DataStage
  • Develop Store procedures in PL SQL to populate tables in the Datawarehouse
  • Configuring and creating execution plans, thematic areas and tasks scheduler and dependencies in Oracle Data Warehouse Administration Console DAC .
  • Assist in the migration of OBIEE.
  • Do documentation of ETL Process

Environment: AscentialDataStage 7.5, OBIEE Oracle Business Intelligence Enterprise Edition, Oracle 10G

Hire Now