We provide IT Staff Augmentation Services!

Informatica Developer Resume

Torrance, CaliforniA

PROFESSIONAL SUMMARY:

  • Over 7 years of experience as Informatica developer with 2.5 years of onsite experience.
  • Seven years of experience in Data Warehousing & RDBMS with in - depth knowledge on operational and reporting environments in all phases including design, development and implementation of enterprise data warehouse and business application systems.
  • Seven years’ hands-on experience with ETL using Informatica Power Center including installation and configuration in Client/Server environment
  • Good work experience in designing Data Warehousing applications, implementations and enhancements of the business applications using Informatica Power Center 9.6.1/9.5.1/9.1/8.6.1/8.1.
  • Worked on various projects involving Data warehousing, Migration projects using Informatica Power Center 9.6.1/9.5.1/9.1/8.6.1/8.1 (Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer & Transformation Developer)
  • Extensively worked on creating Mappings, Transformations, Sessions and Workflows to extract data from various sources and loading into targets.
  • Experienced in performance tuning of mappings, sessions and workflows including partitioning, pushdown optimization and DB tuning using optimization techniques.
  • Involved in full Life Cycle Development of building a Data Warehouse / Data Mart and generating OLAP reports using SSRS/ OBIEE/ Hyperion.
  • Experienced in Extraction / Transformation / Loading of various Data sources ranging from Flat files, RDBMS Databases and Legacy systems.
  • Well versed with Dimensional modeling, Star & Snow Flake Schema, Fact & Dimensions Tables, Normalization, Business Process Analysis, Physical & Logical Data Modeling.
  • Worked on various Databases like Oracle Versions 10g/9i/8i, Teradata, SQL server, DB2 on various operating systems like UNIX and Windows XP/NT.
  • An excellent team player with an ability to perform individually, good interpersonal relations, strong communicational skills, hardworking and high level of motivation. A quick learner with an aptitude for taking responsibilities.
  • Extensively used ETL methodology for supporting Data Extraction, Transformation and Loading processing, in a corporate-wide-ETL Solution using Informatica.
  • Extensively worked on Informatica Designer Components Source Analyzer, Warehouse Designer, Mapping Designer, Transformation Developer, mapplet designer, worklet designer and workflow Manager.
  • Used various transformations like Source qualifier, Aggregators, lookups, Filters, Sequence generators, Routers, Update Strategy, Stored Procedure, Normalizer, Rank, Transaction control, Expression, Sorter, Joiner, Java transformation, XML transformation, SQL transformation etc.
  • Experience in Performance Tuning the mappings.
  • Experience in Performance Tuning and Debugging of existing ETL processes.
  • Creating Deployment groups to migrate code from Environment to other Environment
  • Experience in developing Test Plans, Test Strategies and Test Cases for Data Warehousing projects ensuring the data meets the business requirements.
  • Involved in knowledge sharing and knowledge transfer to the new members of the project & Preparation of knowledge transfer documents.
  • Experience in writing UNIX shell scripts
  • Function as the Onsite coordinator, working with Business/Analysts/DBAs & Offshore team.
  • Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines

TECHNICAL SKILLS:

ETL Tool: Informatica PowerCenter 9.6/9.5/9.1/8.6/8.1

OLAP tool: SSRS, OBIEE, Hyperion

RDBMS: Oracle Versions 11g/10g/9i, SQL, Teradata, PL/SQL, Netezza, Stored Procedures, Functions, Triggers, View, Materialized view, DB2, VSAM

Tools: SQL*Plus, SQL*Loader, TOAD, SQL Developer, SQL Server Management Studio

Languages: Unix Shell script, SQL, PL/SQL, C, C++

Operating Systems: UNIX, Windows XP/NT,IBM AIX

Internet/Web: JavaScript, HTML, XML

Other Tools: Autosys, SNOW, MS Office

PROFESSIONAL EXPERIENCE:

Confidential, Torrance, California

Informatica developer

Environment: Informatica PowerCenter 9.5.1, Aginity 4.2 (Netezza), UNIX, VSAM, Mainframe, OBIEE

Responsibilities:

  • Gathered and analyzed the new data dictionary obtained from upstream.
  • Had requirement gathering sessions with all data mart owners, and prepared business requirement document.
  • Prepared the design document based on the business requirements.
  • Involved in extraction, transformation and loading of the Lease and Retail data into target Database Tables using ETL Informatica tool.
  • Involved in creating logical and physical data models based on business requirements
  • Designed and Developed Workflow/Session execution logic, Involved in writing Shell scripts to be called as pre-session or post session scripts.
  • Designed and maintained various complex mappings using Transformations to implement logic in Informatica
  • Did enhanced performance by using partitioning, SQL tuning and various performance tuning techniques on mappings and sessions level.
  • Used Power Exchange to read mainframe VSAM and Sequential files.
  • Worked closely with DBA in creating the Tables, indexes, materialized views and hints.
  • Extensively used Netezza to test, debug SQL, PL/SQL Scripts, Stored Procedures.
  • Involved in testing at various levels, unit, performance and Integration and based on the business logic, validation rules as given in the Mapping document, prepared Unit, Module test case document
  • Coordination with offshore team.
  • Used shortcuts to reuse objects without creating multiple objects in the repository.
  • Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, and assignment of the workflow.
  • Used mapping parameters and variables to support load control table for validation.
  • Used load control table to keep track of the batch run statistics.
  • Carried out the unit testing and defect fixings

Confidential, Torrance, California

Informatica developer

Environment: Informatica PowerCenter 9.5.1, Power Exchange for Mainframe, SSRS, Oracle 11g, SQL Server Management Studio, UNIX, Toad, Unix Shell scripts, VSAM, Mainframe.

Responsibilities:

  • Involved in Migration project to convert mainframe based systems to CHP product called ALFA which includes converting the VSAM database to Oracle database and convert all the mainframe based reporting to BI reporting using SSRS.
  • Interacted with users and created maintenance documents, translated functional requirements to technical specifications.
  • Did extraction, transformation and loading of the data from various sources into target Database Tables using ETL Informatica tool.
  • Involved in creating logical and physical data models based on business requirements
  • Designed and Developed Workflow/Session execution logic, Involved in writing Shell scripts to be called as pre-session or post session scripts.
  • Participated in building reports using SSRS and developed various reports, dashboards and charts including Line, Column, Area, and Pie Charts for analysis.
  • Designed and maintained various complex mappings using Transformations to implement logic in Informatica
  • Did enhanced performance by using partitioning, SQL tuning and various performance tuning techniques on mappings and sessions level.
  • Used Power Exchange to read mainframe VSAM and Sequential files.
  • Worked closely with DBA in creating the Tables, indexes, materialized views and hints.
  • Extensively used TOAD to test, debug SQL and PL/SQL Scripts, Packages, Procedures and Functions.
  • Involved in testing at various levels, unit, performance and Integration and based on the business logic, validation rules as given in the Mapping document, prepared Unit, Module test case document
  • Preparation of detail design.
  • Coordination with offshore team.
  • Used shortcuts to reuse objects without creating multiple objects in the repository.
  • Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, and assignment of the workflow.
  • Used mapping parameters and variables to support load control table for validation.
  • Used load control table to keep track of the batch run statistics.
  • Carried out the unit testing and defect fixings

Confidential

Informatica developer

Environment: Informatica 9.1, OBIEE, Oracle 10g, UNIX, Toad, Autosys, TIBCO.

Responsibilities:

  • Design walkthrough meetings with business users and BI architect.
  • Design Reviews.
  • End to end ETL framework design and implementation.
  • Creating mappings, sessions, workflows, worklets and mapplets. Scheduled and monitored loading processes using Informatica Workflow Manager.
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
  • Use of parameterising technique in Informatica to create dynamic directories and work-items every time workflow runs
  • Managing defects and resolving environmental issues.
  • Developed mapping parameters and variables to support SQL override.
  • Created reusable mapplets to use them in different mappings.
  • Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, Assignment, Timer and scheduling of the workflow.
  • Used Debugger to test the mappings and fixed the bugs.
  • Involved in Performance tuning at source, target, mappings, sessions, and system levels.
  • Worked with Autosys team to schedule the ETL jobs.
  • Participated in Unit testing, System testing and user acceptance testing.

Confidential

Informatica developer

Environment: Informatica 9.1, Teradata client 13.0, Oracle 10g, UNIX, OBIEE 10.1.3.4.1

Responsibilities:

  • Design walkthrough sessions with business users and BI architect.
  • Preparation of detail design with offshore team.
  • Design Extract Transform Load (ETL) jobs.
  • Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
  • Used transformations such as the Source Qualifier, Expression, Aggregator, Normalizer, Router, Joiner, Connected & unconnected lookups, Filter, Sequence Generator, Sorter, and Update Strategy.
  • Performance tuning of Informatica workflows using Push Down Optimization (PDO)
  • Resolving technical and design issues and performing independent unit testing, System Testing and support for production run.
  • Develop Complex ETL mappings for generating flat files, which would be sent to External agencies over FTP.

Confidential

Informatica developer

Environment: Informatica 8.6/9.1, DataStage 8.1, Teradata client 13.0, OBIEE 10.1.3.4.1 , UC4, Remedy

Responsibilities:

  • Understanding Technical\Functional\Domain of the project content.
  • Developed Data Mapping documents and Technical document specifications as per the BRD.
  • Preparing migration strategy plan after analyzing the currenst datastage jobs
  • Designed and Created complex Informatica mappings with shared objects/reusable transformations using mapping/mapplet Parameters/Variables.
  • Performance tuning of Informatica workflows using Push Down Optimization (PDO)
  • Used Type 2 SCD mappings to update slowly Changing Dimension Tables.
  • Used incremental load techniques using mapping variable.
  • Involved in unit and system testing.
  • Preparation of Knowledge Transfer (KT) documents to share the knowledge to the Production support team.

Confidential

Informatica developer

Environment: Informatica 8.6 Sagent 6.5/6.4, Oracle 10g, UNIX

Responsibilities:

  • Analysing Sagent plans, and preparing migration strategy document
  • Deliver technical Designs and Unit Test plans.
  • End to end ETL Framework design and implementation
  • Sourced large volumes of data from multiple data sources (Relational and Flat File) such as Relational Table, and Flat File into staging area using Informatica PowerCenter.
  • Designed the ETL processes using Informatica tool to load data from Oracle and Flat file into the target Oracle 9i database.
  • Implemented Extract, Transformation, and Loading (ETL) functionality for Data mart using Informatica Power canter.
  • Used Informatica Workflow Manager & Monitor to Create, Monitor Process.
  • Tested mappings to assure that data was loaded as per ETL Specification
  • Used incremental load techniques using mapping variable.
  • Involved in unit and system testing.
  • Preparation of Knowledge Transfer (KT) documents to share the knowledge to the Production support team.

Confidential

Informatica developer

Environment: Informatica 8.1, C++, SQL, PL - SQL, Java, JSP, Unix

Responsibilities:

  • Undergone extensive s in Software Development Life cycle, Object Oriented Analysis and Design, Software Testing as well as tools like Java, JSP, Informatica and PL SQL.
  • Involved in Technical Design & Documentation of the project using the learned skill and techniques.
  • Responsible for coding in Informatica and unit testing.
  • Prepared flow diagram for of the Application.
  • Coordinated with all the other members of the team to complete the tasks on time.
  • Learning various leadership skills.

Hire Now