SUMMARY

• Over 7 years of strong experience in performing ETL operations like Data Extraction, Data Transformation and Data Loading with Informatica Power Center 9.x, 8.x,7.x,6.x
• Experience in all the phases of the Data Warehouse project life cycle involving design, development and Implementation of Data warehouses using ETL, Online Analytical Processing & reporting tools
• Strong experience in Logical and Physical Data Modeling, Dimensional Data Modeling, Star Schema/Snow Flake modeling, Fact and Dimension Tables using Erwin
• Good Understanding knowledge of Ralph Kimball & Bill Inman Methodologies.
• Extensive knowledge of various kinds of Informatica Transformations such as Source Qualifier, Aggregate, Lookup, Rank, Joiner, Filter, Router, Sorter, Sequence, Union, Update Strategy, Stored Procedure, Normalizer, xml Transformation.
• Experience on Informatica designer tools like transformations, reusable transformations, mappings, mapplets, and workflows. Extensively worked with Slowly Changing Dimensions (Type I, Type II and Type III). experience in writing efficient SQL queries, PL/SQL Scripts, fine tuning queries and wrote several SQL queries
• Extensively worked in creating Mappings using Informatica Designer and processing tasks using Workflow Manager to configure data flows from multiple data sources (Oracle, SQL server, Flat files, XML) to targets persistent data stores.
• Experience in maintenance and enhancement of existing data extraction, cleansing, transformation, and loading processes to improve efficiency.
• Worked withInformaticaData Quality 9.1 (IDQ) for Analysis, data cleansing, data matching, data conversion, exception handling, and reporting.
• Experience in Cognos Power Play Transformer, Impromptu Web Reports (IWR), Upfront, Cognos Query.
• Experience working with different Databases like Oracle 11, Oracle10g, Oracle 9i/8i, SQL Server 2005/2008, Teradata, Netezza and MS Access.
• Implemented performance tuning techniques on Targets, Sources, Mappings and Sessions.
• Created Workflows with event wait, decision box, email and command tasks using Workflow Manager and monitored them in Workflow Monitor.
• Extensively worked on production support issues and resolved them using session logs, workflow logs. Handled new enhancements and customer support
• Have exposure to all the steps of Software Development Life Cycle (SDLC). Also worked in development environment using Agile Methodology.
• Skilled in Stored Procedures, Views, Functions, Triggers, Indexes and Packages.
• Extensively worked for monitoring scheduled, running, completed and failed sessions. Involved in debugging the failed mappings and developing error handling methods.
• Experience in UNIX Shell Scripting in order to fetch the input files and archive them for the Power center usage. Created UNIX shell scripts and used them in pre - post session commands.
• Experienced in administrative work by creating users, user groups, folders, configure security, giving permissions in folders and to users in Repository manager.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9..x/8.x/7.x/6.x (Workflow Manager, Workflow Monitor, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, and Informatica server), Power exchange 9.x/8.x

Database & Related Tools: Oracle 10g/9i/8i, MS SQL Server 2005/2008, Teradata, Netezza, DB2, SQL*Plus, SQL Loader, MS Access, SmartFTP, Putty, FileZilla

Data Modeling Tools: TOAD 10.6, MS Visio, Erwin 4.0 (Dimensional Data Modeling, Star schema, Snowflake schema), Physical and Logical Data Modeling

BI & Reporting Tools: Cognos 8.4, Crystal Reports, Business Objects 6.5

Languages: SQL, PL/SQL, C, C++, JAVA, Unix Shell Scripting

Operating Systems: Window / 98/2000/2003/2008/ XP, Unix.

Other: Agile & waterfall methodology, MS Word, MS Excel, MS Office 2003/2007/2010 , Outlook, IBM Lotus Notes, PowerPoint,Autosys

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Sr.Informatica Developer

Responsibilities:

• Work in different stages of project from development, enhancement and production maintenance.
• Worked on view to extract data and load into target based on incremental strategy.
• Create trigger process to send alert for job completion to downstream process.
• Created Migration Request Checklist Documents.
• PerformedUnit and Integrationtesting and wrote test cases.
• Understanding & Working knowledge of CDC (Change Data Capture).
• Created flexible mappings/sessions usingparameters,variables and heavily usingparameter files.
• Developed File watcher jobs to schedule the jobs and call the dependency jobs.
• Performedcode reviews & testingthe ETL code that was modified in connection with this conversion process.
• Enhanced the existing mappings, workflows with new business requirements and report the project status to the management
• Worked extensively with Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
• Contributed to the development ofETLmappingsincludingjoiner, sorter, router, aggregator, union, both connected and unconnected lookup and filter transformationsetc.
• Participated in Designing and documenting validation rules, error handling and test strategy of ETL process.
• Developed Unix Shell scripts and used them in InformaticaPre- & Post- Sessioncommand tasks and Standalone Command tasks.
• Created procedures to truncate data in the target before the session run.
• Worked on object Migration using Repository Manager.
• Also involved intuningthe mappings in the transformations by tracking the reader, writer, transformation threads in the session logs and used tracing level to verbose during development & only with very small data sets.
• Standardized parameter files to define session parameters such as database connection for sources targets, last updated dates for Incremental loads

Environment: Informatica 9.5.1, Oracle Client 11g, Putty, WinScp, MQ Client, Tidal scheduler, Cognos.

Confidential, Overland Park, KS

Sr.Informatica Developer

Responsibilities:

• Involved in designing, developing and documenting of the ETL (Extract, Transformation and Load) strategy to populate the Data from various source systems feeds using Informatica
• Worked with the customers and business analysts for requirements gathering, rules and metadata, understanding the business and designing the solution.
• Involved in sourcing the xml rows from source database
• Parsed the xml filtering the key/value combinations which are not needed. Created the target file which is pipe delimited txt file with each containing policy id, key, value.
• Created data files which are ready to be loaded into the target db tables.
• Used SCD type 2 to load Historical and present Data into ODS and EDW.
• Populated the business rules using jobs into the Repository for Metadata management.
• Partitioned sessions for concurrent loading of data into the target tables.
• Involved in the upgrade of Informatica from 9.0.1 to 9.5.1.
• Designed and developed mappings, defined workflows and tasks, monitored sessions, exported and imported mappings and workflows.
• Worked with data warehousing implementation partners as subject matter expert to define ETL requirements, resolve process, data quality issues, and identify gaps.
• Created and configured workflows and sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• As part of the INBOUND Interface project, have run the (PERL and UNIX) scripts to decrypt files from Insurity and as part of OUTBOUND Interface project, have run (PERL and UNIX) scripts to encrypt and send files to Insurity Server.
• Connected to Insurity FTP site from UNIX server to download the files and used SmartFTP for transferring the files.
• Estimates and planning of development work using Agile Software Development
• Used SQL tools like SQL server management studio to run SQL queries and validate the data pulled in reports.
• Created a Migration strategy to migrate from Development to QA/UAT/Production environment
• Supporting day-to-day issues as well as new pieces of work
• Identified recurring issues/alerts and conduct root cause analysis

Environment: Informatica Power Center 9.x, (Repository Manager, Mapping Designer, Workflow Manager and Workflow Monitor), MS SQL server 2008, Putty, SmartFTP, FileZilla 3.5.3 and UNIX

Confidential, Memphis, TN

ETL Consultant

Responsibilities:

• Primarily responsible to convert business requirements into system design.
• Used ETL to standardize data from various sources and load into Data Stage area, which was in Oracle.
• Work with Business Analyst and business users to clarify requirements and translate the requirement into technical specifications.
• Data Integration is done using Informatica tool
• Designed and developed complex mappings in Informatica to load the data from various sources using different transformations such as Java, SQL, Transaction control, Source qualifier, Look up (connected and unconnected), Expression, Aggregate, Update strategy, Sequence generator, Joiner, Filter, Rank, and Router transformations.
• Designed complex mappings involving target load order and constraint based loading.
• Data quality checking and interacting with the business analysts.
• Designed and developed mappings, defined workflows and tasks, monitored sessions, mappings and workflows, backups, and recovery.
• Extensively worked with database and Informatica Partitioning for performance tuning.
• Extensively designed and developed reusable transformations & aggregations and created target mappings that contain business rules.
• Worked under Agile methodology
• Extensively used Informatica Power Exchange.
• Created and configured workflows, worklets, and sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Implemented Change Data Capture (CDC) to extract information and Partitioned sessions for concurrent loading of data into the target tables.
• Fixed invalid mappings, tested stored procedures and functions, and performed unit testing of Informatica Sessions and Workflows.
• Implemented Slowly Changing Dimensions (SCD) to update the dimensional schema.
• Developed PL/SQL stored procedures and UNIX shell scripts for pre and post session commands and batch jobs.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL
• Wrote shell scripts and control files to load data into staging area and then into database tables.
• Provided extensive support in UAT (user acceptance testing) and deployment of mappings.
• Performed extensive testing on the mappings and wrote queries in SQL to check if the data was loading to the dimension tables and fact tables properly.

Environment: Informatica Power Center 8.6.1(Repository Manager, Designer, Workflow Manager, Workflow Monitor, Repository Administration Console), UNIX, Oracle 10g

Confidential, Euless, TX

ETL Developer

Responsibilities:

• Involved in the Requirement Gathering and analysis of the rules and metadata, understanding the business and designing the solution.
• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document, and ETL specifications
• Used heterogeneous sources like DB2, Oracle, Teradata and MS SQL Server (2005).
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, lookup, and Router
• Used Teradata TPump is a highly parallel utility designed to continuously move data from data sources into Teradata tables without locking the affected table.
• Installed the IDQ Accelerator content in Development and Production environment.
• Created Users, Managed users, Granted Permissions, gave Project level permissions.
• Created target load order group mappings and scheduled them for Daily Loads.
• Data quality checking and interacting with the business analysts.
• BTEQ provided an interactive or batch interface that allows you to submit SQL statements, import and export data, and generate reports.
• Created profiles in the Informatica Analyst tool with various sources like Flat files and relational Data Object.
• Developed strategy and implemented for deployment of data integration into EDW.
• Developed custom rules for parsing and address validation.
• Worked with architects and DBA in designing the rules engine and implementing the logical and physical model based on the rules and metadata.
• Extensively used Autosys to schedule the jobs.
• Used transformations like case converter, labeler etc. in the IDQ.
• Developed new reports in Cognos Report Studio upon requests from business users.
• Worked with Informatica Identity resolution to utilize identity data concerning the doctors.

Environment: Informatica 8.0, Informatica Data Quality8.0, Informatica Developer 8.0, Windows 7, Cognos8, Teradata, SQL Server 2008,Autosys

Confidential, Madison, WI

Informatica Developer

Responsibilities:

• Interacted with the Business Users to analyze the business requirements and transform the business requirements into the technical requirements.
• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Created logical and physical data models using Erwin.
• Created Entity Relationship (ER) diagrams based on requirements.
• Created ETL mapping documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Worked with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Created mappings to load data from source to staging and staging to ODS (Operational Data Sources)
• Created mappings using different transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator etc.
• Developed mapplets and worklets for reusability.
• Implemented weekly error tracking and correction process using Informatica.
• Implemented audit process to ensure Data warehouse is matching with the source systems in all reporting perspectives.
• Designing and creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• Implemented Performance tuning in Mappings and Sessions by identifying the bottlenecks and Implemented effective transformation Logic.
• Executed BTEQ scripts along with performance tuning of queries to handle larger volume of data on Teradata environment
• Created Test tables and worktables on development and production on Teradata.
• Worked extensively with the Teradata Queryman to interface with the Teradata.
• Extensively used Stored Procedures, Triggers, Functions and Packages using PL/SQL for creating Connected and Unconnected Stored Procedure Transformations.
• Created Maestro schedules/jobs for automation of ETL load process.
• Involved in Unit Testing, User Acceptance Testing (UAT) to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Formatted Reports as per the user requirements using extensive functionalities in Business Objects, which allows the users to analyze the data.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, functions, Cross Tab, Master/Detail and Formulae etc.
• Preparing and using test data/cases to verify accuracy and completeness of ETL process.
• Involved in the Production support and also transferred knowledge to the other team members.

Environment: Informatica Power Center 8.5.1, Teradata V2R5, Oracle 10g, Unix, DB2,Sybase 12.x, MS SQL server 2005, Business Objects6.5, TOAD, Erwin, WINCVS, XML, HP-UNIX.

Confidential

SQL Server Developer

Responsibilities:

• Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
• Involved in ER diagrams and mapping the data into database objects.
• Installed and Configured SQL Server 2000 successfully.
• Design of the database and the tables.
• Build table relationships and wrote stored procedure to clean the existing data.
• Coordinated with the front-end developer to put in the business rules. Wrote procedure to check some of the rules at the backend at the time of entering data.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Developed the project using iterative approach.
• Managed database changes based on feedback.

Environment: MS SQL Server 2000 Enterprise Edition, Enterprise Manager, MS Office 97.