SUMMARY

• Over 8+ years of professional experience in IT with progressive experience in design, development, testing and implementation of Data warehouse applications.
• Experience in data modeling, data warehouse, Ralph Kimball models with Star/Snowflake Schema designs with analysis - definition, database design, testing, and implementation and Quality process.
• Experience in shell scripting.
• Expertise in Installing and Managing Informatica Power center, Metadata Manager and Data Quality.
• Strong knowledge in Informatica Administration including Installation, Configuration, maintenance and troubleshooting.
• Analyze system performance and knowledge of system parameters for improvement of the utilization of system resources.
• Creative problem solver and articulate communicator, skilled in the process of translating business needs into technology solutions.
• Involved in the Analysis of Physical Data Model for ETL mapping and the process flow diagrams.
• Actively interacted with the Users in developing ETL design for Reporting layers.
• Extensive Data Warehouse and Data Migration development experience using Informatica Power Center, Oracle 7.x/8i/9i/10g/11g, MS SQL Server 7/2000/2005.
• Extensively used Informatica workflow manager and workflow monitor for creating and monitoring workflows, Worklets and sessions.
• Extensively worked with large databases in production environments.
• Experienced in Agile and waterfall environment and have used Rally and Req-pro as requirement gathering and management tool.
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files, Excel files and SFDC to staging database and from staging to the target Data Warehouse database.
• Performed data cleansing, data manipulations using various Informatica Transformations.
• Experience in debugging and performance tuning of sources, targets, mappings and sessions.
• Collaborated onsite teams, interacted and well managed various offshore teams.
• Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools.
• Strong Team working spirit, communication and relationship management skills.
• Created Mappings in Mapping Designer to load data from various sources using complex transformations like transaction control, Lookup (Connected and Un-connected), Joiner, sorter, Aggregator, Update Strategy, Filter and Router transformations.
• Experience with reading from Oracle, SQL server and SFDC using Informatica Power Exchange.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 6.x/7.x/8.x/9.x and PowerExchange

OLAP/DSS Tools: Tableau, Hyperion

Database Modeling: Erwin 3.5/4.0/4.1

Databases: Oracle - Exadata, Oracle7.x/8.x/9.x/10g,SQLServer 7.0/2000/2003 , SFDC

Languages: SQL, PL/SQL, SOQL

DB Tools: SQL* Plus, SQL* Loader, SQL*Forms, Workbench

OS: MS-DOS 6.1, MS-WINDOWS 95/98/XP

PROFESSIONAL EXPERIENCE

Confidential

Sr. Informatica Developer and System Analyst

Responsibilities:

• Worked closely with the business users across different business Units to gather requirements for building and enhancing the existing process & functionality.
• Functioned as the primary liaison between the business line, operations, & the technical areas throughout the project cycle. Worked on gathering, analyzing & documenting business requirements.
• Participate in grooming and planning sessions, estimate story points
• Create and maintain mapping documents
• Involved in database design using Star schema & Snow flake schema.
• Extensively used Informatica client tools Source Analyzer, Target designer, Mapping designer, Mapplet Designer, Transformations and Informatica Repository Manager
• Imported various sources, targets, and created transformations using Informatica Power Center Designer.
• Designed and developed ETL strategies and mappings from source systems to target systems. ETL strategies were designed to cater initial load and incremental load.
• Extracted data from different sources such as Oracle, flat files, SQL server, salesforce.com using Power Center.
• Designed, developed and tested Informatica mappings using efficient transformations and used reusable transformations as well as Mapplets.
• Load data to flat files, Oracle and salesforce.com
• Performance tuning SQL queries and stored procedures
• Implemented the Mapping dependencies using informatica workflow manager
• Wrote test plans and executed the same at UNIT testing and also supported for system testing, volume testing and USER testing.
• Performed ETL Testing and Involved in Debugging.
• Used parameter file to maintain the file names, locations and log file locations based on dates.
• Involved in creation of various different independent schemas around the database creation.
• Worked in creation of Mapplets and Worklets.
• Created various mappings which define denormalization of data.
• Involved in technical design and education offshore-team.
• Worked handling a team of developers in technical discussions and routing of data.
• Involved in various product release activities.

Environment: Informatica Power center 9.1, Oracle 9i, TOAD, salesforce.com, workbench, UNIX, Windows XP, Oracle 9i/10G, Flat Files, Tableau.

Confidential

Informatica Developer

Responsibilities:

• Worked closely with the business analyst and Data warehouse architect to understand the source data and need of the Warehouse.
• Involved in designing of star schema based data model with dimensions and facts.
• Used Informatica as ETL tool for building the data warehouse.
• Extensively worked on different subject areas like Products, Accounts, Billing, Services, Locations, LOBs, Call details, summary details and geographical regions.
• Created mappings with heterogeneous sources like flat files, Oracle databases and created targets in Oracle using Informatica Mapping Designer 8.1
• Designed and developed complex aggregate, join, lookup transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica Power center.
• Designed and developed mappings using Source qualifier, Aggregator, Joiner, Lookup, Sequence generator, stored procedure, Expression, Filter and Rank transformations.
• Created session variables to build sessions more effectively by using Informatica server manager.
• Having working knowledge of ERWIN 3.5.2 in converting logical data models into physical models.
• Used touch files, event-wait tasks for scheduled job runs in Workflow execution.
• Duties included coordination, attending meetings, and the review of requirements, infrastructure setup, task assignments and code reviews.

Environment: Informatica Power center 8.1, Informatica Power Exchange, Oracle 9i/10G, ERWIN 3.5, Hyperion, PL/SQL, MS Office, SQL Server 2000.

Confidential

Informatica Developer

Responsibilities:

• Involved in design & development of operational data store and acquisition layer
• Reviewed source data and recommend data acquisition and transformation strategy
• Involved in conceptual, logical and physical data modeling and used star schema in designing the data warehouse
• Designed ETL process using Informatica Designer to load the data from various application source databases and flat files to target data warehouse in Oracle
• Used Informatica Workflow Manager to design sessions
• Implemented Type 2 load for the Acquisition layer and Incremental/complete MD5 load for the integration layer(ODS)
• Created parameter based mappings, Router and lookup transformations
• Used Informatica Workflow Monitor to monitor the workflows
• Optimized mappings using transformation features like Aggregator, filter, Joiner, Expression, Lookups
• Created daily and weekly workflows and scheduled to run based on business needs
• Involved in Unit Testing, Integration Testing and System Testing

Environment: Informatica Power center 8.1, Oracle 8i, Erwin 3.5, Shell scripting, Windows 2000