SUMMARY

• Designed and developed Complex mappings from various Transformations like re - usable transformations, and Mappings/Mapplets, Unconnected / Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more, mappings using Stored Procedure’s, Normalizer, XML, External Procedure.
• Involved in designing and implementing Data Mart / Data Warehouse applications using Informatica 9.5.1/9.x/8.x (Designer, Workflow manager, Workflow monitor and Repository Manager).
• Skilled in ILM and Power Exchange.
• Experience in Performance tuning of targets, sources, mappings and sessions.
• Good knowledge on SDLC (software development life cycle) and good experience with unit testing and integration testing.
• Preparing the High Level Design Specifications for ETL Coding and mapping standards.
• Strong expertise in Relational data base systems like Oracle 8i/9i/10g, SQL Server 2000/2005, MS Access, design and database development using SQL, PL/SQL, SQL PLUS, TOAD, SQL LOADER.
• Experience in using SQL, PL/SQL, Dynamic SQL, Stored procedures/functions, Triggers and Packages, Complex Joins, Correlated Sub-Queries, Aggregate functions, Analytic functions, Views, Materialized Views, Indexing, Partitioning and Performance tuning the same using explain plan.
• Experience with UNIX commands, VI editor and writing Shell scripts.
• Experience in Ralph Kimball Methodology, Logical Modeling, Physical Modeling, Dimensional Data Modeling, Star Schema, Snowflake Schema, FACT tables, Dimension tables change or transformed of unstructured data to well-formed XML.
• Worked in Agile team setting to develop features for E-commerce sites with new technology platform. Have good knowledge of Facets.
• Experience in working with scheduling tools Autosys and Control M, Tidal, Maestro.
• Experience with high volume datasets from various sources like Oracle, Text Files, DB2 AS400, VSAM, Mainframe Flat Files, and Netezza Relational Tables and xml targets
• Experience on ILM data archiving tool to retrieve the legacy application.
• ETL experience in development of mappings and tuned existing mappings for better performance using InformaticaPowerExchange, InformaticaPowerCenter as per the business rules.
• Expertise in writing Oracle PL/SQL Stored Procedures/Functions/Packages and cursors, Triggers.
• SQL Tuning and creation of indexes for faster database access, better query performance.
• Expertise in writing DDL, DML, DCL, and TCL commands
• Ability to achieve project goals within project constraints such as scope, timing and budget.Allocating work and managing theresource planning.Day to day monitoring of thedeliverableand meeting the expectations of the business clients.
• Experience in creating reports using JReports, Oracle Business Intelligence 10x, Micro strategy, Crystal Reports.
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.

TECHNICAL SKILLS

Data Warehousing: Informatica 9.5.1/ 8.6/8.1/8.0 , Repository Admin Bachelor of Technology Console, Power Exchange Navigator, Informatica ILM, Informatica Cloud.

ETL: Repository, Informatica Manager, Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping DesignerWorkflow Designer, Task Developer, Worklet Designer, Data Mart, DVO.

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star SchemaSnow-Flake, FACT, Dimensions), OLAP, OLTPCardinality, ER Diagrams, Erwin 4.2/4.0).

Databases: Oracle 11g/10g/9i/8ix, T-SQL, MS SQL Server 2000/7.0, DB2 UDB 8.0, MainframeMS Access, SQL, PL/SQL.

Tools: /Utilities: SQL, SQL*Plus, Toad, PL/SQL Developer MultiLoad, FastExport, FastLoad, BTEQ

Data Masking: ILM DDM 9.6.

Programming Languages: C, C++, SQL, PL/ SQL, UNIX, PHP. Confidential Perl Scripting, Batch Scripting. Confidential

Environment: UNIX (Sun Solaris, HP, Linux), Windows 7/XP/2003/2000.

PROFESSIONAL EXPERIENCE

Lead/Sr. Informatica Developer

Confidential, IL

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements. Communicated with business customers to discuss the issues and requirements.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Responsible toleada team of 4 developers, task allocation, task tracking, reporting risk and issues and review of deliverables
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Responsible for resolving the tickets raised by end users and adhoc requests from client. This includes the data analysis, manipulating the production data to fix the issues (with client approval) and Close the ticket with resolution.
• Perform root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on databases and provide support to all ETL applications.
• Monitor all business requirements and validate all designs and schedule all ETL processes and prepare documents.
• Leading the team in the overall initiation, planning, and execution.
• Provide technical support to meet the application service level agreements by providing daily support to technical support and end users as required.
• Experienced as single point of contact to client for enhancement and support related activities
• Coordinate with other application teams, to avoid production job conflicts due to dependency.
• Ensuring delivery of codes/fixes to production in within specified time line
• Responsible for status report to management on weekly basis.

Environment: InformaticaPower Center 9.5, SQL Server 2012, Oracle 11g, Tidal, JIRA, Microsoft

Lead/Sr. Informatica Developer

Confidential, Virginia

Responsibilities:

• Coordinated with Business users & Business Analysts to understand the business requirements and Involved in reviewing technical documents for implementing solutions as per the needs.
• Created different mappings for loading the data into targets using various transformations such as Source Qualifier, Joiner transformation, Router, Update Strategy, Lookup transformation, Expression, Aggregator, and Sequence generator.
• UsedInformaticaPower Center 9.5.1 to extract data from Flat files, SQL to build Data Source and Applied business logic to load the Facets, Vendor and Pharmacy data into Data Mart Tables.
• Extensively involved in doing SQL Tuning at DB level
• Coordinated with DBA's andInformaticaAdmin to fix the issues.
• Created Stored Procedures to load the crosswalk data for Medicare/Medicaid Provider and Printed Directories to SQL Staging tables.
• Migrated ETL code from Development to QA to Production environments by creating variables and parameter files.
• Created and Deployed SSRS reports for the provider directory Health Plan, Vendor data and for provider excluded data and generate the daily, weekly, monthly and Quarterly reports.
• Created tidal jobs to scheduleInformaticaworkflows using Tidal Scheduler.

Environment: InformaticaPower Center 9.5, SQL Server 2012, Oracle 11g, SSRS, Microsoft Visual Studio 2012, Tidal, JIRA, Microsoft Visio, SharePoint, Tortoise SVN.

Sr. Informatica Developer

Confidential, RI

Responsibilities:

• Responsible for converting Functional Requirements into Technical Specifications.
• Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Expression, Router, Filter, Aggregator and Sequence Generator.
• Extracted data from Flat files and Oracle and loaded them into Teradata.
• Extracted data from Sales Force source using Informatica Cloud and PowerCenter and loaded into Target Teradata Database.
• Loaded the data into the Teradata database using Load utilities like Fast Export, Fast Load, Multi Load.
• Developed complex mappings, mapplets to integrate data from varied sources like Teradata, Oracle, Flat files and loaded into target.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop theInformaticaserver and recover the sessions.
• Worked on Performance Tuning to optimize the Session performance by utilizing, Partitioning, push down optimization, pre and post stored procedures to drop and build constraints.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Created Unix Script for ETL jobs and used them as pre/post session commands for session log cleanup and dynamic parameter.
• Developed shell scripts for Daily and weekly Loads and scheduled using Unix Maestro utility.
• UsedInformaticadebugging techniques to debug the mappings and used session log files, bad files and loader log files to trace errors occurred while loading.
• Involved in Unit testing, User Acceptance testing to check whether the data loads into target are accurate, which was extracted from different source systems.

Environment: Informatica 9.5.1, Oracle, Teradata14, PL/SQL Developer, Teradata SQL Assistant, BTEQ, Fast Load, MultiLoad, ShellScrip, Windows 7, Putty, FileZilla, Informatica Cloud, Salesforce.

Senior Informatica/ILM Developer

Confidential, IL

Responsibilities:

• Worked and coordinated with Data Architects, Business Analysts & users to understand business and functional needs and implement the same into an ETL design document.
• Worked with Informatica power center 9.5.1 to load into Oracle 11g warehouse reading Flat Files, DB2 AS400 data, VSAM, SQL Server data and COBOL files.
• Worked on Source Analyzer, Mapping & Mapplet Designer and Transformations, Informatica Repository Manager, Workflow Manager and Workflow Monitor.
• Used UNIX Shell Scripting to invoke Sessions in the workflow manager.
• Used PHP Script to load documents into Oracle BLOB Columns.
• Implemented performance tuning techniques by identifying bottlenecks in source, target, transformations, mappings and sessions to improve performance and resolving various components like Parameter files, Variables and Dynamic Cache, various SQL queries to improve the performance.
• Experienced in troubleshooting the errors in ILM jobs with Informatica, Followed and Maintained Policies and Guidelines for data movement adhering to Client standards using with ILM tool.
• Created accounts for users and provided appropriate roles for them in ILM tool.
• Created Source and Target connections by using ILM tool.
• Created Entities and loaded the appropriate tables and views and mined them through EDM (Enterprise Data Manager).
• Created new retirement projects and archived the applications successfully by using ILM.
• Generated the row count validation report after successful completion of ILM jobs.
• Worked on Archiving of structured and unstructured data with growth and usage analysis into FAS (File Archive Service).
• Tested Source and target data using Informatica DVO (Data Verification Object) Tool.
• Used Power Exchange to create and maintain data maps for each file and to connect Power center to mainframe.
• Worked on EBCDIC files using power exchange and loaded data to oracle tables.
• Worked on integrating data from Flat files like fixed width /delimited and Mainframe COBOL files.
• Worked extensively on Data Masking transformation applying all the rules available to mask data in QA/DEV/SIT environments depending on the requirement from the SME
• Worked on ILM to create and assign rules for data masking and generating the workflows.

Environment: Informatica 9.5.1/8.6, Power Exchange 9.5.1, UNIX, Oracle 11g/10g, DB2, DB2 AS400, MAINFRAMES, ILM-Data Archiving 6.2, ILM DDM 9.6 SQL, PL/SQL, T SQL, TOAD, XML, PHP, UNIX.

Sr. Informatica Developer

Confidential, MI

Responsibilities:

• Driving the project starting from capturing business requirements, project development, acceptance testing and final implementation.
• Effectively lead the different teams with size of 8-20 resources to achieve project goals within project constraints such as scope, timing and budget.Allocating work and managing theresource planning.Day to day monitoring of thedeliverableand meeting the expectations of the business clients.
• Understand the project requirements given by the Client, Co-ordinate with offshore team to translate technical specs toInformaticawith Business rules.
• Applying rules and policies using ILM (Information Life Cycle Management) workbench for Data Masking Transformationand loading into targets.
• Experienced in troubleshooting the errors in ILM jobs with Informatica offshore team, Followed and Maintained Policies and Guidelines for data movement adhering to Client standards using with ILM tool.
• Finalize resource requirements and building offshore ETL and reporting teams based on signed off business requirements.
• Effectively coordinating with offshore teams, Client BI team and business users to deliver the project on time
• Working closely with the Client BI team for resolving technical issues, getting data models, ETL architectures and high level designs reviewed and any sort of technical support required.
• Effectively coordinating with business users to complete acceptance testing within timelines and obtain sign offs.
• Ensure that all timelines of loading/validating data are met with comparing host (mainframes) files
• Collaborate with team members to resolve issues to assure the successful delivery of high quality ETL and BI Code.

Environment: Informatica9.X, Power Exchange, UNIX, WINSCP, MS ACCESS, Oracle 9i/10g, DB2, MAINFRAMES, Erwin 4.0, ILM-Data Archiving 6.1, SQL, PL/SQL, T SQL, TOAD, LOTUS NOTES.

Lead/Sr. Informatica Developer

Confidential, IL

Responsibilities:

• Involved in gathering and reviewing business requirements. Involved in designing the specifications, Design Documents, Data modeling and design of data warehouse.
• Migration of mappings and transformation from one environment to another. Work with dev team lead and business partners to clarify ETL requirements and rules.
• Design, develop, implement, and assist and in validating ETL processes.
• Create and execute unit test plans based on system and validation requirements.
• Troubleshoot, optimize, and tune ETL processes.
• Maintain existing code and fix bugs whenever needed.
• Ensure smooth functioning of our development, QA, production, and staging environments.
• Used UNIX Putty to transfer, copy, and move and assign privileges to the files like read, write & execute. Used TOAD to develop oracle PL/SQL, DDL's, and Stored Procedures. Performance.
• Used Error handling strategy for trapping errors in a mapping and sending errors to an error table.
• Wrote UNIX shell scripts jobs to automate the workflows for batch processing.
• Used Informatica Load Plan option to maintain the order of target loading.
• Did unit testing and development testing at ETL level in my mappings
• Created informatica mapping template with mapping Visio architect tool.

Environment: Informatica Power Center 9.1/8.6.1, Oracle 10g/11g, PL/SQL, SQL*Plus, SQL Loader, MS SQL Server 2000, MS-Excel, XML, Flat files, HP-UX, Shell Scripting, Winscp, Putty.

Informatica Developer

Confidential, IL

Responsibilities:

• Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
• Created Logical & Physical models and used ERwin for data modeling and Dimensional Data Modeling.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Created connected and unconnected Lookup transformations to look up the data from the source and target tables.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), and Informatica and ETL package design, and RDBMS systems like SQL Server, Oracle.
• Extensively worked on tuning (Both Database and Informatica side) and thereby improving the load time.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning.
• Setting up sessions to schedule the loads at required frequency using Power Center, Workflow manager, PMCMD and using scheduling tools.
• Converting unstructured data into an XML format. Used DTs to build platforms, scheduled the workflows with DT tool.
• Automated the entire processes using UNIX shell scripts.
• Developed the production support technical documents. Worked on UDB/ DB2, Tested the target data against source system tables by writing some QA Procedures.
• Interacted with Lead Developers, System Analysts, Business Users, Architects, Test Analysts, Project Managers and peer developers to analyze system requirements, design and develop software applications.
• Provided Tier l support duties for Informatica Production Support, including off hours and weekends.

Environment: Informatica 9.X/ Power Center 9.0/8.6, Power Exchange, HP UNIX, Oracle 9i/10g, DB2, Erwin 4.0, SQL, PL/SQL, T SQL, TOAD, XML.

Informatica Developer

Confidential, TN

Responsibilities:

• Developed complex Informatica mappings to load the data from various sources using different transformations like source qualifier, connected and unconnected look up, expression, aggregator, joiner, filter, normalizer, rank and router transformations.
• Worked with Informatica power center tools like source analyzer, mapping designer, mapplet and transformations.
• Teradata views have been developed against the Departmental database and claims engine database to get the required data.
• Responsible for Performance Tuning at the Mapping Level and Session level.
• Worked with SQL Override in the Source Qualifier and Lookup transformation.
• Extensively worked with both Connected and Unconnected Lookup Transformations.
• Prepared Unit Test plan and efficient unit test documentation was created along with Unit test cases for the developed code.
• Extensively worked with various lookup caches like Static Cache, Dynamic Cache and Persistent Cache.
• Used Update Strategy DD INSERT, DD UPDATE to insert and update data for implementing the Slowly Changing Dimension Logic.
• Developed Re-Usable Transformations and Re-Usable Mapplets.

Environment: Informatica 9.X/ 8.6.1/8.1.3 , Teradata V2R12/V2R6, Oracle 10g, Teradata SQL Assistant and Administrator, XML, UNIX Shell Scripting, Rational Clear Quest, Windows, Autosys.