SUMMARY

• Several years of professional IT experience as an Informatica developer in different domains like Financial, Banking, Health care domains of IT projects following the SDLC process such as analysis, design, coding, testing and deployment.
• Strong knowledge on development and design of ETL methodology for supporting data transformations and processing in a corporate wide ETL Solution using Informatica Power Center 9.x/8.x (Workflow Manager, Workflow Monitor, Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer), Power Exchange, Informatica data quality (IDQ), Informatica MDM, DataMart, ETL, OLAP, ROLAP, MOLAP, OLTP, Autosys, Control M, Maestro.
• Experience in Logical and Physical data modeling of the data warehouse using Erwin 9.x/7.x Data modeling tool.
• Good knowledge in designing and developing Data marts, Data warehouse using multi - dimensional models such as Snow Flake Schema and Star Schema while implementing Decision Support Systems. Experience in modeling of Fact & Dimensions tables.
• 3 Years of experience working on IDQ and Informatica MDM. Well versed with Data Profiling, creation of Rules, Score Cards, Informatica MDM Hub console, Trust and Validation rules, Match and Merge Process configuration etc.
• Strong database experience using Oracle 11g, MS SQL Server 2012, Teradata 14.0/ 13.0, DB2 LUW, MS Access, Netezza hands on working knowledge in Oracle and PL/SQL, writing Stored Procedures, Packages, Functions and Triggers.
• Extensively worked with ETL tools to extract data from various source including Oracle, Flat files, DB2, XML, Mainframes, SAP and Teradata. Experience in Performance tuning of sources, targets, mappings and sessions.
• Well acquainted using Teradata utilities BTEQ, Fast Load, Multi Load, Fast Export, Tpump, SQL Assistant, SQL Administrator.
• Extensive experience in Designing and Developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Normalizer, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Union, XML Source Qualifier, Address doctor, Standardizer, Labeler, Keygen etc.
• Implemented change data capture (CDC) logic to check for changes in data.
• Expert on Slowly Changing Dimensions Type1, Type 2 and Type 3 for inserting and updating Target tables for maintaining the history.
• Strong knowledge/experience in Informatica Trouble Shooting / Debugging by using Debugger.
• Well experienced with Unix Shell Scripting using PMCMD,INFACMD utility.
• Performed data validation by Unit Testing, Integration Testing, User Acceptance Testing and Operational Acceptance Testing.
• Good Knowledge on IBM Cognos, SSAS and SSIS.
• Involved in 24/7 Production Support.
• Possess good logical ability in providing solution design, resolving issues.
• Well acquainted with onsite-offshore co-ordination, task allocation, client reporting.
• Excellent communication and demonstration skills for analyzing user’s requirements.

TECHNICAL SKILLS

RDBMS: Oracle 11g,MS SQL Server 2012, Teradata 14.0, DB2, MS Access, SQL, PL/SQL

DW/ETL Tools: Informatica Power Center 9.x/8.x(Workflow Manager, workflow Monitor, Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation developer), Informatica PowerMart, Power Connect, Power Plug, Power Analyzer, Power Exchange, Informatica Data Quality, Informatica MDM, Datamart, ETL, OLAP, ROLAP, MOLAP, OLTP, Autosys, Control M, Maestro

Reporting Tools: Business Objects XI R3 - R2-R 1/6.5/6.0/5.1/5.0 , Business Objects SDK, Web Intelligence 2.5/2.6, Cognos Impromptu 8.0/7.0/6.6/6. x

Languages: SQL, PL/SQL, VB 6.0, PERL, Shell Scripting, XML Visual Studio,SQR.

Database Tools: SQL Developer, Teradata SQL assistant, TOAD

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow-Flake Schema Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN, Visio

PROFESSIONAL EXPERIENCE

Confidential, Montvale, NJ

Informatica Developer

Responsibilities:

• Perform an active role in shaping and enhancing overall ETL Informatica architecture, including ETL standards, patterns and best practices. Work with team to ensure standards and patterns are followed.
• Participated in designing and development of software using agile development life cycle.
• Unit testing the solutions in development and testing environment and deploying them in Production.
• Developed complex mappings using Informatica mapping designer for reading data from source flat files, xml files and for transforming the data and for loading the data into target.
• Written PL/SQL procedures for processing business logic in the database. Tuned SQL queries and views for better performance.
• Developed UNIX shell scripts to schedule the Informatica processes using UNIX command and Informatica pmcmd commands.
• Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems and Trust.
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
• Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
• Involved with Informatica team members in Designing, document and configuring the Informatica MDM Hub to support loading, cleansing, matching, merging.
• Implemented CDC (Change Data Capture) by tracking the changes in critical fields required by the user.
• Attending status calls, preparing production activities.
• Used Debugger to test the mappings and to fix bugs.
• Profiled the data using Informatica Analyst tool to analyze source data from source systems and performed Data Quality Audit.
• Experience in Java transformation, XML transformations and well versed in writing java code to implement few of the requirements in an effective manner.
• Involved in preparing Mapping Specification Document.
• Logged defects, fixed and closing defects.
• Implemented various Informatica transformations like Sorter, Filter, Router, Expression, Aggregator, Ranker, update strategy, joiner, Lookup, Sequence generator, Transaction Control, Source Qualifier etc.
• Daily Rigorous interaction with Client and team.
• Implemented different Tasks in work flows which included Session, Command, E-mail, Event-Wait etc.
• Using Informatica versioning.
• Used Dynamic Lookup caches, Incremental Aggregation whenever needed.
• Extensively used PDO.
• Implemented slowly changing dimensions methodology to keep track of historical data.
• Expertise in performance tuning the user queries. Execution of frequently used SQL operations and improve the performance.
• Performance Tuning of sources, Targets, mappings, sessions and SQL queries in transformations.
• Developed unit test plans and involved in system testing.
• Creation of design documents for the requirements.
• Familiar with Logical Data Model and Physical Database design using Erwin Data modeler.

Environment: & Tools Used: Informatica Power Center 9.5.1, Informatica MDM Hub Console, Repository manager, Oracle 11g/10g/9i,Toad,Jira,Univiewer Console, Citrix Receiver, XML, flat files, IBM Cognos, SQL Developer, PL/SQL, Putty, WinScp, HP ALM, Quality Center 9.x,Autosys, Windows 7,Erwin Data modeler and Unix Shell Scripting.

Confidential, Houston, TX

ETL Informatica Developer

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Developed FRD (Functional requirement Document) and data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis.
• Created Mapplets, reusable transformations and used them in different mappings.
• Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.
• Made use of Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for clean up and update purposes.
• Implemented parallelism in loads by partitioning workflows using Pipeline, Round-Robin, Hash, Key Range and Pass-through partitions.
• Validation of Informatica mappings for source compatibility due to version changes at the source.
• Trouble shooting of long running sessions and fixing the issues.
• Prepared 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.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Worked with reporting team to help understand them the user requirements on the reports and the measures on them.
• Migrated repository objects, services and scripts from development environment to production environment. Extensive experience in troubleshooting and solving migration issues and production issues.
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.

Environment: Informatica Power Center 9.5.1, Repository manager, Oracle 11g/10g/9i, SQL Server2008, flat files, IBM Cognos, SQL Developer, PL/SQL, Putty, WinScp, Autosys, Windows 7,Erwin Data modeler and Unix Shell Scripting.

Confidential, Washington, DC

Informatica Consultant

Responsibilities:

• Interacted with Business analysts in requirement gathering and analysis phase.
• Involved in Design Part of the Project by Creating FSD & Business mapping documents.
• Developed Informatica workflows and sessions associated with the mappings using Workflow Manager.
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improved the performance of the mapping Involved in performance tuning on Informatica in all levels.
• Tested all the applications and transported the data to the target Warehouse tables, schedule and run extraction and load process.
• Used Change Data Capture on the source tables to capture the incremental data.
• Designed and Developed transformation scripts to load data into core area using BTEQ/MLOAD.
• Developed and modified the SQL queries based on the client requirements.
• Used IDQ, IDE for Data Analysis.
• Worked on loading of data from several flat files sources using Teradata Fast Load and Multi Load.
• Writing Teradata SQL Queries to join or any modifications in the table.
• Configured Address Doctor which can cleanse whole world address Data and enhanced by making some modifications during installation.
• Used Hierarchies tool for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD.
• Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDM from various source systems.
• Followed Health Level 7(HL7) standards in the project implementation.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Creating tables, indexes for Teradata Stage tables.
• Troubleshooting and Performance tuning of Teradata and applications.
• Transfer of large volumes of data using Teradata Fast Load, Multi Load and T-Pump.
• Prepared low level Source to Target mapping documents.
• Worked with multiple sources such as flat files, Oracle for extraction using Informatica.
• Created BTEQ scripts to insert the target tables.
• Making Unit Test Cases based on business logic and Testing of mappings and workflows.
• Checked the session and error logs to troubleshoot problems, and also used a debugger for complex problem troubleshooting.
• Involved in Code Migration from DEV to QA and QA to PROD.
• Creating OBIEE reports based on user requirements.

Environment: and Tools Used: UNIX, Informatica 9.1,IDQ,Informatica MDM Hub Console, Repository Manager, XML, Flat files, Pl/SQL, SQL Developer, Oracle 11g,IBM DB2 LUW 9.x,Putty,WINSCP,Autosys,Teradata SQL Assistant, HP ALM, OBIEE, Windows 7

Confidential, Houston, TX

ETL - Sr. Developer

Responsibilities:

• Analyzed Business Requirements document and Functional Design document.
• Involved in analysis, design & development of the project.
• Understand the client requirements for data transformation.
• Developed technical specification based on Business requirements.
• Creation and execution of unit test cases and unit testing of Informatica mappings.
• Involved in the development of Informatica Mappings for conversion and interfacing.
• High level and Low level design of Informatica components and Development of mappings, sessions, workflows etc.
• Implemented various Informatica transformations like Expression, filter, Aggregator, Router, Ranker, update strategy, joiner, Lookup, Sequence generator, Source Qualifier, Transaction control, .Stored Procedure etc.
• Used Informatica Workflow Manager to create, execute and Monitor Sessions, Batches and Workflows.
• Peer review of mappings, workflows, sessions etc. and preparation of review checklists for maintaining the production standards.
• Worked extensively on Netezza SQL, its Query Plan.
• Worked on SCD Type 1, Type 2 & Type 3 conversions.
• Developed shell scripts for scheduling/running ETL jobs using pmcmd command.
• Archive the data files generated after successful completions of ETL jobs using UNIX shell scripting.
• Involved in Migration of code to different environments.
• Used HTTP transformation to connect to Web services from Informatica Power Center. Also used SOAP in one of my requirements.
• Preparation of impact analysis based on data analysis of source and target systems.
• Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mapping.
• Attended to Production support issues and Involved in supporting jobs in production environment.
• Involved in the Performance Tuning of Informatica and Netezza database query tuning.
• Involved in production support - root cause analysis of production issues, bug fixing and enhancement of mappings.
• Generated completion messages and status reports using Workflow Manager.
• Provided business user support in generation of reports and analyzing report data.

Environment: and Tools Used: Informatica Power Center 9.1, Oracle 11g/10g/9i, SQL Server2008, SAP, Putty, XML, Flat files, CSV Files,DB2,TOAD,WinScp, Quality Center 9.x, IBM Cognos and Windows XP/Vista.

Confidential, Minneapolis, MN

ETL Developer

Responsibilities:

• Worked closely with the BA and Data Warehouse Architect to understand the source data and need of the Warehouse.
• Analysed Change request (CR) related to ETL and BI applications, as per requests from various team and implemented accordingly.
• Performed Source to Target Mapping.
• Implemented CDC by tracking the changes in critical fields required by the user.
• Developed Complex transformations, Mapplets using Informatica Power Center to Extract, Transform and load data into Data marts, Enterprise Data warehouse (EDW) and Operational data store (ODS).
• Designed Sources to Targets mappings from Excel/Flat files, Xml Files to Oracle using Informatica Power Center.
• Worked on handling performance issues, Troubleshooting of Informatica Mappings, evaluating current logic for tuning possibilities.
• Involved in Data masking for unit testing and fixing the bugs identified, provided data to the reporting team for their daily, weekly, monthly and quarterly reports.
• Created and optimized SQL queries for better performance.
• Created pre sql and post sql scripts which need to be run at Informatica level.
• Responsible for Unit Testing of Mappings and Workflows.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Extensively worked on Slowly Changing Dimensions (SCD) TYPE1, TYPE2 to track the changes.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Responsible for Validation of Data as per the Business rules.

Environment: and Tools Used: Informatica 9.0.x,Oracle 11gR2/11g, SQL SERVER 2008 R2/SQL Server 2012, SSMS 2008R2/2012, IBM DB2 9.x, Oracle SQL developer, Erwin 9.x,RHEL 6.x,IBM AIX Unix V7.x, Autosys 11.x,SSRS & Crystal Reports, Crontab, WinScp/Secure CRT 7.2.x, Microsoft Visio 2013 and Windows 2010.

Confidential

ETL Developer

Responsibilities:

• Extensively used ETL to load data from Flat Files, Oracle to Target Database.
• Developed data Mappings between source systems and warehouse components using Mapping Designer.
• Worked extensively on different types of transformations like the source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator, joiner etc.
• Worked with multiple sources such as flat files, Oracle for extraction using Informatica.
• Involved in the performance tuning of the Informatica mappings and the SQL queries inside the source qualifier.
• Created, launched & scheduled sessions.
• Extensively worked on Slowly Changing Dimensions (SCD) TYPE1, TYPE2, TYPE3 to track the changes.
• Used Workflow Manager to schedule sessions and batches using Informatica.
• Implemented change data capture (CDC) logic to check for changes in data.
• Tested all the applications and transported the data to the target Warehouse Oracle tables.
• Schedule and run extraction and load process.
• Designing and Creating of Session and work flows.
• Reviewing the specifications and mappings.
• Making Unit Test Cases based on business logic and Testing of mappings and workflows.

Environment: and Tools Used: Informatica Power Center 8.6.1, Oracle 11gR2/11g, Toad 9.7.x,SQL Server 2008R2, IBM DB2 8.x, SQL Developer, Erwin 7.x,PL/SQL, Autosys 11.x, Cognos 10.x,Crontab,Secure CRT 7.0.x/WinScp, Quality Center 11.x & QTP 10.x