SUMMARY

• Energetic, composed, motivated ETL developer with a passion for innovation, learning and technology.
• 7 + years of strong experience in ETL methodology for data transformation using Informatica PowerCenter 7.x - 9.x and ITSM.
• Participated in all phases of the System development life cycle with emphasis on project management, Business requirement analysis, Test Planning and execution. Strong interpersonal and communication skills with proficiency at grasping new concepts quickly and implementing the same productively.
• Extensive experience in Informatica (9.x) applications. Designed and developed the Workflows, Worklets, Mappings, Mapplets, Sessions, Tasks, Transformations and schedule the Workflows and Sessions.
• Interacted with end-users and functional analysts to identify and develop Business Specification Documents (BSD) and transform it into technical requirements.
• Strong experience with Informatica tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations Developer and Informatica Repository.
• Designed and developed complex mappings to move data from multiple sources into a common target area such as Data Marts and Data Warehouse using lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Normalizer, Sequence Generator and Update Strategy from varied transformation logics in Informatica.
• Having strong hands on experience in extraction of the data from various source systems ranging from Mainframes like DB2, Flat Files, VSAM files, etc. to RDBMS like Oracle, SQL Server etc.
• Extensively used Slowly Changing Dimension (SCD) technique in insurance application. Expertise in OLTP/OLAP System Study, Analysis, E-R modeling, developing Dimensional Models using Star schema and Snowflake schema techniques used in relational, dimensional and multidimensional modeling.
• Worked on optimizing the mappings by creating re-usable transformations, Mapplets and Store procedures. Created debugging and performance tuning of sources, targets, mappings, transformations, sessions and Store procedures.
• Exposure in overall SDLC including requirement gathering, data modeling (Erwin), development, testing, debugging, deployment, documentation, production support.
• Experience in Task Automation using UNIX Scripts. Extensively used AUTOSYS, Control M for Job monitoring and scheduling.
• Excellent analytical, problem solving and communication skills with ability to interact with individuals at all levels.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9.x/8.xDatabase Oracle 10g/ 9i/ 8i, SQL Server and DB2

DB Tools: SQL*Plus, TOAD, SQL Loader

Environment: WINDOWS 7,XP/2000, UNIX and OS390

Languages: SQL, PL/SQL, UNIX

Reporting Tools: MS Office Suite

Drafting Tools: Microsoft Visio and Erwin

Scheduling Tools: AUTOSYS, ControlM and Lotus Notes

Other Tools/Utilities: HP Quality Center, AQT, Managing IS and CAFM (File master)

PROFESSIONAL EXPERIENCE:

Confidential, Smithfield, RI

Senior Informatica Developer

Responsibilities:

• In Agile Methodology, supporting and enhancing functionalities of Centralized DB involving sources like Oracle, SQL, DB2 and Flat files
• Played role of analyst for preparing design document for the various models and interacted with data modelers on regular basis to design data model and design.
• Responsible for thorough testing of release management’s source code and migration of the same through various environments.(Dev, SIT, UAT)
• SPOC for performing checkout and to provide sign off on major infrastructure upgrades like Control M upgrade from 6.0 to 7.1.
• Involved in building the ETL structures, Sources - Target mapping, mapplets, re-usable objects to load data into Data warehouse.
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level for Slowly Changing Dimensions Type1, Type2 for Data Loads.
• Designed and developed efficient Error handling methods and implemented throughout the mappings. Responsible for Data quality analysis to determine cleansing requirements.
• Responsible for development work includes enhancement to existing Mappings and development of new Workflow, Mappings, Store procedures from requirements to testing and implementation.
• Have worked through complete life of development cycle that involves documentation of version controls.
• Performed scheduled loading and clean ups and Monitored troubleshoots batches and sessions for weekly and Monthly extracts from various data sources across all platforms to the target database
• Responsible for Performance Tuning to avoid bottlenecks at source and target level and Store procedure. Worked very closely with QA and DBA team signoffs and approval.
• PoC for data related queries and business rules clarification. Involved in Data analysis and troubleshooting of production incidents.
• Extensively involved in Test case review, Unit and UAT testing and data analysis of the source files.
• Collaborated and communicated with various stake holder like technical developers and architects onbusinessrequirements for new processes as well as enhancements to existing systems
• Prepared Use cases and assist UAT testing for new businessprocesses and enhancements. Working collaboratively with team from different geographical locations.

Environment: Informatica Power Center 9.1, Workflow Manager, Workflow Monitor, Oracle 10g/9i, ControlM, Linux, Shell Scripts, SQL

Confidential, Stamford, CT

Senior Informatica Developer / Business Analyst

Responsibilities:

• Responsible for handling development and production support of FDR (Financial Data Repository).
• Responsible for requirement gathering and development work includes enhancement to existing Mapping / Cubes and development of new Workflow and Mappings from requirements to testing and implementation.
• Worked on complex Mappings, Mapplets, Workflow, Triggers and Store procedures to meet the business needs with varied sources like Excel, SQL and PeopleSoft (Flat files). Ensured they are reusable transformation to avoid duplications.
• Actively involved in testing and migration of Informatica of 7.x to 9.x and conversion of Autosys scheduling jobs from version 4.5 to 11.
• Responsible for Performance Tuning to avoid bottlenecks at source and target level and worked very closely with DA team and performance engineering team signoffs and approval.
• PoC for all data related queries and business rules for FDR, CCR and WFA systems. Extensively involved in Data analysis and troubleshooting of production discrepancies and incidents.
• Job monitoring, scheduling, Migrations are part of my responsibilities.
• Prepared Unit/ Systems Test Plan and the test cases for the developed mappings.
• Was working collaboratively with offshore team.
• Worked closely with QA team for test data gathering and preparation for provided business requirement.
• Involved in writing use cases and UAT cases for enhancements.

Environment: Informatica PowerCenter, Oracle, Microsoft Office Suite, Flat files, SQL, Windows XP and AUTOSYS

Confidential

ETL Developer / System Analyst

Responsibilities:

• Created analysis of source systems, business requirements and identification of business rules.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica PowerCenter in Claim systems
• Worked on complex mappings, mapplets, workflow and Store procedures to meet the business needs ensured they are reusable transformation to avoid duplications.
• Extensively used of ETL to transfer and extract data from source files (Flat files and DB2) and load the data into the target database.
• Involved in gathering of the business requirements, manage changes to the existing business requirements, extensive use of issue logs and requirement traceability matrix for change management
• Documented Mapping and Transformation details, user requirements, implementation plan and schedule.
• Extensively used Autosys for Scheduling and monitoring
• Worked with several facets of the Informatica PowerCenter tool - Source Analyzer, Data Warehousing Designer, Mapping & Mapplet Designer and Transformation Designer. Development of Informatica mappings for better performance.
• Prepared Unit/ Systems Test Plan and the test cases for the developed mappings.
• Responsible for team members’ work assignment and tracking.
• Performed the Offshore business/rules analyst role in Business Analysis Group of Aviva Auto-INS group..
• Create business requirement documents, functional requirements document and involved in agile development methodology

Environment: Informatica PowerCenter, Oracle 9i, Flat files, PL/SQL, DB2, SQL, Erwin, TOAD 7.0, Windows XP, Managing IS, Lotus Notes, OS390 and Autosys

Confidential

Business Process Associate / ETL Specialist

Responsibilities:

• Analyzed the source system and involved in designing the ETL data load.
• Developed/designed Informatica mappings by translating the business requirements.
• Worked in various transformations like Lookup, Joiner, Sorter, Aggregator, Router, Rank and Source Qualifier to create complex mapping.
• Implemented documentation standards and practices to make mappings easier to maintain.
• Extensive SQL querying for Data Analysis and wrote, executed, performance tuned SQL Queries for Data Analysis & Profiling. Extracted business rule and implemented business logic to extract and load SQL server using T-SQL.
• Involved in automating retail prepaid system process. Created packages and dependencies of the processes.
• Identified common issues in Cognos and published in Wiki page. Established Dashboards and Business reports.
• Created support, maintaining, enhancing and developing new interfaces for Claim warehouse application.
• Used Autosys for scheduling various data cleansing scripts and loading processes; maintained the batch processes using UNIX Scripts.
• Monitor & troubleshoot batches and sessions for weekly and monthly extracts from various data sources across all platforms to the target database.
• Tuned Informatica mappings to ensure source / target bottlenecks and expressions were removed to increase the throughput of the data loads.
• Involved in Gap analysis to differentiate requirements with actual output and documenting same for further enhancements.
• Participated in all phases of Business Analysis

Environment: Informatica PowerCenter, Oracle 10g, PL/SQL, MS SQL Server, DB2, Cognos, Autosys, and Quality Center