We provide IT Staff Augmentation Services!

Informatica Developer Resume

Springfield, MA

SUMMARY

  • Five Plus years of experience in Information Technology with a strong background in Informatica Power Center, SQL Scripts and Data Warehousing.
  • Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tools Informatica Power Center 8.6./9.1/9.5
  • Extensive Experience in Informatica PowerCenter with strong business understanding and knowledge of ETL of data from heterogeneous source systems such as Oracle, Teradata, SQL Server, Flat files, CSV files, XML files Into Data warehouse and Analytical Data Model.
  • Extensive work in ETL process consisting of data transformation, data sourcing, mapping conversion and loading.
  • Strong in Data warehousing concepts, Dimensional, Star Schema and Snowflakes Schema methodologies.
  • Extensively used Flat Files to load data from source systems to targets using Direct and Indirect methods.
  • Proficient in understanding business processes / requirements and translating them into Technical requirements.
  • Extensively worked on Informatica Tools - Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
  • Designed complex mappings using Source Qualifier, Filter, Expression, Aggregator, Router, Update Strategy, Union, Unconnected and Connected Lookups, Joiner, Sorter and XML Transformations.
  • Experience in integration of various data sources like Oracle, Teradata, SQL Server, Flat Files and DB2 into the data warehouse.
  • Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers for Loading target Tables.
  • Excellent expertise with different types of data load strategies and scenarios like Historical dimensions, Surrogate keys and Summary facts etc.
  • Troubleshooting and problem solving applications with Informatica Debugger and performing code migration from Dev to Test.
  • Have performed various testing activities like Unit testing, Integration-system Testing and User Acceptance Testing (UAT) and ensured that the code is ideal.
  • Experience in Shell Scripting on UNIX & Linux platform.
  • Well-developed interpersonal and communication skills.
  • Highly self-motivated and able to set effective priorities to achieve immediate & long-term goals and meet project & operational deadlines.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5/9.1/ 8.6

Methodologies: Star Schema, Snow Flake Schema, FACT and Dimension Tables.

RDBMS: Oracle 11g/10g/9i, Teradata 14.0, SQL Server 2008/2005, MS Access.

Operating System: Windows 7, Windows Vista/XP/2000, UNIX/Linux.

Development tools: Toad for Oracle, Teradata SQL Assistance, SQL Developer.

Programming/Languages: SQL, PL/SQL, UNIX shell scripting, C, C++, Java.

PROFESSIONAL EXPERIENCE

Confidential, Springfield, MA

Informatica Developer

Responsibilities:

  • Involving in creating Technical Specification Document (TSD) for the project by conducting meeting with the users to meet their business requirements.
  • Attending the meetings with business integrators to discuss in-depth analysis of design level issues.
  • Responsible for developing ETL processes/programs with Informatica Power Center to extract data from the client's operational databases and Flat Files, Transform and filter the data, and Load it into Target database and Flat Files.
  • Developing ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality
  • Using Informatica Power Center Work Flow manager to create sessions with the task developer and workflows with workflow manager to run the logic embedded in the mappings.
  • Creating mappings with Informatica PowerCenter 9.1 using Transformations (Expression Transformation, Router Transformation, and Stored Procedure Transformation etc.) and Look ups.
  • Analyzing session log files in session failures to resolve errors in mapping or session configuration.
  • Involving in Production Support in resolving issues and bugs.
  • Coordinating tasks and issues with Team Lead and Project Manager on daily basis.
  • Responsible for coordinating the work and also transfer knowledge to the offshore crew.
  • Trouble shooting and problem solving applications with Informatica Debugger. Used debugger to test the data flow and fix the mappings. Used session log files to identify the errors by analyzing the log files if the session failed and resolved the errors.
  • Performing Unit testing and Data validation testing using Validation scripts for source and target table.
  • Implemented documentation standards and practices to make mappings easier to maintain.

Environment: Informatica Power Center 9.1, Oracle 11g,SQL Server, MS Access, TOAD, SQL Developer, Relational Tables, Flat Files, Unix Script and Windows 7 .

Confidential, Walpole, MA

ETL Developer

Responsibilities:

  • Experienced in working closely with the Business Analyst, SME while preparing and reviewing the business specifications of the project.
  • Design ETL processes using Informatica tool to load data from heterogeneous sources systems such as Oracle, Fixed Width and Delimited Flat Files into Oracle Target database.
  • Worked with various Informatica Power Center tools - Source Analyzer, Target designer, Mapping Designer, Mapplet Designer, Transformations, Workflow Manager and Workflow Monitor.
  • Developed ETL mappings in Informatica PowerCenter Designer using various transformations like Source Qualifier, Router, Expression, Filter, Connected and Unconnected Lookup, Update Strategy, Sequence Generator, SQL transformations, Union etc.
  • Done p erformance tuning of the process at the mapping level, session level, source level, and the target level.
  • Used Session Task, Command Task, and Event Raise/Event Wait, Email task etc. to develop Workflows.
  • Created pre sql and post sql scripts which need to be run at Informatica level.
  • Trouble shooting and problem solving applications with Informatica Debugger. Used debugger to test the data flow and fix the mappings. Used session log files to identify the errors by analyzing the log files if the session failed and resolved the errors.
  • Implemented Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD.
  • Performed Unit testing and Data validation testing using Validation scripts for source and target table.
  • Implemented documentation standards and practices to make mappings easier to maintain.
  • Monitored and improved query performance by creating views, indexes, and sub queries and Extensively Used Oracle Explain plan for query Performance Tuning.
  • Used SQL Developer and Toad for Oracle to development of scripts, views, PL/SQL Stored procedures to loading data to the target tables.
  • Scheduled various workflows tasks using Informatica Scheduler. Involved in attending Daily and Weekly Project Status Meetings.
  • Wrote documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Center 9.5, Oracle 11g, TOAD, SQL Developer, Relational Tables, Flat Files and Windows 7 .

Confidential, Atlanta, GA

ETL Informatica Developer

Responsibilities:

  • Involved extensively in both development of the ETL (Extract, Transform and Load) processes and production support using Informatica Power Center 9.5/9.1.
  • Handled efficiently both enhancements and development of new code projects simultaneously based on the priority of the project.
  • Developed an ETL Informatica mapping in order to load data into staging area. Extracted from flat files and Relational Table and loaded into Detail and summery table of Teradata 14.0 and Oracle 11g target database.
  • Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database
  • Worked with various Informatica Power Center tools - Source Analyzer, Target designer, Mapping Designer, Mapplet Designer, Transformations, Workflow Manager and Workflow Monitor.
  • Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation, Rank Transformation and Aggregator Transformation.
  • Improving workflow performance by shifting filters as close as possible to the source and selecting tables with fewer rows as the master during joins.
  • Developed Teradata Stored Programs (Procedures, Mecro and Functions) to loading on the fly table for special type of reports.
  • Used Workflow Manager for Creating, Validating, Testing and Running the sequential and concurrent Batches and Sessions, scheduled them to run at a specified time.
  • Done Error Handling and debugging using Informatica debugger, 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.
  • Created Workflows with Worklets, event wait, event raise, decision, email and command tasks using Workflow Manager and monitored them in Workflow Monitor.
  • Involved in User Acceptance Testing and closely worked with the Cognos report developer to ensure that correct data is presented in the reports.
  • Interacted with Teradata DBA team for creation of primary and secondary indexes on Data Warehouse tables
  • Update the source view and target table definition as per the requirement change.
  • Used Teradata SQL Assistance, TOAD for Oracle to run SQL queries and validate and testing the data.

Environment: Informatica Power Center 9.5/9.1, Teradata 14.0, Oracle 11g, Teradata SQL Assistant, TOAD, Relational Table, Flat Files and Windows 7 .

Confidential, MA

ETL Developer/Data Specialist

Responsibilities:

  • Responsible for development of the ETL (Extract, Transform and Load) processes using Informatica Power Center.
  • Developed an ETL Informatica mapping For Extracting data from different type of source like flat files and Relational Table and loaded into Oracle 10g target database.
  • Worked with Source Analyzer, Target designer, Mapping Designer & Mapplet, Transformations -various Informatica Power Center tools.
  • Used transformations like Source Qualifier, Aggregator, Expression, Look Up, Router, Filter, Update Strategy, Joiner, Sequence Generators and Stored Procedure for Creating Informatica mappings.
  • Used Slowly Changing Dimension Mappings of type II and I.
  • Created reusable transformations and Mapplets and used them in complex mappings.
  • Used Workflow Manager for Creating, Validating, Testing and Running the sequential and concurrent Batches and Sessions, scheduled them to run at a specified time.
  • Implemented fine development methods for the Developing mappings.
  • 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.
  • Closely worked with the reporting team to ensure that correct data is presented in the reports.
  • Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
  • Involved in the creation of Test Cases using SQL and executing Unit Test Scripts and publishing Test Results.

Environment: Informatica Power Center 9.1/8.6.1, Oracle10g, SQL Server 2008, TOAD, SQL developer, Relational Table, Flat Files, Linux, Windows XP .

Hire Now