Scribd Logo
Upload

Welcome to Scribd!

  • 107 views

    Email: Mobile No: Professional Summary

    Uploaded by

    nithinmamidala999
    The document provides a summary of a candidate's professional experience and qualifications. It outlines their 3+ years of experience as an ETL Developer using IBM DataStage, expertise in extracting, transforming and loading data from sources like files, Excel and Oracle databases. It also lists their technical skills including SQL, C/C++, Oracle, HTML, and DataStage. Two projects are described where the candidate developed ETL jobs to load data into target databases for healthcare and telecommunications companies.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd

    Email: Mobile No: Professional Summary

    Uploaded by

    nithinmamidala999
    107 views3 pages
    The document provides a summary of a candidate's professional experience and qualifications. It outlines their 3+ years of experience as an ETL Developer using IBM DataStage, expertise in extracting, transforming and loading data from sources like files, Excel and Oracle databases. It also lists their technical skills including SQL, C/C++, Oracle, HTML, and DataStage. Two projects are described where the candidate developed ETL jobs to load data into target databases for healthcare and telecommunications companies.

    Original Description:

    DATASTAGE

    Original Title

    Resume DS

    Copyright

    © © All Rights Reserved

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides a summary of a candidate's professional experience and qualifications. It outlines their 3+ years of experience as an ETL Developer using IBM DataStage, expertise in extracting, transforming and loading data from sources like files, Excel and Oracle databases. It also lists their technical skills including SQL, C/C++, Oracle, HTML, and DataStage. Two projects are described where the candidate developed ETL jobs to load data into target databases for healthcare and telecommunications companies.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    107 views3 pages

    Email: Mobile No: Professional Summary

    Uploaded by

    nithinmamidala999
    The document provides a summary of a candidate's professional experience and qualifications. It outlines their 3+ years of experience as an ETL Developer using IBM DataStage, expertise in extracting, transforming and loading data from sources like files, Excel and Oracle databases. It also lists their technical skills including SQL, C/C++, Oracle, HTML, and DataStage. Two projects are described where the candidate developed ETL jobs to load data into target databases for healthcare and telecommunications companies.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    of 3

    Email:

    Mobile No:

    PROFESSIONAL SUMMARY:

    Having around 3 + Years of Extensive Experience in the field of IT Industry.


    Extensive Experience in Data warehousing as ETL Developer Using IBM Data stage
    8.5 and 8.0.1
    Expertise in developing Parallel Jobs.
    Extensive experience in extraction, transformation and loading of Data directly from
    different source systems like Flat files, Excel, Oracle.
    Good Experience on Data stage Designer tool for Developing Jobs Using Built in
    Active Stages & Passive Stages.
    Working knowledge in Software Development Life cycle(SDLC)
    Good SQL programming skills and relational database knowledge including the ability
    to write analyze & debug queries.
    Strong Experience on Compiling, validating, running, Monitoring and scheduling the
    jobs using the Data Stage Client tool i.e. Director.
    Transformation and Loading processes using ETL tool Data Stage Slowly Changing
    Dimensions using Type1, Type2.
    Willing to work as a key player in challenging and creative environment
    Having Good Communication and interpersonal skills. Ability to quickly adapt to the
    Technical Environment

    ACADEMICS:

    TECHNICAL SUMMARY:

    ETL Tools : IBM Web sphere Data stage 8.5/8.0.1


    Operating Systems : Windows 2003 Server / XP and UNIX
    Languages : SQL, C, C++
    Data bases : Oracle 10g/9i
    Web Technologies : HTML
    Others : Telnet, Toad

    PROFESSIONAL EXPERIENCE:

    Presently Working as Software Engineer for. Hyderabad from Dec 2011 to Till Date.
    Worked as Software Engineer for Hyderabad From March 2010 to Nov 2011.

    PROJECT INFORMATION:
    Project #1:

    Name : EDW - The Regence Group


    Client : Blue Cross Blue Shield - U.S.A
    Duration : Dec 2011 to Till Date
    Role : ETL Developer
    Environment : IBM Data stage 8.5, Oracle-10g and UNIX
    Team size : 16

    Description:

    The client is a Blue Cross Blue Shield affiliated health plan with more than 3 million members.
    It operates across 4 north western states of the US and offers a diverse range of products
    covering Group and Individual Medical, Medicare, Dental and Vision health products.
    The objective of this project is to identify impact of database migration from oracle 9i to 11g on
    database table & Data Stage extract and load jobs.

    Responsibilities:

    Involved in the Analysis of the specifications provided by the clients i.e. mapping doc
    and functional specifications.
    The data is extracted from different source systems like Flat files, database tables,
    Transform the same data as per mapping doc and finally loaded in to Target system by
    using Data Stage.
    Work Data analysis and fixing the incorrect data either by fixing jobs or fixing data
    itself in ODS and DW
    Do performance tuning and code optimization for long running jobs.
    Developing the data stage jobs by using Sequential file stage, Data Set stage,
    Transformer, Sort, Aggregator, Join, Funnel, Filter, Lookup, Surrogate Key and ODBC
    stages.
    Used for simplifying the complex designing.
    Creating job sequences to run the jobs in a specified manner.
    Involved in peer reviews, preparing unit test plans.
    Designing the Jobs using Data stage tool to load data from source to target schema.
    Testing the Jobs according to Unit Test Cases.

    Project #2:

    Name : MTS
    Client : Manitoba telecom services lnc, Manitoba, Canada
    Duration : March 2010 to Nov 2011.
    Role : ETL Developer
    Environment : IBM Data stage 8.0.1, Oracle-9i and UNIX
    Team size : 18

    Description:
    Manitoba Telecom Services inc, or MTS, formerly Manitoba Telephone System is the primary
    telecommunications carrier in the Canadian province of Manitoba and the fourth largest
    telecommunications provider in Canada with 7000 employees. It provides local and long
    distance phone services, television service, internet service and wireless services including
    digital PCS cellular and paging. Since acquiring Allstream in 2004, The Company is known as
    MTS Allstream Inc. MTS Allstream has nearly two million total customer connections
    spanning business customers across Canada and residential consumers throughout the province
    of Manitoba.

    Responsibilities:

    Extensively involved in preparation of design documents like LLDs and unit test case
    documents.
    Performed unit Testing activity for all the jobs in the project.
    Extensively used various stages like sequential File Stage, dataset ,lookup file Set,
    Aggregator, sort, change capture, copy, surrogate key generator.
    Passed values by loading parameters through job properties
    Interacted with different source system like Oracle database and flat files.
    Used extensively reject link, job parameters, and stage Variables in developing jobs.
    Used Row Generator , Peek Stages While testing the job designs,
    Designing the Jobs using Data stage tool to load data from source to target schema.

    You might also like