Scribd Logo
Upload

Welcome to Scribd!

  • 47 views

    Mahesh ETL

    Uploaded by

    muneertechinfo
    Mahesh has over 3.5 years of experience as an ETL Developer working with Informatica PowerCenter. He has extensive experience designing mappings between various data sources like flat files and RDBMS and loading data into target databases like Oracle. Some of Mahesh's recent projects include developing an ETL solution for a telecom company to load sales data into a data warehouse and building mappings to extract and transform banking customer profile data.

    Copyright:

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

    Mahesh ETL

    Uploaded by

    muneertechinfo
    47 views5 pages
    Mahesh has over 3.5 years of experience as an ETL Developer working with Informatica PowerCenter. He has extensive experience designing mappings between various data sources like flat files and RDBMS and loading data into target databases like Oracle. Some of Mahesh's recent projects include developing an ETL solution for a telecom company to load sales data into a data warehouse and building mappings to extract and transform banking customer profile data.

    Original Description:

    Resume

    Original Title

    Mahesh_ETL

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Mahesh has over 3.5 years of experience as an ETL Developer working with Informatica PowerCenter. He has extensive experience designing mappings between various data sources like flat files and RDBMS and loading data into target databases like Oracle. Some of Mahesh's recent projects include developing an ETL solution for a telecom company to load sales data into a data warehouse and building mappings to extract and transform banking customer profile data.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    47 views5 pages

    Mahesh ETL

    Uploaded by

    muneertechinfo
    Mahesh has over 3.5 years of experience as an ETL Developer working with Informatica PowerCenter. He has extensive experience designing mappings between various data sources like flat files and RDBMS and loading data into target databases like Oracle. Some of Mahesh's recent projects include developing an ETL solution for a telecom company to load sales data into a data warehouse and building mappings to extract and transform banking customer profile data.

    Copyright:

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

    Mahesh V

    Mobile: 8309215121 EMail:[email protected]


    ________________________________________________________________
    Objective
    Seeking a Position To Utilize My Skills and Abilities in the Information
    Technology that Offers a Professional Growth While Being Resourceful,
    Innovative and Flexible.

    Professional Summary:

    • Having 3.5+Years of overall experience in IT Industry with Data


    warehousing tools using industry accepted methodologies and procedures
    • Worked with various clients in the Telecom, Banking, and Insurance
    industries.
    • Involved in Understanding client Requirements, Analysis of Functional
    specification, Technical specification preparation, Review of Technical
    Specification.
    • Involved in identifying bugs in existing mappings by analyzing the data
    flow, evaluating transformations and fixing the bugs so that they conform
    to the business needs and redesign the existing mappings for improving
    the performance.
    • Expert knowledge in working with Informatica PowerCenter 8.x/9.x
    (Designer, Repository manager, Work flow manager, workflow monitor).
    • Extensive experience in using various Informatica Designer Tools like
    Source Analyzer, Transformation Developer, Mapping Designer, Mapplet
    Designer.
    • Extensively worked on Informatica PowerCenter Transformations such as
    Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update
    Strategy, Rank, Aggregator, Sorter, Sequence Generator, and Normalizer.
    • Extensive experience in error handling and problem fixing in Informatica.
    • Designed Mappings and expertise in Performance Tuning.
    • Good knowledge in using Informatica workflow manager, Workflow
    monitor, pmcmd (Informatica Command line utility) to create, schedule
    and control workflows, tasks, and sessions.
    • Experience in Oracle 10g/11g, SQL, PL/SQL etc.
    • Good knowledge in UNIX and excellent knowledge of Windows
    Operating systems.
    • Excellent analytical, problem solving skills and a motivated team player
    with excellent inter-personal skills
    • Experience in working with different data sources like Flat Files,
    RDBMS.
    • Excellent overall software Development life cycle (SDLC) experience,
    Conceptual and Logical Thinking, Goal oriented, self-motivated and able
    to work independently and as a member of a team.

    Experience Details:
    • Working as ETL Developer in IBM, from Oct 2021 to Till Date.
    • Worked as ETL Developer in Amdocs, from June 2021 to Sep 2021.
    • Worked as ETL Developer in Syntel, from April 2019 to May 2021.

    Education Details:
    • BCA From DR.APJ Abdul Kalam University, Indore, Passed Out 2019.
    Technical Expertise

    Data Informatica Power Center 9.6.1/9.5.1/8..6.1 (Informatica Designer,


    Warehousing Mapping Designer, Mapplet, Transformations, Workflow Manager,
    Work flow Monitor), Informatica Power Exchange, OLTP, OLAP.
    Data Modeling Logical Modeling, Physical Modeling, Dimensional Modeling (Star
    Schema, Snow-Flake), ER Diagrams (Entities, Attributes, Cardinality).
    Databases Oracle 10g/11g,
    Programming SQL, PL/SQL,
    Environment All windows Environment,Unix

    Environment: Informatica Power Center 10.4, Windows NT, Oracle19c, Unix.

    Project #3:

    Project : Telecom Analysis Data Warehouse


    Client : LEAD Communications, UK
    Role : Senior ETL Developer
    Duration : June 2021 to Till Date

    Description:
    Sales Analysis system provides Data warehousing solution for LEAD
    Communications Company, UK. LEAD Communications is an Electrical and
    Communications company. This company is involved in manufacturing and
    selling of Electrical and Communication Devices.

    It is a fixed project to design and develop an analytical Datamart with


    key business drivers
    Data at low granularity. Business defined set of key drivers that are very
    important to analyze business performance. As part of project the key business
    drivers data need to be loaded into the datamart at least possible granularity that
    is at customer, Location and product level along with monthly revenues.

    Responsibilities:
    • Extraction,Transformation and Loading (ETL) of data by using

    Informatica Power Center.

    • As it is a fixed price project we own end to end process like Requirements

    gathering, Design, Development, Testing and Deployment process

    • Understanding Requirements (HLD) and Preparing LLD’s.

    • Created mappings using the transformations such as the Source qualifier,

    Aggregator, Expression, Router, Joiner, Sequence Generator, Update

    Strategy, lookup and SCD’S.

    • Involved in Creating Sessions, Workflows Using Workflow Manager

    • Involved in testing and preparing UTP,UTR documents..

    • Involved in writing the queries for data validation

    Environment: Informatica Power Center 10.2, Windows NT, Oracle19c, Unix.

    Project 2:
    Title : Banking and Finance services Data Collection
    Client : Old National Bank, Evansville (Indiana)
    Role : ETL Developer
    Duration : May 2020 to May 2021

    Description:
    Old National Bank is a multi-billion dollar, multi-state Financial
    Services company Headquartered in Evansville, Indiana. As the largest
    Independent banking company Based in Indiana, It is providing to
    customers with a comprehensive range of financial Products and services,
    including Commercial and Retail Banking, Credit Card Services, Electronic
    Banking, Trust and Asset Management, Brokerage and Insurance Services.

    This bank involved in amounts for various purposes like Personal


    Loan, Vehicle Loan, Housing Loan, Consumer Durable Loans, etc. The
    company requires different level of analysis regarding loan amount, type of
    customers’ type of payment schedules, interest rates, defaulters list and the
    penal interest calculations, etc. The data warehouse, basically it is a Data Mart
    as it covers only one domain of the business and captures data from their
    Historical Database.
    This system is required to extract, transform, and load data from
    the different client system into a relational table environment that can be
    accessible for reporting purposes. A set of reports will be developed against the
    relational tables to deliver the information to its customers in the form of PDF
    files. The data from the different systems will be extracted into a set of text-
    based and Graphical reports.

    Responsibilities:

    • Extraction, Transformation and Loading (ETL) of data by using


    Informatica Power Center.
    • Extracted source data from flat files, Oracle and loaded to an Oracle.
    • Developed mappings in Informatica Power Center Designer to load data
    from staging environment to Data warehouse.
    • Created mappings using the transformations such as the Source qualifier,
    Aggregator, Expression, Router, Joiner,Sequence Generator ,Lookup ,Update
    Strategy, SCD’s.
    • Checked and tuned the performance of Informatica Mappings.
    • Involved in Creating Sessions,Workflows Using Workflow Manager.
    • Involved in testing the mappings (UNIT testing).
    Environment: Windows NT, Informatica Power Center 9.5.1, Oracle 11g, UNIX.

    Project #1
    Project : Life insurance data warehouse.
    Client : American Skyline Insurance Company
    Role : ETL Developer
    Duration : April 2019 to April 2020.
    Description:
    American Skyline Insurance Company, (ASCI) is one of the world’s
    respected players in Health Care Insurance industry. This conceptual enterprise
    Data Warehouse model provides Enterprise wide solution, which deals with
    several treads of the business like Audit& IT Analysis, Billing & Payment
    Analysis, Disability Claim Analysis, customer Profile Analysis, Customer
    Service Analysis, Financial Analysis, Human Resource Analysis, Marketing
    Analysis and Sales Channel Analysis.
    It also supports the Operational Reporting Strategies Development from
    which it is extracting the data through Flat Files, Oracle then Transforming, and
    Loading into Oracle target database. We first constructed the Data Marts
    according to the identified subject areas and then integrated them into Data
    Warehouse.
    Responsibilities:
    • Extraction, Transformation and Loading (ETL) of data by using Informatica Power

    Center.

    • Extracted source data from flat files, Oracle and loaded to an Oracle.

    • Developed mappings in Informatica Power Center Designer to load data from

    staging environment to warehouse.

    • Created mappings using the transformations such as the Source qualifier,

    Aggregator, Expression, Router, Filter, Sequence Generator, and Update Strategy.

    • Involved in Creating Sessions, Workflows Using Workflow Manager

    • Involved in testing the mappings (UNIT testing).

    • Involved in writing the queries for data validation

    • Environment: Informatica Power Center 8.6, Oracle9i, Flat Files,Unix.

    You might also like