We provide IT Staff Augmentation Services!

Informatica Analyst/lead Resume

Sunnyvale, CA

SUMMARY:

  • Over 13 Years of IT experience in Design, Development and Implementation of Data warehouses as an ETL Architect/ Lead/Developer.
  • Experience in designing and implementing ETL environments using ETL strategies as well as tools like Informatica Power Center 10.x/9.x/8.x/ 7.x/6.x and Power mart 5.x.
  • Experienced in the Analysis, Design, Development, Testing, and Implementation of business application systems for Pharma, Financial, Retail, Oil & Natural gas, Automobile, Telecom and Manufacturing Sectors.
  • Extensive experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files, Excel, XML, DB2 UDB, Oracle, SQL Server, Teradata and also from ERP like SAP R/3.
  • Experience in Application development and Data Analytics with specialization in Java and Big Data Technologies.
  • Strong hands on experience in designing optimized solutions using various Hadoop components like Map Reduce, Hive, Sqoop, Pig, HDFS, Flume, Oozie etc.
  • Strong Understanding of Cassandra and HBASE NoSQL Databases.
  • Strong hands on experience with HP - Vertica data base.
  • Extensively worked on Informatica power center tools - Designer, Workflow Manager, Workflow Monitor & Repository Manager.
  • Extensively worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
  • Extensive experience in error handling and problem fixing in Informatica.
  • Strong Experience on Workflow Manager Tools - Task Developer, Workle t & Workflow Designer.
  • Extensively worked in Design, Development, Testing and Production Environments.
  • Exposure in preparation of Technical Design document, Test cases, Unit testing, System testing, and Integration testing.
  • Hands on experience with Complex mappings from varied transformation logics like Connected and Unconnected Lookups,Router,Aggregator,Joiner,UpdateStrategy and Re-Usable transformations.
  • Experienced in Capturing Incremental data (CDC) from source systems.
  • Experience in loading the ERP Sources/Targets data like SAP R3 & BIW using Power Connect.
  • Involved in full life cycle development of Data Warehousing.
  • Exposure in Data Modeling using Star/Snowflake Schema Design, Data Marts, Relational and Dimensional Data Modeling, Fact and Dimensional tables, Physical and Logical data modeling using Erwin.
  • Worked Extensively with Slowly Changing Dimensions i.e. Type1 & Type2.
  • Experienced in Installation, Configuration of Informatica Power Center/Power Mart Client, Server.
  • Perform and participate in all aspects of the project lifecycle including, requirements definition, solution design, and development.
  • Strong experience in Oracle 11g/10g/9i/8.x, UDB DB2 7.x, SQL Server 2012/2008, Teradata V2, MS Access 2000 database programming using PL/SQL and standard built-in Oracle Packages.
  • Experience in working with ETL methodologies (Data Extraction, Transformation & Loading) to develop business intelligence for corporations using IBM Web sphere Data stage (Designer, Manager, Administrator, Director) and Quality stage 8.1.
  • Business Intelligence and reporting knowledge in Tableau, Business Objects & Cognos 8.1.
  • Experienced in using scheduling tools like UC4-Automic, Autosys &Tivoli.
  • Experienced in using SQL, PL/SQL, TSQL, Indexes, Functions, Procedures, Triggers and Cursors.
  • Experience in working with UNIX Shell scripts and Batch scripts and necessary Test Plans to ensure the successful execution of the data loading process.

TECHNICAL SKILLS:

Data Warehousing: Informatica Power Center 10.x/9.x/8.x/ 7.x/ 6.x, Power Mart 5.x, Hadoop, Hive, Sqoop, Data stage 8.1, Erwin 7.2, Hyperion, Cognos 8.x/ 7.x, Business Objects 6.x, Toad, SQL Developer, PL/SQL Developer.

Languages: Visual Basic 6.0, Batch Script, XML, PL/SQL.

Operating Systems: UNIX (AIX, UX), Windows 2003/NT/XP/98.

Databases: Oracle 10g/9i/8i, UDB DB2 7.x, Teradata V2R5, SQL Server 2008MS Access 2000.:

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale CA

Informatica Analyst/Lead

Responsibilities:

  • Involved in Business requirements, performed source system analysis, prepared source to target mapping documents.
  • Provide Design and development work for Spend Mart, PwC, ESIS & DPS Applications.
  • Involved in the ETL technical design discussions and prepared ETL high level technical design document.
  • Extracted data from excel files, high volume of data sets from data files, MS AX, Oracle, SQL Server, SalesForce.com(SFDC) using Informatica ETL mappings/SQL PLSQL scripts and loaded to Staging.
  • Created complex Informatica mappings using Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, Normalizer and Router transformations to extract, transform and loaded data mart area
  • Created re-usable transformations/mapplets and used across various mappings.
  • Wrote complex PLSQL scripts /functions/procedures/packages.
  • Developed Informatica workflows/worklets/sessions associated with the mappings using Workflow Manager.
  • Created Automic jobs to schedule Informatica Workflows.
  • Involved in performance tuning of Informatica code using standard informatica tuning steps.
  • Involved in the performance tuning of SQL/PLSQL scripts based on explain plan.
  • Involved in Master Data Management Solution Customer Party MDM Domain using MDM 9.6
  • Involved in implementing the jobs to load data into Landing, Staging tables and Base objects for the Customer Data Set into Informatica MDM from various source systems.
  • Data standardization and validations by using IDQ.
  • Supported during QA/UAT/PROD deployments and bug fixes.
  • Wrote UNIX shell scripts for file transfer/archiving/Email notifications.
  • Involved in code Reviews as per ETL/Informatica standards and best practices.
  • SKILLS REQUIRED: Informatica Power Center 10.1/9.5.1, Informatica Siperian 10.2/9.5,IDQ, SQL Server 2012, Erwin, Oracle11g, Toad, SQL, PL SQL, HP - UX, Automic and Tableau.

Confidential, Santa Clara CA

Sr Informatica Lead Developer

Responsibilities:

  • Involved in gathering Business Requirements.
  • Prepared low level Source to Target mapping documents.
  • Involved in the ETL Design and finding several mythologies to extract data from several sources.
  • Created and Imported/Exported various Sources, Targets, and Transformations using Informatica Power Center 9.1.
  • Design, develop, configure, program and implement software applications, packages and components customized to meet specific needs and requirements.
  • Worked with Sales Orders, Invoices, Finance & GL Ledger data from Oracle EBS and JD Edwards.
  • Integrating B2B Application, SFDC with JD Edwards System.
  • Worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer and Mapplet Designer.
  • Creating mappings for Dimensions and Fact Tables.
  • Created reusable transformations and mapplets by using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc.
  • Worked with Complex Xml source & target files for B2B Applications.
  • Involved in running Hadoop jobs for processing data coming from different sources.
  • Involved in development and design of a Hadoop cluster using Apache Hadoop for POC and sample data analysis.
  • Analyzed large data sets by running Hive queries and Shell scripts.

Environment: Informatica 9.1, Oracle EBS, JD Edwards, Oracle 11g, Sql Server, Cognos 10,Hadoop, Hive, Sqoop, Unix and Windows 7.0

Confidential, Palo Alto CA

Informatica Designer

Responsibilities:

  • Provide development work Pricing Analytics (PRAO) and Customer Analytics application.
  • Analyze complex user requirements, procedures, and problems to improve existing system design.
  • Design, develop, configure, program and implement software applications, packages and components customized to meet specific needs and requirements.
  • Creation and Imported/Exported various Sources, Targets, and Transformations using Informatica Power Center 9.0.
  • Creation of Informatica Mappings, Sessions and Workflows.
  • Created reusable transformations and mapplets by using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer, and Mapplet Designer, respectively.
  • Extract data from Oracle & Flat files and load into SQL Server
  • Work with the data conversions, standardizing, correcting, error tracking and enhancing the data.
  • Work with the generation of XML using Informatica and load into PRAO.
  • Creation of Database Tables and Indexes.
  • Writing of Shell Scripts to automate the process end to end using TIDAL Scheduler.
  • Develop end to end application components involving business layer, persistence layer, and database and web services layer.
  • Review and modify programs to ensure technical accuracy, security and reliability.
  • Develop and execute unit test cases.
  • Provide quality documentation, status updates.
  • Importing and exporting data into HDFS and Hive to help BI Team for Reporting.
  • Analyzed large data sets by running Hive queries and Shell scripts.
  • SKILLS REQUIRED: Informatica Power Center 8.6, SQL Server 2012, Oracle11g, HP - UX, Hadoop, Hive, Sqoop, Vertica, Linux &Tidal.

Confidential, Dallas TX

Informatica Lead

Responsibilities:

  • Involved in gathering Business Requirements.
  • Prepared low level Source to Target mapping documents.
  • Involved in the ETL Design and finding several mythologies to extract data from several sources.
  • Created and Imported/Exported various Sources, Targets, and Transformations using Informatica Power Center 9.0.
  • Migrating code from Informatica 8.6 to 9.0.
  • Worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer and Mapplet Designer.
  • Created reusable transformations and mapplets by using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer, and Mapplet Designer, respectively.
  • Extensively worked with the data conversions, standardizing, correcting, error tracking and enhancing the data.
  • Implemented the process for capturing incremental data from source systems and move the data warehouse area
  • Worked with XML Sources and XML Targets.
  • Worked with Shell scripts for handling of files to compress, archives and SFTP to end user.
  • Worked with Cron tab & Control-M Scheduling.
  • Involved in performance tuning with Informatica and database
  • Created updated and maintained ETL technical documentation.

Environment: Informatica Power Center 9.0, Oracle 10g, Unix, Connectivity Services & Windows XP.

Confidential, Moutain view, CA

Informatica Consultant

Responsibilities:

  • Involved in gathering Business Requirements.
  • Prepared low level Source to Target mapping documents.
  • Involved in the ETL Design and finding several mythologies to extract data from several sources.
  • Created and Imported/Exported various Sources, Targets, and Transformations using Informatica Power Center 8.6.
  • Extracting data from several source systems and loading data into EDW (Enterprise Dataware house).
  • Worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer and Mapplet Designer.
  • Created reusable transformations and mapplets by using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer, and Mapplet Designer, respectively.
  • Extensively worked with the data conversions, standardizing, correcting, error tracking and enhancing the data.
  • Implemented the process for capturing incremental data from source systems and move the data warehouse area
  • Loading data into several Dimensions and Facts.
  • Developing Mappings for Type 1& Type 2.
  • Involved in performance tuning with Informatica and database
  • Created updated and maintained ETL technical documentation.
  • Versioning for ETL Code & DB scripts are maintained in CVS & Clear Case.

Environment: Informatica Power Center 8.6, Oracle 10g, Clear Case, HP AIX & Windows XP.

Confidential, SFO CA

Informatica Lead

Responsibilities:

  • Involved in Design Part of the Project by Creating FSD & Business mapping documents.
  • Involved in gathering Business Requirements.
  • Prepared low level Source to Target mapping documents.
  • Created and Imported/Exported various Sources, Targets, and Transformations using Informatica Power Center 8.6.
  • Extracting data from several source systems and loading data into WRET data base and also feeding data into some external systems.
  • Worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer and Mapplet Designer.
  • Created reusable transformations and mapplets by using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer, and Mapplet Designer, respectively.
  • Extensively worked with the data conversions, standardizing, correcting, error tracking and enhancing the data.
  • Implemented the process for capturing incremental data from source systems and move the data warehouse area.
  • Involved in performance tuning with Informatica and database.
  • Involved in Migration of objects from Dev and Test server to Production servers.
  • Worked with DBA to create schema instances and tables in DEV, TEST & PROD.
  • Writing Stored Procedures and Functions for processing business logic in the database.
  • Worked on Erwin tool for forward engineering & reverse engineering.
  • Involved in Shell Scripting.
  • Created updated and maintained ETL technical documentation.
  • Versioning for ETL Code & DB scripts are maintained in CVS & Clear Case.
  • Workflows scheduled by using Autosys Scheduler Tool.
  • Involved in Design, Development &Testing Phases.

Environment: Informatica Power Center 8.6, Erwin 7.2, Oracle 10g, SQL Server 2008, Jira, HP AIX, Erwin, Autosys & Windows XP

Confidential, Energy, OK

Responsibilities:

  • Worked with the applications like Wells, Reservoir, Tax, General Ledger, Statement Processing, Volume quantities and Accounting balances data.
  • Worked with the Application Clients for Gathering Requirements.
  • Created and Imported/Exported various Sources, Targets, and Transformations using Informatica Power Center 8.1.
  • Developed various Mappings with the collection of all Sources, Targets, and Transformations.
  • Created Mapplets with the help of Mapplet Designer and used those Mapplets in the Mappings.
  • Created reusable transformations and mapplets using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer, and Mapplet Designer, respectively.
  • The tables had to be populated for use in daily load for the initial load ‘inserts’ and then updated using incremental loads and update strategy transformation.
  • Worked Extensively with Slowly Changing Dimensions i.e. Type1 & Type2.
  • Created Jobs & Job plans for the Workflows, SQL jobs & Unix scripts by using UC4 tool.
  • All the Job plans are scheduled through Cron jobs &UC4 Scheduler tool.
  • Tuned performance of Informatica sessions for large data files by implementing pipeline partitioning and increasing block size, data cache size, sequence buffer length and target based commit interval and resolved bottlenecks.
  • Extracting Incremental data (Change Data Capture) from Source Systems using Informatica Power Exchange.
  • Created and managed the global and local repositories and permissions using Repository Manager.
  • Optimized the mappings by changing the logic and reduced running time and encouraged the usage of reusable objects viz., mapplets.
  • Performed data cleansing activities like Data Enhancement, Parsing, Matching and Consolidation.
  • Exclusively used ETL to load data from flat files to Oracle Database.
  • Writing PL/SQL procedures & functions for processing business logic in the database.
  • Tuning of SQL queries for better performance.
  • Involved in Logical and Physical Database Design, identify the Entities, Attributes and apply referential integrity rules using ERWIN Tool.
  • Used NDM for transferring files from Mainframes system.
  • Worked on Erwin tool for forward engineering & reverse engineering.
  • Creating and Refreshing Materialized Views.
  • Involved in Development, Testing and Production support.

Environment: Informatica Power Center 8.1, SQL Server 2005, DB2, Mainframes, Oracle 10g, Toad, SQL Developer. PL/SQL Developer, Erwin 7.0, HPUX, Jira, UC4, Hyperion IR 9.3, Solaris and Windows XP.

Confidential -Mogul, MI

Responsibilities:

  • Worked on Customer Objects for cluster 1 along with manufacturing plants data like Glasgow.
  • Involved in Extraction, Transformation and Loading of data using Informatica.
  • Extracted data from SAP 4.6, DB2, Flat files and Loaded into SAP 5.0.
  • Extracted data into Oracle data base from SAP 4.6 using SAP R/3 Tables, BAPI and Function Modules.
  • Generated and Installed ABAP Program / SAP R/3 Code Using Informatica 8.1.
  • Created mappings Using Function Modules, BAPI, LSMW, IDOC’S.
  • Performed data cleansing activities like Data Enhancement, Parsing, Matching and Consolidation.
  • Loaded data into SAP 5.0 using IDOC’S, LSMW, BAPI and Function Modules.
  • Processing the IDOC’S manually in Sap 5.0.
  • Worked in Development, Testing, Pre-production and Production Servers.
  • Worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer and Mapplet Designer.
  • Created complex reusable transformations and mapplets using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer, and Mapplet Designer, respectively.
  • Created reusable Sessions and Commands in the Workflow Manager.
  • Created and implemented variables and parameters in the Mapping Designer.
  • Created reusable Worklets in Worklet Designer and set up Workflows in the Workflow Manager.
  • Extracting Incremental data (Change Data Capture) from Source Systems using Informatica Power Exchange.
  • Analyzed the session, event and error logs for troubleshooting mappings and sessions.
  • Debugged the mapping in the Mapping Designer using the Debugger.
  • Created updated and maintained ETL technical documentation.
  • Involvement in Shell scripting & Perl Scripting.
  • Used FTP to move data from one server to another server.
  • Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
  • Making Code Reviews.

Environment: Windows XP, Informatica (Power Center 8.1), Sap R/3, Unix, Oracle 9i, Toad.

Confidential, Atlanta, GA

Responsibilities:

  • Created and Imported/Exported various Sources, Targets, and Transformations using Informatica Power Center, Repository Manager and Designer.
  • Developed various Mappings with the collection of all Sources, Targets, and Transformations.
  • Created Mapplets with the help of Mapplet Designer and used those Mapplets in the Mappings.
  • Developed and scheduled various Pre and Post Sessions, Batches for all Mappings for data loading from Source TXT files, Tables to Target tables.
  • Tuned performance of Informatica sessions for large data files by implementing pipeline partitioning and increasing block size, data cache size, sequence buffer length and target based commit interval and resolved bottlenecks.
  • The tables had to be populated for use in daily load for the initial load ‘inserts’ and then updated using incremental aggregation and update strategy transformation.
  • Created and managed the global and local repositories and permissions using Repository Manager.
  • Created Mappings between Source and Target using Power Center Designer.
  • Used multiple Sources and Multiple targets.
  • Worked Extensively with Slowly Changing Dimensions i.e. Type1 & Type2.
  • Used Dimensional Modeling Techniques to create Dimensions, Cubes and Fact tables.
  • Imported an XML file to Designer, performed multiple operations, used in the Mappings and exported into an XML file.
  • Optimized the mappings by changing the logic and reduced running time and encouraged the usage of reusable objects viz., mapplets.
  • Involved in Logical and Physical Database Design, forward engineering & reverse engineering using Erwin tool.
  • Performed data cleansing activities like Data Enhancement, Parsing, Matching and Consolidation.
  • Analyzed and Created Facts and Dimension Tables.
  • Worked on Teradata BTEQ & T-SQL Tools for querying and retrieving data.
  • Worked with Mload, Fload & Fast export Scripts for Inserting and exporting data from Teradata database.
  • Involved in Development & Testing Phase.

Environment: Informatica Power Center 6.0, Erwin 4.0, XML, DB2, SQL Server 2000, Teradata, Oracle 8.x, AIX, HPUX, Solaris and Windows 2000.

Confidential

Responsibilities:

  • Involved in Extraction, Transformation and Loading of data using Informatica.
  • Created mappings to move from Various Systems (Flat files, Oracle database) to Transaction History database (Reporting Database).
  • Created complex Informatica mappings to load the data mart and monitored them.
  • The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner and Sequence generator.
  • Created, updated and maintained ETL technical documentation.
  • Was part of scripting team for shell script to automate and migrate data from ODS to Data warehouse.
  • Loading data into Dimension tables and Fact tables.
  • Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
  • Created various reports using Business Objects.
  • Involved in Development phase and Production support.

Environment: Windows 2000, Oracle 9i, Informatica 7.1, Business objects 5.0, HP-UX 11i V2, ER Win 4.5, MS-Excel.

Confidential

Responsibilities:

  • I worked for the Hong Kong market for the object development.
  • Creating the Technical design specifications based on client functional specs.
  • Developed the mappings and Sessions.
  • Worked with Transformations like Source qualifier, Expression, joiner, Normalizer, Filter, Router, Aggregator.
  • Involved in Creating Test plans and test cases.
  • Involved in Testing especially in Unit test & prepare the Unit test logs.
  • Responsible for Change Requests, Technical Problem Reviews.
  • Responsible for the Logging Issues and onsite/offshore Coordination.
  • Involved in Development phase.

Environment: Windows 2003, Oracle 8i, Informatica 7.1, MS-Excel.

Confidential, Glendale, CA

Responsibilities:

  • Involved in Extraction, Transformation and Loading of data using Informatica.
  • Extensively used Informatica to load source data from fixed width Flat files, Oracle, SAP to DB2, and SAP.
  • Experience with the data conversions, standardizing, correcting and validating and enhancing the data.
  • Worked on Informatica - Designer, Workflow Manager & Monitor.
  • Requirement Study and understanding business logic.
  • Developed Informatica Objects for the countries US and UK.
  • Preparation of Technical Design document, UTC, UTP, Test Data, Actual Results of different interfaces.
  • Preparation of various Technical Design document & Support spreadsheets.
  • Enhancing the interfaces using Informatica Mappings, Sessions & Workflows.
  • Migrating ETL objects from Development Server to Test Server and from Test server to Production server.
  • Transformations like Source Qualifier, Aggregator, Expression, Update strategy, Lookup, Filters, Stored procedure, Router are mostly used in part of coding.
  • Maintaining the Software development management system (SDMS) for creating program profiles, SCR logs, TPR logs, Issue logs, Work item review reports, and time estimation.
  • Monitoring and fixing the production Sessions and Work Flow failures.
  • Involved in Development phase and Production support.

Environment: Windows 2000, DB2, Informatica (Power center), UNIX, Sap, MS-Excel, ER Win 4.5, MS-Excel, Perl.

Hire Now