We provide IT Staff Augmentation Services!

Sr Datastage Developer Resume

3.00 Rating

Lombard, IL

SUMMARY

  • Over 8 years of IT experience in analysis, design and development of data warehouse and oracle related applications.
  • 4+ years of solid experience in building data warehouse/Data marts especially with ETL tools like IBM Information Sever Datastage 9.1/8.5/8.01/ 7. x/6.x/5.x
  • Extensive knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development and Deployment.
  • Proficient in Extraction, Transformation and Loading (ETL) processes using IBM Infosphere Information Server (9.1/8.5/8.0/7.5/7.0/6.0 ).
  • Used Quality Stage to check the data quality of the source system prior to ETL process.
  • Created the Data quality jobs dealt with field validations vs the data validations.
  • Used stages like standardize, match frequency, Investigate in Quality Stage for cleansing of customer data based on address, state, zip.
  • Performed Debugging, Troubleshooting and performance tuning of Datastage Jobs.
  • Expert in Dimensional Data Modeling, Star Schema modeling, Snowflake Schema modeling, fact and dimension table design, physical and logical Data modeling using ERwin 4.2/4.1/3.x.
  • Experience in Database programming Load Data Warehouses (Star Schemas). Developed Strategies for Extraction Transformation Loading (ETL) mechanism
  • Handled huge data in various kinds of formats like EBDIC/Binary, data containing unusual characters using Complex flat file stage.
  • Report creation using OLAP data source and having knowledge in OLAP universe.
  • Used EPM strategy to review the overall business requirements, and how these requirements have been translated into a project plan and system design.
  • Strong skills in fulfilling EDI requirements and experience with XML, CSV, and fixed field length file transformations
  • Worked extensively with Data migration, Data Cleansing, ETL Processes.
  • Extensive experience in designing and working with Oracle 8i/9i/10g and writing SQL queries and PL/SQL Procedures, Functions, Packages, Database Triggers, Exception Handlers, Ref Cursors, Database Objects using PL/SQL. Proficient in writing Unix Shell scripts.
  • Developing ETL job streams, which reflect business logic to populate Netezza warehouse database.
  • Comprehensive knowledge of tuning and performance enhancing the long running queries in Oracle and Netezza using SQLTrace, Explain Plan, Netezza query plan, different types of optimizer hints, indexes, tables and best practices in SQL and PL/SQL.
  • Netezza is responsible for the architecture design and strategic direction for Data Warehouse support.
  • Strong knowledge of SQL with comfort in the following RDBMS systems (Oracle, SQL Server, Netezza)
  • Prepared documentation for standard practices using Datastage for enhanced performance.
  • Expertise in Testing phase planning, preparation and execution.
  • Expertise in creating schema objects, Performance Tuning of SQL statements.
  • Able to work within an aggressive and demanding project schedule and environment.
  • Strengths include excellent communication skills and interpersonal skills, good analytical skills and logical approach to problem solving.

TECHNICAL SKILLS

Operating System: Windows 95/98/2000/XP/Vista, Unix and Linux

Databases: Teradata 13.0, Oracle 11g/10g/9i/8i, SQL Server, DB2, Mainframes

Programming languages: C,C++

Scripting languages: SQL, PL/SQL, C, Unix - shell scripting

Tools: Queryman, Designer 1.3/2.0/6I; Developer 6i; Erwin, SQL Loader; Oracle, Toad, QueryAnalyzer, OEM.

Warehousing Tools: IBM Information Server 8.5, 8.0.1, IBM Information Analyzer 8.0 DataStage 11.1 Version above, QualityStage 8.5

Testing Tools: Quality Center,Win Runner 7.0, LoadRunner7.0, Test Director 7, Rational Clear Quest

Other Tools: SubVersion, Control-M, MSOffice, MSWord, MS Excel.

PROFESSIONAL EXPERIENCE

Confidential, Lombard IL

Sr Datastage Developer

Responsibilities:

  • Involved in the Dimension Modeling, Logical Design of Data Warehouse schema, and Physical Design of Data Warehouse schema.
  • Involved in analysis, requirements gathering, function/technical specifications, development, deploying and testing.
  • Experience working with Data Warehousing Appliances such as Netezza
  • Installation, configuration, setup and Administration of Data Stage Server.
  • Created Shared Containers for reusable calculations in various strings.
  • Created Data Model using Erwin from data sources and defined the dimensions, levels and measures in the model.
  • Extensively used Data Stage Designer stages such as ODBC, Aggregator, Transformer, Join, Pivot, FTP and Merge.
  • Extensively used Email Notification, Nested Condition, Sequencer and Terminator activities in Job Sequences.
  • Developed Routines for Error handling and also developed before/after job subroutine.
  • Extensively used Quality Stages like Investigate, Match and Survivorship.
  • Used the Data Stage Administrator to assign privileges to users or user groups (to control which Data Stage client application or jobs they see or run), move, rename or delete projects and manage or publish jobs from development to production status.
  • Used Director for executing, analyzing logs and scheduling the jobs.
  • Developed Hash files for performance improvement by reducing the reference lookup time.
  • Created monthly and weekly job reports using Datastage for analysis purpose.
  • Converted existing SQL procedures and scripts into Datastage jobs to improve performance of the existing system applications.
  • Used Quality Stage plug-in to call Quality Stage jobs from Data stage.
  • Used the Folder stage and RTI stage to extract data from .xml type files and load into Oracle database.
  • Developed, tested Store procedures, Functions and packages in PL/SQL for Data ETL.
  • Written SQL scripts to create and drop the indexes those are passes as parameters in the pre & post sessions.
  • Involved in investigating & solving the data integrity issues.
  • Worked on scheduling tool control M for monitoring and scheduling jobs.
  • Wrote UNIX shell Scripts for file validation and scheduling DataStage jobs.

Environment: IBM Information Server 8.5 (DataStage, Quality Stage and Information Analyzer), Erwin 4.1, Windows XP, Unix Shell scripting, TOAD 6.3, Oracle 11g, SQL, PL/SQL, Control-M, SVN

Confidential, Chicago, IL

Sr DataStage Developer

Responsibilities:

  • Collected the information about the existing sources by reverse engineering them.
  • Extracted data transformed and loaded into Oracle database according to the required provision using IBM WebSphere DataStage 7.0.
  • Used the DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
  • Designed the mappings between sources external files and databases like Oracle, SQL Server, DB2 and XML files to Operational staging targets.
  • Used built-in as well as complex custom transformations
  • Involved in creating more than 80 jobs using Datastage Designer.
  • Used Datastage manager to manage the Metadata repository and import/export of jobs.
  • Involued in MQseries environment and installation of MQ on linux and AIX platforms. Have created QManagers, queues and established channel among those queues for transfer of messages.
  • Used PL/SQL processes to upload flat files using SQL*Loader.
  • Optimized job performance by carrying out Performance Tuning.
  • Created source table definitions in the Repository by studying the data sources.
  • Created Log Tables containing data with discrepancies to analyze and re-process the data.
  • Trouble-shooted the designed jobs using the Debugger.
  • Good hands-on experience with scripting in the Linux environment.

Environment: DataStage 7.0, (Designer, Director, Manager, Parallel Extender), Oracle 9i, SQL Server 2000, DB2, MS-Access, XML files, ERwin 4.1.4, PL/SQL, Teradata,MQ series, UNIX,LINUX,Windows NT, Stored procedure knowledge(SYBASE).

Confidential, Irwin, CA

ETL Developer

Responsibilities:

  • Analyzed the transactional data model, data elements. Interacted with Business analyst, SME (Subject Matter Experts) on day-to-day basis to create technical specification for data conversion programs.
  • Involved in the Development, Implementation of the backend systems for the Database.
  • Created Data Model using Erwin from data sources and defined the dimensions, levels and measures in the model.
  • Developed several Server jobs using DataStage Designer. Performed data transformations by using various stages like Transformer, FTP, conditioning, and validation and loading into the Data warehouse.
  • Extracted data using different strategies from the various heterogeneous sources like DB2, Sybase, Oracle & flat files.
  • Wrote system and user acceptance test scripts.
  • Developed test plans and test cases.
  • Designed UML diagrams using MS Visio.
  • Designed and developed jobs to migrate data using Ascential DataStage.
  • Developed DataStage Server jobs extensively using various stages like Transformer, Hash File, Aggregator, Sequential stage, ORAOCI etc.
  • Imported and exported Jobs from DataStage Manager to different environments.
  • Used DataStage Director to monitor, validate and execute the Server Jobs created in the DataStage Designer.
  • Wrote SQL queries for Oracle to fetch the data.
  • Wrote stored procedures, functions, views and triggers.
  • Developed UNIX k-shell scripts for archiving files on remote machine.
  • Responsible for Unit, System and Integration testing.
  • Supported existing production systems.

Environment: Ascential DataStage 7.5, Oracle 9i, Sun Solaris 5.8,Sybase, TOAD, Perl, SQL, PL/SQL, DB2, UNIX Shell Scripts, C++, Seibel, MS Visio, WS FTP Pro.

Confidential, Boston MA

ETL Developer

Responsibilities:

  • Used Netezza in design integration and also a part in PureData analytics applications for running the algorithm with efficiency.
  • NPS (Netezza Platform Services) is used combine with DB2, Hadoop, Oracle for deep insight of the query.
  • By using Netezza it very cost efficient because it has self-encrypting drives and enhanced security in PureData analytic system.
  • Involved in the requirements gathering, analysis to define business and functional specifications.
  • Responsible for Data Modeling, Functional and Technical Design for the Client.
  • Involved in designing, developing and documenting of the ETL (Extract, Transformation and Load) strategy to populate the Data Warehouse from various source systems (Oracle) feeds using Data Stage, PL/SQL and Unix Shell scripts.
  • Extracted data from various sources like DB2, Oracle, XML and Flat Files and loaded to target tables.
  • Developed Shared Containers, which can be reused several times.
  • Used Metabroker for importing Metadata using MetaStage and created new job categories and new data elements.
  • Used Datastage Designer to design and develop jobs for extracting, transforming, integrating, and loading data targets.
  • Automated the FTP Extraction Process by job control to use one job for several extractions.
  • Developed Hash files for performance improvement by reducing the reference lookup time.
  • Extensively used Datastage Designer stages such as FTP, Folder Stage, ODBC, OCI, Aggregator, Transformer and Hashed File.
  • Used Job Control routines and Transform functions in the process of developing the job.
  • Job Parameters were extensively used to parameterize the server jobs.
  • Used DataStage Director and the runtime engine to schedule running the server jobs, monitoring and debugging its components.
  • Developed star schemas and created custom star schema as per the business requirements.
  • Applied Performance Tuning logic to optimize session performance.
  • Developed PL/SQL stored procedures for source pre load and target pre load to verify the existence of tables.

Environment: Ascential Datastage 6.5.x (Designer, Administrator, Director and Manager), DB2 UDB, Oracle, PL/SQL, Unix Shell scripts, TOAD, SQL*Loader, UNIX AIX and Metastage.

Confidential

Intern Programmer

Responsibilities:

  • Worked on creating basic reports for management team.
  • Running daily scheduled jobs and analyzing the results.
  • Involved in writing procedural scripts using PL/SQL
  • Involved in coding and testing of the system
  • Stored procedures and triggers were developed for business rules
  • Generated various types of reports by using reports builder
  • Involved in implementation and documentation of the system
  • Generated business specific reports using crystal reports.

Environment: Oracle, PL/SQL and Windows NT.

We'd love your feedback!