SUMMARY

• Over 7+ years of IT experience in design, analysis, development, documentation, coding and implementation including Databases, Data Warehouse, ETL Design, Oracle, PL/SQL, SQL, Business Objects (Designer, Web Intelligence, Supervisor), Informatica 9.x/8.x/7.x, Informatica Data Quality
• Expertise in the ETL Tool Informatica and have extensive experience in Power Center Client tools including Designer, Repository Manager, Workflow Manager/ Workflow Monitor
• Extensively worked with complex mappings using various transformations like Filter, Joiner, Router, Source Qualifier, Expression, Union, Unconnected / Connected Lookup, Aggregator, Stored Procedure, XML Parser, Normalize, Sequence Generator, Update Strategy, Reusable Transformations, User Defined Functions, Mapplets, etc.
• Experienced in mapping techniques for Type 1, Type 2 and Type 3 Slowly Changing Dimensions
• Extensive experience in debugging mappings, identifying bottlenecks/bugs in existing mappings/workflows by analysing the data flow and evaluating transformations
• Hands - on experience in Informatica upgrade from 8.6 to 9.1
• Data modelling experience in Star schema, Snowflake schema design, Fact, Dimensions tables, Physical and Logicaldata modelling using Erwin
• Solid experience in implementing business requirements, error handling, job control & job auditing using Informatica PowerCenter tools
• Experience in using IDQ for name matching validation.
• Expert in analyzing Business & Functional Specifications, creating Technical Design Document and Unit Test cases
• Strong experience in SQL, PL/SQL, Tables, Database Links, Materialized Views, Synonyms, Sequences, Stored Procedures, Functions, Packages, Triggers, Cursors, Collections and Indexes in Oracle
• Sound knowledge of Linux/UNIX, Shell scripting, experience in command line utilities like pmcmd to execute workflows in non-windows environments
• Experience in integration of various data sources with Multiple Relational Databases like DB2, Oracle, SQL Server, MS Access, Flat Files, and XML files
• Experience in Migrating Data from Legacy systems to Oracle database using SQL*Loader
• Well versed with onsite/offshore project delivery model and experience in working with offshore teams
• Highly motivated, Reliable, Responsible, Good team player

TECHNICAL SKILLS

Operating System: UNIX, Linux, Windows

Programming and Scripting: Perl Scripting, Shell Scripting, XSLT, PL/SQL, T-SQL.

Specialist Applications & Software: Informatica PowerCenter 9.x/8.x (Repository Manager, Designer, Server manager, Work Flow Monitor, Work Flow Manager)

Data Modeling (working knowledge): Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions), ER Diagrams.

Databases tools: SQL Server Management Studio(2008), Oracle SQL Developer(3.0), AQT (Oracle/Netezza).

Scheduling tools: Informatica Scheduler,CA Scheduler, crontab, ESP, Maestro.

Conversion/Transformation tools: Informatica Data Transformation, Oxygen XML Editor(ver 9,ver 10)

Software Development Methodology: Agile, SDLC, Lean.

Domain Expertise: Publishing, Insurance/Finance.

Others (working knowledge on some): OBIA RPD creation, OBIEE, ECM, Informatica Data TransformationXMAP, DAC, Rational Clear Case, WS-FTP Pro, Schema, DTD, XML

ETL Tools and Reporting Tools: InformaticaPowerCenter 9.5/9.1/8.6/8.1/7.1 , Informatica Power Exchange.

RDBMS: SQL, SQL*Plus, SQL*Loader, Oracle11g/10g/9i/8i, Teradata, IBM DB2, UDB 8.1/7.0, Sybase 12.5,Netezza v9

Data Modeling: MS SQL Server 2000/2005/2008 , MS Access 7.0/2000.

Tools: Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, Erwin 3/ 4/4.1, Tortoise SVN 1.6.15, CA Scheduling Tool,ESP, CICS, CA WA Workstation, CA Software Change Management Workbench.

Database Tool: SQL ServerManagement, Toad 11.6 (Oracle), AQT v9 (Advanced query tool)(Oracle/netezza),DB Artisan 9.0 (Sybase), SQL Browser(Oracle,Sybase), Isql.

Operating Systems: UNIX,LINUX,WINDOWS & MAC OS

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr. ETL/Informatica Developer

Responsibilities:

• Worked extensively on Source Analyzer, Mapping Designer, Target Designer, Workflow Manager and Workflow Monitor
• Currently working as Consultant (ETL development).
• Work along with other stakeholders to create, test and deploy ETL programs for Nationwide’s Data Warehousing.
• Responsible for Evaluation, Analysis, Design, Development and Delivery of ETL programs using Informatica, Perl, Shell and SQL(NZSQL for Netezza and PL/SQL for Oracle).
• Interact with Business Users, Business Analysts and Source/Target System owners to formulate the Requirements and Business Logic and ensure technical compatibility.
• Work closely with business analysts, end users, developers and QA team to communicate project expectations to team members and status to all stakeholders in a timely and effective manner for taking constructive/corrective measures.
• Worked on multiple regulatory projects like Retirement Pensions Datafeeds, (Nation wide financial network ) NFN and ADC line
• Develop/Implement UNIX shell scripts for file-handling and other tasks requirements.
• Test Mappings for compliance to required functionality and standards.
• Test data integrity among various sources and targets.
• Facilitate Unit, System and Integration testing of applications.
• Provide support and expertise during QA, UAT, deployment and post implementation, as needed.
• Carry out performance tuning techniques by identifying and resolving the bottlenecks in sources, targets, transformations, mappings and sessions.
• Troubleshoot/Optimize modules by identifying bottlenecks in ETL processes.
• Schedule Extraction/Load processes using Maestro and ESP/CICS scheduling tools.

Environment: UNIX, Oracle, Informatica PowerCenter 9.x, Linux, Perl, Shell, PL/SQL, AQT, Netezza, Maestro, ESP, CICS,, CA Software Change Management Workbench.

Confidential, Columbus, OH

Sr. ETL/Informatica Developer

Responsibilities:

• Worked extensively on Source Analyzer, Mapping Designer, Target Designer, Workflow Manager and Workflow Monitor
• Created Complex mappings using Connected and Unconnected Lookups, Aggregate, Update Strategy, and Router transformations for populating target table in efficient manner.
• Worked extensively with update strategy transformation for implementing inserts, updates and deletes
• Extensively worked with flat file sources, both fixed-width and delimited, to read data and write the data into the flat files.
• Worked on Unix shell scripts used to manipulate data flat files that were input and output of Informatica workflows.
• Utilized Subversion and the Tortoise SVN client to save source code in a central repository and work with teammates on the same code.
• Converted multiple Abinitio graphs to Informatica workflows, which transformed and loaded party and credit reference data.
• Converted Sybase SQL stored procedures to Informatica workflows related to employee reference data and other client coverage reports
• Developed Informatica parameter files to allow parameterization of concurrent execution-enabled workflows.
• Developed Informatica workflows by reading the data from one database and loading the data to another database
• Developed jobset and job definitions for Computer Associates (CA) Unicenter scheduling tool that executed Informatica workflows and Unix scripts.
• Responsible for using CA Unicenter GUI to execute jobsets in test environments.
• Responsible for monitoring source code and scheduling definition deployments to various environments, such as system integration testing, user acceptance testing, and production regions.
• Extensively worked with various Active transformation like Filter, Sorter, Aggregator, Router, Lookup, Joiner and Update Strategy transformations
• Responsible for validating production deployments and initial batch runs during off-hours, specifically weekends.
• Responsible for defining test scenarios to be executed operations teams in controlled test environments.
• Developed test cases, conducted unit tests, monitoring the jobs and running the validations in testing environments
• Worked on multiple regulatory projects for the Office of the Comptroller of the Currency, specifically Anti-Money Laundering (AML) efforts.
• Worked with Connected look up and unconnected lookup and configured the same for implementing complex logic
• Developed SQL for Sybase 12.5 and 15.0 to produce data to reconcile with data feeds sent to federal organizations as part of the AML effort.

Environment: Informatica Power Center 9.5.1, Sybase 12.5, UNIX, Tortoise SVN 1.6.15, Windows XP, DB Artisan 9.0, SQL Browser,ISQL, Shell scripting, CA Scheduling Tool

Confidential, MN

Sr. Informatica Developer

Responsibilities:

• Worked with Business Analysts (BA) to analyze the Data Quality issue and find the root cause for the problem with the proper solution to fix the issue...
• Document theprocess that resolves the issue which involves analysis, design, construction and testing for Data quality issues
• Involved in doing the Data model changes and other changes in the Transformation logic in the existing Mappings according to the Business requirements for the Incremental Fixes
• Worked extensively with Informatica tools like Source Analyzer, Warehouse Designer, Transformation Developer and Mapping Designer.
• Extracted data from various heterogeneous sources like DB2, Mainframesand Flat Files using Informatica Power center and loaded data in target database.
• Extensively worked with different transformations such as Expression, Aggregator, Sorter, Joiner, Router, Filter and Union in developing the mappings to migrate the data from source to target.Used connected and Unconnected Lookup transformations and Lookup Caches in looking the data from relational and Flat Files. Used Update Strategy transformation extensively with DD INSERT, DD UPDATE, DD DELETE, and DD REJECT.
• Extensively Implemented SCD TYPE 2 Mappings for CDC (Change data capture) in EDW.
• Code walkthrough and Review of documents which are prepared by other team members.
• Involved in doing Unit Testing, Integration Testing and Data Validation.
• Migration of Informatica maps extensively involved in migration from Dev to SIT and UAT to Production environment.
• Developed unix script to sftp, archive, cleanse and process many flat files
• Created and ran Pre-existing and debug sessions in the Debugger to monitor and test the sessions prior to their normal run in the Workflow Manager
• Extensively worked in migrating the mappings, worklets and workflows within the repository from one folder to another folder as well as among the different repositories.
• Created Mapping parameters and Variables and written parameter files.
• Implemented various Performance Tuning techniques by finding the bottle necks at source, target, mapping and session and optimizing them.
• Used SQL queries and database programming using PL/SQL (writing Packages, Stored Procedures/Functions, and Database Triggers).Used SQL tools like TOAD to run SQL queries and validate the data in warehouse.
• Worked with the SCM code management tool to move the code to Production
• Extensively worked with session logs and workflow logs in doing Error Handling and trouble shooting.

Environment: Informatica Power Center 9.0.1,Erwin,Teradata, Tidal, SQL Assistance, DB2, XML, Oracle 9i/10g/11g, MQ Series, OBIEE 10.1.3.2, Toad and UNIX Shell Scripts.

Confidential, Schenectady, NY

SrETL/Informatica Developer

Responsibilities:

• Designing the dimensional model and data load process using SCD Type II for the quarterly membership reporting purposes.
• Derived the dimensions and facts for the given data and loaded them on a regular interval as per the business requirement.
• Generating the data feeds from analytical warehouse using required ETL logic to handle data transformations and business constraints while loading from source to target layout.
• Extracted data from multiple sources such as Oracle, XML, and Flat Files and loaded the transformed data into targets in Oracle, Flat Files.
• Designing and coding the automated balancing process for the feeds that goes out from data warehouse.
• Implement the automated balancing and control process which will enable the control on the audit and balance and control for the ETL code.
• Improving the database access performance by tuning the DB access methods like creating partitions, using SQL hints, and using proper indexes.
• All the jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica power center designer and workflow manager.
• Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations.
• Use debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations and Create mapplets that provides reusability in mappings.
• Analyzing the impact and required changes to in corporate the standards in the existing data warehousing design.
• Following the PDLC process to move the code across the environments though proper approvals and source control environments.
• Source control using SCM.

Environment: Informatica Power Center 9.0/.6, Erwin 7.2/4.5, Business Objects XI, Unix Shell Scripting, XML, Oracle 11g/10g, DB2 8.0, MS Excel, Flat Files, SQL Server 2008/2005, PL/SQL, Windows NT 4.0, Sun Solaris 2.6.

Confidential, NJ

Informatica Developer

Responsibilities:

• Involved in the requirement definition and analysis support for Data warehouse efforts.
• Documented and translated user requirements into system solutions; developed implementation plan and schedule.
• Designed dimension and fact tables for Star Schema to develop the Data warehouse.
• Extracted the data from Teradata, SQL Server, Oracle, Files, and Access into Data warehouse.
• Created dimensions and facts in physical data model using ERWIN tool.
• Used Informatica Designer to create complex mappings using different transformations to move data to a Data Warehouse
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Look up, Aggregator, Stored Procedure, Update Strategy, Joiner, Filter.
• Scheduling the sessions to extract, transform and load data into warehouse database on Business requirements.
• Loaded the flat files data using Informatica to data warehouse
• Created Global Repository, Groups, Users assigned privileges Using Repository manager.
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center server Manager.
• Handled common data warehousing problems like tracking dimension change using SCD type2 mapping.
• Used e-mail task for on success and on-failure notification.
• Used decision task for running different tasks in the same workflow.
• Assisted team member with their various Informatica needs.
• Developed and maintained technical documentation regarding the extract, transformation and load process.
• Responsible for the development of system test plans, test case creation, monitoring progress of specific testing activities against plan, and successfully completing testing activities within the requisite project timeframes.

Environment: Informatica Power Center 7.1, Oracle 9i, UNIX, Sybase, MS SQL Server Windows 2000

Confidential, Irving TX

ETL Developer

Responsibilities:

• Involved in full project life cycle - from analysis to production implementation and support with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into BI database.
• Based on the business requirements created Functional design documents and Technical design specification documents for ETL Process.
• Designing and developing ETL solutions in Informatica Power Center 8.1
• Designing ETL process and creation of ETL design and system design documents.
• Developing code to extract, transform, and load (ETL) data from inbound flat files and various databases into various outbound files using complex business logic.
• Created automated shell scripts to transfer files among servers using FTP, SFTPprotocols and download files.
• Developed Informatica mappings, enabling the ETL process for large volumes of data into target tables.
• Designed and developed process to handle high volumes of data and high volumes of data loading in a given SLA.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Informatica scheduling tool.
• Expertise in creating control files to define job dependencies and for scheduling using Informatica.
• Involved in jobs scheduling, monitoring and production support in a 24/7 environment.

Environment: Informatica Power Center 8.1, ETL, Business Objects, Oracle 10g/9i/8i, HP - Unix, PL/SQL.