SUMMARY

• Overall 7+yrs of experience in software design, development, maintenance, testing and troubleshooting on ETL/DWH applications.
• Experience in development of Data warehousing solutions using Informatica Power Center 10.2/9.5/9.0.1 (Workflow Manager, Workflow Monitor, Repository Manager, Designer - - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, and Transformation Developer)
• Working knowledge on different data sources such as Flat files, Oracle, SQL Server and Excel files.
• Experience in Data Warehouse development working with Data Migration, Data Conversion, and Extraction/Transformation/Loading using Informatica Power Center with Oracle, SQL Server, Teradata.
• Strong knowledge in Data warehousing concepts like Star schema, Snowflake schema methodologies.
• Well Experienced in doing Error Handling and Troubleshooting using various log files.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experienced in Performing Unit testing, system testing, regression testing, smoke testing and system integration testing.
• Developed shell scripts for invoking Informatica workflows.
• Involved in Informatica Performance tuning of the ETL process and SQL tuning.
• Experienced in Full Life Cycle Development of building a Data Warehouse for large technology projects including Analysis, Design, Development, Testing, Maintenance and Documentation.
• Experience in optimization techniques such as concurrent caching, auto memory calculations and using push down optimization.
• Vast experience in Designing and developing complex mappings from varied transformation logic like Source Analyzer, Warehouse Designer, Mapping Designer - data transformation and mapping issues, Mapplets, Transformations, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Java, SQL etc.
• Experience in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema, which are used in relational, dimensional and multidimensional modeling.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements.
• Solid understanding of OLAP concepts and challenges, especially with large Data Management sets.
• Worked extensively on Data Analysis, Data Validation, Data Cleansing, and Data migration
• Expertise working on slowly changing dimension type1and type2
• Having knowledge and experience in Change data capture (CDC) using Informatica Power Centre.
• Excellent Communication and interpersonal skills. Ability to quickly grasp new concepts, both technical and business related.
• Experience to create Use Cases, Activity diagrams, functional specifications.
• Extensive experience in formulating error handling mechanism in problem management.
• Experience in implementing High availability architecture for data warehouse components which include Informatica and reporting metadata components.
• Work independently or cooperatively in a team, eager to learn, ability to grasp quickly.
• Worked with Dimensional Data warehouses in Star and Snowflake Schemas, Slowly changing dimensions in Change management and created slowly growing target mappings, Type1/2/3 dimension mappings.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions
• Strong exposure to working on scheduling tools like Informatica schedular, AutoSys and Tidal.
• Experienced in Performing Unit testing, system testing, regression testing, smoke testing and system integration testing
• Good interpersonal skills, experience in handling communication and interactions between different teams
• Experience includes thorough domain knowledge of Health Care, Telecom, Retail, Pharma and Insurance Industry.

TECHNICAL SKILLS

Dataware Housing Tools: Informatica Power Center 9.5/8.6/9.1,Talend open studio 5, Metadata Reporter Data Profiling, Data cleansing, OLAP, OLTP, Star Snowflake Schema, FACT & Dimension Tables, Physical & Logical Data Modeling.

BI Tools: Cognos 10

Databases: SQL Server 2008/2005, Oracle 11g/10g/9i, MS-AccessScripting Languages: Java, XML,COBOL,PL/SQL,UNIX Shell Scripting Environment

Operating Systems: Windows XP/NT/2000

Scheduling tools: Autosys, Tidal, Informatica Schedular.

DB Programming Tools: RDBMS, Joins, Indexes, Views, Functions, Triggers,Clusters, Procedures, Export/Import, TOAD,SQL Server.

PROFESSIONAL EXPERIENCE

Confidential - Deerfield, IL

Informatica Developer / Production Support

RESPONSIBILITIES:

• Monitor the jobs in Optimize load and full load in Monthly, Daily, Hourly, Weekly and track issues using session log.
• Extracted the data from the flat files, to RDS, staging, facts and Dimensions, Raptor and vertex schemas.
• Monitoring the jobs using scheduling tool and troubleshoot batches and sessions for weekly and Monthly extracts from various data sources across all platforms to the target database.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels using PDO, Pass through partition.
• Support team in various performances related issues.
• Create documentation in MPP and screen shots as per the jobs run.
• Used Workflow Manager for creating and maintaining the Sessions.
• Also used Workflow Monitor to monitor, edit, schedule, copy, aborts and delete sessions.
• Provided detailed technical, process and support documentation like daily process rollback and detailed specifications and very detailed document of all the projects with the workflows and their dependencies.
• Monitored and improved the performance of Sources, Targets and Mappings.
• Documented the Sources, Targets and Mappings.
• Resolve the issues and enhance the changes based on the priority levels in to environments.
• Worked with Tidal team to implement real-time scheduling for transactional ETL processes designed for batch loading.
• Worked with QA team to find and fix bugs in mappings.
• Defect handling after code migration to production.
• Work with testing and quality, production support teams to meet implementation dates and allow smooth transition throughout the development life-cycle.
• Creation of ETL logic for Error Handling and calculation of load statistics in ETL process along with building Informatica mappings, sessions, workflows, and other various reusable Informatica objects (Mapplets & reusable transformations).
• Monitor the jobs in production during warranty period, providing KT to support team and prepare necessary documentation.
• Performing automation of existing processes.

Environment: Informatica 10.2, Talend, Oracle, Unix, SQL Developer, Putty, Toad, Tidal, Talend open studio 5.2

Confidential - Nyc, NY

Informatica ETL Developer

RESPONSIBILITIES:

• Understanding requirements and preparation/review Mapping Document and technical specification documents.
• Extract the current DM and CDW applications information and load data to EDW Tables using Informatica 9.1 ETL Tool. .
• Remove the existing flat files as source and read the data directly from SAP Tables using Informatica 9.1 and load data to EDW Tables.
• Extensively used Informatica Designer to design, develop ETL jobs for extracting, transforming and loading the data
• Created new workflows, sessions, mappings to extract the information from SAP sources and load data into EDW and CDW Tables.
• Worked extensively with Parameters and Variables, Pre SQL/Post SQL and Emails in converting the current applications
• Written Unix Shell Scripts to execute the existing and updated workflows.
• Developed complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to extract the information from SAP Source to CDW Oracle Tables
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Creating new workflows and sessions for EDW Conversion and executing the designed jobs using Tidal Scheduler.
• Developed Test Cases according to Business and Technical Requirements and prepared SQL scripts to test data.
• Generated the mapping and workflow specifications as a part of the post-code technical transformation document.
• Involved in Unit testing, Integration testing, UAT and deployment of workflows. Moved code across Development, Test and Production Repositories.
• Monitoring of application batch processes to ensure successful completion of jobs.

Environment: Informatica Power Center 9.1, Netezza 7.0, SQL Server 2005/2008, Oracle 11g, PL/SQL, SAP, Flat files, UNIX Shell Scripts, Tidal Scheduler.

Confidential - Harrisburg, PA

Informatica Developer

Responsibilities:

• Develop the Informatica mappings for converting the data from Legacy systems(ADAPT and CHAMPS) to VACMS(target systems)
• Responsible for testing the mappings as per the rules of transformations and validations and ensure that the mappings do the transformation as and created test cases for the mapping in legacy systems.
• Developed Mapplets and user defined functions for reusability.
• Develop store procedures for converting the data according to the conversion plan tool.
• Scheduling daily, weekly and monthly loads for the managers according to the business specs.
• Create test data and unit test cases for the unit testing, check whether the data is correctly loaded or not as per the requirements.
• Performed Unit Testing and Integrated testing for the mappings .
• Involved to gather requirements to create logical modeling and physical model documentation
• Migrating the data from different environments like Development to production for creating shortcuts and by creating deployment groups.
• Developed mappings as per the business validation rules and Business rules.
• Created scheduling of jobs in Workflow Manager to trigger tasks on a daily, weekly and monthly basis.
• Wrote shell scripts to join or concatenate target files, to delete or remove one or more such files if not needed.
• Monitored the production loads and fixed them, when necessary.
• Involved in the Performance Tuning of Informatica servers and other legacy databases.
• Worked with the reporting team as well to create detailed report.
• Develop the mappings for converting the data from VSAM to Flatfiles in staging
• Created effective Test Cases and involved in designing the ETL testing strategies for functional, integration and system testing for Data warehouse implementation.
• Worked with the End Users directly and performed user acceptance testing.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.

Environment: Informatica Power Center 9.5, Oracle11g, Windows XP, SQL Server 2000,SQL, PL/SQL, Crystal reports, UNIX Shell Scripts, Flat files, CSV files.

Confidential - Titusville, NJ

Informatica Developer

RESPONSIBILITIES:

• Understand the Requirements and Functionality of the application from specs
• Involved in the development of Informatica mappings and tuned existing mappings for better performance.
• Develop required Unix shell scripts to automate ETL processes.
• Responsible for testing the mappings and ensure that the mappings do the transformation as proposed.
• Develop Check list & SOP’s of all developed processes in JNJ required templates.
• Developed Mapplets and Worklets for reusability.
• Created mappings using different transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, data masking and Sequence Generator etc.
• Involved in Unit Testing, create test cases to check whether the data loads into target.
• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Scheduling daily, weekly and monthly loads for the managers according to the business specs.
• Develop workflows, sessions used command task in workflow manager.
• Configure the Driving tables according to the variation of data and maintain CSV documents as per that.
• Developed Informatica mappings for TYPE 2 Slowly Changing Dimensions.
• Creating sessions and work-flows for the Informatica mappings.
• Improved the Informatica Mappings and Session performance by eliminating extensive cache usage transformations, increasing commit interval and calculating the cache sizes appropriately.
• Configuring sessions for different situations including incremental aggregation, pipe-line partitioning etc.
• Migrated Informatica code from Dev to QA and QA to Production environments.
• Involved in writing Oracle stored procedures and functions for calling during the execution of Informatica mapping or as Pre or Post session execution.
• Performance Tuning, partitioning, Parallelism, Push-Down Optimization techniques were implemented to improve the through put.
• Documented Mappings, Transformations and Informatica sessions.
• Created effective Test Cases and involved in designing the ETL testing strategies for functional, integration and system testing for Data warehouse implementation.
• Worked with the End Users directly and performed user acceptance testing.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Performed tunings of mappings, sessions for optimum performance
• Performed Unit Testing and Integrated testing for the mappings created.
• Used Business Objects to create various reports.
• Assisting Reporting team in designing Monthly and Daily Universes.

Environment: InformaticaPower Center 9.1, Oracle 11g, SQL Server 2008, Micro strategy, Mainframes VSAM, Flat Files, UNIX, PL/SQL, Business Objects, UNIX, Shell Scripting, Windows, TOAD 9.0, Agile,Autosys.

Confidential - Reston, VA

Jr. Informatica Developer

Responsibilities:

• Developed Informatica ETL mappings and workflows.
• Designed and developed Informatica mappings for data loads and data cleansing. Extensively used many of the transformations of Informatica including
• Resolved Logical, Design Errors in mapping with the help of Debugger and different Log files.
• Involved in Unit Testing By Using Unix.
• As the project had a crunching timeline we had work overtime but were successful in meeting the deadline.
• Effectively communicated with Informatica Support team and BAs on Informatica bugs & issues.
• Design and implement error Handling Strategy, Performance Monitoring and Tuning
• Business Induction to new team Members
• Used the Slowly Changing Dimensions - Type II in various mappings.
• Used debugger to test the data flow and fix the mappings.
• Create and secure a Data Warehouse environment to improve data quality and end user access controls
• Create Informatica Mappings, using transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Joiner, Union and Normalizer
• Create Sessions and Workflows.
• Create Defect Logs and PDIM
• Instantiate a set of common reports
• Responsible for creating user groups, privileges to the users using repository manager
• Involved in Unit Testing By Using UNIX.
• As the project had a crunching timeline we had work overtime but were successful in meeting the deadline.
• Developed Fast Export scripts to send data files to other teams.
• Developed mappings which load data mart data into SQL SERVER.
• Designing and creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter using CDC.
• Implemented Performance tuning in Mappings and Sessions by identifying the bottlenecks and Implemented effective transformation Logic.
• Maintain Development, Test and Production mapping migration using Repository Manager.
• Involved in enhancements and maintenance activities of the data warehouse including performance tuning.
• Experience in analyzing the reporting requirement.
• Created AutoSys schedules/jobs for automation of ETL load process.
• Involved in Unit Testing, data masking,User Acceptance Testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Preparing and using test data/cases to verify accuracy and completeness of ETL process.
• Actively involved in the Production support and also transferred knowledge to the other team members.
• Worked on performance tuning of various mappings and session to identify and remove the bottle necks.
• Logged the bugs in test directory and coordinated with other team member in resolving the issues.
• Validated all the applications and run the workflow using Workflow Manager.
• Created events and tasks in the workflows using work flow manager.
• Performed tunings of mappings, sessions for optimum performance
• Performed Unit Testing and Integrated testing for the mappings created.
• Used Business Objects to create various reports.
• Assisting Reporting team in designing Monthly and Daily Universes.
• Project review meetings, Status Reporting, Issue tracking.

Environment: InformaticaPowerCenter9.1.1, Oracle11i, UNIX, Windows XP, Flat Files, Autosys, Teradata, Business Objects,TOAD