We provide IT Staff Augmentation Services!

Senior Etl/ Datastage Developer Resume

Lansing, MI

SUMMARY:

  • 9+ years of strong experience in Data warehousing, Data Integration, Data Migration and ETL using, IBM Info Sphere Data Stage 8.7,IBM WebSphere Data stage 11.3/8.1/8.0, Ascential Data Stage 7.5, Data cleansing and Data Analysis.
  • Over 1+ years of experience in Developing and scheduling reports in Business objects XI.
  • Designed, Developed and tested jobs to extract data from multiple data sources like Oracle, Flat Files, DB2, XML
  • Strong Experience in Dimensional modeling using Star and Snowflake schema. Experience in Data warehouse and RDBMS methodologies.
  • Strong working experience on Data Warehousing applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.
  • Assisting the data modeler/data warehouse developer in reviewing staging, data warehouse and data.
  • Responsible for all activities related to the development, implementation, administration and support of ETL processes for large - scale data warehouses using Data Stage.
  • Strong in SQL, And Implementing SQL’s In ETL for Better Performance.
  • Experience in Unix shell scripting
  • Documentation of ETL mappings, processes and batch process.
  • Experienced in designing parallel and server jobs using Data Stage 11.X/8.X, extensively used Link Partitioner, Link collector, Routines, Transformations, Hashed file and Developed Job sequencers for executing Data stage jobs.
  • Experience in resolving on-going maintenance issues and bug fixes and monitoring ETL processes.
  • Worked extensively with slowly changing dimensions.
  • Experience in UNIX Shell scripting as part of file manipulation, and have strong knowledge in scheduling Data Stage jobs using Autosys.
  • Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings.
  • Used Business intelligence application tools with an extensive use of SQL knowledge of business processes, internal and external identification and documentation of Business intelligence requirements.
  • Experienced in integration of various data sources (Oracle, Teradata and XML) into data staging area.
  • Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing
  • Excellent communication skills and analytical skills and ability to perform as part of the team.

TECHNICAL SKILLS:

ETL Tool: IBM Info Sphere DataStage and QualityStage 11.3/8.7/8.5, IBM Info sphere 8.1/8.0, Ascential Data Stage7.5, Informatica9.5.1/7.1PowerCenter

Reporting Tools: Business Objects XI /6.5

Scheduling tools: AppWorx, Autosys

Script Languages: UNIX Korn Shell, SQL, PL/SQL

Tools: Toad, PLSQL Developer, SQL*Loader, TOAD, OEM, SQL NavigatorSQL Tools, Erwin, Datastage 9.1/11.3

Databases: IBM DB2, MS SQL server 2008/2005 and Oracle 11G/10G/9.x, Teradata

GUI Tools: Oracle Forms 6i/9i/10g, Reports 6i,9i

Other Utilities: Erwin 7.2/4.0, MS Office, MS Visio, TOAD

Methodologies: Star Schema, Snow Flake, Ralph Kimball, RDBMS

PROFESSIONAL EXPERIENCE:

Confidential, Lansing, MI

Senior ETL/ DataStage Developer

Responsibilities:

  • Involved in requirement gathering, analysis and study of existing systems.
  • Extensively using Data Stage designer for designing Parallel jobs and performed complex mappings based on user specifications.
  • Working in designer for Extracting Data, Performing Data Transformations and Aggregate Data.
  • Generated .XML files for various departments in state like MDOT(Michigan Department of Transportation), MSP( Michigan State Police), MDHHS (Department of Health and Human services), MDNR(Department of Natural Resources), MDOS(Department of State) using Oracle DB tables provided by them.
  • Created validation process to validate the .xml generated according to design specifications.
  • Extensively used real time stages in Data Stage such as XML input, XML output, and Hierarchical stages to generate .XML files for different departments of State.
  • Added, deleted and setup Data Stage projects and managed users from Data stage administrator
  • Used Data Stage Administrator for setting the variables and parameters.
  • Distributed load among different processors by implementing the Partitioning method.
  • Designed complex jobs to handle data and loading them to Target
  • Involved in bug fixing for the existing data stage codes.
  • Created generic jobs using RCP to extract data from various source systems.
  • Designed and developed ETL processes using Data Stage designer to load data from Oracle and XML files to staging database and from staging to the target Data Warehouse database.
  • Prepared high level Micro Design documentation to be reviewed by client.
  • Created unit test cases and documented them for approval, for code move to SIT.
  • Wrote UNIX shell Scripts for FTP of files from remote server and backup of repository and folder.
  • Involved in writing UNIX shell scripts for automation, job run, file processing, initial load, batch loads, cleanup, job scheduling.
  • Created jobs sequences and job schedules to automate the ETL process by extracting the data from flat files, Oracle and Teradata into Data Warehouse.
  • Involved in Performance tuning at source, target, mappings, sessions, and system levels.
  • Prepared migration document to move the jobs from development to testing and then to production.

Environment: IBM Info Sphere Data Stage 11.3, Oracle 11G, SQL Server 2008, Teradata, Toad, Windows 2000, UNIX

Confidential, Troy, MI

Senior ETL/ DataStage Developer

Responsibilities:

  • Involved in requirement gathering, analysis and study of existing systems.
  • Extensively using Data Stage designer for designing Parallel jobs and performed complex mappings based on user specifications.
  • Working in designer for Extracting Data, Performing Data Transformations and Aggregate Data.
  • Designed jobs using different stages like Transformer, Aggregator, lookup, Source dataset, external filter, Row generator, column generator, peek stages.
  • Added, deleted and setup DataStage projects and managed users from Data stage administrator
  • Used DataStage Administrator for setting the variables and parameters.
  • Distributed load among different processors by implementing the Partitioning method.
  • Extracted data from oracle and transformed data and loaded into Oracle data warehouse.
  • Designed complex jobs to handle data in multi millions of records and loading them to Target
  • Designed and customized data models for Data warehouse supporting data from multiple sources on real time
  • Involved in bug fixing for the existing data stage codes.
  • Worked on a Migration project from Mercator (DataStage TX) to DataStage 11.3
  • Used Data Profiling tool Information Analyzer for Column Analysis, Primary Key Analysis and Foreign Key Analysis.
  • Created generic jobs using RCP to extract data from various source systems.
  • Designed and developed ETL processes using DataStage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Data Warehouse database.
  • Involved in Performance tuning at source, target, mappings, sessions, and system levels.
  • Prepared migration document to move the jobs from development to testing and then to production.

Environment: IBM Info Sphere Data Stage 11.3, IBM WebSphere Data stage 8.1, Oracle 11G, Windows 2000, UNIX

Confidential, San Francisco, CA

ETL Developer

Responsibilities:

  • Involved in requirement gathering, analysis and study of existing systems.
  • Extensively used Data Stage designer for designing server jobs and performed complex mappings based on user specifications.
  • Worked in designer for Extracting Data, Performing Data Transformations and Aggregate Data.
  • Worked in Manager to store, manage reusable Metadata and created custom routines and transforms for the jobs.
  • Experience in Data Stage to Validate, Run, and Schedule and Monitor Data stage jobs.
  • Extensively worked in Data Stage Administrator to assign privileges to user groups.
  • Designed jobs using different stages like Transformer, Aggregator, lookup, Source dataset, external filter, Row generator, column generator, peek stages.
  • Worked with sequential files, Oracle as sources and Oracle and XML as Targets.
  • Distributed load among different processors by implementing the Partitioning method.
  • Extracted data from flat files, sequential files and access files, applied transformations and loaded the data into data warehouse.
  • Created routines for the validation of files provided by client.
  • Participated in disaster recovery phase.
  • Investigate client reported issues and identify root cause.
  • Determine short term and permanent resolution, including possible workarounds.
  • Communicate with the client as needed to diagnose and present options.
  • Specify and develop code corrections for defects and minor enhancements.
  • Created job sequences to define the flow of the jobs
  • Developed and scheduled month end reports for clients in Business objects XI and other internal developed reporting tool called Campaign Manager.
  • Written UNIX shell scripts to automate the Data Load processes to the target Data warehouse.

Environment: IBM Info Sphere Data Stage 8.X, Ascential Data Stage 7.5, Microsoft SQL Server, Windows 2000, UNIX, and SAP Business Objects XI

Confidential, Dallas, TX

DataStage with Oracle PL/SQL Developer

Responsibilities:

  • Involved in the Full SDLC from analyzing business requirements to Go Live into Production.
  • Designed jobs for different source systems, for data movement from source to target.
  • Entity Level and Attribute Level data analysis of Source Data from Reporting Data Repository (RDR) Warehouse to meet business requirements.
  • Implemented Slowly Changing Dimension Type 2 and Type 1 for some dimensions.
  • Worked using financial Oracle application (GL, SC, PP, MAXIMO, PEOPLESOFT) as source and target.
  • Worked using Quality stage deliver accurate, complete information to business users.
  • Used Siebel to gather requirements from Client.
  • Performed SQL tunings to handle HR PeopleSoft Database on Oracle and extracted data from it.
  • Experienced in developing shell scripting for scheduling the jobs.
  • Extensively worked with Data stage to implement different transformations satisfying business rules.
  • Assisted Data Modeler in data analysis for various source systems, while creating the Model.
  • Generated XSLT in jobs.
  • Created XML files using XSD.
  • Loaded XML files in parallel jobs.
  • Involved in high level technical design meetings with business analysts to discuss mappings.
  • Designed complex jobs to handle data in multi millions of records and loading them to Target.
  • Extensively used Nested condition, Notification activity, sequencer and routine activities in sequence job.
  • Developed Reconciliation Process for every design of job in Data stage for auditing needs.
  • Involved in bug fixing for the existing data stage codes.
  • Created shell scripts which will invoke the Data Stage jobs passing all the variables for the job to execute like the Source and Target databases connection information
  • Prepared high level Micro Design documentation to be reviewed by client.
  • Created unit test cases and documented them for approval, for code move to SIT.
  • Was responsible for code move, Exporting and Importing from and to DEV, UAT and PROD.
  • Made use of different stages, like Transformer, ODBC, DB2 Enterprise, Lookup, Merge, Funnel, and Change Capture extensively to design jobs that meet business functionality.
  • Assisted other resources in designing jobs yielding better performance
  • Worked with Architect in designing the incremental loading strategies.
  • Designed jobs for Delta Capture for incremental loading, to handle millions of records.

Environment: IBM Web Sphere Data Stage/Quality stage 8.1, Siebel, Oracle 10G, PEOPLESOFT, PL/SQL, SQL*Loader, SQL Server, AIX, UNIX, XML (XSD), XSLT

Confidential, Providence, RI

DataStage/ SQL Developer

Responsibilities:

  • Designed jobs for different source systems, for data movement from source to target.
  • Experienced in developing shell scripting for scheduling the jobs.
  • Extensively worked with Data stage to implement different transformations satisfying business rules.
  • Developed jobs for handling different data transformations as per specified requirements using stages like Join, Merge, Lookup, Transformer and Aggregator etc.
  • Designed and developed Shared Containers that can be reused by other parallel jobs.
  • Involved in performance tuning to reduce the time consumption.
  • Involved in high level technical design meetings with business analysts to discuss mappings.
  • Designed complex jobs to handle data in multi millions of records and loading them to Target.
  • Developed Reconciliation Process for every design of job in Data stage for auditing needs.
  • Involved in bug fixing for the existing data stage codes.
  • Created shell scripts which will invoke the Data Stage jobs passing all the variables for the job to execute like the Source and Target databases connection information
  • Created unit test cases and documented them for approval, for code move to SIT.
  • Was responsible for code move, Exporting and Importing from and to DEV, UAT and PROD.
  • Made use of different stages, like Transformer, ODBC, DB2 Enterprise, Lookup, Merge, Funnel, and Change Capture extensively to design jobs that meet business functionality.
  • Assisted other resources in designing jobs yielding better performance
  • Worked with Architect in designing the incremental loading strategies.

Environment: IBM Web Sphere Data Stage, Oracle 9G, PL/SQL, SQL*Loader, SQL Server, AIX, UNIX, XML (XSD), XSLT.

Hire Now