SUMMARY

• Around 7+ years of extensive experience in ETL (Extract Transform Load), Data Integration and Data Warehousing, Business Analysis, Application Design, Data Modeling, Development Implementation and Testing Data Warehouse and Database applications for Health care, Telecommunications Services, Retail, Commercial and Financial Services using Informatica, Oracle PL/SQL, Teradata and My SQL.
• Extensive knowledge in Business Intelligence and Data Warehousing Concepts with emphasis on ETL and System Development Life Cycle (SDLC).
• Extensive knowledge on Data Profiling using Informatica Developer tool.
• Experience in Performance Tuning and Debugging of mappings and sessions. Strong in optimizing the Mappings by creating/using Re - usable transformations, Mapplets and PL/SQL stored procedures
• Implemented Slowly changing dimension types (I, II &III) methodologies for accessing the full history of accounts and transaction information designed and developed change data capture solutions (CDC) for the project, which captures and analyses changes from daily feeds to maintain history tables.
• Proficiency in design and developing the ETL objects using Informatica Powercenter with various Transformations like Joiner, Aggregate, Expression, SQL, Lookup, Filter, Update Strategy, Stored Procedures, Router, Rank, normalizer transformations etc.
• Involved in Data Migration projects from DB2 and Oracle to Teradata. Created automated scripts to do the migration using UNIX shell scripting, Oracle/TD SQL.
• Proficient with Data Warehouse models like Star Schema and Snowflake Schema.
• Very good experience in Oracle database application development using Oracle 10g/9i/8i/x, SQL, PL/SQL, SQL Loader.
• Extensively used Mapping Variables, Mapping Parameters, and Dynamic Parameter Files for improved performance and increased flexibility and also worked with XML Sources & Targets.
• Data Processing Experience in Designing and Implementing Data Mart applications, mainly Transformation Process using Informatica.
• Involved in massive data profiling using IDQ (Analyst tool) prior to data staging.
• Worked with Informatica Data Quality toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
• Developing workflows with Worklets, Event waits, Assignments, Conditional flows, Email and Command Tasks using Workflow Manager.
• Knowledge of push down optimization concepts and tuning Informatica objects for optimum execution timelines.
• Experienced with identifying Performance bottlenecks and fixing code for Optimization in Informatica and Oracle.
• Created UNIX shell scripts for Informatica post and pre session operations, database.
• Administration and day-to-day activities like monitor network connections and database ping utilities.
• Extensive experience in implementation of Data Cleanup Procedures, Transformation, Scripts, Stored Procedures and execution of Test plans for loading the data successfully into Targets.
• Creating Checklists for Coding, Testing and Release for a smooth, better & error free project flow.
• Experienced in handling huge volumes of data with the target database.
• Expertise in the QA process of ETL mappings like Unit, Functional and Integration testing.

TECHNICAL SKILLS

Primary Tools: Informatica Power Center 9.0.1/8.6/8.1 , Ab Initio (Co>Op 3.0.3.9/2.15/2.14 , GDE 3.0.4/1.15/1.14 ), Teradata SQL, Teradata Tools and Utilities, Oracle 10g/9i, MS SQL Server 6.5/7.0/2000

Languages: Teradata SQL, SQL

Databases: Teradata 14/13/12/V2R6.2, Oracle 10g/9i, DB2/UDB, SQL Server

Operating Systems: Windows 95/98/NT/2000/XP, UNIX, Linux, NCR MP-RAS UNIX

Data Modeling: Erwin, ER Studio

Scheduling tools: Control M, Autosys

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

Sr. Informatica Developer

Responsibilities:

• Involved in full Software Development Life Cycle (SDLC) - Business Requirements Analysis, preparation of Technical Design documents, Data Analysis, Logical and Physical database design, Coding, Testing, Implementing, and deploying to business users.
• Providing technical support and guidance to the offshore team to address complex business problems.
• Involved in gathering business requirements, logical modeling, physical database design, data sourcing and data transformation, data loading, SQL and performance tuning.
• Defining the schema, staging tables, and landing zone tables, configuring base objects, foreign-key relationships, complex joins, and building efficient views.
• Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Using various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developing as well as modifying existing mappings for enhancements of new business requirements mappings to load into staging tables and then to target tables in EDW. Also created mapplets to use them in different mappings.
• Working on different tasks in Workflows like sessions, events raise, event wait, e-mail, command, worklets and scheduling of the workflow.
• Creating sessions, configuring workflows to extract data from various sources, transforming data, and loading into enterprise data warehouse.
• Running and monitoring daily scheduled jobs by using Work Load manager for supporting EDW (Enterprise Data Warehouse) loads for History as well as incremental data.
• Investigating failed jobs and writing SQL to debug data load issues in Production.
• Writing SQL Scripts to extract the data from Database and for Testing Purposes.
• Interacting with the Source Team and Business to get the Validation of the data.
• Involved in Transferring the Processed files from mainframe to target system.
• Supported the code after postproduction deployment.
• Familiar with Agile software methodologies (scrum).

Environment: Informatica Power Center 9, UNIX, SQL, PL/SQL, Work Load Manager, MS Access, UNIX, BO XI R2, Erwin, Sun Solaris, Shell Scripts, Rapid SQL, PVCS, Visio, AutoSys.

Confidential, Jersey City, NJ

Informatica Consultant

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 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.
• 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).
• Worked with Power Center Versioning (Check-in, Check-out), Querying to retrieve specific objects, maintaining the history of objects.

Environment: Informatica 9.1(Designer, Repository Manager, Workflow Manager, Workflow Monitor), Informatica 8x, Oracle 10G, Teradata, UNIX, PL/SQL Developer, SQL Loader, DB2, Autosys.

Confidential, Houston, TX

Senior 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 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.
• 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).
• Played a major role in coordinating Admin and DBA Team for data exports, imports and migration between different environments.
• Created various UNIX Scripts for Job automation of Data loads.
• Created Test cases for Unit testing, System Integration Test and UAT to check the data.

Environment: Informatica 9.1(Designer, Repository Manager, Workflow Manager, Workflow Monitor), Informatica 8x, Oracle 10G, UNIX, PL/SQL Developer, Advanced Query Tool, UNIX AIX 5.1.

Confidential, Heathrow, FL

Informatica Consultant

Responsibilities:

• Design, Development and Documentation of the ETL (Extract, Transformation & Load) strategy to integrate different interfaces with Exigen.
• Extensively used Informatica Designer to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
• Based on the logic, used various transformation like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner, XML Generator, XML source qualifier, input, output transformation in the mapping.
• Created different source definitions to extract data from XML, flat files and relational tables using Informatica PowerCenter.
• Used XML editor to create personalized views and validated them.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision.
• Created Oracle Stored Procedure to implement complex business logic for good performance and called from Informatica using Stored Procedure transformation.
• Used various Oracle Index techniques like B*tree, bitmap index to improve the query performance and created scripts to update the table statistics for better explain plan.
• Created Test cases for Unit Test, System Integration Test and UAT to check the data quality. Extensively used HP Quality Center for bug fixing.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate the process.
• Created UNIX shell scripts and called as pre session and post session commands. Used WinSCP for FTP purpose for Windows.

Environment: Informatica PowerCenter 8.6.1, Power Exchange, Oracle 10g, PL/SQL, Mainframe DB2, SQL Developer, Toad, Cobol, Quest Central for DB2, ERWIN Data Modeling tool, EASparx, WinSCP, HP Quality Center, Windows 2000, Autosys, UNIX AIX 5.1

Confidential, Tampa, FL

ETL Developer

Responsibilities:

• Interacted with business analysts and translate business requirements into technical specifications.
• Using Informatica Designer, developed mappings, which populated the data into the target.
• Used Source Analyzer and Warehouse Designer to import the source and target database schemas and the mapping designer to map the sources to the targets.
• Responsibilities included designing and developing complex Informatica mappings including Type-II slowly changing dimensions.
• Worked extensively on Workflow Manager, Workflow Monitor and Worklet Designer to create edit and run workflows, tasks, shell scripts.
• Developed complex mappings/sessions using Informatica Power Center for data loading.
• Enhanced performance for Informatica session using large data files by using partitions, increasing block size, data cache size and target based commit interval.
• Extensively used aggregators, lookup, update strategy, router and joiner transformations.
• Developed the control files to load various sales data into the system via SQL*Loader.
• Extensively used TOAD to analyze data and fix errors and develop.

Environment: Informatica 7.X, Oracle 9i, PL/SQL, Windows XP, 2000/2003 Server.