PROFESSIONAL SUMMARY:

• 7 years of IT experience in Data Warehousing technology and Database in all phases of Software Development Life Cycle SDLC including Business Requirement Analysis, Application designing, Development, Implementations and Testing of Data warehousing and Database business systems for Retail, Healthcare, Financial, Insurance domains.
• 6.5 years of experience in designing and development of ETL Methodology using Informatica Power Center9.5/9.0.1/8.x/7.x.
• 7 years of experience in working with ORACLE 11g/ 10g/ 9i/ 8i.
• 2 years of Experience in Designing ER Dimensional Data Models using ERWIN 7.2/4.5, ORACLE Designer.
• 1 years of experience in Change Data Capture CDC Methodology using PowerExchange 9.0/8.x.
• 2 years of experience in Teradata utilities like MLOAD, FastLoad.
• Interacted with end-users and functional analysts to identify and develop Business Requirement Document BRD and transform it into technical requirements.
• Worked extensively in design and analysis of Requirements, Development, Testing and Production support.
• Worked on documentation of requirements, Testdata, DatamovementschemaandMapping between applications.
• Extensive knowledge of Informaticatuning and SQL/PL SQL tuning.
• Experience in integration of various data sources like Oracle, SQLserver and sequentialfiles into stagingarea.
• Conducted System, UAT and Functionality testing and investigated software bugs.
• Created and modified UNIXShell Scripts for ETL jobs.
• Extensive experience with Data Extraction, Transformation, and Loading ETL from Multiple Sources.
• Worked on data integration from various source files such as flatfiles, CSV files, RelationalDatabases etc. into a common analytical DataModel.
• Production support experience. Extensive understanding of Production issues and Data issues.
• Excellent communicationskills, ability to communicate effectively with different levels of management, strong analytical, problem solving skills.
• Working experience in Agile and Waterfall methodologies.
• Designed and developed complex mappings Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy from varied transformation logics in Informatica.
• Experience in Debugging and Performance tuning of targets, sources, mappings and sessions in Informatica.
• Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets and PL/SQL stored procedures.
• Extensively used Slowly Changing Dimension SCD technique in business application.
• Conducted Unit tests, Integration tests and Customer Acceptance tests UAT .
• Expertise in OLTP/OLAP System Study, Analysis, E-R modeling.
• Developing Database Schemas like Star schema and Snowflake schema used in relational,dimensional and multidimensional modeling.

SKILL SET:

PROFESSIONAL EXPERIENCE:

Confidential

Role: Informatica Developer

Role Responsibility:

• Gathered report requirements with BusinessUsers and converted them into projectdocumentation.
• Arrived at the dimension model of the OLAPdata marts inERwin.
• Optimized/Tuned mappings for better performance and efficiency. Performance tuning of SQLQueries, Sources, Targets and sessions.
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management. Understand the business needs and implement the same into a functional database design.
• Maintain Development, Test and Production mapping migration Using Repository Manager. Alsoused Repository Manager to maintain the metadata, Security and Reporting. Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Worked on System Analysis Design of process/data flow.
• Worked on Teradata SQL and Utilities like MLOAD, FASTLOAD.
• Populating the business rules using mappings into the target tables.
• Translated the PL/SQL logic into Informatica mappings. Extensively Worked on Database stored procedures and views.
• Configured Informatica Real time workflows to capture CDC.
• Locate data rapidly with flexible object filtering techniques to reduce errors and speed development with a point-and-click interface using PowerExchange.
• Implemented optimization techniques for performance tuning and wrote Pre Post session shell scripts.
• Used Workflow manager to create and configure workflow and sessiontask to load data. Used Informatica workflow monitor to create, monitor workflow in case of process failures. Performed testing as per UTC.
• Created Informatica PowerExchange Data Map and Registration on Mainframe source files and tables and importing them to Informatica shared folder.
• Configured the sessions using workflow manager to have multiple partitions on source data and to improve performance.
• Involved in end-to-end systemtesting, performance and regressiontesting and data validations.
• Worked on Data Extraction, Transformations, Loading, Data Conversions and Data Analysis.

Environment: Informatica PowerCenter9.5/9.1, Power Exchange 9.5/9.1, Teradata 13, Oracle 11g, Erwin 8, Putty, Sun Solaris.Rally, Basecamp, WinSCP, and SCM.

Confidential

Role: Informatica Developer

Role Responsibility:

• Designed and developed mappings, mapplets and sessions from source to target database using Informatica PowerCenter.
• Worked with various file formats like fixed length and delimited.
• Used Debugger extensively to validate the mappings and gain troubleshooting information about data and error conditions.
• Developed various mappings using Mapping Designer and worked with Source qualifier, aggregator, connected unconnected lookups, Filter transformation, and sequence generator transformations.
• Extensively used Informatica to transfer data from different source system and load the data into the target database.
• Extracted the data from the flatfiles and other RDBMS databases into stagingarea and populated onto Data Warehouse.
• Developed number of complexInformaticamappings, mapplets and reusabletransformations to implement the business logic and load the data incrementally.
• Used Debugger to track the path of the source data and to check the errors in mapping.
• Handled slowly changing dimensions of Type 1 and Type 2 to populate current and historical data to dimensions and facttables in the Data Warehouse.
• Developed Informatica mappings by usage of aggregator, SQL overrides in lookups, source filter and source qualifier and data flow management into multiple targets using router transformations.
• Extensively involved in performance tuning of the ETL process by determining the bottlenecks at various points like targets, sources, mappings, sessions or systems. This led to a better sessionperformance.
• Document the process for further maintenance and support. Worked on test cases and use cases.

Environment: Informatica PowerCenter8.6, SQL Server 2008, Oracle 11g, UNIX, Sun Solaris, Harvest, Remedy, Jira, Putty, Winscp, BaseCamp, Erwin 8.5, Toad.

Confidential

Role: ETL Developer

Role Responsibility:

• Interacted with business community and gathered requirements based on changing needs and incorporated identified factors into Informatica mappings to build Data Marts.
• Designed and developed complex mappings using Mapping Designer to load data from various sources.
• Extensively created mapplets for reusable business rules.
• Used Pipelinepartitioning and ExternalLoader to improve Sessionperformance, createdindicatorfiles for event drivensessions.
• Used the updatestrategy to effectively load data from source to target.
• Involved in Data Quality Assurance, created validation routines, unit test cases and test plan.
• Created tasks, workflows and worklets using workflowmanager.
• Used pmcmd to run workflows and Autosys to automate their schedules.
• Involved in identifying bugs in existingmappings by analyzing the data flow, evaluating transformations and fixing bugs so that they conform to the business needs.
• Handled Incrementalloading using mappingvariables and Implemented versioning of folders in the Informatica Designer tool.
• Used Parameter files to specify DB Connection parameters for sources.

Environment: Informatica Power Center 8.1, Business Objects XI, Oracle 10g, PL/SQL, SQL Plus, SQL Server 2000, XML files, UNIX Shell Scripting, Windows NT/2000. Teradata V2R6.

Confidential

Role: Informatica Developer

Role Responsibility:

• Gathering business and technical requirements for the project.
• Participating in business/technical discussions to understand the report requirements, which involve client's technical team to help us understand existing, design.
• Designing reporting environment database based on the reporting technical requirements.
• Develop technical design documents and mappings specifications to build Informatica Mappings to load data into target tables adhering to the business rules.
• Involved in Data Modeling using Star/Snowflake Schema Design, Data Marts, Relational and Dimensional Data Modeling, SlowlyChangingDimensions, Fact and Dimensional tables, Physical and Logical data modeling using Erwin.
• Hands on experience with Complex mappings from varied transformation logics like Connected and UnconnectedLookups, Router, Aggregator, Joiner, UpdateStrategy and many more.
• Involved in migration of objects in all phases DEV, QA and PRD of project.
• Maintain existing code and fixbugs.

Environment: Informatica PowerCenter 7.5Oracle 10g, Toad, DB2, UNIX Shell Scripting, Flat Files, Microsoft Office