We provide IT Staff Augmentation Services!

Data Stage Developer Resume

Mettawa, IL

PROFESSIONAL SUMMARY:

  • 7+ years of profound IT experience in Design, Development and Implementation of Relational Database and Data Warehousing Systems using IBM InfoSphere Information Server 8.1 (DataStage, Quality Stage), IBM DataStage Enterprise and DataStage 8.5/8.1/7.5 Client - Server environment.
  • Hands on experience in creating Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to assist efficient data manipulation and data consistency.
  • Strong knowledge of Relational Database Management Systems (RDBMS) concept in several databases like SQL Server 2008/2005 and Oracle 10g/9i/8i.
  • Worked on activities related to the development, implementation, administration and support of ETL process for large-scale Data Warehouses using SSIS, DataStage.
  • Creating data mappings and data dictionaries and understanding business data relationships.
  • Experience in working with Server jobs, Parallel jobs, debugging, troubleshooting and performance tuning.
  • Expertise in working with different versions of DataStage - DataStage Standard (Server Jobs and sequence jobs), DataStage Enterprise (Server jobs, sequence jobs and parallel jobs) offering parallel processing features and DataStage Enterprise MVS allowing jobs to be developed on a Unix or Windows server and transferred to the mainframe to be compiled and run.
  • Worked on DataStage client tools like DS Designer, DS Director, DS Manager and DS Administrator.
  • Experience in Designing, Compiling, Testing, Scheduling and running DataStage jobs.
  • Experience in various phases of IT projects Software Development Life Cycle (SDLC) such as analysis,
  • Design, construction and testing, deployment and production support.
  • Strong skills in data mapping for the Slowly Changing Dimensions - SCD1, SCD2 (Flagging, Time Stamping and Version), and SCD3.
  • Implemented the complex business rules by creating reusable transformations and Mappings / Mapplets.
  • Experience in debugging and Performance tuning of targets, sources, mappings and Sessions in Informatica and performed debugging, troubleshooting, monitoring and performance tuning using DataStage.
  • Expertise in Dimensional Data modeling SSAS techniques like Star Schema, Snowflake modeling, Fact and Dimensions tables, Physical and logical data modeling.
  • Designed DataStage Jobs to extract data from XML files using XML input stage, Used XML transformer Stage to cleanse and transform the data to load it into the Data Mart.
  • Used built-in Quality Stage 8.x for data cleansing, data quality and consistency by standardizing, validating, matching, and merging information to create comprehensive and authoritative information for multiple uses.
  • Good Knowledge of ODBC Connector, SQL Builder, Advanced and Quick Find, Parameter Set, Common Logging, Resource Estimation tool.
  • Interacted with Developers, Business analysts, Database team, Deployment team, and Release
  • Management in an efficient and effective manner.
  • Experience in developing ETL mappings and scripts using DataStage 7.5/7/6.x/5.x using Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager and Workflow Manager.
  • Effective leadership skills with good written, verbal communication and presentation skills. Self-motivated with result oriented approach. Committed collaborator and team leader.

TECHNICAL SKILLS:

ETL Tools: IBM InfoSphere DataStage 8.5/8.1/7.5.2 (Designer, Director, Parallel Extender)

RDBMS: DB2, Teradata V12, Oracle 8i/9i/10g

Languages: SQL, PLSQL, UNIX Shell, C, C++, HTML, XML, COBOL, JCL

Other tools & utilities: COGNOS 8.4, OBIEE 10g/11g, Autosys, SQL Assistant 12.0, Erwin 4.0

Operating Systems: UNIX, Windows 2000/2003/XP/VISTA/7/8

PROFESSIONAL EXPERIENCE:

Confidential, Mettawa, IL

Data Stage Developer

Responsibilities:

  • Worked on total IT Experience in the Design, Development, Testing, Implementation and Support for data migration life cycle for various industry verticals.
  • Worked on Experience in ETL DataStage for maintaining data warehouses and data marts using IBM
  • WebSphere/InfoSphere Information Server (Ver. 8.5/8.1/7.5.2 ) Server edition, Enterprise edition
  • (Parallel Extender).
  • Designed and Prepared Mapping Documents for Source to Target mapping with ETL transformation rules.
  • Strong Data modeling skills including Star Schema, Snow-Flake Star Schema models and E-R Modeling, Dimensional modeling.
  • Experience using Parallel Extender for Extraction, Transformation and Loading of data from flat filesDB2.
  • Extensively worked on Parallel Jobs using Various Stages like Join, Transformer, Lookup, Change
  • Capture, Filter, Funnel, Sort, and Aggregator.
  • Expert level experience for performance troubleshooting and enhancement for large volumes of data and Strong analytic skill of debugging existing DataStage applications.
  • Experience in scheduling tools like Autosys for automating and scheduling jobs run.
  • Extensively worked on different Databases Oracle, SQL Server, RDBMS, IBM DB2, and Teradata.
  • Extensively used DataStage components like DataStage Designer, Director.
  • Hands on experience in Migration and Data Migration projects.
  • Designed and developed jobs using Parallel Extender for splitting bulk data in to subsets and to Dynamically distribute to all available nodes to achieve best job performance.
  • Strong Experience in designing of Parallel jobs.
  • Excellent Domain knowledge on consumer banking background.
  • Excellent technical and analytical skills.
  • Experience in working closely with the business users to gather requirements and impact analysis.
  • Excellent interpersonal, written and verbal communication skills. Quick learner with ability to multi-task.

Environment: IBM Info Sphere Information Server V8.5 Suite DataStage, Teradata 12, DB2, Oracle, UNIX Shell Scripting, Windows XP, Erwin.

Confidential, Lisle, IL

Data Stage Developer

Responsibilities:

  • Worked extensively on Data warehousing, extensively used DataStage an ETL tool to design Mappings to move data from Source to Target database-using Stages.
  • Interacting with Business/Domain expert to gather ETL requirements & analysis of various data Sources, Flat files, Oracle, SQL server.
  • Interacting with DBA team to convert Logical Data Model into the Physical Data Model.
  • Design and Development of DataStage ETL jobs using various stages like Aggregator, Join, Transformer,
  • Sort, Merge, Filter and Lookup, Sequence, Modify, Peek etc. stages to load Daily and Historical data into star schema data model.
  • Broadly involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using DataStage PX.
  • Successfully Integrated data across multiple source with high volumes of data.
  • Performance Tuning of existing ETL Jobs and Automation of ETL processes using DataStage Job
  • Sequencer, Job Control routines and Transform functions.
  • Migration of Entire ETL jobs/script//Shell Scripts/DSN connection to production environment.
  • Involved in Design and developing the DataStage code along with Unit Testing and performance tuning.
  • Designed ETL jobs to identify and remove duplicate rows using remove duplicate stage.
  • Extensively worked with surrogate key generator to generate warehouse keys before loading data into warehouse
  • Supporting to stakeholders in Regression testing.
  • Following all the processes as per agile methodology.
  • Involving in high level standup meetings with the client and team.
  • Documentation on Job designing and code review demos to the client.

Environment: IBM Info Sphere Information Server V8.5 Suite DataStage, Teradata 12, DB2, OracleUNIXShell Scripting, Windows XP, Erwin.

Confidential, Milwaukee, WI

Data Stage Developer

Responsibilities:

  • Performed Unit test/Link Test on various integration.
  • Worked extensively on Data warehousing, used DataStage an ETL tool to design mappings to move
  • Data from Source to Oracle database-using Stages.
  • Interacting with Business/Domain expert to gather ETL requirements & analysis of various data sources, Flat files and oracle.
  • Interacting with DBA team to convert Logical Data Model into the Physical Data Model and participated in the data modeling processes using Erwin as the modeler.
  • Involved in design and development of parallel jobs using DataStage designer.
  • Design and Development of DataStage ETL jobs using various stages like Aggregator, Join,
  • Transformer, Sort, Merge, Filter and Lookup, Sequence, Modify, Peek etc. stages to load Daily and Historical data into starschema data model.
  • Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using DataStage PX.
  • Successfully Integrated data across multiple source with high volumes of data.
  • Deployed the solutions that maximize the consistency and usability of data.
  • Performance Tuning of existing ETL Jobs and Automation of ETL processes using DataStage Job
  • Sequencer, Job Control routines and Transform functions.

Environment: IBM Info Sphere Information Server V8.5 Suite DataStage, Oracle 10g, UNIX Shell Scripting, Erwin.

Confidential, Milwaukee, WI

Data Stage ETL Developer

Responsibilities:

  • Involved in complete Data Warehouse Life Cycle from requirements gathering to end user support.
  • Provide day-to-day and month-end production support for various applications like Business
  • Intelligence Center, and Management Data Warehouse by monitoring servers.
  • Involved in Designing, Testing and Supporting DataStage jobs.
  • Developed Parallel jobs using various stages like Join, Merge, Lookup, Surrogate key, Scd, Funnel,
  • Sort, Transformer, Copy, Remove Duplicate, Filter, Pivot and Aggregator stages for grouping and
  • Summarizing on key performance indicators used in decision support systems.
  • Accomplished various development requests through mainframe utilities, CICS Conversation
  • Meet the clients on a weekly basis to provide better services and maintain the SLAs.
  • Use Control-M to schedule jobs by defining the required parameters and monitor the flow of jobs.
  • Automated the process of generating daily and monthly status reports for the processing jobs.
  • Drop indexes, remove duplicates, rebuilt indexes and rerun the jobs failed due to incorrect source data.
  • Involved in the process of two client bank mergers by taking care of the customer account numbers, Bank numbers, and their respective applications.

Environment: IBM Info sphere Data stage 8.5/8.1, SunOS 5.8, Control-M 6.4.01, PL/SQL Developer 7.1, Teradata12, Erwin, Autosys, Toad, and Case Management System.

Confidential, Columbus, OH

Data Stage Consultant

Responsibilities:

  • Worked extensively with Parallel Stages like Copy, Join Merge, Lookup, Row Generator, Column
  • Generator, Modify, Funnel, Filter, Switch, Aggregator, Remove Duplicates and Transformer Stages
  • Gathered requirements and wrote specifications for ETL Job modules.
  • Worked as SME in providing support to the team in designing the flow of complex jobs.
  • Apart from providing technical support to the team and I also handled escalations.
  • Worked on production support by selecting and transforming the correct source data.
  • Data Warehouse was implemented using sequential files from various Source Systems.
  • Worked closely with DBA and BA to better understand the business requirement.
  • Developed Mapping for Data Warehouse and Data Mart objects.
  • Performed through data cleansing by using the Investigate stage of Quality Stage and also by writing
  • PL/SQL queries to identify and analyze data anomalies, patterns, inconsistencies etc.
  • Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements.
  • Design and Develop ETL jobs using DataStage tool to load data warehouse and Data Mart.
  • Performance tuning of ETL jobs.
  • Perform data manipulation using BASIC functions and DataStage transforms.
  • Import relational metadata information for project.
  • Developed DataStage Routines for job Auditing and for extracting job parameters from files.
  • Create master controlling sequencer jobs using the DataStage Job Sequencer.
  • Create and use DataStage Shared Containers, Local Containers for DS jobs and retrieving Error login formation.
  • Design, build, and manage complex data integration and load process
  • Developed PL/SQL scripts to perform activities at database level.

Environment: IBM Data Stage 7.5(Data Stage, Quality Stage, Information Analyzer, Metadata Workbench, Business Glossary), Oracle 9i/10g, DB2 UDB, Teradata, Mainframe, PL/SQL, Oracle 10g with 2 node RAC, Autosys, Erwin 4.2, TOAD, SQL Developer.

Hire Now