We provide IT Staff Augmentation Services!

Informatica Developer Resume

FL

SUMMARY

  • IT professional with over 8 years of experience in the Development and Implementation of Data warehousing with Informatica Power Center, OLTP and OLAP using Data Extraction, Data Transformation, Data Loading and Data Analysis.
  • Exposure with Installation and Configuration of Informatica tools.
  • Experience in all phases of the Data warehouse life cycle involving Analysis, Design, Development and Testing of Data warehouses using ETL.
  • Strong Data warehousing experience using Informatica Power Center 9X/8x/7x.
  • Extensively used Informatica tools such as Informatica Server and Client tools like Designer, Workflow manager, Workflow Monitor, Repository Manager.
  • Experience in implementing the complex business rules by creating transformations, re - usable transformations (Expression, Aggregator, Filter, Connected and Unconnected Lookup, Router, Rank, Joiner, Update Strategy), and developing complex Mapplets and Mappings, and SQL Stored Procedure, and Triggers.
  • Extensive knowledge in architecture design of Extract, Transform, Load environment using Informatica Power Center.
  • Developed Slowly Changing Dimension Mappings of type I, II and type III (version, flag and time stamp).
  • Used Incremental Aggregation to update the values in Summary tables.
  • Developed mapping using Parameters and Variables. Extensively used parameter file to pass mapping and session variables.
  • Experience in Performance Tuning of sources, targets, mappings, transformations and sessions, by implementing various techniques like partitioning techniques and pushdown optimization, and also identifying performance bottlenecks.
  • Extensive experience in implementing CDC using Informatica Power Exchange 8.x/7.x.
  • Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.
  • Experience in using the Informatica command line utilities like pmcmd to control workflows in non-windows environments.
  • Well Experienced in doing Error Handling and Troubleshooting using various log files.
  • Experience using Repository Manager to create Repository, User groups, Users and managed users by setting up their privileges and profiles.
  • Worked on B2B tool for extracting data from any file, document, or message regardless of format, complexity, or size transforming it into a usable form.
  • Having command on troubleshooting with the help of error logs generated by Informatica server.
  • Extracted data from various sources like Oracle, Flat file, SQL SERVER, XML files, loaded into Oracle database.
  • Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
  • Experience with UNIX shell scripting for File validation and SQL programming.
  • Practical understanding of Star and Snowflake Schema Methodology using Data Modeling tool Erwin 4.0/4.2.
  • Hands on experience in writing, testing and implementing Triggers, Stored, Procedures, Functions, Packages at database level and form level using SQL.
  • Highly adaptive to a team environment and proven ability to work in a fast paced teaming environment with excellent communication skills.
  • Excellent problem solving, interpersonal and communication skills with experience working in fast paced, challenging and dynamic environment. Highly motivated with passion for learning.

TECHNICAL SKILLS

Operating Systems: Windows 2000/XP, UNIX.

ETL Tools: Informatica Power Center V9X/V8x/V7x, Informatica power Exchange V8x, Informatica Power Connect, B2B.

Data Modeling Tool: Erwin 4.0/4.2

Databases: Oracle 8i/9i/10g/11g, SQL, SQL Server 2000/2005/2008 , Teradata, DB2

Languages: C, C++, SQL, Html

BI Tools: Crystal reports, Business objects XI 3.1

Database utilities: Toad, SQL Loader, PL SQL developer, Oracle SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, FL

Informatica Developer

Responsibilities:

  • Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
  • Developed FRD (Functional requirement Document) and data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis.
  • Worked on dimensional modeling to design and develop STAR schemas by identifying the facts and dimensions. Designed logical models as per business requirements using Erwin.
  • Worked with Power Center Designer tools in developing mappings and Mapplets to extract and load the data from flat files, XML files and Oracle (source) and loaded into Oracle (target).
  • Prepared software requirement specifications through interaction with business analysts and designed Star schema, logical and physical database designs.
  • Created reusable Mapplets transformations to load data from operational data source to Data Warehouse and involved in Capacity Planning and Storage of data.
  • Created different transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator for loading the data into targets.
  • Developed complex mappings such as Slowly Changing Dimensions Type 2, Type 3, Type 1 - Time Stamping in the Mapping Designer.
  • Used Informatica Workflow Manager to create Workflows, database connections, sessions, and batches to run the mappings.
  • Monitored the workflow performance and the status with Workflow Monitor.
  • Developed various command tasks to automate the Pre session jobs. Did performance tuning to improve the load. Wrote complex SQL Queries involving multiple tables with joins.
  • Involved in writing of Triggers, Functions, and Packages.
  • Converted SQL/Procedures and SQL Loader scripts to Informatica mappings.
  • Used the Target Load Ordering with Stored Procedures to update database.
  • Used Variables and Parameters in the mappings to pass the values between sessions.
  • Worked with Informatica Debugger to debug the mappings in Designer.
  • Scheduled Informatica jobs using Informatica Scheduler.
  • Determined various bottle necks and successfully eliminated them to great extent.
  • Designed and developed B2B transformations for EDI and other formats using Informatica B2B Data Transformer.
  • Employed B2B tool to extract data from any from complex files, documents (e.g. XML based formats, MS Office files, PDF’s) using B2B transformation and transformed it into a usable form.
  • Performed Unit Testing and Involved in tuning the Session and Workflows for better Performance.
  • Implemented Optimization/performance tuning techniques to identify bottlenecks- Query tuning (Explain Plan, SQL Trace), table partitioning, memory tuning and cache management.
  • Debugged and sorted out the errors and problems encountered in the production environment.
  • Generated Adhoc reports using Business objects.
  • Developed Desktop Intelligence and Web Intelligence reports Using Business objects.
  • Created graphical representation of reports such as Bar charts, Pie charts as per requirements.
  • Created & tested reports using Business Objects functionality like Queries, Sections, Break points, variables, Formulae etc.
  • Documented the entire process. The documents included the mapping document, unit testing document and system testing document among others.

Environment: Informatica 9.5.1/ 9.1, Oracle 11g/10g, MS SQL Server 2012, flat files, Windows XP, Business objects xi, Power Exchange 8.6.1, B2B tool, UNIX.

Confidential, NJ

ETL Developer

Responsibilities:

  • Worked with business analysts for requirement gathering, business analysis, and testing and project- coordination.
  • Responsible for development, support and maintenance of the ETL (Extract, Transform and Load) processes using Informatica Power Center.
  • Developed an ETL Informatica mapping in order to load data into staging area. Extracted from flat files and databases and loaded into Oracle 10g target database.
  • Designed Mapping document, which is a guideline to ETL Coding.
  • Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Look Up, Router, Filter, Update Strategy, Joiner, Sequence Generators and Stored Procedure
  • Worked with various Informatica Power Center tools - Source Analyzer, Target designer, Mapping Designer & Mapplet, Transformations.
  • Used Slowly Changing Dimension Mappings of type II and I.
  • Created reusable transformations and Mapplets and used them in complex mappings.
  • Wrote Stored Programs (Procedures & Functions) to do Data Transformations and integrated them with Informatica programs and the existing application.
  • Used Workflow Manager for Creating, Validating, Testing and Running the sequential and concurrent Batches and Sessions, scheduled them to run at a specified time.
  • Used mapping Parameters and Variables.
  • Worked on Parameterize of all variables, connections at all levels in Window NT.
  • Created Sessions, Worklets and Workflows for carrying out test loads.
  • Analyzed Session log files to resolve errors in mapping and managed session configuration.
  • Created, configured, scheduled and monitored the sessions and workflows on the basis of run on demand, run on time using Informatica Power Center Workflow Manager.
  • Involved in migrating the ETL application from development environment to testing environment.
  • Extensively usedSQLandPL/SQLto write Stored Procedures, Functions, Packages and Triggers.
  • Used PLSQL developer, TOAD to run SQL queries and validate the data.
  • Worked on Teradata SQL Assistant to analyze the existing data and implemented new business rules to handle various source data anomalies.
  • Extensively used Teradata utilities like Fast load, Multiload to load data into target database.
  • Documented and presented the production/support documents for the components developed, when handing-over the application to the production support team.
  • Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage and ODS.
  • Developed advanced reports using Report Studio - Using Tabular Objects, Sub reports, Cascading/customizing prompts and cross tabs, list, charts, Drill- through reports.
  • Customized data by adding Calculations, Summaries and Functions.
  • Experienced in writing complex reporting using sql performance tuning and providing operational support for OLTP and OLAP applications.

Environment: Informatica Power Center 9.1, Teradata V2R6, Oracle11g/10g, SQL Server 2008, TOAD, Business Objects XI, Linux, Windows XP.

Confidential, CLEVELAND, OH

Informatica Developer

Responsibilities:

  • Involved in the Design, Analysis and Development of data warehouse using Informatica Power Center tools. The project involved in creating data warehouse/data mart which is further used for reporting purpose.
  • Coordinated with Business system analyst (BSA) to understand and gather the requirements. Documented user requirements, translated requirements into system solutions and developed implementation plan and schedule.
  • Analyzed Mapping, Session, Source, Target and System Bottlenecks to improve and tuned Performance of various ETL jobs.
  • Designed and developed complexInformaticamappings including Type-II slowly changing dimensions.
  • Worked extensively on different types of transformations like Source Qualifier, Aggregator, Joiner, Lookup, and Sequence Generator, Stored Procedure, Expression, Normalizer, Filter and Rank transformations.
  • Categorized different alerts and exception types to be built from User’s Data Validation list and built mappings to generate exceptions and alerts accordingly.
  • Coordinated with OBIEE Team regarding the reporting data for Answers and BI Publisher reports and also for the Dashboard Designs.
  • Created UNIX scripts for file transfers, to remove unwanted characters from source files, and update the time dimension table that was maintained for reporting purposes.
  • Involved in maintaining the data model, creating the tables and granting the privileges for read and write operations
  • Widely used Shared folders, project folders (Non-Shared folders) and short cuts to maintain integrity between Development, Test, Data validation and Performance.
  • Frequently used import and export utility to migrate session from developer’s folder to subject folder.
  • Extensively used parameter file to pass Mapping and Session Variables.
  • Involved in many technical decisions and prepared technical design document along with vision diagrams for ETL.
  • Worked as an individual to develop most of the process as well as worked in a team with other team members.
  • Performed Unit Testing for all developed ETL mappings.

Environment: Informatica Power Center 8.6, SQL*Plus, Toad 8.0, Toad, Oracle 9i, OBIEE 10.1.x, UNIX Shell scripting, PL/SQL, CA-7 Scheduling.

Confidential, FL

Informatica ETL Developer

Responsibilities:

  • Analyzed the business requirements and framed the Business Logic for the ETL Process.
  • Extensively used ETL to Load Data from fixed width as well as Delimited Flat files.
  • Worked extensively on different types of transformations like Normalizer, Expression, Union, Filter, Aggregator, Update Strategy, Lookup, Stored Procedure, Sequence Generator and Joiner.
  • Designed and Developed complex mappings, Reusable Transformations for ETL using Informatica Power Center.
  • Loaded the data from .CSV file to Oracle and Teradata.
  • Designed Mappings between sources to operational staging targets, using Star Schema, Implemented logic for Slowly Changing Dimensions.
  • Developed and tested all the Informatica mappings involving complex Router, lookups and update strategies.
  • Extensively wrote user SQL coding for overriding for generated SQL query in Informatica
  • Created workflows and worklets for Designed Mappings.
  • Implemented variables and parameters in the mappings.
  • Scheduled the loads at required frequency by Setting up batches and sessions using Power center workflow manager, PMCMD and also using scheduling tools.
  • Generated completion messages and status reports using workflow manager.
  • Worked with Workflow Manager to import/export metadata, jobs, and routines from repository, and also created data elements
  • Worked on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.
  • Extensively worked in Performance Tuning of programs, ETL procedures and processes. Also used debugger to Troubleshoot Logical Errors.
  • Wrote ETL specifications and unit test plans for the mappings.

Environment: Informatica Power Center 8.1, Oracle 9i,Teradata, SQL, PL/SQL, MS SQL Server 2005, TOAD, Erwin 4.1, UNIX Shell Script, Windows 2003

Confidential, IL

Informatica ETL Developer

Responsibilities:

  • Involved in the team during the entire ETL process and development of data marts using Informatica Power Center.
  • Developed Transformation logic and created various Complex Mappings and Mapplets using the designer.
  • Created set of Reusable Transformations and Mapplets.
  • Implemented Type III Slowly Changing Dimensions.
  • Debugged a valid mapping to gain Troubleshooting information about Data and Error Conditions.
  • Employed Informatica Power Center Workflow Manager for session management, database connection management and scheduling of jobs to be run in the batch process.
  • Worked with Variables and Parameters in the mappings to pass the values between sessions.
  • Worked on Partitioning of the Sessions and Performance Tuning of Informatica.
  • Created Multiple Sessions and executed workflows using Workflow designer and viewed the results using workflow monitor.
  • Involved in Unit Testing for the validity of the data from different data sources
  • Fine tuned transformation and mappings for better performance.
  • Worked with PMCMD command line program to talk with the Informatica server.

Environment: Informatica Power Center 7.9.3, Windows 2000, Oracle 8i, SQL Server 2005/2000,Flat files and Toad, Cognos 7.0

Hire Now