SUMMARY

• 8 years of experience in IT with strong background in Data Warehousing and Business Intelligence concepts.
• Exposure to various domains like Healthcare, Telecom, Banking, Finance and Retail Industry.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Requirement Analysis, Design, Development, Testing and Deployment.
• Having good knowledge on Relational Database Management System (RDBMS) concepts.
• Experience in Data Extraction, Transformation and Loading data using Informatica PowerCenter 9.5.1/9.1/8. x.
• Extensively worked on tools like Informatica PowerCenter Admin console, Repository Manager, Workflow Manager, Workflow Monitor and Designer which consists of Mapping Designer, Transformation Developer, Mapplet Designer, Source Analyzer and Target Designer.
• Experience in designing complex mappings using different transformations like Source Qualifier, Update Strategy, Expression, Sequence Generator, Aggregator, Filter, Joiner, Java, Router, Connected Lookup, Unconnected Lookup, Normalizer, Rank, XML, Sorter, Transaction Control, Union and Unstructured Data Transformation.
• Experience in processing Structured data from different sources like Flat files (Delimited files and Fixed width files), XML, Mainframe Cobol/VSAM files, Oracle, SQL server, DB2 and Teradata.
• Experience is processing Unstructured data using Informatica B2B Data Transformation Studio.
• Worked on Workflow Manager by creating Workflows, Worklets, Reusable Tasks like Sessions, Command, Email and Non - Reusable tasks like Decision, Event Wait and Event Rise.
• Having good experience in performance tuning at database level and Informatica level. Have effectively used Performance tuning techniques like Pushdown Optimization (PDO) and session partitioning.
• Experience in managing or implementing the Slowly Changing Dimensions (SCD) Type 1, Type 2 and Type 3.
• Experience in profiling the data and standardizing the data using Informatica Data Quality(IDQ).
• Have effectively used Informatica Developer and Informatica Analyst tool.
• Extensively worked on transformations like Standardizer, Labeler, Parser, Case Convertor, and Address Validator.
• Worked on different databases like Teradata, Oracle, DB2 and SQL Server.
• Good Knowledge on Teradata utilities like FastLoad, Multiload and BTEQ scripts.
• Good Knowledge of PL/SQL 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 and Workflow manager.
• Have Experience in extracting the data from the Oracle GoldenGate and Oracle Exadata.
• Experience in writing Simple/Complex SQL Queries using Sub queries and multiple table joins using left, right, inner joins.
• Having experience in using the Informatica command line utilities like INFACMD, PMCMD and PMREP.
• Having good knowledge on Informatica Administration topics.
• Experience in UNIX Shell Scripting and batch scripting for parsing files.
• Having good work experience in Core Java.
• Having hands on experience in Cognos and BO reporting tools.
• Having good exposure to Agile Methodology, like attending the Sprint planning meeting, Sprint Closure or backlog meetings and Scrum calls.
• Having good exposure to Onshore and Offshore kind of projects like attending the offshore calls, getting the status and updating the status to onshore counterpart.
• 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.0.1, 9.1 and 9.5, Informatica Developer, Informatica Analyst

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

Scripting Languages: Unix Shell scripting.

Operating Systems: Unix,WindowsXP/7.

Utilities: FastLoad, Multiload, Bteq.

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

PROFESSIONAL EXPERIENCE

Confidential, Bellevue, WA

Senior Informatica Developer

Responsibilities:

• Interacted with Business teams to understand the requirements and translated them into appropriate technical solutions.
• Attended the sprint planning meetings and provide the estimations for each and every user story.
• 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.
• Profiling the data using Informatica Analyst tool and updating it to the business on the values and getting the appropriate Domain values.
• Standardizing the possible domain values using the reference tables in the developer tool and integrating them with the PowerCenter.
• 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 BO 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.
• 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, Informatica Developer, Informatica Analyst, Oracle 11g, Teradata v13, Fastload, UNIX, Control-M, Toad, HPQC, Teradata SQL Assistant, SQL Server, DB2, XML Viewer, BO.

Confidential, Hartfort, CT

Senior Informatica Developer

Responsibilities:

• Created Technical specification documents based in the desing documents.
• Created Source Definitions and Target Definitions for relational tables.
• Connecting to Oracle GoldenGate and extracting the data from the source.
• 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.
• 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, Tivoli, Putty, HPQC, SQL Server, DB2, Cobol files, XML.

Confidential, Minneapolis, MN

Informatica Developer

Responsibilities:

• Understanding the Client Requirements and design & functionality of the system by viewing the Design documents.
• Analyze impacts to the existing system and provide estimate.
• 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 Warehouse.
• 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.
• Have implemented the iterative logics with the help of Java code.
• Have worked extensively in core java and having good hands on advanced java concepts.
• 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 Warehouse 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 Oracle tables.
• 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.
• Guide the fellow resources to in meeting the project dead-lines.
• Supporting the users during the UAT phase of the application and fixing the issue.
• Attending the Daily & weekly status calls and updating the status of the Project and Team to the client from offshore.

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

Confidential

Programmer Analyst

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 through 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

Software Engineer

Responsibilities:

• Understanding the Client Requirements and design & functionality of the system by viewing the Design documents.
• Involved as team member in coding and understanding the problem.
• 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.
• Attending the Daily & weekly status calls and updating the status of the Project and Team to the client from offshore.

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