PROFESSIONAL SUMMARY:

• Software Professional with 10+ Years of IT experience in Data Warehousing (Business Intelligence) Development, Design, Enhancement, Migration, Testing Projects 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.
• Knowledge on Hadoop ecosystem such as Hive, Python, Scala, Flume, Sqoop, Zookeeper, SPARK, Kafka, Impala.
• 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 warehouse techniques - efficient data integration, source data profiling, data cleansing.
• 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.
• Experience in data profiling & data quality rules development using Informatica Data Quality (IDQ) tools
• 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.
• Knowledge in Data warehousing tools like Power Exchange, Power Analyzer, Informatics Data Quality (IDQ) and Informatics Data Explorer (IDE).
• Experience on basic Informatica administration tasks such as creating folders, users, granting permissions, optimizing Informatica server settings, configuring Informatica repository and installation on the server, etc.
• Experience on Installing and configuring Informatica components on Windows environment.
• Collaborated with Developers during Unit testing and debug Informatica Jobs.
• Focuses on delivering business solutions. Have strong technical skills, Self-starter and ability to adapt and learn and picks up new technologies fastly.
• Demonstrates leadership skills and motivates the team for increased productivity. Have good communication, interpersonal and presentation skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.6.1/8.6.1/8.1.1 Informatica Analyst 9.5.1(IDQ), Informatica Developer 9.5.1Mapping Architect Visio (MAV), Oracle Data Integrator 11.x (ODI)

Reporting Tools: Business Objects XI 3.x, OBIEE 10.1.3.4, and SSIS

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

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

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr. ETL Informatica Developer/Analyst

Responsibilities:

• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica.
• Performed data cleansing and transformation using Informatica
• Monitored the ETL jobs/schedules and responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor..
• Tuned Informatica mappings and sessions for optimum performance.
• Assisted the other ETL developers in solving complex scenarios and coordinated with source systems owners with day-to-day ETL progress monitoring.
• Provided reliable, timely support of integration, performance and user acceptance testing processes.
• Involved in performance tuning of mappings, transformations and (workflow) sessions to optimize session performance.
• Worked with export and import utilities in Repository manager.
• Involved in migrating Informatica ETL application objects through various environments such as Development, Testing, and UAT (SIT).

Environment: Informatica Power Center 9.6.1, Oracle 11g, Cobol Files, XML files, Flat files (.csv and .dat file - fixed-width or delimited), Oracle SQL Developer 4.0,Unix, Putty, WinSCP, Autosys

Confidential, Denver, CO

DW ETL - Analyst & Developer

Responsibilities:

• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse
• Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g) by incorporating business rules using different objects and functions that the tool supports.
• Created Complex mappings using Unconnected, Lookup, and Aggregate and Router transformations for populating target table in efficient manner.
• Created source to target mappings, edit rules and validation, transformations, and business rules. Analyzed client requirements and designed the ETL Informatica mapping.
• Scheduled and Run Workflows in Workflow Manager and monitored sessions using Informatica Workflow Monitor.
• Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor.
• Validated and tested the mappings using Informatica Debugger, session logs and workflow logs.

Environment: Informatica Power Center 9.5.1, Oracle 10g (Toad, Oracle, SQL Developer), UNIX, Putty, ESP Scheduler, HPSM Scheduler

Confidential, Bridgewater, NJ

DW ETL - Analyst & Developer

Responsibilities:

• ETL design and development, Creation of the Informatica mappings, sessions and workflows to implement the Business Logic.
• Used Workflow Manager to create session task and other tasks.
• Scheduled and Run Workflows in Workflow Manager and monitored sessions using Informatica Workflow Monitor.
• Used debugger to test the mapping and fixed the bugs.
• Analyzing the dependencies between the jobs and scheduling them accordingly using the Work Scheduler.
• Imported metadata from different sources such as Relational Databases, XML Sources
• Improved the performance of the mappings, sessions using various optimization techniques.
• Scheduled and Run Workflows in Workflow Manager and monitored sessions using Informatica Workflow Monitor.
• Validated and tested the mappings using Informatica Debugger, session logs and workflow logs.

Environment: Informatica Power Center 9.6.1, Metadata, Oracle 10g (Toad, Oracle SQL Developer), UNIX (SSH-Secure File Transfer)

Confidential, Atlanta, Georgia

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.
• Developed interfaces to load the data from flat files.
• Conducted code reviews and planned the knowledge transfer to client.

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

Confidential, Beaverton, OR

DW ETL - Analyst & Developer

Responsibilities:

• 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.
• Designed and developed Informatica DQ Jobs, Mapplets using different transformation like Address validator, matching, consolidation, rules etc for data loads and data cleansing.
• Preparation of technical specification for the development of Extraction, Transformation and Loading data into various stage tables.
• Created transformations and mappings using Informatica Power center to move data from multiple sources into targets.
• Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
• Scheduled and Run Workflows in Workflow Manager and monitored sessions using Informatica Workflow Monitor.
• Validated and tested the mappings using Informatica Debugger, session logs and workflow logs.

Confidential, Lake Forest, IL

DW ETL - Analyst & Developer

Responsibilities:

• 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.
• Designed and developed Informatica DQ Jobs, Mapplets using different transformation like Address validator, matching, consolidation, rules etc for data loads and data cleansing.
• Preparation of technical specification for the development of Extraction, Transformation and Loading data into various stage tables.
• 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.
• Validated and tested the mappings using Informatica Debugger, session logs and workflow logs.

Environment: Informatica Power Center 9.5.1, Informatica Data Quality 9.5.1(IDQ), Informatica Developer 9.5.1, Oracle 10g (Toad), UNIX (SSH Secure Shell Client)

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.
• Extract data from multiple sources, integrate disparate data into a common data model, and integrate data into a target database, application, or file using efficient ETL processes
• Created scripts using Fast Load, Multi-Load to load data into the Teradata data warehouse.
• Identifying Bugs and reporting defects.
• Scheduled and Run Workflows in Workflow Manager and monitored sessions using Informatica Workflow Monitor.
• Collaborate with Quality Assurance resources to debug ETL development and ensure the timely delivery of products.

Environment: Informatica Power Center 9.5.1, Informatica Data Quality 9.5.1(IDQ), Informatica Developer 9.5.1, Oracle 10g, DB2, Teradata V2R6, UNIX (WinSCP, Putty)

Confidential

ETL Informatica Developer

Responsibilities:

• Preparation of technical specification for the development of Extraction, Transformation and Loading data into various stage tables.
• 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.
• Developed Unit test cases and Unit test plans to verify the data loading process.
• Created documents for data flow and ETL process using Informatica mappings to support the project once it implemented in production.
• Created debugging sessions before the session to validate the transformations and also used existing mappings in debug mode extensively for error identification by creating break points and monitoring the debug monitor.

Environment: Informatica Power Center 8.6.1, Informatica Power Exchange CDC, Power enter Mapping Architect for Visio (MAV), Oracle 10g, BO XI 3.1, Toad, UNIX.

Confidential, Jacksonville, FL

DW ETL - Analyst & Developer

Responsibilities:

• 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.
• Preparation of technical specification for the development of Extraction, Transformation and Loading data into various stage tables.
• 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.
• Exposure to on-shore and off-shore support activities.
• Developed Unit test cases and Unit test plans to verify the data loading process.

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.
• 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

Confidential, Stamford, Connecticut

ETL Developer

Responsibilities:

• Involved in resolving 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.
• Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor.
• 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, Oracle 9i, Teradata 12.6, TOAD, Redwood Cronacle, UNIX

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

Environment: Informatica Power Center 8.1.1, Oracle 9i, TOAD, OBIEE, UNIX