SUMMARY

• Over 7 years of IT experience in System Analysis, Design Development, Implementation and testing of Databases, Data Warehouse Applications on client server technologies in Pharma, Health care, Banking and Finance Domains.
• Experience in Extraction, Transformation and Loading (ETL) of Data into Data Warehouse using Informatica Power Center 8.x, 7.xversions.
• Designed the Workflows, Mappings, creation of Sessions and scheduling them using Informatica Power Center 8.6, 8.1 and 7.1.
• Experience in Designing and developing the complex mappings from various Transformations like Source Qualifier, Joiner, Aggregator, Router, Filter, Expression, Lookup, Sequence Generator, Java Transformation, Update Strategy, XML Transformations and Web Services.
• Experience with relational and dimensional data modeling, fact constellations and snowflake schema.
• Hands on experience on PRD (Process Requirement Document) in SDLC.
• Designing logical and physical databases using Erwin and developed data Mappings between source systems and target components using Mapping Design Document.
• Experienced in understanding the components of Informatica Data Quality (IDQ).
• Involved in creating complex physical/logical data objects and creation of Profiles and Scorecards.
• Experience in Debugging sessions and mappings; Performance Tuning of the Sessions and mappings, implementing the complex business rules, optimizing the mappings.
• Experience in Data cleansing, Slowly Changing Dimensions
• Implemented data warehousing techniques for Data cleansing, Slowly Changing Dimension Phenomenon’s (SCD) and Change Data Capture (CDC).
• Extensive development, support and maintenance experience working in all phases of the Software Development Life Cycle (SDLC) especially in Data warehousing.
• Good understanding and working experience in Logical and Physical data models that capture current/future state data elements and data flows using Erwin.
• Experience in production Support in Technical and Performance issues.

TECHNICAL SKILLS

Data Warehousing Tools: Informatica Power Center, Informatica Developer, Metadata Manager, Business Glossary Desktop and Power Exchange 9.x, 8.x, 7.x, 6.x and 5.x, Business Objects XIR2, 5.1, 6.5, Informatica Analyst

Databases/RDBMS/Others: MS SQL Server 2008/ 2005/2000 , Oracle 8i/9i/10g/11g, DB2 UDB, Teradata V2R5.0/V2R6.0, XML, Flat Files, CSV Files

Microsoft Suite: Excel, Word, PowerPoint

Data Modeling Tools: CA Erwin, MS Visio

Scripting Languages: UNIX Shell scripting, Korn Shell Scripting (K - Shell) and Perl

Job Control/Other Tools: Control-M, Autosys, TOAD, Putty and CVS

Programming Languages: SQL, PL/SQL, BTEQ, T-SQL, and PHP.

PROFESSIONAL EXPERIENCE

Confidential, OH

Informatica Developer

Responsibilities:

• Designed and developed ETL processes based on business rules using Informatica Power center.
• Developed mappings in Informatica Power Center to load the data from various sources using transformations like Source Qualifier, Expression, Lookup (connected and unconnected), Aggregator, Update Strategy, Filter, Router etc.
• Implemented CCAR Methodology which is the most severe, comprehensive and rigorous tests conducted by most of the US banks.
• Solid experience with Oracle, PL/ SQL, Informatica, XML, Erwin, Visio, Unix/Linux Shell Scripting, Autosys and Quality Center.
• Extensively worked on performance tuning by identifying the bottlenecks in Sources, Targets, Mappings and Transformations and enhanced Performance for Informatica session using large data files by using partitions.
• Created Health check queries for all the audit fields and SSN fields in the stage, data store and EDW applications.
• Experienced in working with Informatica IDQ 9.51. HF3 and have a complete understanding of IDQ Components.
• Responsible for the development of Complex data quality rules and index design, development and implementation patterns with cleansing, parsing, standardization, validation, scorecard, exception, notification and reporting with ETL tool.
• Created Physical data objects, logical data objects in Data Quality in Informatica Developer.
• Created Profiles and Scorecards in IDQ and provided the Scorecards (pictorial representation) in the Informatica Analyst tool.
• Have used Informatica Metadata Manager which is a Power Center web application used to browse, analyze, and manage metadata from disparate metadata Repositories.
• Experienced in working with Metadata Manager which uses Power Center workflows to extract metadata from metadata sources and load it into a centralized metadata warehouse.
• Created and configured the Run data lineage, performed data profiling on the metadata, sharing metadata and report extraction in the Metadata Manager
• Created Business Terms and categories through Business Glossary desktop and results were successfully displayed in Analyst tool

Environment: Informatica Power Center9.5.1 HF3, Informatica IDQ 9.5.1,TOAD for Oracle, Oracle10g/11g, Metadata Manager, Business Glossary Desktop, SQL Server2005/2008, PL/SQL, Informatica Analyst and UNIX K-shell Scripting.

Confidential, NY

Informatica Developer

Responsibilities:

• Designed and developed ETL processes based on business rules using Informatica Power center.
• Developed mappings in Informatica Power Center to load the data from various sources using transformations like Source Qualifier, Expression, Lookup (connected and unconnected), Aggregator, Update Strategy, Filter, Router etc.
• Responsible for identifying reusable logic to build several Mapplets which would be used in several mappings.
• Created mappings to extract and de-normalize (flatten) data from XML files using multiple joiners with Informatica Power Center.
• Worked on performance tuning by identifying the bottlenecks in Sources, Targets, Mappings and Transformations and enhanced Performance for Informatica session using large data files by using partitions.
• Created the transformation routines to transform and load the data.
• Worked closely with the end users and Business Analysts to understand the business and develop the transformation logic to be used in Informatica Power Center.
• Was part of scripting team for shell script to automate and migrate data from ODS to data warehouse.
• Written UNIX Korn shell scripts along with Control M for scheduling the sessions and workflows.
• Informatica cloud platform allows the partners to build complex integrations and running them as custom Informatica cloud services.
• Developed Test Plans and written Test Cases to cover overall quality assurance testing.
• Used global temporary tables and volatile temporary tables in Teradata and used Fload, Mload and error tables from Teradata.

Environment: Informatica Power Center9.1, Informatica IDQ 8.x,Informatica Power Exchange 8.0, TOAD for Oracle, Oracle10g/11g,Informatica cloud services, Teradata, SQL Server2005/2008, Erwin 4.0, DB2, PL/SQL, Power Builder and Shell(K) Scripting.

Confidential, TX

Informatica Developer

Responsibilities:

• Collaborated with Business analysts for requirements gathering, analysis, ETL design and development for extracting data from the heterogeneous source systems like MS SQL Server, Oracle, flat files, XML files and loading into Staging and Data Ware House Star Schema.
• Extensively used ERWIN for Logical / Physical data modeling and Dimensional data modeling, and designed Star and Snowflake schemas.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Involved in massive data cleansing prior to data staging.
• Designed and developed ETL routines, using Informatica Power Center within the Informatica Mappings, usage of Lookups, Aggregator, Java, XML, Ranking, Mapplets, connected and unconnected stored procedures / functions / Lookups, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers were extensively done.
• Created complex mappings with shared objects/Reusable Transformations/Mapplets using mapping/Mapplet Parameters/Variables.
• Designed and developed the logic for handling slowly changing dimension table’s load by flagging the record using update strategy for populating the desired.
• Extensively used pmcmd commands on command prompt and executed Unix Shell scripts to automate workflows and to populate parameter files.
• Worked with UNIX shell scripts extensively for job execution and automation.
• Scheduled Informatica workflows using AppWorx to run at regular intervals.
• Used SQL tools like Query Analyzer and TOAD to run SQL queries and validate the data.
• Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
• 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.

Environment: Informatica Power Center 8.6, Oracle 10g, MS SQL Server 2008, Toad, Windows XP and UNIX.

Confidential, VA

Informatica Developer

Responsibilities:

• Involved in design, development and maintenance using procedures for getting data from all systems to Data Warehousing system and data was standardized to store various Business units in tables
• Worked with business users to create/modify existing reports using the reporting tool.
• Parsed high-level design specifications to simple ETL coding and mapping standards.
• Used Power Center for Extraction, Transformation and Loading data from heterogeneous source systems into the target data base.
• Created DTS Packages using SQL Server 2000.
• Used stored procedure, views and functions for faster processing of bulk volume of source data
• Upgraded exiting complex DTS packages to corresponding SSIS by using integration services Control Flow and Data Flow Transformation tasks (i.e. File system, For Each Loop, Derived Columns, Union all, Merge join, Condition Split, Aggregate).
• Develop ETL processes to replicate data from multiple platforms into reporting databases.
• Created and scheduled SSIS packages for transferring of running feeds from various departments and multiple servers and resources to Dev. Servers.
• Responsible for unit testing and Integration testing.
• Assisted in mentoring internal staff on Informatica best practices and skill.
• Responsible for Performance Tuning of Informatica Mapping and Tuned SQL Queries.
• Responsible for multiple projects with cross functional teams and business processes.
• Responsible for development and support of ETL routines and designed Informatica loads required for populating the data warehouse and Experience in loading high-volume data, Tuning and troubleshooting of mappings and Created documentation to support for the Application.
• Developed ETL process for the integrated data repository from external sources.
• Provided production support by monitoring the processes running daily basis.
• Created Functional Specifications for the different Problem Logs to get the approval of the work.
• Created Remedy Tickets for the work approval from different users.

Environment: Informatica Power Center 8.6, PL/SQL, SQL Server 2000, SSIS, Control M, HP-UX, AIX 4.3.3, Shell Scripting.

Confidential

Data warehouse Developer

Responsibilities:

• Involved in the requirement definition and analysis in support of Data Warehousing efforts.
• Created Repository using Repository Manager.
• Worked Extensively on Informatica tools -Repository Manager, Designer and Server Manager.
• Involved in Extraction, Transformation and Loading (ETL) Process.
• Created the Source and Target Definitions using Informatica Power Center Designer.
• Imported Flat files to Designer did some modifications, used in the Mappings and exported into an Oracle tables.
• Developed and tested all the backend programs, Informatica mappings and update processes.
• Created and Monitored Batches and Sessions using Informatica Power Center Server.
• Tuned the mappings to increase its efficiency and performance. Used Informatica Workflow Manager to create workflows, Workflow Monitor was used to monitor and run workflows
• Involved in production support which also includes trouble shooting of connectivity issues.

Environment: Informatica Power Center 5.1/6.2, Oracle 8i, UNIX, TOAD, Windows NT.