SUMMARY:

• 8+ years of strong Data Warehouse & Business Intelligence experience in Informatica Power Center 9.1/8.6/8.5.1 and 5.1/6.2/7.1.1/7.1.4 and Informatica B2B (Data Exchange & Data Transformation), Informatica Data ServicesHands on experience with Informatica, Informatica Power Exchange and Datastage 8.5/8.0/7.5. Data warehousing/Data modeling experience in the areas of data administration, physical database design, database performance tuning and expertise in SQL and PL/SQL.
• 6+ years of experience in Oracle (11g, 10g, 9i, and 8.x), on both OLTP and OLAP environments for high volume database instance
• Erudite in using Dimensional Data Modeling (Star Schema Modeling, Snow - Flake Modeling) FACT and Dimension Tables, Physical and Logical Data Modeling.
• Strong Knowledge on Informatica Source Analyzer, Warehouse Designer, Mapping Designer, and Transformation Developer.
• Extensively worked with various source systems like Oracle, SQL Server, MS Access, Flat files, DB2, Teradata and XML.
• Designed and developed complex mappings, mapplets and reusable transformations.
• Strong Knowledge in Informatica performance tuning and SQL tuning.
• Pushdown Optimization.Hands on experience with Informatica Installation and Configuration.
• Extensively worked with slowly changing dimensions Type I, Type II and Type III.
• Good working knowledge in UNIX Shell Scripting, Perl Scripting and Korn Shell Scripting.
• Good work experience in Teradata SQL Tools & Utilities (BTEQ, Fast Export, Multi Load, Fast load, TPUMP)
• Strong hands on Experience with Informatica, Datastage, OBIEE (Oracle Business Intelligence) and ODI.
• Solid experience in Database Design, Creation and Management of Schemas, Writing Stored Procedures, Functions, Triggers and Packages.
• Experienced with RDBMS design, implementation and development using Oracle 9i, PL/SQL and experience in modeling Entity- Relation database Oracle.
• Strong knowledge in version controlling tool subversion and vss (Visual Source Safe).
• Good Knowledge on Data Error Handling.
• Experience with working on UNIX, Windows NT/2000/XP.
• Extensive working knowledge with Database tools like Toad, SQL Developer and SQL*Loader.
• Experience with OLAP reporting business intelligence and Analytical tool OBIEE.
• Participate in daily meeting with the team, walkthroughs and defect tracking meetings.
• Provided support for system testing and implementation.
• Experience on to create and execute the unit test cases.
• Strong analytical skills with ability to quickly understand client’s business needs.
• Involved in meetings to gather information and requirements from the clients.
• Research-oriented, motivated, proactive, self-starter with strong technical, analytical and interpersonal skills. Capable of leading a team of technical resources.
• Excellent communication & customer facing skills.

TECHNICAL SKILLS:

Warehousing Tools: Informatica Power Center 9.1/8.6.1/8.5.1/7.1/6.2/5.1.2 , Informatica B2B (Data Exchange & Data Transformation), Informatica Data Services, OBIEE, OWB, ODI, IBM Datastage, DAC.

Architectures: Data Warehousing, Business Intelligence, ETL Architectures, Relational Data Modeling and Database Design.

Databases: Oracle 9i/10g/11g, Teradata, DB2, Microsoft SQL Server, MySQL, MS-AccessExadata.

Languages: Java, SQL, PL/SQL, C, C++.

Reporting Tools: OBIEE, Business Objects.

Methodologies: Dimensional Modeling, Kimball Lifecycle, Inmon Lifecycle.

Database Tools: Toad, Raptor, SQL Developer, DBVisualizer

SCM Tool: VSS, Subversion

Scheduling Tools: Autosys, Control -M

Operating Systems: Windows NT/95/2000/XP, UNIX, Solaris, Linux

PROFESSIONAL EXPERIENCE:

Confidential, CA

Informatica Lead

Responsibilities:

• Prepared technical design document as per requirements.Designed and Developed ETL processes using Informatica, PL/SQL, Oracle, SQL loader (bulk loads) and Unix shell programming for loading data warehouse.
• Extensively involved in interacting with client and gathering requirements.
• Worked as ETL Lead for the team of six developers.
• Closely worked with ETL Architect and implemented ETL process.
• Involved in the extraction, transformation and loading of the source data to the target database.
• Created source to target mapping based on the functional requirements.
• Worked on source data analysis to figure the mapping between various legacy source data.
• Imported Sources and Targets to create Mappings based on business logic and developed Transformations using Power center Designer. Used Informatica Workflow Manager, Workflow Monitor to create sessions and batches.
• Extensively used transformations like Aggregator, Expression, Sorter, Sequence Generator, Joiner, Filter, Router, Rank, Look up and Update Strategy transformations to model various standardized business processes.
• Used Informatica features to implement Type I, II, and III changes in Slowly Changing Dimension tables.
• Worked very closely with analysts to determine data requirements and identify data sources, provide estimates for task duration.
• Responsible for trouble shooting, identifying and resolving data problems.
• Developed error handling & data quality checks in Informatica.
• Worked on Informatica Power Center tools - Source Analyzer, Warehouse Designer, Mapping & Mapplet Designer, and Transformation Developer.
• Designed and developed Informatica Mappings, Mapplets, and Sessions, Workflows based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Implemented Unit, Functionality, and Performance testing on Mappings and created Test plans to support the Testing Team.
• Developed process to move Informatica packages from Dev to QA and Production.
• Optimized performance of Mappings and sessions by identifying bottlenecks and eliminating them.
• Involved and co coordinated the system integration test (SIT).
• Coordinated the user acceptance testing (UAT).
• Extensively resolved Level 3 Informatica complex production issues.
• Involved in the enhancements, maintenance and production support for the existing system.
• Responsible and provided production support for the same.
• Given extended technical support to the team

Environment: Informatica Power Center 8.6, Toad, Oracle 11g (Stored Procedures, Packages & Triggers, DDL, DML), Informatica Data Services, Unix shell scripting, OBIEE, Win-SCP, Erwin Data Modeler, Ctl-M, Microsoft Office.

Confidential, CA

Informatica Senior Consultant

Responsibilities:

• Involved in meetings to gather information and requirements from the clients.
• Involved in Designing the ETL process to Extract translates and load data from OLTP Oracle database system to warehouse database.
• Prepared technical design document as per requirements.
• Technical expert in the areas of relational database logical design, physical design, and performance tuning of the RDBMS.
• Prepared the DDL’s for the staging/work tables and coordinated with DBA for creating the development environment and data models.
• Involved in analyzing the source data coming from different Data sources such as Oracle, XML sources, DB2, SQL Server, flat files and identifying data anomalies in operational data.
• Perform tuning and optimization of database config and application SQL.
• Imported Sources and Targets to create Mappings based on business logic and developed Transformations using Power center Designer. Used Informatica Workflow Manager, Workflow Monitor to create sessions and batches.
• Extensively used transformations like Aggregator, Expression, Sorter, Sequence Generator, Joiner, Filter, Router, Rank, Look up and Update Strategy transformations to model various standardized business processes.
• Used Informatica features to implement Type I, II, and III changes in Slowly Changing Dimension tables.
• Responsible for troubleshooting, identifying and resolving data problems, Worked with analysts to determine data requirements and identify data sources, provide estimates for task duration.
• Gather information from different data warehouse systems and loaded into One Financial Information Consolidated system.
• Developed error handling & data quality checks in Informatica.
• Extensively used PMCMD commands on command prompt and executed Unix Shell scripts to Automate Workflows and to Populate Parameter files.
• Created mapping parameters and variables, used them in mappings.
• Implemented Unit, Functionality, Performance and Stress testing on Mappings and created Testing Documents.
• Optimized performance of Mappings and sessions by identifying bottlenecks and eliminating them.
• Involved in unit testing, systems testing, integrated testing and user acceptance testing.

Environment: Informatica Power Center 8.6, Toad, Oracle 10g(Stored Procedures, Packages & Triggers, DDL, DML), Windows XP, Unix shell scripting, Win-SCP, Erwin data Modeler, Ctl-M, Microsoft Office

Confidential, GA

Informatica Senior Developer (SME)

Responsibilities:

• Used Informatica CDE tool to convert client format to Confidential format and to Implement Buyer specific Business validations (Informatica B2B parser, mapper and serializer). Resolved Level 2 Informatica complex production issues.
• Analyzed the requirements to identify the necessary tables that need to be populated into the staging database.
• Prepared the DDL’s for the staging/work tables and coordinated with DBA for creating the development environment and data models.
• Designed and developed Informatica Mappings, Mapplets, and Sessions, Workflows based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Responsible for loading data from Buyer format into the Confidential native format.
• Worked on Informatica B2B Data Exchange tools, provided technical guidance to development team.
• Used Error handling strategy for trapping errors in a mapping and sending errors to an error table.
• Lead the Informatica team in resolving development and production issues.
• Used Mapping variables for Incremental Extraction of operational data.
• Wrote Unix Shell scripts to automate workflows.
• Used Power Center Workflow Manager to create workflows, sessions, and also used various tasks like command, event wait, event raise, email to run with the logic embedded in the mappings.
• Schedule and Run Extraction and Load process, monitor task and workflow using the Workflow Manager and Workflow monitor.
• Used FTP services to retrieve Flat Files from the external sources.
• Involved in Performance Tuning at various levels including Target, Source, Mapping, and Session for large data files.
• Worked on Migration Strategies between Development, Test and Production Repositories.
• Supported the Quality Assurance team in testing and validating the Informatica workflows.
• Created documents for Informatica configuration, workflow migration and impact analysis for database changes.

Environment: Informatica B2B (Data Exchange & Data Transformation), Informatica Power Center 8.5.1, PL/SQL Developer, Oracle 9i, Microsoft SQL Server, Data Junction, Beyond Compare, Ultra Edit, Perl Scripting, Unix Shell Scripting, Ctl-M, Sub version, Sugar Case Tracker, Mercury Quality Center, Autosys.

Confidential, OH

Datastage Developer

Responsibilities:

• Involved in the enhancements, maintenance and production support for the existing system.
• Participated in the review and approval of the technical transformation requirements document used to design and build the ETL modules in Datastage Designer.
• Extensively worked with Facts and Dimension tables to produce source - target mappings based upon business specs.
• Used DataStage Manager to implement the Import and Export Interfaces.
• Developed many Datastage application jobs for data processing, loading and jobs are scheduled using Datastage Director.
• Designed several DataStage parallel jobs using Sequential File, Join, Merge, Lookup, Change Apply, Change Capture, Remove duplicates, Funnel, Filter, Copy, Column Generator, Peek, Dataset, Aggregator, Transformer, Modify and Compare.
• Automated Job Control using Batch logic to execute and Schedule various DataStage jobs.
• Migrated data from Oracle, SQL Server, DB2 and other flat files data sources using DataStage.
• Analysed and tuned the database application for performance improvement.
• Extensively used DataStage Designer components to design various Parallel jobs in accordance with business specs.
• Developed the ETL Jobs for handling the SCD Type-II.
• Used Before and After Stage subroutines to further enhance performance of the system.
• Developed the Data Quality jobs, performed the Unit testing of all the jobs through the Job Sequences and documented the test case results as per the standards.
• Involved in the low level ETL design discussions
• Develop complex ETL jobs by using DataStage parallel extender parallel processing capabilities.
• Designed and Developed ETL processes using Datastage, Teradata, PL/SQL, Oracle, SQL loader (bulk loads) and Unix shell programming for loading RDB data warehouse.
• Help team members in tuning and improve performance for handling high-volume ETL jobs.
• Resolve functional and technical issues during system test phase of development.
• Developed PL/SQL database procedures to implement complex business rules.
• Developed BTEQ scripts to extract data from the detail tables for reporting requirements.
• Developed Multiload & BTEQ scripts to Load the data from Staging area to Data Warehouse
• Written scripts to extract the data from DB2, Oracle and load into Teradata
• Developed unix shell scripts to automate the Data Load processes to the target Data warehouse.
• Using autosys shell controller for overall batch processing.

Environment: IBM DataStage 7.5, DB2, Teradata, Oracle 9i, SQL, PL/SQL, XML, Shell Scripts, Erwin, UNIX, Windows XP, Autosys.

Confidential

Informatica Consultant

Responsibilities:

• Extensively used ETL and Informatica to load data from MS SQL Server, Excel spreadsheet, flat files and XML files into the target Teradata database.
• Implemented various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router.
• Created and ran workflows and Worklets using Workflow Manager to load the data into the Target Database.
• Involved in design of logical and physical data models using Erwin.
• Involved in creations of transaction level snapshots, periodic snapshots and Accumulated Snapshots.
• Implemented pipeline partitioning concepts like hash-key, round robin, key-range, pass-through techniques in mapping transformations.
• Designed processes to extract and transform data from flat files and other relational sources (SQL Server, Oracle) to load into targets.
• Used Teradata Utilities Fast Export, Multi Load, Fast load, TPUMP to load Datawarehouse Teradata database.
• Involved in performance tuning of Queries, Sources, Targets and sessions.

Environment: UNIX, Informatica Power Center 7.1.1, OWB, ODI, TOAD, Oracle 9i, MS- Access, Flat files, Teradata.

Confidential

Informatica Consultant

Responsibilities:

• Involved in creating of Informatica mappings, sessions and workflows.
• Served as Developer on the Data Extraction.
• Worked on Informatica Power Center 7.1 tools - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager and Mapplets.
• Involved testing of the changes to the mapping and verification data for the Extract work carried out from offshore.
• Hands on experience with Informatica Installation and Configuration, gave Informatica technical guidance to development team.
• Involved in fixing invalid Mappings, verification of changes in Workflows, Worklets and Sessions as per the Extract Document and Checklist.
• Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, and Sequence Generator etc.
• Created several mappings to load claims related data from multiple sources to Data Warehouse.
• Used the parameter file for executing sessions & workflows.
• Tested loaded target data according to client requirement.

Environment: Oracle 8, SQL Loader, XML, Flat files, UNIX, Informatica Power Center 7.1.1, OWB, ODI, Sql developer.