SUMMARY

• Over 7+ years of IT experience in Software Development, with specialization in Data Warehousing using Informatica and Oracle based Client server computing
• Experienced in developing ETL Mappings, Mapplets, Workflows, Worklets using Informatica Power Center 9.6.1/9.5.1/9.1/8. x
• Experienced in all activities related to the development, implementation, testing and Production support of ETL processes for large - scale data warehouses using Informatica Power Center.
• Extensive ETL experience using Informatica Power center client tools (Designer, workflow manager, workflow monitor and server manager).
• Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, OLTP Data Modeling and Data warehousing concepts (Star Schema and Snow Flake Schema).
• Experience in integration of various data sources like Oracle, SQL server, MS access and non-relational sources like flat files into staging area.
• Varied experience in Designing and developing the complex mappings by using various Transformations like Source Qualifier, Joiners, Aggregator, Routers, Filters, Expressions, Lookups, Sequence Generators, Update Strategy etc.
• Hands on experience on several key areas of Enterprise Data Warehousing such as Change Data Capture (CDC), Slowly Changing Dimensions (SCD Type I and Type II).
• Having good expertise in migrating various Informatica power center mappings and sessions from one version to another.
• Strong experience in performance tuning, debugging and Error handling of mappings, sources and targets for better performance, also identified and fixed the bottlenecks.
• Experienced in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations. Expert in using debugger in Informatica Designer tool to test and fix errors in the mappings.
• Ability to write complex SQLs needed for ETL jobs and analyzing data, and is proficient and worked with databases like Oracle, SQL Server and MS Access.
• Good experience in creating and using Stored Procedures, Functions, Triggers, Views and packages in Oracle database
• Experience in creating Reusable Mapplets, Worklets used event wait, Event raise, Decision box and Command tasks in Workflows.
• Experienced in UNIX work environment, file transfers (FTP, SFTP), job scheduling and error handling.
• Hands on experience on UNIX shell scripts for Informatica pre & post session operations.
• Experienced in Scheduling the workflows using Data warehouse administration console(DAC) Scheduler
• Experienced in Performance Tuning of sources, targets, mappings, transformations and sessions.
• Experienced in scheduling the workflows using Control-M Scheduling tool.
• Production Support experience using Control-M Scheduler and HP Service Manager.
• Experienced in developing Test Plans, Test Strategies and Test Cases for Data Warehousing projects ensuring the data meets the business requirements.
• Knowledge in Preparing migration document to move the mappings from development to testing and then to production repositories.
• Experienced on production support and code migration from DEV to Prod environment
• An excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills, hardworking and high level of motivation. A quick learner with an aptitude for taking responsibilities.
• Excellent skills in understanding business needs and converting them into technical solutions.

TECHNICAL SKILLS

Operating Systems: UNIX Sun Solaris, Windows 2008/2003/XP

Database Platforms: Oracle 10g/11g, Teradata,DB2,SQL Server,Ms Access

Programming Skills: PL /SQL,UNIX shell scripting, PLSQL

ETL Tools: Informatica Power Center 9.6, 9.5, 9.1, 9.0

Scheduling Tools: Control-M, TWS

Web Technologies: HTML, JavaScript, CSS

Ticketing tools: BMC remedy, HPSM

PROFESSIONAL EXPERIENCE

Confidential, Kansas City

Informatica Developer

Responsibilities:

• Involved in requirement gathering from the business users and converted them into mapping documentation.
• Designed the Mapping Technical Specifications on the basis of Functional Requirements.
• Worked closely with the BI (Business Intelligence) Reporting team to make sure reporting data requirements were accommodated into the Data warehouse.
• Developed ETL programs using Informatica to implement the business requirements, Using Agile Scrum Model
• Designed and developed ETL mappings to load, transform data from source to Target using Informatica Power Center 9.6.1.
• Created ETL mappings using Informatica Power Center to move Data from multiple sources like Flat files, Oracle into a common target area such as Staging, Data Warehouse.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Hands on experience on UNIX shell scripts for Informatica pre & post session operations.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Pre and post session assignment variables were used to pass the variable values from one session to other.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Experience scheduling of ETL jobs using Control-M scheduler.
• Involved in unit testing, peer review.
• Involved in team meetings with Data Modelers, Data Architects and Business Analysts to analyze and resolve the modeling issues and to discuss requirements.
• Involved in in production support and code migrations from DEV to SIT, SIT to UAT and UAT to PROD migrations.

Environment: Informatica Power Center 9.x, Oracle 11g, Windows 2008 Server, SQL*PLUS, UNIX, TOAD.

Confidential, Atlanta,GA

Informatica Developer & Production Support Analyst

Responsibilities:

• Manage incoming tickets and requests for the EDW and Query HPSM queues.
• Review priority and work on tickets appropriately, monitor progress, and ensure timely updates thru satisfactory resolution within SLA
• Supported Welcome season, Major Releases, Shakeout, and escalated/incidents/requests.
• Work with Teradata DBA to manage long running and CPU intensive queries to run the Teradata environment smoothly
• Identified areas for continued improvement and provided appropriate solutions to address the issues
• Collaborate with SME and DEV team to ensure issues are addresses appropriately.
• Provide approvals for the design and Test result documents for the upcoming releases.
• Ability to handle simple to complex technical requests from initial triage to completion.
• Monitoring batches in TWS monitoring tool and check the logs for the failures to fix.
• Involved in the development backend code, altered tables to add new columns, Constraints, Sequences and Indexes as per business requirements.
• Perform DML, DDL Operations as per the Business requirement.
• Resolved production issues by modifying backend code as and when required.
• Used different joins, sub queries and nested query inSQLquery.
• Involved in creation of sequences for automatic generation of Product ID.
• Testing of code functionality using testing environment.
• Involved in migration projects tomigrate datafrom data warehouses on Oracle/DB2 toTeradata.
• Scripted SQL to create Views on top of tables, based on user and/or reporting requirements
• Worked on ETL tool like Informatica to load data to Teradata by making various connections to load and extract data to and from Teradata efficiently.
• Worked on the complete software development life cycle (SDLC) process.
• Performance tuned and optimized various complex SQL queries.
• Documented, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• Extensively worked on TWS (Tivoli) tool for monitoring production batches and implementing new schedules in production after UAT test.
• Wrote UNIX shell scripts for loading landing/stage table from file and file movement jobs from incoming to data directories and also for different job purposes.
• Ability to innovate and come up with simple automation process for production job failures.
• Assist leadership in minimizing and managing escalations.

Environment: Teradata SQL Assistant, Teradata, Oracle 11g, Outlook, Putty, HPSM, Tivoli, SQL*PLUS, UNIX, TOAD, Informatica Power Center 9.5.1

Confidential, Dallas,TX

Informatica Developer

Responsibilities:

• Created and Imported/Exported various Sources, Targets, and Transformations using Informatica Power Center, Repository Manager and Designer.
• Developed various Mappings with the collection of all Sources, Targets, and Transformations.
• Involved in End to End Data flow design in ETLInformaticamappings.
• Created several complexInformaticamappings, Mapplets depending on client requirements. Extensively worked on Connected & Unconnected Lookups, Router, Expression, Source Qualifier, Aggregator, Filter, and Sequence Generator.
• Created Reusable Mapplets in the Mapplet Designer and used in different Mappings.
• Designed and developed Informatica Mappings, Reusable Sessions, Worklets, Workflows, Dynamic Parameter files.
• To get optimal performance, used parameter files and mapping parameter, Variables in mappings and session variables in workflows.
• Provided solutions for various performance bottle necks in Informatica Mappings.
• Extracted Data from Oracle Database, Flat Files - Performed necessary data calculations and Loaded into the Target tables.
• Implemented the SCD Type 2 concept for the inserts and updates on the Slowly Changing Dimensions in Data Warehousing using Update Strategy Transformation.
• Documented the ETL, Mapping process for future reference.
• Used Workflow Manager to schedule and run batches, sessions, as well as to check session logs and other session related activities.
• Responsible for Error handling, bug fixing, Session monitoring and log analysis.
• Involved in unit testing, UAT testing and integrated testing of entire process flow.
• Worked on DAC to create subject areas, task groups, and included new customized tasks to configure, monitor and schedule ETL routines based on the requirements.

Environment: Informatica Power Center 9.x, Oracle 11g, Windows 2008 Server, SQL*PLUS, UNIX, TOAD.

Confidential

Informatica Developer

Responsibilities:

• Actively involved in the successful implementation from end-to-end on GL module (financial analytics) with Custom Subject Areas and developed the reporting functionality.
• Involved in analyzing the data models of legacy implementations, identifying the sources for various dimensions and facts for different data marts according to star schema design patterns.
• Developed complex mapping using Source qualifier, Aggregators, Connected & unconnected lookups, Filters & Update strategy.
• Extensively used Various Data Cleansing and Data Conversion Functions in various transformations.
• Used Debugger to validate transformations by creating break points to analyze, and monitor Data flow.
• Tuned performance of Informatica Session by increasing block size, data cache size, sequence buffer length and Target based commit interval, and mappings by dropping and recreation of indexes.
• Worked along with the QA Team and provided production support by monitoring the processes running daily.
• Defined Target Load Order Plan for loading data into Target Tables.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Implemented slowly changing dimensions methodology and developed mappings to keep track of historical data
• Written SQL overrides in Source Qualifier and Lookups according to business requirements.
• Involved in troubleshooting the loading failure cases, including database problems.
• Responsible for Documentation of the Test cases, completed modules and the results of acceptance testing.

Environment: Informatica Power Center 8.1, Oracle 9i, Flat Files, Windows XP, TOAD,XML.

Confidential

Responsibilities:

• Used Workflow Manager to load data from different sources (Oracle, Text files) to the target database, which was Oracle.
• Imported various Sources and Targets, created Transformations using Informatica Power Center 8.1 Designer.
• Designed and developed Informatica Mappings and Sessions based on requirements and business rules to load data from source flat files and Relational target tables.
• Used transformations like Connected and Unconnected lookups, Aggregator, Expression, Update, Router and Sequence generator, Sorter.
• Used joiner transformation to extract data from different tables.
• Did performance tuning at source, transformation, target, and workflow levels.
• Developed and scheduled Workflows using task developer, Worklet designer and monitored the results in Workflow monitor.

Environment: Informatica Power Center, SQL*PLUS, Power Connect, PL/SQL, UNIX, TOAD