SUMMARY:

• Around 8+ years of total IT experience focusing on Data warehousing and ETL process using Informatica.
• SDLC: 8+ years of IT experience in all aspects of analytics/data warehousing. I have been key in delivering innovative database /data warehousing solutions using Informatica tool to the Insurance, Finance and Telecom Industries.
• Databases: 8+ years of experience using Oracle 11g/10g, Teradata,SQL.
• Developed mappings in Informatica to load the data from various sources into the Data warehouse using different transformations like Source Qualifier, Sorter, Expression, Lookup, Aggregator, Update Strategy and Joiner.
• Experience in resolving on - going maintenance issues and bug fixes; monitoring Informatica power center sessions as well as performance tuning of mappings and sessions.
• Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre & post session operations. knowledge of Extraction Transformation and Loading (ETL) processes using IBM WebSphere Data Stage.
• Experience working with software models like Agile, Waterfall methodologies.
• Created AutoSys JIL (BOX, CMD, and FW) Scripts to schedule ETL jobs and Unix scripts
• Experience in working in an onsite-offshore structure and effectively coordinated tasks between onsite and offshore teams.
• ETL Performance Tuning: Broad Experience in ETL tuning, identifying and resolving performance bottlenecks at various levels like sources, targets, mappings and sessions and performance tuning at transformations.
• Understanding of Dimensional Data Modeling using Ralph Kimball Approach, Star/Snowflake Modeling, Data marts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling.
• Superior communication skills, strong decision making and organizational skills along with outstanding analytical and problem solving skills to undertake challenging jobs. Able to work well independently and also in a team by helping to troubleshoot technology and business related problems.

TECHNICAL SKILLS:

Domain Knowledge: Data Warehousing, Banking & Financial Services and Telecom

Programming: C, C++, SQL, PL/SQL, Unix

ETL/Reporting Tool: Informatica 8.6.1, 9.1.0, Datastage 8.1 Scheduler AutoSys

Tools: & Utilities: TOAD, SQL Developer, FTP, WinSCP, Putty, HP Quality Center, Star Team

Database: Oracle11g/10g, SQL Server

Operating Systems: Windows 9x/2000/XP, Linux/UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Informatica Developer

Responsibilities:

• Worked on ETL processes such as creating Informatica power center mappings using various transformations including Aggregator, Lookup, Joiner, Stored Procedure, Source Qualifier, Expression, Filter, Router, Update Strategy and Union.
• Developed PL/SQL stored procedures & functions for implementing business rules and transformations.
• Used SQL tools like sql developer to run SQL queries to validate the data.
• Developed Workflows to run multiple sessions that are sequential in nature.
• Used parameters and variables at different mappings and sessions.
• Used Debugger to fix errors in the mappings and to check the data flow.
• Partitioned sessions for parallel loading of data into the target tables.
• Executed workflows using pmcmd command.
• Involved in Power Center Change Data Capture (CDC) process to minimize the resources required for ETL processes that deals only with data changes and ensure data synchronicity.
• Used Mapping variables for Incremental Extraction of operational data.
• Optimized the performance of the mappings by various tests on sources, targets and transformations. Identified the Bottlenecks, removed the Bottlenecks and implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Used Informatica features to implement Type I, II changes in slowly changing dimension tables.
• Worked on Migration Strategies between Development, Test and Production Repositories.
• Identified opportunities for business process improvement and initiated efforts to make improvements.
• Assisted in designing test plans, test scenarios and test cases for unit and integration testing.

Environment: Informatica Power Center 9.1.0, Oracle 11g, Teradata,PL/SQL, UNIX, SQL Developer, Putty, WinSCP, Star team, AutoSys, HP ALM

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Extensively used Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Designed and developedMapplets, shortcutsfor faster development, standardization and reusability purposes.
• Worked on ETL processes such as creating Informatica power center mappings using various transformations including Aggregator, Lookup, Joiner, Stored Procedure, Source Qualifier, Expression, Filter, Router, Update Strategy and Union.
• Ensured the correct application of the business rules through data query after the data is loaded into the Data Warehouse.
• Used SQL tools like sql developer to run SQL queries to validate the data.
• Developed Workflows to run multiple sessions that are sequential in nature.
• Used parameters and variables at different mappings and sessions.
• Involved in Power Center Change Data Capture (CDC) process to minimize the resources required for ETL processes that deals only with data changes and ensure data synchronicity.
• Used Mapping variables for Incremental Extraction of operational data.
• Implemented sending of Post-Session Email once data is loaded.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Optimized the performance of the mappings by various tests on sources, targets and transformations. Identified the Bottlenecks, removed the Bottlenecks and implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Used Informatica features to implement Type I, II changes in slowly changing dimension tables.
• Worked on Migration Strategies between Development, Test and Production Repositories.
• Identified opportunities for business process improvement and initiated efforts to make improvements.

Environment: Informatica Power Center 9.1.0, Oracle 11g, AutoSys,Control-M, Unix, TOAD

Confidential, Princeton, NJ

Informatica Developer

Responsibilities:

• Extracted data from flat files and oracle database, applied business logic to load them in the central oracle database.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center.
• Created reusable transformations and mapplets and used them in mappings.
• Used Informatica Power Center for extraction, loading and transformation (ETL) of data in the data warehouse.
• Expertise in planner/designer using mapping, transformations, data validation, oracle data warehouse builder.
• Developed strategies for Incremental data extractions as well data migration to load into the Oracle.
• Implemented slowly changing dimension to maintain current information and history information in dimension tables.
• UsedWorkflow Managerfor Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduling them to run at specified time.
• Usedpre-sessionandpost-sessionscripts for dropping and recreating indexesbefore and after loading data into target table to optimize performance for bulk loading.
• Designed and implemented processes usingParameter file to overridemapping parameter, mapping variables, Workflow Variables, Session Parameters and Source-Target Application Connection parameters.
• Implemented UNIX and Informatica variables to synchronize the development, test, preprod and breakfix and Production environments.
• Involved in production support to resolve the issues and complete the nightly process.

Environment: Informatica Power Center 8.6.1, Oracle 10g, PL/SQL, UNIX, TOAD

Confidential, New York, NY

Informatica Developer

Responsibilities:

• Worked as Offshore ETL Developer.
• Worked with Business analysts and the DBA for gathering requirements and for project coordination.
• Implemented logical and physical data modeling with STAR schema techniques.
• Performance tuning of Informatica sessions for large data files has been done by increasing the block size, data cache size, and sequence buffer length.
• Worked on Informatica - Source Analyzer, Mapping Designer and transformations.
• Extensively used Normal Join, Full Outer Join, Master Outer Join, Detail Outer Join in the Joiner Transformation.
• Responsible for analyzing and comparing complex data from multiple sources Worked on debugging using session Log messages.
• Used Informatica Power Center Workflow manager for session management, and scheduling of jobs to run in batch process.
• Worked on database connections, SQL joins, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.

Environment: Informatica Power Center 8.6.1, Oracle 10g, PL/SQL, UNIX, TOAD

Confidential, San Antonio, TX

ETL Developer

Responsibilities:

• Offshore ETL Developer.
• Datastage job design and development, which involved extensive use of different stages and Transformations.
• Implementation of Sequences, Coded Main Sequence that calls all the individual jobs that is created.
• Actively involved in Analysis, Design, Development, Unit Testing, System Testing and Implementation.
• Prepared Design, UTC, STC and deployment document.
• Involved in Rejection recovery and reconciliation process
• UNIT testing and System testing of ETL codes.
• Acquired the knowledge of business process flow.
• UNIX shell scripting and scheduling the Datastage jobs.

Environment: IBM Datastage 8.1, Oracle 10g, UNIX, Star Team, Putty, Toad