SUMMARY

• Certified Informatica and Oracle IT professional with 7+ years of technical and 3+ managerial experience (3+ years with Fortune 500 Company) in Data Analysis, Informatica Power Center 9.x/8.x, Informatica Data Quality (IDQ), Change Data Capture (CDC), Oracle (SQL & PL/SQL), Oracle, Teradata, Data Warehousing and UNIX and used the Business Intelligence tools like Spotfire, Business Objects.
• Involved in development of Informatica mappings with required transformations like (Source Qualifier, Rank, Joiner, Lookup, Filter, Router, Sequence Generator, Union, Sorter, Update Strategy, Aggregator, and Expression)
• Good understanding of Change Data Capture (CDC) techniques along with Ralph Kimball Dimensional Modeling using Star schema methodology and Bill Inman Snow Flake schema methodology.
• Strong experience in Extraction, Transformation, Loading (ETL) data from various heterogeneous source systems like Oracle 11g/10g, Teradata, SQL Server 2008/2005, DB2 10, Flat files, XML, SAP R/3, SAP BW into Data Warehouses and Data Marts using Informatica Power Center (Designer, Workflow Manager, Workflow Monitor, Metadata Manger).
• Expert in creating and using Mapplets, Worklets, and Advance Transformation like SQL, Transaction control, Normalizer, HTTP.
• Expertise in Performance Tuning (Teradata and Oracle Query tuning, Informatica dynamic session partitioning for optimal performance).
• Expertise in implementing slowly changing dimensions SCD type1/2/3 with optimal performance.
• Extensive use of Lookup Shared Cache, Persistent cache, Static cache, Connected, Un connected lookups, Target Update override.
• Teradata experience using Teradata SQL Assistant, Teradata Administrator and data load/unload utilities like BTEQ, FastLoad, MultiLoad, FastExport, and Tpump
• Experience in leading team and possess excellent communication and interpersonal skills, ability to quickly grasp new concepts, both technical and business related and utilize as needed.
• As an onsite lead responsibility to coordinate requirements and assigning development work and guiding them during Development and Unit testing Phases to implement logic and troubleshoot the issue that they were experiencing.
• Responsible for projects estimates, Project Plan, risk mitigation plan, design documents, Best Practices Document for Informatica, Oracle and Teradata.
• Worked on both waterfall model as well as agile methodology projects.
• Implemented various Frame as ETL Framework for Operational Metadata Logging, Change Data Capture (CDC) Framework, Align code review Frame work etc.
• Extensive experience in Healthcare domain.
• Experience in creating and using Stored Procedures, Functions, Triggers, Views, Synonyms, and Packages in Oracle 11g/10g/9i and Teradata.
• Skilled in Unix Shell Scripting and experience on different UNIX platforms.
• Experience in scheduling of ETL jobs using Autosys.
• A highly motivated self - starter and a good team-player with excellent verbal and written communication skills.
• Successfully managed complex projects with global implementation, and rapidly evolving requirements.
• Effective communication skills and record for coordination between globally located teams.
• Project delivery under stringent timelines and high pressure.
• Conducted a budget planning of the project through walkthroughs and meetings involving various leads from Development, QA and Technical Support teams.
• Exceptional ability to maintain and build client relationships, frequent travel meeting one on one with clients, able to comfortably converse with all facets in the clients organization.
• Define Business Process; identify the risk, doing risk analysis and providing baseline acceptance criteria and deliverables. Check the data quality using IDQ
• Adept in providing Analytical Support to key business Applications /solutions
• Excellent verbal and written skills, especially with regards to presenting findings to both technical and non-technical audiences
• Thorough Understanding of Software Development Life Cycle (SDLC), involved in various phases like Requirements, Analysis/Design, Development and Testing.
• Acted as liaison between management and development team for Requirements and QA.
• Managing reports, analysis and decision-making for a change request.
• Project Management, Project Schedule, Project Tracking and Team Management
• Rich experience in translating Business requirements to understandable IT systems requirements and implementing proper Processes & Procedures across the organization.

TECHNICAL SKILLS

ETL Tools: Informatica 9.x/8.x, Information Data Quality

Databases: Oracle 11g/10g/9i, DB28.x, SQL Server 2000/2005, Teradata

Languages: SQL, PL/SQL, Shell Scripting

Operating Systems: UNIX (SOLARIS, AIX), Linux, Windows 95/98/NT/2000/XP and DOS

DB Tools: SQL Plus, SQL Loader, Toad, Power Designer, Erwin

Scheduling Tools: Autosys, UNIX crontab, Informatica Scheduler

Others: MS Office (MS Access, MS Excel, MS PowerPoint, MS Word, MS Visio).

PROFESSIONAL EXPERIENCE

Confidential, Agoura Hills, California

Enterprise Information Manager

Responsibilities:

• Creation of the counterparty credit agreements, understanding and standardizing a common Information handling format.
• Analysed source systems, business requirements and identified business rules for building the data warehouse.
• Developed Technical Specifications of the ETL process flow
• Designed and developed Informatica mappings in Informatica 9.5.1 and 9.6 environments, workflows to load data into Oracle ODS.
• Extensively used the CDC
• Installed and Configured Informatica Power Center client tools and connected with each database in Data Ware house using repository server. Check the data quality using IDQ
• Extensively used Informatica to load data from Oracle, XMLand Flat Files to Oracle.
• Used Informatica workflow manager, monitor, and repository manager to execute and monitor workflows and assign user privileges.
• Extensively worked with Aggregator, Sorter, Router, Filter, Join, Expression, Lookup and Update Strategy, Sequence generator transformations.
• Set up Metadata driven utility design for the ETL processes using Informatica.
• Used debugger to test the mapping and fixed the bugs.
• Involved in tuning the performance of sessions and mappings.
• Used the Workflow manager to create workflows and tasks, and also created Worklets.
• Involved in Production Support in resolving issues and bugs.
• Worked onSQL stored procedures, functions and packages in Oracle.
• Created and maintained UNIX shell scripts for pre/post session operations and various day-to-day operations.
• Developed unit and system test cases, using System Procedures to check data consistency with adherence to the data model defined. Check the data quality using IDQ

Confidential, Thousand oaks, California

Sr. Informatica Lead Developer

Responsibilities:

• Analysed source systems, business requirements and identified business rules for building the data warehouse.
• Developed Technical Specifications of the ETL process flow
• Extensively used Change Data Capture for production issues analysis, troubleshooting of the problem tickets, and to keep production data efficient, and to improve the performance of the ETL mappings. Check the data quality using IDQ
• Designed and developed Informatica mappings in Informatica 9.5.1 environment, workflows to load data into Oracle ODS.
• Installed and Configured Informatica Power Center client tools and connected with each database in Data Ware house using repository server.
• Extensively used Informatica to load data from Oracle, XMLand Flat Files to Oracle.
• Used Informatica workflow manager, monitor, and repository manager to execute and monitor workflows and assign user privileges.
• Extensively worked with Aggregator, Sorter, Router, Filter, Join, Expression, Lookup and Update Strategy, Sequence generator transformations.
• Set up Metadata driven utility design for the ETL processes using Informatica.
• Used debugger to test the mapping and fixed the bugs.
• Involved in tuning the performance of sessions and mappings.
• Used the Workflow manager to create workflows and tasks, and also created Worklets.
• Involved in Production Support in resolving issues and bugs.
• Worked onSQL stored procedures, functions and packages in Oracle.
• Created and maintained UNIX shell scripts for pre/post session operations and various day-to-day operations.
• Developed unit and system test cases, using System Procedures to check data consistency with adherence to the data model defined. Check the data quality using IDQ

Confidential, Bridgewater, New Jersey

Informatica ETL CoE (Center Of Excellence) Lead

Responsibilities:

• ITIL based ticket Management for Incidents, Problem, Change & Release management
• The ticketing tool used is BMC Remedy.
• Asset management to track service impacts among various Configuration Items
• Knowledge Management to build a strong known error repository, documenting major and recurring incidents
• 24/7 ticket processing for critical applications
• Extensively used Change Data Capture for production issues analysis, troubleshooting of the problem tickets, and to keep production data efficient, to improve the performance of the ETL mappings.
• Ongoing Monitoring of Servers and ensuring their availability 24/7
• Monitor and support all the platforms & applications
• Communication to the application project teams regarding system maintenance activities or downtime
• Flexible minor enhancement capacity model including the requirement analysis, impact analysis, design, coding, testing and deployment
• Enhanced application support processes with internal Xxx staff, external partner systems and vendors
• Designed and developed shell scripts to monitor the integrity of the system towards minimizing the downtime in transaction processing. The auto correcting scripts resulted in 25% reduction of the problem tickets on system
• Implemented software releases and patches on the user acceptance and production environments
• Performed defect analysis of the real time issues in the production environment.

Confidential

ETL Lead

Responsibilities:

• Involved in gathering business requirements and attended technical review meetings to understand the data warehouse model.
• Involved in data modeling and design of data warehouse in star schema methodology with confirmed granular dimensions and Fact tables.
• Extensively used ETL to load data from Flat files, DB2 and Oracle into Oracle.
• The SAP integration with Informatica was required to be implemented using the SAP chains, invoking these SAP chains Informatica workflows were triggered fetching data from SAP sources.
• Used Informatica Designer to Extract & Transform the data from various source systems by incorporating various business rules. Also used different transformations, sessions and command tasks. Check the data quality using IDQ
• Created mappings using different transformations like Aggregator, Expression, Stored Procedure, Filter, Joiner, Lookup, Router and Update Strategy.
• Worked with mapping variable, Mapping parameters and variable functions like Setvariable, Countvariable, Setminvariable and Setmaxvariable.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Used Informatica partitioning to improve data loading performance.
• Developed shell scripts for job automation, which will generate the log file for every job.
• Created Informatica Frame work for Audit and Error Balancing.
• Validated Data to Maintain Referential Integrity.Developed UNIX shell scripts to move source files to archive directory.
• Involved in Unit, Integration, system, and performance testing levels.
• Worked on back end programming such as PL/SQL procedures, functions and packages.
• Prepared a production monitoring and support handbook for ETL Process.
• Coordinated offshore and onsite team with a total of 7 ETL developers.

Environment: Informatica Power Center 9.x, Oracle 11g, Teradata, UNIX, UNIX Shell Programming, PL/SQL, TOAD Quest Software.

Confidential

ETL Lead

Responsibilities:

• Code review, assigning development work to offshore team and guiding them during Development and Unit testing Phases to implement logic and troubleshoot the issue that they were experiencing.
• Requirement gathering and FRS clarification.
• Preparing High Level and Low Level design documents.
• Worked with power center tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Used Informatica data services to profile and document the structure and quality of all data.
• Extensively used Various Data Cleansing and Data Conversion Functions in various transformations.
• Translated Business processes into Informatica mappings for building Data marts by using Informatica Designer which populated the Data into the Target Teradata Instance.
• Followed the required client security policies and required approvals to move the code from one environment to other.
• Developed ETL mappings, transformations using Informatica Power center 9x.
• Created Informatica complex mappings with complex SQL queries (complex joins and unions, hierarchy queries, Analytical functions, MODEL clause) to build business rules to load data.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
• Created automated scripts to perform data cleansing and data loading.
• Preparing, executing and documenting Unit Test Cases.Providing full support during SIT and UAT phase. Check the data quality using IDQ
• Performed complex defect fixes in various environments like UAT, SIT etc to ensure the proper delivery of the developed jobs into the production environment.
• Attended daily status call with internal team and weekly calls with client and updated the status report.

Environment: Informatica PowerCenter 9x, Oracle11g, Teradata, PL/SQL, TOAD8.0, Windows NT, Unix ShellScripting.

Confidential

ETL Lead Developer

Responsibilities:

• Code review, assigning development work to offshore team and guiding them during Development and Unit testing Phases to implement logic and troubleshoot the issue that they were experiencing.
• Requirement gathering and FRS clarification.
• Preparing High Level and Low Level design documents.
• Worked with power center tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Used Informatica data services to profile and document the structure and quality of all data.
• Extensively used Informatica Transformation like Source Qualifier, Rank, SQL, Router, Filter, Lookup, Joiner, Aggregator, Normalizer, Sorter etc. and all transformation properties.
• Extensively used Various Data Cleansing and Data Conversion Functions in various transformations.
• Translated Business processes into Informatica mappings for building Data marts by using Informatica Designer which populated the Data into the Target Teradata Instance.
• Followed the required client security policies and required approvals to move the code from one environment to other.
• Developed ETL mappings, transformations using Informatica Power center 9x.
• Created Informatica complex mappings with complex SQL queries (complex joins and unions, hierarchy queries, Analytical functions, MODEL clause) to build business rules to load data.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
• Created automated scripts to perform data cleansing and data loading.
• Preparing, executing and documenting Unit Test Cases.Providing full support during SIT and UAT phase.
• Performed complex defect fixes in various environments like UAT, SIT etc to ensure the proper delivery of the developed jobs into the production environment.
• Attended daily status call with internal team and weekly calls with client and updated the status report. Check the data quality using IDQ

Environment: Informatica Power Center 9.x/8.x, Oracle8i, PL/SQL

Confidential, Bridgewater, NJ

Sr. Informatica Lead Developer

Responsibilities:

• Co-ordinated Joint Application Development (JAD) sessions with Business Analysts and source developer for performing data analysis and gathering business requirements.
• Developed technical specifications of the ETL process flow.
• Designed the Source - Target mappings and involved in designing the Selection Criteriadocument.
• Worked on design and development of Informatica mappings, workflows to load data into staging area, data warehouse and data marts in SQLServer and Oracle.
• Used Informatica PowerCenter to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different sourcesystems (SQL server, Oracle, Flat files).
• Created mappings using various Transformations like Source Qualifier, Aggregator, Expression, Filter, Router, Joiner, Stored Procedure, Lookup, Update Strategy, SequenceGenerator and Normalizer.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Used version mapping to update the slowly changing dimensions to keep full history to the target database.
• Well versed with Informatica Partitioning, Change data capture (CDC).
• Implemented Informatica Framework for (dynamic parameter file generation, start, failed and succeeded emails for an integration, Error handling and Operational Metadata Logging).
• Implemented sending of Post-Session Email once data is loaded.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Used Debugger to test the mappings and fixed the bugs.
• Tuned performance of mapping and sessions by optimizing source, target bottlenecks andimplemented pipeline partitioning.
• Worked with DBA for partitioning and creating indexes on tables used in source qualifier queries.
• Involved in Performance/Query tuning. Generation/interpretation of explain plans and tuning SQL to improve performance.
• Scheduled various daily and monthly ETL loads using Autosys.
• Involved in writing UNIX shell scripts to run and schedule batch jobs.
• Involved in unit testing and documentation of the ETL process.
• Involved in Production Support in resolving issues and bugs.

Environment: Informatica PowerCenter 9.x, Teradata, PL/SQL,Oracle 11g, Toad 8.0, UNIX Shell Scripting.

Confidential

ETL Developer

Responsibilities:

• Analysed source systems, business requirements and identified business rules for building the data warehouse.
• Developed Technical Specifications of the ETL process flow
• Designed and developed Informatica mappings, workflows to load data into Oracle ODS.
• Installed and Configured Informatica Power Center client tools and connected with each database in Data Ware house using repository server.
• Extensively used Informatica to load data from Oracle, XMLand Flat Files to Oracle.
• Used Informatica workflow manager, monitor, and repository manager to execute and monitor workflows and assign user privileges.
• Extensively worked with Aggregator, Sorter, Router, Filter, Join, Expression, Lookup and Update Strategy, Sequence generator transformations.
• Set up Metadata driven utility design for the ETL processes using Informatica.
• Used debugger to test the mapping and fixed the bugs.
• Involved in tuning the performance of sessions and mappings.
• Used the Workflow manager to create workflows and tasks, and also created Worklets.
• Involved in Production Support in resolving issues and bugs.
• Worked onSQL stored procedures, functions and packages in Oracle.
• Scheduled and executed batch and session jobs on Autosys.
• Created and maintained UNIX shell scripts for pre/post session operations and various day-to-day operations.
• Developed unit and system test cases, using System Procedures to check data consistency with adherence to the data model defined.

Environment: Informatica Power Center 9.x, Oracle8i, PL/SQL