SUMMARY:

• 6+ years of IT experience in Analysis, Design, Development, Implementation, Testing, Support of Data warehousing and Data Inetgration Solutions using Informatica Powercenter
• Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.1 PowerCenter Client tools
• Expertise in working with relational databases such as Oracle 10g/9i, SQL Server 2008 and Teradata
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center
• Experience in creatingReusable Transformations(Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) andMappingsusing Informatica Designerand processing tasks usingWorkflow Managerto move data from multiple sources into targets
• Experience in Performance Tuning and Debugging of existing ETL processes
• Extensive Hands - on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Involved inUnit testing, System testingto check whether the data loads into target are accurate.
• Expertise in understanding the business rules based on High Level document specifications and implementation of the data transformation methodologies.
• Conducted multiple PoC's for the ETL application teams for Informatica
• Experience with dimensional modeling using star schema and snowflake models
• Worked across various verticals ranging from Finance, Energy and Utility and Dell Services
• Independently perform complex troubleshooting, root-cause analysis and solution development
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills
• Team player, Motivated, able to grasp things quickly with analytical and problem solving skills
• Area of expertise has been project delivery, solution design and implementation of various sizes
• Certified in Informatica 8 Designer from Informatica Corporation.

TECHNICAL SKILLS:

ETL Tool: Informatica 8.1,8.6 and 9.1

Databases: Oracle 10g/9i, Microsoft SQL Server 2008, Teradata, PL/SQL Developer

Programming Languages: UNIX Shell Scripting, SQL, PL/SQL

Scheduling Tools: Control M

Environment: Windows 9X/NT/2000 Server, UNIX

Other Software: Toad, Putty,Filezilla

Other Application: HP Quality Center 9/10, Remedy, Microsoft Visual SourceSafe,Citrix

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

Sr. Informatica developer

Responsibilities:

• Analyzing, designing and developing ETL strategies and processes, writing ETL specifications, Informatica development, and administration and mentoring other team members.
• Developed mapping parameters and variables to support SQL override.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, and SQL, Lookup (File and Database) to develop robust mappings in the Informatica Designer.
• Worked on Teradata and its utilities - tpump, fastload through Informatica.Also created complex Teradata Macros
• Worked and Implemented Pushdown Optimization (PDO) to optimize performance issues of complex mappings involving numerous transformations and hence degrading the performance of the session.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Exhaustive testing of developed components.
• Worked on the various enhancements activities, involved in process improvement.
• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer, WorkFlow Manager, Workflow Monitor.
• Worked on Change data Capture (CDC) using CHKSUM to handle any change in the data if there is no flag or date column present to represent the changed row.
• Worked on reusable code known as Tie outs to maintain the data consistency. It compared the source and target after the ETL loading is complete to validate no loss of data during the ETL process.
• Worked on Ab Initio in order to replicate the existing code to Informatica.
• Implemented Teradata MERGE statements in order to update huge tables thereby improving the performance of the application.
• Used reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Migrated the code into QA (Testing) and supported QA team and UAT (User).
• Working with Power Center Versioning (Check-in, Check-out), Querying to retrieve specific objects, maintaining the history of objects.
• Worked on Global data across all regions building a warehouse for Dell
• Developed and tested ETL components using Informatica Power Center 8.6.0.
• Converted the PL/SQLProcedures toInformaticamappings
• Worked on the development of logical models with help of SME’S, building the ETL and database design
• Coordinating with user to gather the new requirements and working with existing issues.
• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing. Recoded the SQL server procedures to Teradata Macros
• Optimizing performance tuning at source, target,mapping and session level
• Involved in Unit Testing and Resolution of various Bottlenecks came across.
• Worked on Flat Files having global data, also handled special characters not read by Informatica.
• Well informed about the code page compatibility in Informatica and its importance while importing data from flat files
• Migration of Informatica code to QA and Production Environments.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Been responsible for project deployment and worked with engineering team during code deployment.
• Delegating and Tracking the change requests inInformatica.
• Use HP Quality center to track of all the issues and defects logged by QA or UAT (user).
• Maintained naming standards and warehouse standards for future application development.
• Closely worked with the reporting team to ensure that correct data is presented in the reports.

Environment: Informatica 8.6(Designer, Repository Manager, Workflow Manager, Workflow Monitor), Oracle 10g, Teardata, UNIX, Delimited Flat files, Microsoft SQL server 2008, Citrix, Putty

Confidential

Informatica developer/Sr. Informatica Developer

Responsibilities:

• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Supporting (includes Development & Support) all AREVA T&D applications which uses Informatica to migrate data to/from SAP migrate data to/from CRM (Sales force) migrate data to/from XML files migrate data to/from AREVA T&D DWH (using files/tables)
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
• Handled slowly changing dimensions of Type 1/ Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse. Updated the table without using Update Strategy improving session performance
• Worked on different tasks in Workflow Manager like Sessions, Decision, E-mail, Command, Worklets .Used sending attachment functionality to the user using session post email property.
• Worked with complex mappings having an average of 15 transformations.
• Prepared estimates and tracked each and every task and strictly adhered to the estimated deadlines
• Effectively worked on Onsite and Offshore work model.
• Worked on Surrogate key implementation in order maintain primary key in the table using a unique identifier in place of multiple columns forming a composite key.
• Used Debugger to test the mappings and fixed the bugs. Used breakpoints in between to capture the row causing the problem.
• Followed Informatica recommendations, methodologies and best practices.
• Worked on Unit Testing and preparing Unit Test Logs for the end users
• Populated error tables as part of the ETL process to capture the records that failed the migration.
• Migrated the code into QA (Testing) and supported QA team and UAT (User).
• Extensively used workflow variables, mapping parameters and mapping variables.

Environment: Informatica Power Center 8.1, 8.6(Designer, Repository Manager, Workflow Manager, Workflow Monitor), Oracle 9i, TOAD, UNIX, Flat Files, Citrix, Filezilla