Professional Summary:

• Around 7 Years of Professional experience in Data Warehousing ETL Technologies using Informatica power center Client tools – Designer, Work Flow Manager, Work Flow Monitor and Repository Manager.
• Handled Production Support, Development and Off-Shore status meetings simultaneously.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server and Worked on integrating data from flat files like fixed width and delimited.
• Extensive experience in extraction, transformation and loading of data from different heterogeneous source systems like flat files and Oracle.
• Worked for Low Level Design Document, ETL Design Document, and ETL Templates.
• Proficient in ETL design using ETL tool like Informatica power center 7x/8x/9x and hands on Experience with Data Extraction, Transformation and Loading.
• Good Knowledge of Principles of Data warehousing with Sound Expertise on Informatica suite and Oracle (SQL).
• Hands on experience with mappings from varied transformation logics like Connected and Unconnected lookups, Router, Aggregator, Joiner, Update Strategy and re-usable transformations.
• Knowledge on TWS (Tivoli Workload scheduler) System for Scheduling.
• Process Oriented and have excellent Understanding of SDLC process, have ability to learn things quickly and implement.
• Extensively used ETL methodology for supporting Data Extraction, transformation and loading, in a corporate-wide-ETL Solution using Informatica.
• Have also worked in an Onsite – Offshore model have carried out the different phases of the projects effectively by excellent co-ordination activities.
• Excellent problem solving skills with strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet deadlines and work under pressure.

Technical Skills:
ETL Tools : Informatica Power Center 7.x/8.X/9.X
Database Tools : TOAD, SQL Developer
Language : SQL and UNIX shell scripting
Operating systems : Windows 98/2000/XP/7, UNIX and LINUX
Database : Oracle 9i, 10g & 11g, SQL Server 2005 and DB2
Automation Tools : TWS (Tivoli Workload Scheduler)

Professional Experience:
Confidential,WA Feb-2012 to Till Date
Role : Senior ETL developer
Responsibilities:

• Involved in Requirement Analysis, ETL Design and Development.
• Developed complex Reformat mappings to reformat from Property Source (flat files) System to pre-staging, from pre-staging to staging and staging area to Production DB.
• Used Informatica Power Center Workflow manager to create sessions and workflows to run the logic embedded in the mappings.
• Created different transformations like Source Qualifier, Expression, Router, Filter, Lookup, Sequence Generator, Normalizer transformations for loading the data into the targets.
• Wrote complex SQL scripts to avoid Informatica joiners and Look-ups to improve the performance as the volume of the data was heavy.
• Wrote shell scripts to ensure e-mails sent to respective people on Failure/Success, error handling, control/auditing of different processes.
• Worked with Memory cache for static and dynamic for the better throughput of sessions containing Lookup, Joiner, Sorter and Aggregator transformations.
• Prepared documentation for business data flow from source to targets and also for the changes made to the mappings/sessions existing to eliminate the errors.
• Responsible for migrating project between environments (Dev, Test, QA, Prod) and also between Operating systems using Static Deployment and Labelling.
• Coordinate with onshore business team and offshore development team to implement the project.
• Debugging and Unit testing.
• Perform data validation tests using complex SQL statements

Environment : Windows 7, Informatica Power Center 9.0.1, Linux, DB2, Toad, Tivoli scheduling

Confidential, GA Sep-2010 to Nov-2011
Role : Senior ETL developer
Responsibilities:

• Worked closely with business analysts to plan, design and development and implement the ETL requirements.
• Developed mappings using various transformations like Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Update Strategy, and Sequence generator transformations.
• Developed mappings and workflows that process large volumes of data.
• Worked on different tasks like sessions, event wait, decision, e-mail, command, worklets, Timer and scheduling of the workflow.
• Prepared the validation scripts to compare the new data with the legacy system.
• Assisted and involved in performance tuning of long running jobs.
• Involved with the Architects in finalizing the load sequence of the created ETL objects.
• Deployed ETL code to multiple environments like QA and PRODUCTION.
• Performed Unit Testing on all the developed mappings.
• Extensively used debugger to analyze the bugs and defect fixes to meet the business requirements.
• Created Deployment Plan, Operational and Maintenance plan to help support the Production deployment.
• Used Track Plus tool effectively for issues and tasks tracking.
• Effectively used version control.
• Provided support for project related Informatica processes in PRODUCTION environment.

Environment: Windows XP, Power Center 8.6/9.0, UNIX, SQL Server 2005, Oracle 10g, Toad and Harvest version control

Confidential,NJ Jan-2009 to Aug-2010
Role : ETL Developer
Responsibilities:

• Involved in analysis, design and development to ensure the successful execution of the data loading process.
• Used Pre and Post Session SQL to drop and recreate the indexes.
• Tuned Informatica Mappings and Sessions to enhance the performance
• Have worked on testing and gathering statistics and monitoring the run times for the performances and fixing it.
• Involved in data quality analysis to determine cleansing requirements designed and developed Informatica mappings for data loads.
• Developed shell scripts to run Informatica workflows using PMCMD command.
• Prepared documentation in relation to detailed work plans and mapping documents.
• Involved in migrating Informatica mappings and workflows to version 8.1.
• Worked on creating reusable functions and transformations.
• Prepared validation scripts for Unit testing.
• Scheduling, Monitoring and debugging of Informatica Sessions and Workflows in Tivoli Scheduler.
• Creating deployment groups to move the code to QA and production environments.
• Performed qualitative and quantitative tests to validate the data as part of Unit testing.
• Involved in production support.

Environment: Windows XP, Power Center 7.1/8.1, UNIX and ORACLE 10g, SQL Developer

Confidential,India May-2006 to Dec-2008
Role : Junior ETL Developer
Responsibilities:

• Analysis of existing Source System, Business Flow & Target System using given Functional Document.
• Designed the Mappings according to the Mapping Design Document.
• Worked on all the Transformations like Lookup, Aggregator, Expression, Filter, Update Strategy (Implemented slowly changing dimensions Type1 and Type2), Sequence Generator, Sorter and Router.
• Involved in the Code review and fixing problems during Code review
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed. Debugged the mapping of the failed sessions.
• Optimizing/Tuning mappings for better performance and efficiency.
• Used Pre and Post Session SQL to drop and recreate the indexes.
• Debugging and Unit testing of Informatica mappings.

Environment : Informatica 7.1, Oracle 9i, Windows XP, Linux, SQL Developer, Microsoft VSS