SUMMARY

• 8+ years of IT experience in Design, Development, Implementation and Maintenance of Data warehouse applications.
• Experienced in analyzing business requirements and translating them into functional and technical specifications.
• Sound understanding of Data warehousing concepts and dimensional Modeling.
• Solid understanding of ETL design principles and very good practical knowledge of performing ETL design processes through Informatica Power Center, Informatica Data Quality (IDQ) and Informatica cloud.
• Implemented Slowly changing dimensions and change data capture using Informatica Power center.
• Developed mappings on Informatica Developer (IDQ) and ran the workflows from Informatica power center.
• Strong experience working on Databases such as Oracle 11g/10g, MS SQL Server, Sybase, MS Access and salesForce.com.
• Very strong experience working on Oracle Packages, PL/SQL Stored Procedures, Triggers and Functions.
• Expertise on extracting data from salesforce application (objects) and loading into SFDC sandbox.
• Experience in performance tuning of sources, targets, mapping, transformations and sessions by implementing various techniques like partitioning techniques and pushdown optimization (PDO), and also identifying performance bottlenecks.
• Extensively worked on tuning oracle PL/SQL packages &Stored procedures for better performances.
• Looked at the explain plan (Cost) of the PL/SQL code and made necessary changes to the code to improve the performance.
• Created various documents including high - level design documents, data mapping documents, knowledge transfer documents and unit test case documents.
• Analyzed the session logs, bad files and error tables for troubleshooting mappings and sessions.
• Used GUIs like TOAD / SQL Developer for Oracle, Force.com IDE Eclipse/ data loader for salesforce.
• Experience in Scheduling the Scripts using Autosys, DBMS jobs & DBMS Scheduler.
• Good communication skills, Team player as well as capable of working independently.
• Exceptional problem solving and sound decision making capabilities.

TECHNICAL SKILLS

Data warehousing tools: Informatica cloud, Informatica Data Quality (IDQ), Informatica Power center 9.5.1/9.1.0/8.6.1/8.1/7. x, Toad, Star-Schema and Snowflakes modeling, Power Exchange, Control-M, Autosys.

Languages: PL/SQL, Unix-Shell Scripting, T-SQL Scripts, XML.

Databases: Oracle 11g/10g, Teradata, SQL Server, Sybase, IBM DB2, Mainframes, MS Access.

Domain Knowledge: Retail, Banking, Insurance, Health care.

Operating Systems: Unix, Linux, Sun Solaris, Windows 2000 Server.

Other tools: Toad 11.6.x, Sql developer 2.0, Force.com IDE Eclipse, Putty, share point, OBIEE, Oracle developer, salesforce data loader, SOAP web services.

PROFESSIONAL EXPERIENCE

Confidential, OH

Sr. Informatica Developer

Responsibilities:

• Analyzed the functional specs provided by the business, data architect and created technical specs documents for all the mappings.
• Designed Sources to Targets mapping from primarily Flat files, oracle 11g/10g, Sales Force sources to targets using Informatica data quality 9.1, Informatica Cloud and Informatica Power Center 9.1.0.
• Developed multiple ETL processes to synchronize data between Legacy and New systems.
• Created transformations such as Labeler, standardizer, Consolidation, Key generator, Lookup, Aggregator, Joiner, Union, Rank, Update Strategy, Source Qualifier expression, Filter, Stored Procedure, Sequence Generator in creating simple/complex mappings and mapplets.
• Extensively used Lookup and Update Strategy transformation to update slowly changing dimensions Type 1 and Type 2.
• Developed mappings on IDQ and used those mapping as mapplets and mappings in power center.
• Also developed Informatica mappings by using Pushdown Optimization (PDO) and partitioning techniques to improve the performance. Tweaked the design of mapping so that the PDO limitations are totally gone.
• Extensively developed PL/SQL Packages, Stored Procedures, Views, Functions and Triggers.
• Designed/developed reusable transformations using Informatica Designer.
• Identified process bottlenecks and implemented performance tuning at mapping and session levels.
• Developed and tested mappings on Informatica Data Quality (IDQ) which reduced the development time to a great extent.
• Used Informatica Debugger to troubleshoot job failures and invalid results.
• Used power Exchange connectivity while extracting data from salesforce.com and loading them into sales force targets.
• Improved the performance of PL/SQL code by keeping the cost as low as possible in the EXPLAIN PLAN .
• Created deliverables such as design documents, Unit test documents and KT documents for the testing team.
• Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Used versioning and labeling options in power center to keep track of mapping and workflow changes and used deployment groups to deploy changes.
• Performed knowledge transfer to the production/ testing support team in India and Poland.

Environment: Informatica cloud, Informatica data quality 9.1, Informatica Power Center 9.1.0, oracle 11g/10g, Toad, OBIEE, Oracle developer, Windows 2000, Salesforce.com, Power Exchange, Unix scripting.

Confidential, Boston, MA

Sr. Informatica/ Oracle Developer

Responsibilities:

• Involved with requirement gathering and analysis for the data marts focusing on data analysis, data quality, data mapping between ODS, staging tables and data warehouses/data marts.
• Worked with users to understand their reporting requirements and translate those requirements to extract data, and load data in the form of a report.
• Implemented various business rules of data transformations using various Informatica transformations like Normalizer, Source Qualifier, Update Strategy, Look up(connected/unconnected/static cached/dynamic cached), Sequence Generator, expression, Aggregator, XML(source and generator), Stored Procedures.
• Used Salesforce connections to read and write data at SFDC sandboxes.
• Analyzed the session logs, bad files and error tables for troubleshooting mappings and sessions.
• Implemented various scenarios related to slowly growing targets and slowly changing dimensions (Type1, Type2) and worked on CDC (Change Data Capture).
• Worked with newer Informatica transformations like Java transformation, Transaction Control.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Extensively used pmcmd commands on command prompt and executed Unix Shell scripts to automate workflows and to populate parameter files.
• Wrote PL/SQL stored procedures/functions to read and write data for the Control Processes at ODS levels.
• Used Pushdown Optimization and partitioning techniques to improve the performance of the mapping.
• Scheduled workflows using Autosys job plan.
• Worked on performance tuning of PL/ SQL code.
• Provided production support and involved with root cause analysis, bug fixing and promptly updating the business users on day-to-day production issues.
• Co-ordinated with the off-shore teams and mentored junior developers.

Environment: Informatica Power Center 9.5.1, oracle 11g, Autosys, Sql developer, Salesforce sandbox, Sql plugin for sales force, Toad 9.0, Force.com IDE Eclipse, MS Access, HP Unix, Unix scripting.

Confidential, Houston, TX

Sr. Informatica Developer

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Created new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Used Informatica reusability at various levels of development.
• Developed mappings/sessions using Informatica Power Center 9.1 for data loading.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed Workflows using task developer, Worklets designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Implemented slowly changing dimension methodology for accessing the full history of accounts.
• Optimizing performance tuning at source, target, mapping and session level.

Environment: Informatica Power Center 9.1, oracle 11g/10g, IBM DB2, Sql server, Sybase, flat files, Windows 2000, BI tool (SSRS), Erwin, Autosys, Salesforce.com, T-sql, Power Exchange, Unix scripting, SSH.

Confidential, Los Angeles, CA

ETL Informatica Developer

Responsibilities:

• Responsible for requirement definition and analysis in support of Data Warehousing efforts.
• Worked closely with business analysts and gathered functional requirements. Designed technical design documents for ETL process.
• Performed data manipulations using various Informatica transformations like Joiner, Rank, Router, Expression, Lookup, Aggregator, Filter, Update strategy and Sequence generator.
• Extensively used xml source qualifier, Mid-stream XML parser transformation, Mid-stream XML generator transformations, as our main source type was XML Files.
• Extensively used Dynamic Lookup transformation and Update Strategy transformation to update slowly changing dimensions.
• Extensively utilized the Debugger utility to test the mappings.
• Extensively worked on Performance Bottlenecks to improve the performance of the sessions.
• Used workflow manager for creating, validating, testing and running the Sequential and Concurrent sessions and scheduling them to run at specified time with required frequency.
• Created and used different tasks like Decision, Event Wait, Event Raise, Timer and E-mail.
• Used Unix Scripting and Scheduled PMCMD to interact with Informatica Server from command mode.
• Develop, maintain, and manage all analytical and operational mission-critical business reports such Cognos Report Studio/8.x, Cognos Framework Manager 8.2 and Business Objects XI R2/6.x.
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Created database Triggers, Stored Procedures, Exceptions to perform calculations when retrieving data from the database.
• Defined Mapping parameters and variables and Session parameters according to the ETL requirements.
• Used power exchange connectivity while importing data from mainframes ADABAS.
• Used CONTROL M Tool to schedule Informatica jobs

Environment: Informatica Power Center 8.6.1/8.0.1 , flat files, Oracle 10g, sql server, Sybase, Linux, UNIX Sell Scripting, BI tools (Cognos, BO), Power Exchange, Windows XP, Teradata, Mainframes, DB2 UDB.

Confidential, Dallas, TX

Informatica Developer

Responsibilities:

• Worked on the standard SDLC lifecycle project development.
• Extensively used ETL and Informatica to load data from MS SQL Server, Excel spreadsheet, flat files into the target Oracle 9i database.
• Implemented various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router etc.
• Involved in development of Informatica mappings and also in tuning of mappings for better performance.
• Developed PL/SQL procedures/packages to load the data into Oracle.
• Used Informatica features to implement Type I, II, and III changes in slowly changing dimension tables.
• Efficiently used Workflow Manager and Workflow monitor to create and run Sessions and Workflows.
• Optimized/Tuned mappings for better performance and efficiency.
• Involved in performance tuning of SQL Queries, Sources, Targets and sessions.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Written UNIX shell scripting.
• Involved in ETL process under development, test and production environments.

Environment: Informatica PowerCenter 7.1.0, Informatica PowerConnect, Power Play, Oracle 9i, MS SQL Server 2000, Transformer, PL/SQL,SQL, Toad.

Confidential

PL/SQL Developer

Responsibilities:

• Understand and analyze the system, draw context flow and data flow diagrams.
• Create system requirement specifications and functional specifications.
• Database designing that included creating E-R diagrams, defining tables, views, constraints, triggers, stored procedures.
• Extensively used Joins, Cursors, Triggers, Stored Procedures and Functions in interaction with backend database using PL/SQL.
• Testing the application.
• Involved in Data modeling concepts like Setting up relation, applying Normalization rules for whole database.
• Used Stored Procedures, functions, packages for applying various business rules and generating reports.

Environment: Oracle, PL/Sql.