SUMMARY

• 8 years & 9 months of specialized IT experience in building Enterprise Data Warehouse, Data Marts, Operational data stores in major industry sectors using Informatica Power Center 9.x, 8.x and 7.x.
• Strong Focus on Software Development Life Cycle (SDLC) with design, concept, architecture, planning, modeling, coding, development, testing, implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI.
• Expertise in working with relational databases such as Oracle 10g/9i,Teradata 14/12, SQL Server 2000/2005/2008 , DB2, My Sql, Sybase.
• Strong experience working with Business Analyst & Modelers to understand the requirements, Model.
• Designed and developed complex mappings to move data from multiple sources into a common target area such as Data Marts and Data Warehouse using lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Normalizer, Sequence Generator, and Update Strategy from varied transformation logics in Informatica as well as performance tuning of mappings and sessions.
• Strong experience in Enterprise Data Warehouse environment with Informatica & Teradata combination and extensive work with Slowly Changing Dimensions.
• Hands on experience with Teradata utilities likeBTEQ, Fast Export, Fast Load, and Multi Loadto export and load data to/from different source systems including flat files.
• Extensive experience in writing UNIX shell scripts and handling Perl scripts and automation of the ETL processes using UNIX shell scripting. Worked with PMCMD to interact with Informatica Server from command mode.
• Experience in using Automation Scheduling tools like Autosys, Control - M and Maestro
• Expertise in OLTP/OLAP System Study, Understanding E-R modeling and Dimensional Models using Star schema and Snowflake schema techniques, Identifying Facts and Dimensions.
• Good communication skills with ability to work as Team player. Ability to work in groups as well as independently with minimum supervision.
• Expert Agile & Waterfall methodology also expert in using Agile tools Rally & Jira.

TECHNICAL SKILLS

Operating Systems: Windows, Unix, Linux, MS-DOS

Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow - flake Schema Modeling, E-R Modeling, Microsoft Visio.

RDBMS: Oracle 10g/9i, Teradata 14/13/12, DB2, SQL Server 2000/2005/2008 , DB2, MySQL, Sybase

ETL Tools: Informatica PowerCenter 9.6.1/9.5.1 /8.6.1/7.1.1

Reporting Tools: Cognos, Business Objects

Languages: XML, UNIX Shell Scripting, Perl 5.10/5.12, SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Wisconsin

Sr. ETL Informatica Developer

RESPONSIBILITIES:

• Developed internal and external Interfaces to send the data in regular intervals to Data warehouse systems.
• Extensively used Power Center to design multiple mappings with embedded business logic.
• Involved in discussion of user and business requirements with business team.
• Performed data migration in different sites on regular basis.
• Involved in upgrade of informatica from 9.1 to 9.5.
• Created complex mappings using Unconnected Lookup, Sorter, and Aggregator and Router transformations for populating target tables in efficient manner.
• Attended the meetings with business integrators to discuss in-depth analysis of design level issues.
• Involved in data design and modeling by specifying the physical infrastructure, system study, design, and development.
• Extensively involved in performance tuning of the Informatica ETL mappings by using the caches and overriding the SQL queries and also by using Parameter files.
• Developed complex SQL queries to develop the Interfaces to extract the data in regular intervals to meet the business requirements and extensively used Teradata Utilities like M - load, F- Load, TPT, BTEQ and Fast Export.
• Analyzed session log files in session failures to resolve errors in mapping or session configuration.
• Written various UNIX shell Scripts for scheduling various data cleansing scripts, loading process and automating the execution of maps.
• Created transformations like Expression, Lookup, Joiner, Rank, Update Strategy and Source Qualifier Transformation using the Informatica designer.
• Created mapplet and used them in different mappings.
• Worked on Flat Files and XML, DB2, Oracle as sources.
• Written PL/SQL Procedures and functions and involved in change data capture (CDC) ETL process.
• Implemented Slowly Changing Dimension Type II for different Dimensions.
• Involved in Informatica, Teradata and oracle upgrade process and testing the environment while up gradation.
• Worked with Informatica version Control excessively.
• Experience in using SVN as version control for migration.
• Written Unit test scripts to test the developed interfaces.
• Managed enhancements and coordinated with every release with in Informatica objects.
• Provided support for the production department in handling the data warehouse.
• Worked under Agile methodology and used Rally tool one to track the tasks.
• Written thorough design docs, unit test documentation, Installation and configuration guide documents.
• Performed bulk data imports and created stored procedures, functions, views and queries.

ENVIRONMENT: Informatica Power Center 9.6.1/9.5.1 , Teradata 14/12, Oracle 10g, DB2, XML, Flat Files, Sql Assistant, Toad, PL/SQL, Unix shell scripting, Cognos, SVN, Windows 7.

Confidential, CA

Sr ETL Informatica Developer

RESPONSIBILITIES:

• Utilized all the features of Source Qualifier transformation such as filter, joiner, sorter and SQL override to the extend level at the source level.
• Worked with Business data Analysts (BDA) to understand the requirements for MDW development.
• Extensively worked with different transformations such as Expression, Aggregator, Sorter, Joiner, Router, Lookup, Filter and Union in developing the mappings to migrate the data from source to target.
• Extensively used Lookup transformation and Lookup Caches in looking the data from relational and Flat Files.
• Extracted data from various heterogeneous sources like Sybase, Flat Files and COBOL (VSAM) using Informatica Power center and loaded data in target database DB2.
• Extensively worked with session logs and workflow logs in doing Error Handling and trouble shooting.
• Experience with medical procedure codes like Current Procedure Terminology (CPT), Healthcare Common Procedure Coding System (HCPCS).
• Developed complex SQL queries to develop the Interfaces to extract the data in regular intervals to meet the business requirements and extensively used Teradata Utilities like M - load, F- Load, TPT, BTEQ and Fast Export.
• Involved in doing Unit Testing, Integration Testing and Data Validation.
• Worked with the Control M scheduling team in scheduling Informatica Jobs as per the requirement and frequency.
• Implemented various Performance Tuning techniques by finding the bottle necks at source, target, mapping and session and optimizing them.
• Used FACETS in extracting the sampling data.
• Modified theshell/Perlscripts as per the business requirements.
• Used Perl scriptsto edit the xml files and calculate line count according to the client's need.
• Managed a number of stored procedures, triggers, SQL (in Oracle and MS SQL server) and UNIX shell and Perl scripts for business logic and the interface between UNIX and informatica.
• Involved in DWH up gradation for source system changes.
• Created Mapping parameters and Variables and written parameter files.
• Created UNIX shell scripts for various needs.
• Worked with the Debugger Wizard in debugging the mappings.
• Used Normalize Transformation for Cobol (VSAM) sources.
• Worked with External stored procedures for data cleansing purpose.
• Worked with the Cognos team in generating various reports.
• Involved in preparing the Migration Documents.
• Implemented Informatica Procedures and Standards while developing and testing the Informatica objects.
• Successful in Providing 24x7 On-call Support for Production databases.

ENVIRONMENT: Informatica Power Center 9.1.1, Teradata 13, Sybase, DB2, Flat Files, Cobol (VSAM),Win SQL, FACETS, Toad, Ultra Edit - 32, SQL Advantage, Control Center, Power Designer SQL Modeler, CDMA, Ms-Access, MS-Visio, Cognos, Perl 5.10/5.12, UNIX, Windows XP Professional.

Confidential, Dallas, TX

Informatica ETL Developer

RESPONSIBILITIES:

• Involved in Requirement analysis in support of Data Warehousing efforts
• Maintain Data Flow Diagrams (DFD’s) and ETL Technical Specs or lower level design documents for all the source applications
• Worked with source databases like Oracle, SQL Server and Flat Files
• Extensively worked with various Active transformations like Filter, Sorter, Aggregator, Router and Joiner transformations
• Extensively worked with various Passive transformations like Expression, Lookup, Sequence Generator, Mapplet Input and Mapplet Output transformations
• Created complex mappings using Unconnected and Connected lookup Transformations
• Implemented Slowly changing dimension Type 1 and Type 2 for change data capture
• Worked with various look up cache like Dynamic Cache, Static Cache, Persistent Cache, Re Cache from database and Shared Cache
• Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, transform, cleanse data and load it into data marts
• Worked with various Informatica PowerCenter objects like Mappings, transformations, Mapplet, Workflows and Session Tasks
• Responsible for the performance tuning of the ETL process at source level, target level, mapping level and session level
• Worked extensively with update strategy transformation for implementing inserts and updates
• Extensively used the tasks like email task to deliver the generated reports to the mailboxes and command tasks to write post session and pre session commands
• Extensively used debugger to test the logic implemented in the mappings
• Performed error handing using session logs
• Tuned performance of Informatica session for large data files by increasing block size, data cache size and target based commit interval
• As per business we implemented Auditing and Balancing on the transactional sources so that every record read is either captured in the maintenance tables or wrote to Target tables
• Auditing is captured in the audit table and EOD snapshot of daily entry is sent to the distributed list to analyze if anything is abnormal
• Monitored workflows and session using PowerCenter workflows monitor
• Used Informatica Scheduler for scheduling the workflows

ENVIRONMENT: Informatica Power Center 8.5 / 8.6.1, Oracle 9i, Sql Server, Sybase, SQL, PL/SQL, Cognos, Unix AIX and windows XP.

Confidential

Informatica ETL Developer

RESPONSIBILITIES:

• Developed Informatica mappings, Reusable transformations. Developed and wrote procedures for getting the data from the Source systems to the Staging and to Enterprise Data Warehouse system.
• Extensively used transformations to implement the business logic such as Sequence Generator, Normalizer, Expression, Filter, Router, Rank, Aggregator, Look Up (Target as well as Source), Update Strategy, Source Qualifier and Joiner, Designed complex mappings involving target load order and constraint based loading
• Create/build and run/schedule Workflows and Worklets using the Workflow Manager.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes. Coded Database triggers, functions and Stored procedures and written many SQL Queries. Helped coding shell scripts for various administration activities for daily backup. Involved in Physical schema implementation, objects like table-space, table rollback segments, Created database structures, objects and their modification as and when needed.
• Performance Tuning of the Informatica Mappings by adopting Explain plans, cutting down query costs using Oracle hints, changing the mapping designs.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query Performance.
• Optimizing/Tuning mappings for better performance and efficiency, Creating and Running Batches and Sessions using the Workflow Manager, Extensively used UNIX Shell scripts for conditional execution of the workflows. Optimized the performance of Mappings, Workflows and Sessions by identifying and eliminating bottlenecks
• Performed Unit Testing at development level, Source code migration and documentation
• Involved in full life cycle development including Design, ETL strategy, troubleshooting Reporting, and Identifying facts and dimensions.
• Managed the Metadata associated with the ETL processes used to populate the data warehouse.
• Involved in solving Trouble Tickets raised by Data warehouse Users.
• Experience with on call support.

ENVIRONMENT: Informatica Power Center 8.5, Oracle, Flat Files, UNIX (AXI), Toad.

Confidential

Informatica ETL Developer

RESPONSIBILITIES:

• Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Developed data conversion/quality/cleansing rules and executed data cleansing activities such as data.
• Consolidation, standardization, matching Trillium for the unstructured flat file data.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 8.5
• Experience in integration of heterogeneous data sources like Oracle, DB2, SQL Server and Flat Files (Fixed & delimited) into Staging Area
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Implemented complex business rules in Informatica Power Center by creating re-usable transformations, and robust Mapplets.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Improved session Performance by enabling property incremental aggregation to load incremental data into target table.
• Worked with Functional team to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.
• Copied/Exported/Imported the mappings/sessions/ worklets /workflows from development to Test Repository and promoted to Production.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.

ENVIRONMENT: Informatica 8.1.1, UNIX, Oracle, DB2, Flat File, Toad, SQL Developer