SUMMARY:

• Around 10+ years of experience in Information Technology and 6+ years with a strong background in Data warehousing using Informatica Power Center 9.x/8.x/7.x/6.x/5.x.
• Good knowledge of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De normalization.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, Teradata, SQL Server and Worked on integrating data from flat files like fixed width and delimited.
• Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Migrated data from flat files to DB2 using DB2 load utilities.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.
• Strong Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer
• Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.
• Extensively used Informatica Repository Manager and Workflow Monitor.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Hands on experience in Performance Tuning of sources, targets, transformations and sessions.
• Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow.
• Worked with Stored Procedures, Triggers, Cursors, Indexes and Functions.
• Have good knowledge in SSIS and SSRS
• Developed applications in .NET Framework 3.0
• Strong Knowledge in optimizing database performance.
• Having good knowledge in UNIX shell scripting, CRON, FTP and file management in various UNIX environments.
• Highly Motivated to take independent responsibility as well as ability to contribute and be a productive team member

TECHNICAL SKILLS:

ETL Tools: Informatica 9.1/8.6.1/8.5.1/7.1/6.2/5.1 (Power Center/Power Mart ) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect)

Data Modeling: Erwin 4.0/3.5, Star Schema Modelling, Snow Flake Modelling.

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

SAP Tools: ECC 6.0, 4.X, BW3.X

OLAP Tools: Business Objects6.5/XI/R1/R2

Programming Languages: ASP, C# and .NET 3.5

Languages: SQL, PL/SQL, Unix Shell Script, Visual Basic

Tools: Toad, SQL* Loader

Operating Systems: Windows 2003/2000/NT, AIX, Sun Solaris, Linux

WORK EXPERIENCE:

Confidential, Bloomington, IL

Sr.Informatica Developer

Responsibilities:

• Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
• Extracted data from relational databases DB2, Oracle and Flat Files.
• Developed Complex transformations, Mapplets using Informatica to Extract, Transform and load data into Datamarts, Enterprise Data warehouse (EDW).
• Developed data Mappings, Transformations between source systems and warehouse
• Performed Type1 and Type2 mappings.
• Migrated data from flat files to DB2 using DB2 load utilities.
• Developed Data Quality check mappings on top of Target mappings.
• Managed writing test cases and test scenarios from requirement for newly added features and executing test scripts.
• Developed efficiencies throughout the SDLC on an iterative basis, this includes reuse of existing internal/third-party components.
• Worked in Onsite/Offshore model and coordinated with offshore team.
• Adding requirements into Quality Centre, Mapping Requirements with Test cases.
• Documenting defects in Quality center Uploading all necessary information into Share point.
• Worked closely with UAT team.
• Preparation of test cases/scenarios and execution of the same
• Recording, tracking and closing of defects/bugs in a systematic manner into a Defect Tracking System and preparation of bug report with bug severity and bug priority.
• Managed the Metadata associated with the ETL processes used to populate the data warehouse.
• Implemented Aggregate, Filter, Join, Expression, Lookup and Update Strategy transformations.
• Used debugger to test the mapping and fixed the bugs.
• Created sessions, sequential and concurrent batches for proper execution of mappings using server manager.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Responsible for daily verification that all scripts, downloads, and file copies were executed as planned, troubleshooting any steps that failed, and providing both immediate and long-term problem resolution.

Environment: Informatica Power Center 9.5/9.1, DB2 V9.7 Utilities, Unix, Erwin, HP Service manager, Quality CenterRational Suite, Business Objects XI R2,Salesforce

Informatica Developer

Responsibilities:

• Created Technical design specification documents based on the functional design documents
• Participated in data modeling (logical and physical) for designing the Data Marts for finance, Sales, Billing.
• Developed standards and procedures for transformation of data as it moves from source systems to the data warehouse.
• Responsible for Extract the data from multiple source systems SAP, SQL server and DB2, develop Informatica mappings, load the data in to data warehouse, support and maintenance for the ETL processes.
• Understanding the domain and nodes as well as by using the informatica integration service to run the workflows in 8.5.1
• Involved in source data profiling & source system analysis.
• Developed sql code for data validations and data computation process on source DB2 transaction system and on target warehouse
• Create and execute different test cases in Quality Center and maintain all the documentations in Share point.
• Served as a point of contact for the ETL testing, attend business, project and defect meetings with the development and the end-users to review and resolve the issues.
• Involved in massive data cleansing prior to data staging.
• Developed shell scripts for job execution and automation on server side.
• Define strategy for ETL processes, procedures and operations
• Prepared a handbook of standards and Documented standards for Informatica code development.
• Administrated users and user profiles and maintained the repository server.
• Tuning the complex mappings based on source, target and mapping, session level
• Extensively used transformations like router, aggregator, lookup, source qualifier, joiner, expression, aggregator and sequence generator transformations in extracting data in compliance with the business logic developed.
• Involved in performance and tuning the ETL processes.
• Created Workflows and scheduled the jobs .
• Debugging invalid mappings using break points, testing of stored procedures and functions, testing of Informatica sessions, batches and the target Data.
• Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
• Used SQL tools like TOAD 9.5 to run SQL queries and validate the data in warehouse.
• Extensively used Maestro tool for scheduling batch jobs.

Environment: Informatica Power Center 8.5.1/7.1.4, IDQ, Business Object XI, SAP R/3,SAP BW, Oracle 10g, Mainframes, DB2, MS SQL Server 2005, Toad, PL/SQL, SQL, XML, AIX

Informatica Developer

Responsibilities:

• Involved in full life cycle design and development of Data warehouse.
• Implemented Informatica 8 new SQL transformation for executing SQL statements.
• Installed and configured Informatica repository server
• Created and maintained users and user profiles
• Maintained repository server and scheduled Workflows
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Involved in business analysis and technical design sessions with business and technical staff to develop Entity Relationship/data models, requirements document, and ETL specifications.
• Used Informatica Designer to create complex mappings, transformations, source and target tables.
• Administer the repository by creating folders and logins for the group members and assigning necessary privileges.
• Black Box, Negative, Regression, and Integration & Security Tests Using QTP
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases.
• Used Exception handling logic in all mappings to handle the null values or rejected rows
• Query Optimization for improving the performance of the data warehouse.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, and filter.
• Performed Type1 and Type2 mappings
• Used session parameters and parameter files to reuse sessions for different relational sources or targets.
• Used SQL*Loader for loading bulk data.
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Extract data, Transform data, Load data).
• Created documentation on mapping designs and ETL processes.
• Maintain Development, Test and Production mapping migration Using Repository Manager.
• Developed Korn shell scripts for Informatica pre-session, post session procedures
• 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

Environment: Informatica Power Center 7.1.3/8.0, Mainframes, DB2, Oracle 10g, SQL, PL/SQL, TOAD, Erwin, SQL SERVER 2005, XML, T-SQL, Shell Scripts, SQL Navigator, Rational Suite, Crystal reports XI, AIX

Programmer

Responsibilities:

• Involved and Designed the System Development Life Cycle, i.e. such as conducting the preliminary investigation and technical specs.
• Involved in technical and user level documentation and training.
• Involved in the generation of Forms & Reports.
• Involved in creation of tables, writing stored procedures, Triggers, PL/SQL Libraries.
• Performed Normalization and Logical Database Design Unit Testing of the modules.
• Developed user-friendly forms for easy data entry.

Environment: Oracle 9i, SQL, PL/SQL, Erwin, Windows NT/XP/2000