SUMMARY

• An IT professional with more than 7 years of experience in mission critical software applications with a strong background in Data Warehousing and Oracle technology areas.
• Well versed with Data warehousing Architecture on the Design, Development, Extraction, Transformation and Loading of data using Informatica Power Center as an ETL tool.
• Experience in all phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Strong experience with SDLC methodologies like Waterfall and Agile.
• Strong knowledge of Entity - Relationship, Facts and Dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Experience in building the Data warehouse using Ralph-Kimball methodology.
• Extensive experience in developing mappings for Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouse/Data Marts.
• Experience in creating Reusable Transformations (Joiner, Lookup, Sorter, Aggregator, Expression, Update Strategy, Router, Filter, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Expertise in configuration, performance tuning, installation of Informatica, & in integration of various data sources like Oracle, DB2, flat files into the staging area and Design ETL processes that span multiple projects.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Extensively used SQL and PL/SQL in creation of Triggers, Functions, Indexes, Views, Cursors and Stored Procedures.
• Strong experience with UNIX and Shell Scripting.
• Proficient in writing documents, preparing presentations and presenting them.
• Well organized, goal oriented, with excellent trouble shooting and problem solving skills.
• Strong ability to quickly adapt to new applications, platforms and languages.
• Excellent team player with good organizational, communication, interpersonal & analytical skills.

TECHNICAL SKILLS

ETL: Informatica PowerCenter 9.x/8.x/7.x, Informatica Powermart

Designing Tools: ERStudio 9.x, Erwin, Visio.

Databases: Oracle 11g/10g/9i, MS Access, SQL Server, Teradata, DB2

Languages: C, C++, HTML, SQL, PL/SQL, Unix Shell Scripting

OS: Windows 98/2000/NT/XP, UNIX

Database Tools: SQL* PLUS, SQL Loader, Toad, IBM Data Studio

Scheduling Tools: Autosys, Control M

Reporting Tools: OBIEE, MicroStrategy

PROFESSIONAL EXPERIENCE

Confidential, Silver Spring, MD

Sr. Informatica Developer

Responsibilities:

• Prepared User Requirements Documentation for mapping and additional Functionality.
• Analyzed the functional specifications provided by the data architect and detail design documents for all the mappings.
• Created Process flow for mappings and sessions.
• Responsible for Data Extraction and Transformation from disparate sources like Oracle, flat files and Loading to Oracle using Informatica Power Center.
• Created Informatica maps using various transformations like Source Qualifier, Expression, Look up, Stored Procedure, Aggregate, Update Strategy, Joiner, Union, Filter and Router.
• Implemented complex business rules by creating reusable transformations, and robust Mappings/Mapplets.
• Used Dynamic Lookup transformation for implementing Slowly Changing Dimensions.
• Created Workflows using Workflow manager for different tasks like sending email notifications, when an event occurs and sessions to run a mapping.
• Created Pipeline partitioning to improve Session performance and synchronizing the target load rows throughout the session run.
• Used the Debugger to validate the transformations by creating break-points and analyzing the debug monitor.
• Involved in Performance Tuning and optimization of Informatica mappings and session.
• Used Informatica scheduler to schedule the tasks.
• Scripts were run through UNIX shell programs in Batch scheduling.
• Created Test data and Unit test cases to ensure successful data loading process.

Environment: Informatica Power Center 9.1, Oracle 11g, SQL*Loader, PL/SQL, Windows 7, UNIX, Putty, Control-M.

Confidential, Bloomington, IL

Informatica Developer

Responsibilities:

• Worked closely with the Business Analysts to understand the Data requirements, definitions, and business rules to be implemented.
• Gathered business rules and requirements of different Lines of Business for the ETL process from various Development Centers in the Enterprise.
• Involved in developing conceptual, logical and physical models using ER Studio.
• Prepared the required application design documents based on functionality required.
• Used Informatica as an ETL Data movement tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various platforms.
• Developed mappings using flat files and relational databases as sources.
• Developed reusable transformations and mapplets, and used them in mappings.
• Used SQL override queries in source analyzer to customize mappings.
• Used Informatica debugger to find troubleshooting information about data and error conditions in the mappings.
• Used Workflow Monitor to monitor the jobs, review error logs that were generated for each session, and resolved them.
• Responsible for creating mappings and transforming existing feeds into the new data structures maintaining client standards utilizing Normalizer, Router, Lookups (Connected, Unconnected), Expression, Aggregator, Update strategy transformation.
• Responsible for designing and creating restorability and failover mechanisms and implemented them using informatica mappings which can support real-time synchronization of mapping to run continuously 24/7.
• Involved in design discussions when creating a separate exception handling framework to deal with the real time and non real time exception records which helps in storing/reprocessing/audit purposes.
• Actively involved in various proof of concept discussions by exploring various solutions to meet and satisfy business requirements and needs.
• Handled UNIX operating system tasks to run informatica jobs using Control-M and also generating Pre and Post-Session UNIX Shell Scripts.

Environment: Informatica Power Center 9.1, MS Access, Oracle 11g, DB2, Salesforce, Control M, ER Studio 9.x, Visio, UNIX Scripting, Putty.

Confidential, Omaha, NE

Informatica Developer

Responsibilities:

• Involved in full life cycle development including Design, ETL strategy, troubleshooting Reporting, and Identifying facts and dimensions.
• Prepared the required application design documents based on functionality required.
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files (Fixed Width), and Excel files to staging database and from staging to the target Oracle Data Warehouse database.
• Implemented the best practices for the creation of mappings, sessions and workflows and performance optimization.
• Implemented slowly changing dimensions methodology to keep track of historical data.
• Created mappings using transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.
• Designed and developed the logic for handling slowly changing dimension tables load by flagging the record using update strategy for populating the desired.
• Involved in cleansing and extraction of data and defined quality process for the warehouse.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Involved in migration of mappings and sessions from development repository to production repository
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Involved in production support working with various mitigation tickets created while the users working to retrieve the database.
• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data.

Environment: Informatica Power Center 9.1, Oracle 11g, TOAD 9x, PL/SQL, LINUX, UNIX Scripting, Putty, SQL*Loader.

Confidential, Nutley, NJ

Informatica Developer

Responsibilities:

• Instrumental in Analysis, Requirements Gathering and documentation of Functional & Technical specifications.
• Involved in Dimensional modeling to Design and develop STAR Schemas using ERWIN to identify Fact and Dimension Tables.
• Worked extensively on Informatica client tools such as Designer, Workflow manager, Workflow Monitor.
• Based on the business requirements Reusable transformations are created in transformation developer and Mapplets in the Mapplet designer.
• Developed complex mappings to transform the data using Rank, Sorter, Stored Procedure, Joiner, Aggregator, Filter, Connected lookup, unconnected lookup and Router transformations.
• Implemented slowly changing dimensions type 2 to keep track of historical data.
• Extensively used dynamic lookup cache for slowly changing dimensions.
• Used workflow manager for creating, validating, testing and running the Sequential and Concurrent batches and sessions and scheduling them to run at specified time with required frequency.
• Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions.
• Used Workflow Monitor to monitor the jobs, review error logs that were generated for each session, and resolved them.
• Extensively performed unit testing and system testing.

Environment: Informatica PowerCenter 8.6, Oracle 10g, Autosys, SQL, PL/SQL, Teradata, DB2, Toad, ERwin 3.5, Unix Scripting, Putty.

Confidential 

ETL Developer

Responsibilities:

• Requirement Analysis and Design
• Coding (involves coding of shell scripts, Informatica mapping, sessions and workflows)
• Unit Testing
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Developed Shell Scripts, PL/SQL stored procedures, table and Index creation scripts.
• Created complex transformations using Source Qualifier, Joiner, Aggregator, Lookup, Router, Expression, Update Strategy and Sequence Generator.
• Used Informatica Power Center Server manager to create sessions, batches to run with the logic embedded in the mappings.
• Involved in developing the SQL scripts for Extract and load the data warehouse.
• Involved in Unit and Integration testing of Informatica Sessions and Target Data.

Environment: Informatica PowerCenter 7.1, MS Access, SQL, Oracle 9i/8i, PL/SQL, SQL*Loader, Windows 2000, UNIX Scripting.