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. Has TEMPeffectively used Performance tuning techniques like Pushdown Optimization (PDO) and session partitioning.
• Experience in managing or implementing teh Slowly Changing Dimensions (SCD) Type 1, Type 2 and Type 3.
• Experience in profiling teh data and standardizing teh data using Informatica Data Quality(IDQ).
• Has TEMPeffectively 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.
• Has Experience in extracting teh data from teh Oracle GlodenGate 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 teh 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 teh Sprint planning meeting, Sprint Closure or backlog meetings and Scrum calls.
• Having good exposure to Onshore and Offshore kind of projects like attending teh offshore calls, getting teh status and updating teh 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 teh requirements and translated them into appropriate technical solutions.
• Attended teh sprint planning meetings and provide teh estimations for each and every user story.
• Designed teh technical specification documents as per teh mapping documents, attended teh review sessions with ETL Architect, BA team and got teh 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 teh Teradata warehouse.
• Designed teh 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 has 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 teh source filenames and provide those to teh sessions.
• Involved in optimizing teh performance by eliminating teh Source, Target, Mapping and Session bottlenecks.
• Has improved teh performance by TEMPeffectively using teh Pushdown optimization and Informatica partitioning techniques.
• Profiling teh data using Informatica Analyst tool and updating it to teh business on teh values and getting teh appropriate Domain values.
• Standardizing teh possible domain values using teh reference tables in teh developer tool and integrating them with teh PowerCenter.
• Has written unit test cases and execute those during teh unit testing phase.
• Supported teh users during teh User Acceptance testing phase.
• Scheduled and monitored teh jobs using Control-M.
• Closely worked with teh BO reporting team and helped them to get teh data for creating reports.
• Has created deployment groups and promoted teh code from Dev to test environment.
• Participated in teh code review sessions that are developed by teh offshore team.
• Worked on agile methodology, attended teh sprint planning meetings and provided teh appropriate estimations, attended teh sprint closure meetings.
• Attend teh daily scrum calls and teh client status calls and provide teh appropriate status to teh 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 teh desing documents.
• Created Source Definitions and Target Definitions for relational tables.
• Connecting to Oracle GlodenGate and extracting teh data from teh 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 teh mappings.
• Involved in Optimizing teh Performance by eliminating Target, Source, Mapping, and Session bottlenecks.
• Written PL/SQL stored procedures to handle teh complex transformations.
• Done Unit Testing (UT) based on Unit Test Case documents and captured teh results.
• Reviewed Test Cases and participated in Code Reviews within teh team.
• Attended daily status meetings with teh client and use to update teh status.
• Coordinated with teh offshore team and get teh 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 teh Client Requirements and design & functionality of teh system by viewing teh Design documents.
• Analyze impacts to teh 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 teh source data to be brought down to teh 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 teh indexes and keys of source and target tables.
• Developed teh source to target mapping document for ETL development in Informatica.
• Has implemented teh iterative logics with teh help of Java code.
• Has 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 teh source to target mapping document.
• Designed, developed Informatica mappings using Informatica 9.0.1, enabling teh extract, transport and loading of teh data into target tables and loading into teh Oracle tables.
• Assist business analysts/users in identifying data gap and data variances.
• Developed ETL procedures to transform teh data in teh intermediate tables according to teh 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 teh Business requirements.
• Documented and maintained and ensured teh process and quality of teh system.
• Guide teh fellow resources to in meeting teh project dead-lines.
• Supporting teh users during teh UAT phase of teh application and fixing teh issue.
• Attending teh Daily & weekly status calls and updating teh status of teh Project and Team to teh 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 teh Code to Production environment based on teh instructions provided by teh development team.
• Monitored teh scheduled jobs in production in 24X7 shifts using Tivoli tool.
• Gathered teh scheduled run statistics and track it for metrics purpose.
• Fixing teh failed jobs, by analyzing teh issue using teh session log.
• Rerunning of teh jobs for those that got failed in teh production environment.
• Use to make sure that teh production is up and running and used to clean up teh unix box that is with unnecessary files.
• Has fixed teh minor issues in that comes through change request.
• Used to tune teh user queries for better performance.
• Has written complex SQL’s by using inner, left outer and right outer joins.
• Has attended daily status call and provided teh status to teh onsite team.

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

Confidential

Software Engineer

Responsibilities:

• Understanding teh Client Requirements and design & functionality of teh system by viewing teh Design documents.
• Involved as team member in coding and understanding teh problem.
• Worked with data analyst to know teh requirements of teh 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 teh session logs to check teh progress of data load.
• Supported testing team, UAT team and production team.
• Attending teh Daily & weekly status calls and updating teh status of teh Project and Team to teh client from offshore.

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