SUMMARY:

• Around 8 Years of IT Experience in Tourism, Financial, Insurance industries with broad knowledge on data integration, data migration, data quality and data modeling.
• Experience in using Informatica Power Center 9.6.1./ 9.5.1/9.1/8.6.1 .
• Extensive experience in IT Industry involving Software Analysis, Design, Implementation, Coding, Development and Testing with focus on Data warehousing applications using Informatica ETL tool.
• Understood the overall business requirements, created the design for data integration from disparate source systems.
• Participated in business requirements verification and validation ensuring that all projects are consistent with strategic architecture.
• Involved in performance testing of ETL development, applied different performance optimization techniques.
• Consulted business stakeholders to evaluate interface between legacy &Target Systems, performance analysis, risk mitigation and resolve problems.
• Knowledge of different DW Methodologies, Schemas (Star and Snow Flake) to fit reporting, query and business analysis requirements.
• Involved in designing the data model using Erwin.
• Extensively used Informatica Client tools like Designer, Workflow Manager, Workflow Monitor, Repository Manager and Server tools - Informatica Server, Repository Server
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and Union.
• Experience in resolving on-going maintenance issues and bug fixes.
• Extensively used SQL to validate the data.
• Good Knowledge on PL/SQL Scripts like Stored Procedures, Functions, Packages and Triggers.
• Excellent communication, interpersonal and analytical skills.
• Quick learner and adaptive to new and challenging technological environments.

TECHNICAL SKILLS:

ETL TOOLS: Informatica Power Center 9.6.1./ 9.5.1/9.1/8.6.1

RDBMS: SQL Server, Oracle 11g, Oracle 10g, Netezza

Data Modeling: Star-Schema Modeling, Snowflake Modeling, Fact and Dimension Tables

DESIGN TOOLS: Erwin

DB TOOLS: Toad, SQL* Loader

OPERATING SYSTEMS: MS-DOS, HP UNIX, Windows 2010/2000/XP/Vista

SCHEDULER TOOLS: TIDAL 5.3.X, Control-M

PROFESSIONAL EXPERIENCE:

Confidential, LOS ANGELES, CA

Till nowInformatica Developer

Roles and Responsibilities:

• Analyzed information to determine, recommend and plan GDPR project and designed technical specification document to meet the business process.
• Acquired and interpreted business requirements, created technical specifications, and determined the most efficient/appropriate solution design, thinking from an enterprise - wide view.
• Worked in the Data Integration Team to perform data and application integration with a goal of moving data more effectively, efficiently and with high performance to assist in critical business projects coming up with huge data extraction.
• Built components to synchronize data between legacy and Oracle systems, data migration between Oracle Apps to DWH.
• Worked with Functional Consultants, Business users for analyzing and mapping the existing Legacy System Data to Oracle.
• Designed and developed jobs which load delta records into target system.
• Designed and developed one-time load batch jobs to meet business requirements
• Modified existing mappings for enhancement of new business requirements.
• Performed data manipulation using Informatica Transformations like Joiner, Aggregator, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router etc.
• Used Informatica features to implement Type I & II changes in slowly changing dimension tables.
• Prepared migration document to move the objects from development to testing and then to production repositories.
• Involved in Data Quality Testing and Data validation.
• Used debugger to test mapping and fixed the bugs.
• Optimized/Tuned mappings for better performance and efficiency.
• Worked on identifying Bottlenecks and improved session performance accordingly.
• Extensive experience in troubleshooting and solving migration issues and production issues.

Environment: Informatica Power Center 9.6.1, Db2, Oracle 11g, Flat files, Unix shell scripting, Tidal 5.3.X, Toad, OBIEE.

Confidential, Phoenix, AZ

Informatica Consultant

Roles and Responsibilities:

• Prepared Technical Specifications for the mappings.
• Designed the ETL processes using Informatica to load data from Oracle and Flat Files.
• Modified and tuned existing mappings as per new changes.
• Worked with peers from various functional areas for code reviews, unit test documentation and knowledge sharing sessions.
• Performed data manipulations using various Informatica Transformations like Source Qualifier, Normalizer, Filter, Connected Lookup, and Unconnected Lookup, Update strategy, Router, Aggregator, Sequence Generator and Reusable sequence generator transformation.
• Implemented Change data capture (CDC) using Mapping Variable Concept.
• Extensively used SCD's (Slowly Changing Dimension) to handle the Incremental Loading for Dimension tables and Fact tables.
• Exported the mappings/sessions/worklets/workflows from Dev Repository to Test Repository after duly testing all transformations and vice versa to modify existing content.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent sessions and scheduling them to run at specified time with required frequency.
• Involved in improving performance of the Server Sessions by identifying and eliminating the Performance Bottlenecks.
• Worked on Performance Tuning to optimize the Session performance by utilizing, Partitioning, Index Cache, Data Cache and incremental aggregation.
• Written post session shell scripts to FTP files to Mantas platform.

Environment: Informatica Power Center 9.6.1(Domain, Services, Repository Manager, Designer, Workflow Manager, Workflow Monitor, Repository Administration Console), Oracle, Netezza, Toad, Delimited Flat Files, Autosys, Micro Strategy, UNIX Shell Programming.

Confidential, New York, NY

Informatica developer

Roles and Responsibilities:

• Involved in business analysis and technical design with business and technical staff to develop requirement document and ETL specifications.
• Involved in the detailed database design document which included data estimates, entity relationship (ER) diagrams, dimensional model (Snowflake schema) using Erwin, MS Office and MS Visio.
• Extensively Used Informatica Designer as an ETL tool to extract data from Source systems to Target systems.
• Participated in multiple meetings with data architect / ETL architect to propose better strategies for performance improvement.
• Extracted data from multiple operational sources for loading into Data warehouse, Data Marts using SCD's (Type 1 and Type 2) loads.
• Created ETL Mappings, sessions and workflows using Informatica Power Center to move Data from multiple sources like XML, SQL Server, and Oracle into a common target such as Data Marts and Enterprise Data warehouses. Used direct and indirect flat files as source of data.
• Extensively used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner (all type of joiner), Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Mart and Enterprise Data Warehouse.
• Extensively used parameter file to pass mapping and session variables and parameters.
• Tuned performance of sessions and mapping. Identified source and target bottlenecks, transformation error, and resolve the problem, used Push down Optimization to tune performance.
• Developed unit test cases for mapping and data validations.
• Involved and assisted in Unit and Integration testing.
• Worked with pmcmd command line program to communicate with the Informatica server, to start, stop and schedule workflows.

Environment: Informatica Power Center 9.5.1, Oracle 11g, Flat Files, Win7, Cognos, SQL * Plus, Toad and UNIX.

Confidential, San Diego, CA

Informatica developer

Roles and Responsibilities:

• Redesigned broken ETL processes using Informatica to load data from heterogeneous sources to target database.
• Involved in preparation of technical specs for the mappings.
• Executed Informatica Transformations, Expression, Aggregator, Filter, Update Strategy, and Sequence Generator.
• Extensively worked in the performance tuning of the ETL Procedures and processes.
• Developed SQL overrides in source Qualifier according to business requirements.
• Involved in scheduling of workflows and sessions using Informatica.
• Developed pre - session scripts using UNIX for the activities needed before session runs.
• Scheduled Informatica workflows using cronjobs and Control-M.

Environment: Informatica Power Center 9.1, Delimited Flat Files, Excel Files, Control-M, OLTP, Oracle, SQL, PL/SQL, UNIX Shell Programming, Business Objects.

Confidential

Jr. Informatica Developer

Roles and Responsibilities:

• Developed ETL mappings with Transformations and Loaded data using Informatica Power Center 8.6.1.
• Extracted data from data sources like Oracle RDBMS, MS Excel and Flat files.
• Worked on different types of transformations like source qualifier, expression, filter, aggregator, update strategy, Lookup, sequence generator, joiner, Stored Procedure.
• Worked on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.
• Developed and tested all the Informatica mappings, sessions and workflows - involving several Tasks.
• Analyzed the session, event and error logs for troubleshooting mappings and sessions.
• Provided support for the applications after production deployment to take care of any post-deployment issues.

Environment: Informatica 8.6.1, UNIX shell scripting, Oracle 10g, SQL Programming, MS Excel, SQL *Plus.