SUMMARY

• Around 7.7 Years of IT experience in Data Warehousing (Business Intelligence) Development as an ETL Developer using Informatica.
• Experience in Information Technology Industry with strong technical and functional domain knowledge (Finance, Healthcare, Insurance, Banking, Corporate and Transportation) in Informatica and DWH.
• Experience in ETL/DWH Project Design, Development, Implementation, Testing, support, Upgrade and Maintenance using Informatica Power Center 9.x/8.x/7.x. and Oracle.
• Actively interacting with client throughout the project to make sure that the term & condition and the requirements of the clients is fulfilled.
• Implementing Change data capture techniques with slowly growing target, Simple Pass through mapping, slowly changing dimension (SCD) type1 and type2.
• Well experienced in doing Error handling, Troubleshooting using various log files and problem fixing in Informatica as well as the performance tuning and also review of Informatica code & preparing the Unit test case.
• Proficient in Data Warehousing concepts.
• Expertise in Data Warehousing projects using Informatica 9.x/8.x/7.x, Informatica Data Quality (Data Analyst) IDQ 9.5.1, Oracle 10G/9i, Teradata, SQL & PL/SQL.
• Proven skills in all phases within the Star/Snowflake schemas, Reengineering, Dimensional Data modeling, Fact & Dimension tables, Physical & logical data modeling and SDLC in the implementation and maintenance of ETL Processes.
• Extensive knowledge and worked with Informatica Data Quality (IDQ 9.5.1) for data analysis, data cleansing, data validation, data profiling and matching/removing duplicate data in using of Informatica.
• Experienced in loading data into Data Warehouse/Data Marts using Informatica, Teradata Multiload, Fast load and BTEQ utilities.
• Experience on Installing and configuring Informatica components on Windows environment.
• Worked with Team track for managing system change requests and work requests.
• Collaborated with Developers during Unit testing and debug Informatica Jobs.
• Good experience in working with onshore, offshore team and End to End teams to ensure test commitments are met.
• Excellent analytical, presentation, communication & interpersonal skills, multitask with an ability to interact with a wide range of people and enthusiastic in learning new tools and business environment.
• Self - starter and ability to adapt and learn new things quickly.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5.1/8.6.1/8.1.1 Informatica Analyst 9.5.1(IDQ), Informatica Developer 9.5.1Mapping Architect Visio (MAV), ODI 10.1.3.5, BODI 11.7

Reporting Tools: Business Objects XI, Cognos, OBIEE 10.1.3.4, SSIS, Crystal Reports

Databases & Tools: Oracle 9i/10g/11g, Teradata 12.6, MS SQL Server 2000, DB2

Operating Systems: Microsoft Windows 2000/XP/NT, Linux, UNIX

Other Tools: SQL * Loader, Toad, PL/SQL Developer, Teradata SQL Assistant, Erwin r9.2Putty, SSH, WinSCP

Languages: SQL, PL/SQL, UNIX

Scheduling Tools: Cronacle 6.0.2, Autosys, Control-M

Software: MS Office, MS Project, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Lake Forest, IL

DW ETL/IDQ - Analyst & Developer

Responsibilities:

• Worked with business users to get the requirement and to involve in complete SDLC life cycle.
• ETL design and development, Creation of the Informatica mappings, sessions and workflows to implement the Business Logic.
• Created source to target mappings, edit rules and validation, transformations, and business rules. Analyzed client requirements and designed the ETL Informatica mapping.
• Extensive knowledge and worked with Informatica Data Quality (IDQ 9.5.1) for data analysis, data cleansing, data validation, data profiling and matching/removing duplicate data in using of Informatica.
• Created transformations and mappings using Informatica Power center to move data from multiple sources into targets.
• Scheduled and Run Workflows in Workflow Manager and monitored sessions using Informatica Workflow Monitor.

Environment: Informatica Power Center 9.5.1, Oracle 10g (Toad), UNIX (Winscp, Putty)

Confidential, Portland, ME

DW ETL/IDQ - Analyst & Developer

Responsibilities:

• Interaction with IT team of the client for the purpose of requirement gathering, understanding requirements.
• ETL design and development, Creation of the Informatica mappings, sessions and workflows to implement the Business Logic.
• Extensive knowledge and worked with Informatica Data Quality (IDQ 9.5.1) for data analysis, data cleansing, data validation, data profiling and matching/removing duplicate data in using of Informatica.
• Created source to target mappings, edit rules and validation, transformations, and business rules. Analyzed client requirements and designed the ETL Informatica mapping.
• Well acquainted with Performance Tuning of sources, targets, mapping and sessions to overcome the bottlenecks in mappings
• Created transformations and mappings using Informatica Power center & Informatica Developer to move data from multiple sources into targets.
• Scheduled and Run Workflows in Workflow Manager and monitored sessions using Informatica Workflow Monitor.

Environment: Informatica Power Center 9.5.1, Informatica Data Quality 9.5.1(IDQ), Informatica Developer 9.5.1, DB2, MS SQL Server 2000,Teradata SQL Assistant, UNIX (Winscp, Putty)

Confidential, Jacksonville, FL

DW ETL - Analyst & Developer

Responsibilities:

• Worked with business users to get the requirement and to involve in complete SDLC life cycle of RUP.
• Analyzed source data and gathered business requirements from the business users.
• Developed end-to-end ETL processes for RUP.
• Involved in Designing ETL Specification.
• Developed bulk mapping through PowerCenter mapping architect for Visio & MacroExcel.
• Designed and developed Informatica Mappings, and Sessions for data loads and data cleansing.
• Developed complex mappings and SCD type-I, Type-II mappings in Informatica to load the data from sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank, Router and XML transformations.
• Used Workflow Manager to create session task and other tasks.
• Scheduled and Run Workflows in Workflow Manager and monitored sessions using Informatica Workflow Monitor.

Environment: Informatica Power Center 9.5.1, Oracle 10g, BO XI 3.1, Toad, UNIX, Mainframe, PowerCenter Mapping Architect for Visio (MAV)

Confidential, New York, NY

ETL Developer

Responsibilities:

• Analyzed source data and gathered requirements from the business users
• Developed end-to-end ETL processes for US Public Finance.
• Extracting, Transforming and Loading data from Oracle, XML, Flat files and placing it into Data warehouse.
• Worked closely with business analysts to understand the business needs for decision support data.
• Worked on source Analyzer, Designer Mapping and Mapplet Designer and Transformations.
• Used Transformations like Router, Sequence Generator, Expression, Filter and Normalizer Transformations in Mappings.
• Designed and developed Informatica Mappings, Mapplets and Sessions for data loads and data cleansing.
• Used Workflow Manager to create session task and other tasks.
• Used pre-session and post-session scripts for implementing various functionalities.
• Scheduled and Run Workflows in Workflow Manager and monitored sessions using Informatica Workflow Monitor.
• Improved the performance of the mappings using various optimization techniques.

Environment: Informatica Power Center 9.1, Oracle 10g, TOAD, BO XI, UNIX, Autosys, SQL*Loader, PowerCenter Mapping Architect for Visio, Microsoft Office Outlook

Confidential, Fairfield, CT

ETL Developer

Responsibilities:

• Interaction with IT team of the client for the purpose of requirement gathering, understanding requirements.
• ETL design and development, Creation of the Informatica mappings, sessions and workflows to implement the Business Logic.
• Testing and Preparation of the Documents
• Tested data through Informatica Data Validation and Data Profiling
• Monitoring the workflows till the end of loads
• Resolved the issues raised by the user
• Support and Enhancement

Environment: Informatica Power Center 8.6.1, Informatica Data Profiling, Oracle 9i, SQL/PLSQL, TOAD, UNIX

Confidential, Shelton, Connecticut

ETL Developer

Responsibilities:

• Set up the Topology including physical architecture, logical architecture and context.
• Created new models for the data sources - flat files, Oracle.
• Did reverse engineering for the data sources and targets.
• Develop ETL flows and framework to support ETL development
• Development of ETL processes utilizing Oracle Data Integrator
• Developed interfaces to load the data from flat files.
• Conducted code reviews and planned the knowledge transfer to client.

Environment: Informatica Power Center 8.6.1, Oracle 10g, PL/SQL Developer 7.1.3., UNIX, Control-M.

Confidential

ETL Developer

Responsibilities:

• Understanding the Business Requirements culminating in the preparation of the Technical Design Document.
• ETL design and development, Creation of the Informatica mappings, sessions and workflows to implement the Business Logic.
• Developed bulk mapping through PowerCenter mapping architect for Visio & Macro Excel.
• Unit testing.
• Follow Confidential coding techniques.
• Knowledge and understanding of processing data across multiple platforms.

Environment: Informatica Power Center 8.6.1,Informatica Power Exchange CDC, Power enter Mapping Architect for Visio, Oracle 10g, BO XI,SQL, Oracle SQL Developer.

Confidential

ETL Developer

Responsibilities:

• Gather the user requirements by interacting with Client.
• Configure the Data Integrator Job Server, Data Integrator Access Server, and repository usage & Prepare and review the ETL specs as per the design.
• Cleansing data in DI using proper data types and mappings
• Perform simple and complex transformations in Data Flows
• Creating, Testing and Executing Data Integrator jobs using Data Integrator Designer to transfer data from source to target
• Data integrator XI (ETL) in design and implementation of work flows, data flows and DI scripting.
• Debugging execution errors using Data Integrator logs (trace, statistics, and error) and by examining the target data
• Deployment & Production Moves

Environment: Business Objects Data Integrator 11.7, Oracle 9i, BO, SQL/PLSQL, TOAD, Shell Script.

Confidential, Shelton, Connecticut

ETL Developer

Responsibilities:

• Analyzed source data and gathered requirements from the business users.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin
• Developed end-to-end ETL processes for Data Mart
• Extracted source data from flat files (UTF-8 & EBCDIC code page) and XML.
• Worked on source Analyzer, Designer, Mapping and Mapplet Designer and Transformations.
• Used Transformations like Router, Sequence Generator, Expression and Filter Transformations in Mappings.
• Used Joiner, Aggregator, Expression Update Strategy and Lookup Transformation to manipulate data related to Customers.
• Imported various heterogeneous and homogenous sources using Informatica PowerCenter Source Analyzer
• Responsible for Tuning and optimization Informatica mappings and oracle scripts.

Environment: Informatica Power Center 8.1.1, Oracle 9i SQL/PLSQL, TOAD, SAPBW, OBIEE, UNIX, Shell Script.

Confidential, Stamford, Connecticut

ETL Developer

Responsibilities:

• Resolve tickets, including analysis, bug fixes, data reconciliation, end-user testing and signoff, migration of fixes to production using GEHC’s Change Control process.
• Provide the necessary technical application support for the applications in scope.
• Interface with other support teams within GEHC, e.g. Production Support & Monitoring, Architecture, DBA’s etc. as required for application support, design & development, testing and deployment.
• Designed and Created data cleansing, data conversion, validation and External loading scripts like MLOAD and FLOAD for Teradata warehouse using Informatica ETL tool.
• Optimized the SQL and PL/SQL queries by using different tuning techniques like using hints, parallel processing, and optimization rules and using Analyze, Explain Plan and optimizer hints.
• Documentation, Development and Unit testing of enhancements as per GEHC guidelines.
• Scheduled workflows, BTEQ Scripts, UNIX shell scripts using Redwood Cronacle Scheduling tool.
• Report on a weekly basis the status of Clarify Tickets & Enhancements, in a format approved by GEHC RTS Manager.

Environment: Informatica Power Center 8.1.1., Teradata 12.6 (Utilities like BTEQ, Mload), Oracle 9i, Redwood Cronacle, TOAD, UNIX.

Confidential, Fairfield, CT

ETL Developer

Responsibilities:

• Analysis and gathering of the Business Requirements.
• Interaction with IT team of the client for the purpose of business needs and understanding.
• Creating file specs and ETL specification.
• Data load strategy i.e. Insert/Truncate and CDC-technique
• Analyze, design and develop ETL applications and workflows based on business requirements.
• Performed Tuning by identifying and eliminating the bottlenecks occurred for increasing the performance.
• Use Unix-script for trigger the file, dat file check validation, generate the indirect file, create the backup file after loading the into target

Environment: Informatica Power Center 7.1.3, Oracle 9i, Toad, UNIX