SUMMARY

• 8+ years of IT experience with strong background in Data Warehousing and Business Intelligence concepts.
• Exposure to various domains like Health care, Insurance, Banking, Mortgage, Retail Industry and Financing.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving System Analysis, Design, Development and Implementation.
• Good at Relational Database Management System (RDBMS) concepts.
• Experience in Data Extraction, Transformation and Loading data using Informatica Power Center 9.5.1/9.1/8. x.
• Worked on tools like Repository Manager, Workflow Manager, Workflow Monitor, Designer consists of objects like Mapping Designer, Transformation Developer, Mapplet Designer, Source Analyzer and Target Designer, Admin console and Data Administration.
• Experience in designing complex mappings using Source Qualifier, Update Strategy, Expression, Sequence Generator, Aggregator, Filter, Joiner, JAVA, Router, Connected Lookup, Unconnected Lookup, Normalizer, Rank, XML, Sorter, Transaction Control and Union to load data into different target types from different sources like Flat files (Delimited files and Fixed width files) like text files or CSV files, XML, Oracle, Cobol files, SQL server, DB2, Teradata and having good knowledge on Informatica B2B.
• Experience in managing Slowly Changing Dimensions (SCD) Type 1, Type 2 and Type 3, Data Marts, OLAP, OLTP and Change Data Capture (CDC).
• Worked on Workflow Manager by creating Sessions/tasks, Workflows, Worklets, Reusable Tasks like Sessions, Command, Email and Non - Reusable tasks like Decision, Event Wait and Event Rise.
• Knowledge on Data Cleansing, Data Staging, Data profiling, Error Handling, Session log files, Workflow log files and Performance optimization like Pushdown Optimization (PDO), session partitioning, which troubleshoots the bottleneck problems at different levels like source, target, mapping, session and system.
• Worked on different databases like Teradata, Oracle, DB2 and SQL Server.
• Good Knowledge on Teradata utilities like FastLoad, Multiload and BTEQ scripts.
• Having good experience in performance tuning at database level and Informatica level.
• Good Knowledge of Data Warehousing, staging tables, stored procedures, Functions, cursors, Dimension tables, Fact tables, Surrogate Key, Primary keys, Foreign Keys, Star Schema, Snow Flake Schema, Triggers and Normalization/Denormalization.
• Experience in Scheduling Tools like Tivoli, Control-M, Autosys and Workflow manager.
• Good Knowledge of writing PL/SQL procedures.
• Experience in using Oracle Development tools such as Tool for Oracle Application Development (TOAD).
• Hands on experience in writing Simple/Complex SQL Queries using Sub queries and multiple table joins using left, right, inner joins.
• Experience in UNIX Shell Scripting and Windows power shell scripting for parsing files.
• Having a basic knowledge on Cognos.
• Having experience in using the Informatica command line utilities like PMCMD and PMREP.
• Having good knowledge on Informatica Administration topics.
• Having good knowledge on Core Java.
• Good communication skills both verbal and written, hardworking, self-motivated, ability to work independently or co-operatively in a team, eager to learn and ability to grasp quickly.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.1 and 9.5

Database: Teradata 13,Sql Server 2005/2008, Oracle, DB2

Scripting Languages: Unix Shell scripting, Windows power shell scripting.

Operating Systems: Unix,WindowsXP/7.

Utilities: FastLoad, Multiload, Bteq.

Other Tools: Toad, Teradata SQL Assiatant, SQL Developer, Tivoli, Control-M, Autosys, QC, WinScp, TFS.

PROFESSIONAL EXPERIENCE

Confidential, Bellevue, WA

Senior Informatica Developer

Responsibilities:

• Interacted with Business team to understand the requirements and translated them into appropriate technical requirement document.
• Designed the technical specification documents as per the mapping documents, attended the review sessions with ETL Architect, BA team and got the required signoffs.
• Designed mappings using different transformations like Lookup’s (connected, Unconnected, Dynamic), Expression, Sorter, Joiner, Router, Union, Transaction Control, Update strategy, Normalizer, Filter, Rank, Unstructured and Aggregator using Informatica Power center designer.
• Extracted data from different data sources like Oracle, SQL Server, Flat files including Delimited and fixed width text files, XML files and loaded them into the Teradata warehouse.
• Designed the mappings using Slowly Changing Dimension (SCD) Type 1 and Type 2.
• Written complex SQL queries using inner joins, left outer joins, right outer joins and have written PL/SQL stored procedures.
• Worked on Teradata utilities like Fastload, Bteq and Multiload.
• Created and configured workflows, worklets and sessions using Informatica Workflow Manager.
• Written unix shell scripts to dynamically read the source filenames and provide those to the sessions.
• Involved in optimizing the performance by eliminating the Source, Target, Mapping and Session bottlenecks.
• Have improved the performance by effectively using the Pushdown optimization and Informatica partitioning techniques.
• Have written unit test cases and execute those during the unit testing phase.
• Supported the users during the User Acceptance testing phase.
• Scheduled and monitored the jobs using Control-M.
• Closely worked with the Cognos reporting team and helped them to get the data for creating reports.
• Have created deployment groups and promoted the code from Dev to test environment.
• Worked extensively on Customer, Member, Provider and Claims subject area.
• Participated in the code review sessions that are developed by the offshore team.
• Worked on agile methodology, attended the sprint planning meetings and provided the appropriate estimations, attended the sprint closure meetings.
• Attend the daily scrum calls and the client status calls and provide the appropriate status to the entire team.

Environment: Informatica PowerCenter 9.5.1, Oracle 11g, Teradata v13, Fastload, UNIX, Control-M, Toad, HPQC, Teradata SQL Assistant, SQL Server, DB2, Cognos.

Confidential, Minneapolis, MN

Informatica Developer

Responsibilities:

• Interacted with Business team to understand the requirements and translated them into appropriate technical requirement document.
• Designed the technical specification documents as per the mapping documents, attended the review sessions with ETL Architect, BA team and got the required signoffs.
• Designed mappings using different transformations like Lookup’s (connected, Unconnected, Dynamic), Expression, Sorter, Joiner, Router, Union, Transaction Control, Update strategy, Normalizer, Filter, Rank, Unstructured and Aggregator using Informatica Power center designer.
• Used Informatica B2B data transformation to process the unstructured data and converted those into XML files using the parser component.
• Extracted data from different data sources like Oracle, SQL Server, Flat files including Delimited and fixed width text files, XML files and loaded them into the oracle warehouse.
• Designed the mappings using Slowly Changing Dimension (SCD) Type 1 and Type 2.
• Written complex SQL queries using inner joins, left outer joins and right outer joins and have written PL/SQL stored procedures also.
• Created and configured workflows, worklets and sessions using Informatica Workflow Manager.
• Written unix shell scripts to dynamically read the source filenames and provide those to the sessions.
• Involved in optimizing the performance by eliminating the Source, Target, Mapping and Session bottlenecks.
• Have improved the performance by effectively using the Pushdown optimization and Informatica partitioning techniques.
• Have written unit test cases and execute those during the unit testing phase.
• Supported the users during the User Acceptance testing phase.
• Scheduled and monitored the jobs using Control-M.
• Closely worked with the Cognos reporting team and helped them to get the data for creating reports.
• Worked with the Cognos team in validating the sql’s that are generated by the Cognos.
• Have created deployment groups and promoted the code from Dev to test environment.
• Worked extensively on Customer, Member, Provider and Claims subject area.
• Participated in the code review sessions that are developed by the offshore team.
• Worked on agile methodology, attended the sprint planning meetings and provided the appropriate estimations, attended the sprint closure meetings.
• Attend the daily scrum calls and the client status calls and provide the appropriate status to the entire team.

Environment: Informatica PowerCenter 9.5.1, Oracle 11g, UNIX, Control-M, Toad, HPQC, SQL Server, DB2, Informatica B2B data transformation, XML Viewer.

Confidential, Hartford, CT

Informatica Developer

Responsibilities:

• Created Technical specification documents based in the desing documents.
• Created Source Definitions and Target Definitions for relational tables.
• Developed mappings, mapplets, user defined functions, sessions, workflows, worklets, tasks, parameter files with mapping parameters / variables, session parameters and workflow parameters.
• Used Aggregator, Union, Router, Rank, Joiner, Expression, Normalizer Transformations etc in the mappings.
• Involved in Optimizing the Performance by eliminating Target, Source, Mapping, and Session bottlenecks.
• Written PL/SQL stored procedures to handle the complex transformations.
• Generated csv data files to the windows servers using the power shell scripting.
• Done Unit Testing (UT) based on Unit Test Case documents and captured the results.
• Reviewed Test Cases and participated in Code Reviews within the team.
• Attended daily status meetings with the client and use to update the status.
• Coordinated with the offshore team and get the deliverables on time.
• Participated in Offshore Onsite meetings to gather new requirements and change requirements on a regular basis.

Environment: Informatica 9.1, Oracle 10g, Toad, Putty, HPQC, SQL Server, DB2, Cobol files, XML, Unix shell scripting, Power shell scripting.

Confidential, Dallas, TX

ETL Informatica Developer

Responsibilities:

• Involved in translating business requirements to Technical specifications.
• Designed, developed, implemented and maintained Informatica PowerCenter for matching and merging process.
• Work with source system SMEs to identify the source data to be brought down to the Data mart.
• Involved in full project life cycle - from analysis to production implementation and support.
• Extensively used Informatica Client tools - Powercenter Designer, Powercenter Repository Manager, Powercenter Workflow Manager and Powercenter Workflow Monitor.
• Created pre and post session Stored procedures to drop, recreate the indexes and keys of source and target tables.
• Developed the source to target mapping document for ETL development in Informatica.
• Worked Extracted/loaded data from/into diverse source/target systems like Oracle, XML and Flat Files.
• Performed unit testing to ensure data is loaded and mapped correctly to Data mart tables according to the source to target mapping document.
• Designed, developed Informatica mappings using Informatica 9.0.1, enabling the extract, transport and loading of the data into target tables and loading into the Teradata.
• Assist business analysts/users in identifying data gap and data variances.
• Developed ETL procedures to transform the data in the intermediate tables according to the business rules and functionality requirements.
• Create and execute unit test plans based on system and validation requirements, Troubleshoot, optimize, and tune ETL processes.
• Responsible to create interactive Dash board reports as per the Business requirements.
• Documented and maintained and ensured the process and quality of the system.

Environment: Informatica Power center 9.0.1, Teradata, SQL Server, Oracle, DB2, XML, Toad for DB2, Flat Files, Quality Center and UNIX, SQL Server Management studio, Autosys.

Confidential, Charlotte, NC

Informatica Developer

Responsibilities:

• Extensively used Informatica Client tools - Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Flat Files, DB2 and transformed the data as per the mapping document and loaded into the target tables.
• Developed complex mapping using Informatica PowerCenter tool.
• Extracting data from Oracle and Flat file, Excel files and performed complex joiner, Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to load data into the target systems.
• Created Sessions, Tasks, Workflows and worklets using Workflow manager.
• Worked with Data modeler in developing STAR Schemas
• Involved in performance tuning and query optimization.
• Used TOAD, SQL Developer to develop and debug procedures and packages.
• Involved in developing the Deployment groups for deploying the code between various environment (Dev, QA)
• Created pre sql and post sql scripts which need to be run at Informatica level.
• Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
• Used Debugger to fix the defects/ errors and data issues.
• Expertise in using both connected and unconnected Lookup Transformations.
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Monitored and improved query performance by creating views, indexes, hints and sub queries
• Created List, Crosstab, Chart type reports using Business Objects.
• Extensively involved in enhancing and managing Unix Shell Scripts.
• Developed workflow dependency in Informatica using Event Wait Task, Command Wait.

Environment: Informatica PowerCenter, Oracle 10g, SQL Server 2008, MS Access, UNIX, Winscp, Putty, SQL, PL/SQL, Tivoli.

Confidential

Informatica Production support

Responsibilities:

• Deployed the Code to Production environment based on the instructions provided by the development team.
• Monitored the scheduled jobs in production in 24X7 shifts using Tivoli tool.
• Gathered the scheduled run statistics and track it for metrics purpose.
• Fixing the failed jobs, by analyzing the issue using the session log.
• Rerunning of the jobs for those that got failed in the production environment.
• Use to make sure that the production is up and running and used to clean up the unix box that is with unnecessary files.
• Have fixed the minor issues in that comes trough change request.
• Used to tune the user queries for better performance.
• Have written complex SQL’s by using inner, left outer and right outer joins.
• Have attended daily status call and provided the status to the onsite team.

Environment: Oracle 10g, Informatica 8.5, Tivoli, Toad, UNIX, SQL Server, Putty, Winscp.

Confidential

Informatica Developer

Responsibilities:

• Worked with data analyst to know the requirements of the project.
• Worked with various data sources like oracle, flat files, Sybase data coming as customers data and load into Oracle warehouse.
• Involved in designing of Informatica mappings by using transformations like source qualifier, expression, update strategy, router, joiner, connected lookup, unconnected lookup, dynamic lookup, transaction control, rank, sequence generator, Aggregator.
• Implemented Slowly Changing Dimensions (SCD) Type 1 and Type2.
• Created reusable transformations and Mapplets and used them in mappings.
• Worked on shared folders and reusable transformations.
• Worked on UNIX Shell scripting.
• Created PL/SQL procedures for certain Business Requirements
• Designed SQL overrides in source Qualifier according to business requirements
• Created sessions and workflows for designed mappings and created Sequential Workflow using
• Monitoring the session logs to check the progress of data load.
• Supported testing team, UAT team and production team.

Environment: Informatica 8.5, SQL Server, PL/SQL, Sybase, Oracle, Toad, Control-M, UNIX, Putty, TFS.