SUMMARY

• Extremely Strong working experience of around 8 years on Informatica Data Integration Tools - Informatica Repository manager, PowerCenter, PowerConnect/PowerExchange, Workflow Manager and Metadata manager (MDM).
• Business Requirements Gathering, Data Analysis, Designing, Reporting, Gap analysis, Data Modeling, Development, Testing and Documentation of various functionalities of Data Warehouse and Business Intelligence.
• Expertise in using Dimensional Data modeling, Star Schema, Snow flake schema, Fact and Dimension tables, Physical and logical data modeling.
• Experience in creating Informatica mappings that sourced data from some unusual sources: MS Excel spreadsheets, OLTP, ODBC and flat file reports as well as Mainframes and relational databases.
• Proficient in developing strategies for extracting, transforming and loading using Informatica Power Center 9/8.6.1/8.1.1/8.0/7.1.1/7.1.3.
• Experience in Dimensional Data modeling, Fact & Dimensions tables and Physical & Logical data modeling using Erwin.
• Strong skills in data mapping for the Slowly Changing Dimensions - SCD1, SCD2 (Flagging, Time Stamping and Version), and SCD3.
• Experienced in the CDC (Type1, Type2 and Type3), session partitioning, Performance Tuning and advanced optimization techniques such as concurrent caching, auto memory calculations and push down optimization.
• Strong experience in SQL-Programming, T-SQL, PL/SQL Stored Procedures writing daily batch jobs for automation of ETL using UNIX shell scripts.
• Created and generated reports using Business Objects like Period, Demographic reports, Comparative Reports and various other reports on Daily, Weekly, Monthly and Yearly basis.

TECHNICAL SKILLS

Data Warehousing/ETL Tools: Informatica9/1/8.5/8/7/6 (Informatica PowerCenter, PowerConnect/PowerExchange)Business ObjectsXIR3.1/ XIR2

RDBMS: - Oracle 10g/9i, TeraData V2R5, DB2/UDB 7.0/6.0, SQL Server 2005/2000Programming Languages - PL/SQL, SQL, Perl/Shell Scripting, C, Java, HTML, XML.

ERP: - SAP R/3, People soft, IBM Mainframes

Tools: & Utilities: - TOAD 7.x, SQL Navigator 7.x, Visio, Rational Clear Case, Erwin 4.0, Autosys 4Tivoli (TWS)

Operating Systems: - Windows 98/NT/2000/XP/VISTA, UNIX (Sun Solaris, HP-UX, RS 6000), Linux.

PROFESSIONAL EXPERIENCE

Confidential, McLean, VA

Informatica Developer

Responsibilities:

• Analysis,Requirements gathering, function/technical specification, development, deploying, testing and production.
• Designed and developed Informatica Mappings to load data from Source Systems to EDH (Enterprise Data Hub) for initial Historical loads and daily (Incremental) Loads.
• Extensively usedTransformationslike Lookup, Router, Aggregator, Normalizer, Source Qualifier, Joiner, Expression, Update Strategy etc.
• UsedSequence Generatorto createDimension keysandUpdate Strategyto insert records into the target table in staging andData Mart.
• Worked with business SMEs and acted as a point of contact on developing the business rules for the development and applied business rules.
• Developed, testedStore procedures, FunctionsandpackagesinPL/SQLto load data in to the Infrastructure tables.
• UsedInformatica Power Exchange change data capture (CDC)to capture data as customer creation or order data by capturing the database inserts, updates, and deletes underlying these events as soon as they occur.
• Complex to simple workflows/Load creation and maintenance using workflow tasks like Sessions, Worklets, Control Task, Command tasks, Decision tasks, Event wait, Email tasks, Pre-sessions, Post-session and Pre/Post commands.
• DesignedAudit Strategyto audit the data betweenSource System, Target Systemand OtherParallel Reporting Systems.
• Involved inProduction Deployment and Support.
• Automated the scheduled Jobs using Autosys Scheduling tool.
• Automated the entire processes using UNIX shell scripts.

Environment: Informatica Power Center 9.1,, PowerConnect/PowerExchange CDC, SAP, Oracle, Teradata, DB2 UDB, SQL, PL/SQL, SQL*Loader, SQL Assistant, Windows NT

Confidential, Needham, MA

Informatica Developer

Responsibilities:

• Business Requirements gathering and analysis provided by the client, preparation of functional specifications and design documents.
• Actively involved in gathering requirements and acquiring application knowledge from Business Managers & Application Owners.
• Performed extensive data analysis along with subject matter experts and identified source data and implemented data cleansing strategy.
• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Worked with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, and filter.
• Read\Wrote XML Messages from\to MQ Series Queues and worked extensively with XML Parser(XSD) and XML Generator Transformations.
• Created Mapplets, reusable transformations and used them in different mappings.
• Created Workflows and used various tasks like Email, Timer, Scheduler, Control, Decision, and Session in the workflow manager.
• 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.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Created, Tested and debugged the Stored Procedures, Functions, Packages, Cursors and triggers using PL/SQL developer.
• Used the feature EXPLAIN PLAN to find out the bottlenecks in a given Query, thus improving the performance of the job.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Migrated repository objects, services and scripts from development environment to production environment
• Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.

Environment: Informatica Power Center 8.6.1, SQL server, Oracle 10g, DB2, Teradata Utilities, Flat Files, Windows, UNIX, Maestro, TOAD, Erwin 7.3

Confidential, Reston, VA

Informatica Developer

Responsibilities:

• Requirements Gathering and Analysis for new requirement.
• Document Business Requirements.
• Document Business Rules for ETL Process.
• Analyzed business process workflows and developed ETL procedures to move data from various source systems to target systems.
• Involved in development of Informatica Mappings using transformations like Source qualifier, Expression, Aggregator, Connected & unconnected Lookups, Filter, Update Strategy, Rank, Stored Procedure, Normalizer, Sequence Generator.
• Extensively worked on Power Center Tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Developed several Re usable Transformations and created Mapplets by using the Power Center Designer
• Mapping new business requirements to technical specifications and design logic for implementing the same.
• Coordination of all activities with offshore teams
• Participate in design, code reviews, documentation of design, and implementation of methodologies for all databases.
• Provide analytical solutions to Production Support problems with my current knowledge.
• Effectively communicate to Business Partners and team members the problem and the expected time of resolution.
• Fine tune SQL queries and database performance for all applications within the development environment.
• Oversee performance monitoring and tuning and capacity planning.
• Performance Monitoring, benchmarking and Tuning of Sessions and Mappings that are in Production.
• Responsible for planning the disaster recovery scenarios
• Creating and maintaining all the production support related docs like Runbooks, Maestro docs, Dashboards etc.

Environment: Informatica Power Center 8.6.1, SQL server, Oracle 10g, DB2, Teradata Utilities, Flat Files, Windows, UNIX, Maestro, TOAD, Erwin 7.3

Confidential, Denver, CO

ETL Developer

Responsibilities:

• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Created Informatica mappings that sourced data from some unusual sources: MS Excel spreadsheets, ODBC, VSAM files, flat files, XML, COBOL files and relational databases.
• Developed complex SQL Scripts and strategies to extract the requirement specific data from the source and loaded to the Informatica Repository.
• Extracted sales order transaction data from Mainframes and loaded to Teradata target tables using PowerExchange.
• Created different transformations for loading the data into targets like Joiner, Update Strategy, Lookup, Rank Transformations, Aggregator, and Sequence Generator.
• Created Informatica mappings to update Type2 slowly changing dimension (CDC) tables to keep full history.
• Increased performance by tuning the transformations and by resolving database issues along with the DBA.
• Designed data feeds to load Teradata from Oracle and vice-versa, using Fastload/ Multiload and SQL*Loader.
• Wrote shell scripts for job scheduling and automation of workflows for the loading of the data.
• Involved in Unit, Integration, and User Acceptance testing of mappings.

Environment: Informatica PowerCenter 8, PowerExchange, SQL*Plus, SQL*Loader, IBM Mainframes, JCL, XML, COBOL, flat files, Oracle, Teradata, Teradata SQL Assistant, TOAD, MS Excel, Outlook, Sun Solaris

Confidential

Informatica Developer

Responsibilities:

• User interaction, requirements analysis and specifications.
• Worked on Source Analyzer, Mapping Designer, and Warehouse Designer.
• Developed several Mappings and Mapplets using corresponding Source, Targets and Transformations.
• Wrote the shell scripts to process the PL/SQL procedures and wrote the PL/SQL program units for data extracting, transforming and loading
• Analyzed source data and decided on appropriate extraction, transformation and loading strategy.
• Worked on transformations like Filter, Aggregator, Expression, Router, Lookup, and Update Strategy.
• Created E-mail tasks, Event wait tasks, pre and post load commands in the work flows, sessions using the Workflow manager for the Informatica Loads.
• Production Support has been done for ongoing issues and troubles shoot the issues and identified the bugs and resolving the issues with the loads and maintenance.
• Responsible for Creating workflows and worklets - Created Session, Event, Command, Control, Decision and Email tasks in Workflow Manager.
• Wrote Pre-session and Post-session shell scripts for dropping, creating indexes for tables, Email tasks and various other applications.
• Creation of different types of reports, such as Master /Detail, Cross Tab and Chart using Business objects for the ease of UAT.

Environment: Informatica 7.1, Oracle, SQL Server, MS Access, TOAD, UNIX, Windows NT.