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