ETL Informatica Resume

					     Informatica Resume


            Having 3 years of experience of Development in Data warehousing using
             Informatica Power Center 8X.
            Extensive experience in designing and Development.
            Good knowledge in SQL & PL/SQL programming
            Strong knowledge in BusinessIntelligence, Data warehousing, Dimensional modeling,
             Star Schema, Snowflake Schema and OLAP concepts.
            Good exposure to Oracle8i/9i/10g databases.
            Excellent communication and inter-personal skills.


            Working as Associate in Accenture from July 2008 to till date.
            Worked as Software Engineer for HCL From Apr 2007 to June 2008.


            Having Good experience using Informatica power center 8.1.
            Good understanding of ETL and Reporting process.
            Experience in Banking and Retail industry Business process.
            Experience of project life cycle Design, development, test, release.
            Good experience with SQL query optimization & tuning techniques.
            Exceptional user facing skills and client relationship skills, ability to perform
             independently as well as in team player, ability to meet tight deadlines and
             work under pressure.
            Good understanding of CMM processes and ISO standards.


         Master of Computer Application from ST John’s Institute of Science and Technology.


    ETL Tools              Informatica (Power center 7,8).
    RDBMS                  Oracle 8i/9i and MS-Access 2000,Sybase
    Languages              SQL,PL/SQL,Shell Scripting
    Operating Systems      WindowsNT/95/98/2000/XP, UNIX

Project: 1
Bank of Austria Enterprise DW.                                              Aug2009 – Till date

           Bank Austria, the largest bank in Austria, has successfully executed several challenging
   mergers over the last two decades. Bank Austria called on Accenture to help the newly formed
   entity become a high-performance business by realizing synergies and achieving high-
   performance results from the merger.


               Involved in developing mapping to populate data from various systems like flat files
                and oracle to the single data warehouse.
               Involved in fact constellation using confirmed dimension.
               Involved in parameter files generation for all the staging mappings.
               Extensively worked with SQL, Lookup, Expression and Normalizer transformation.
               Involved in Unit test case preparation.
               Done Unit Testing.

Informatica8.1, Flat files, Oracle 9i/10g,Banking Finance.

Project: 2

Sales Data mart                                                               Jul 2008 to Jul 2009

            The information technology (IT) company of this retailing group in Spain provides IT
solutions and computer services for large companies, as well as government agencies. Since its
founding, this IT company has evolved from being a distributor, reseller and manufacturer of
computers to also being a provider of software, consulting and systems integration solutions.
Originally developed to provide point-of-sale (POS) support to the retail chain and the retailer’s
POS devices, the solution was enhanced over the years and made available to other retail
companies in Spain and Latin America.


              Involved in requirement gathering for Sales Data mart.
              Created High-level design documents, low level documents and designed the ETL
               processes using Visio tool to load data from Flat files, XML files and Oracle into the
               target Oracle 10g database.
              Prepare Central repository of exposure data to monitor risk associated with invested
               amount for each Businesses.
              Increase productivity for reporting from facts.
              Created Reusable Transformations, mapplets using Designer Tool of Informatica.
              Involved in Unit test case preparation.
              Done Unit Testing for the developed mappings.

Informatica 8.1, Oracle, Flat files, XML files, UNIX, Retail.

   Project: 3
   Broker rewards                                                          Apr 2007–Jun 2008
   Wells forgo, USA
                Wells forgo is a big banking organization in the USA, The company offers various
   loans services. This data warehouse is structured to give rankings for the brokers, And to know
   the each product’s market. Broker rewards warehouse helps the officials in developing better
   Organization intelligence.

   Roles: ETL Developer


          Involved in creation of Detailed ETL Mapping design document for development.
          Involved in creating and Maintaining Informatica technical specifications for application
          Involved in the tuning the mappings to achieve performance.
          Developed mappings using Informatica Power Center Designer to load data from various
           source systems to target database.
          Extensively used ETL to load data from Oracle and Flat files to Data Warehouse
          Extensively involved in the slowly changing dimension mappings.
         Involved in identifying business requirements and deliver the solutions.
          Used various transformations like Source qualifier, Aggregators, lookups, Filters,
           Sequence Generators, Routers, Update Strategy, Expression, Sorter etc.
          Prepared the Unit Test Cases and executed them.

Informatica 8.1, Oracle 10g, VSS, Banking

Shared By:
Description: Informatica ETL Resume