We provide IT Staff Augmentation Services!

Informatica Developer Resume

MD

SUMMARY:

  • 5+ years of IT experience in Data Warehousing technology in Informatica PowerCenter 9.6/9.1/8.6 applications and various databases like Oracle 11g/10g, Teradata 14, SQL Server 2000/2007.
  • Interacted with end - users and functional analysts to identify and develop Business Requirement Document (BRD) and transform it into technical requirements.
  • Worked extensively in design and analysis of Requirements, Development, Testing, Deployment and Production support.
  • Worked on documentation of Design, Test case, Data flow and ETL Code between applications.
  • Designed and developed complex mappings (Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy) from varied transformation logics in Informatica.
  • Experience in Debugging and Performance tuning of targets, sources, mappings and sessions in Informatica.
  • Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets and PL/SQL stored procedures.
  • Extensively used Slowly Changing Dimension (SCD) Type 1, 2 and 3 technique in data warehouse.
  • Expertise in OLTP/OLAP System Study, Analysis, E-R modeling, developing Dimensional Models using Star schema and Snowflake schema techniques used in relational, dimensional and multidimensional modeling.
  • Experience in writing UNIX Script for various phase of ETL process.
  • Extensive understanding of Production issues and Data issues and provided Production support. communication skills, ability to communicate effectively with different levels of management, strong analytical, problem solving skills.
  • Worked on documentation of Design, Test case, Data flow and ETL Code between applications.
  • Designed and developed complex mappings (Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy) from varied transformation logics in Informatica.
  • Expertise in OLTP/OLAP System Study, Analysis, E-R modeling, developing Dimensional Models using Star schema and Snowflake schema techniques used in relational, dimensional and multidimensional modeling.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 8.6/9.x

Databases: Oracle 11g/10g, MS SQL Server 7.0/2000, DB2, TeraData 14

DB Tools: SQL*Plus, SQL* Loader, TOAD

Environment: Sun Solaris, UNIX, WINDOWS XP/2000/NT

Languages: C, C++, Java, SQL, PL/SQL, XML, UNIX

Drafting Tools: Visio, Rational Rose, Erwin, UML.

Development Tools: Microsoft Visual Studio, Dream Weaver.

Office Suite: MS Word, MS Power Point, MS Excel, MS Access.

PROFESSIONAL EXPERIENCE:

Confidential, MD

Informatica Developer

Roles & Responsibilities:

  • Converted business requirements into technical documents - Business Requirement Document, explained business requirements in terms of technology to the developers.
  • Developed Data Flow diagrams to create Mappings and Test plans. The Data flow diagrams ranged from OLTP systems to staging to Data warehouse.
  • Developed Test plan to verify the logic of every Mapping in a Session. The test plans included counts verification, look up hits, transformation of each element of data, filters, and aggregation and target counts.
  • Developed complex Informatica mappings using various transformations- Source Qualifier, Normalizer, Filter, Connected Lookup, Unconnected Lookup, Update strategy, Router, Aggregator, Sequence Generator, Reusable sequence generator transformation.
  • Extensively used SCD’s (Slowly Changing Dimension) to handle the Incremental Loading for Dimension tables, Fact tables.
  • Designed various mappings for extracting data from various sources involving Flat files, Oracle, Sybase and SQL Server, IBM DB2, XML files.
  • Worked Teradata Utilities like FLOAD, MLOAD & TPump to load data in staging and OLAP.
  • Worked on Debugging and Troubleshooting of the Informatica application. For debugging utilized Informatica debugger.
  • Worked on Performance Tuning to optimize the Session performance by utilizing, Partitioning, Push down optimization, Index Cache, Data Cache and incremental aggregation.
  • Worked on complex Informatica Mappings for Household dimension, Multi valued dimension and Point in time dimension.
  • Utilized Quality Center 9 web based test management tool to keep track of all the releases, requirements, test plans, labs and defects.

Confidential, Bethesda, MD

DW Informatica Developer

Tools: and Technologies used: Informatica Power Center 9.1, OLAP, Oracle 10g, MS SQL Server 7.0, IBM DB2/400, Sybase, MS Excel 97, Flat files, PL/SQL, SQL, SQL*Loader, Erwin 3.5, Toad 7.0, Windows 2000, HP-UX, and Unix Shell Scripting.

Roles & Responsibilities:

  • End-to-end ETL development of the Data Mart. Data Quality Analysis to determine cleansing requirements. Designed and developed Informatica mappings for data loads
  • Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management. Understand the business needs and implement the same into a functional database design
  • Extensively used ETL and Informatica to load data from MS SQL Server, Excel spreadsheet, flat files into the target Oracle 9i database.
  • Implemented various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router etc.
  • Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer. Development of Informatica mappings and also in tuning of mappings for better performance.
  • Loading the Data from the tables into the OLAP application and further aggregate to higher levels for analysis.
  • Developed PL/SQL procedures/packages to load the data into database.
  • Tuning Informatica Mappings and Sessions for optimum performance
  • Used Informatica features to implement Type I & II changes in slowly changing dimension tables. Created and ran workflows and Worklets using Workflow Manager to load the data into the Target Database.
  • Optimized/ Tuned mappings for better performance and efficiency. Performance tuning of SQL Queries, Sources, Targets and sessions.
  • Responsible for ETL process under development, test and production environments
  • Developed Interfaces using UNIX Shell Script to automate the bulk load & update processes.
  • Maintained warehouse metadata, naming standards and warehouse standards for future application development Parsing high-level design spec to simple ETL coding and mapping standards

Hire Now