SUMMARY:

• 8+ years of total IT experience in analysis, design, development, testing and implementation of applications.
• 7+ years of Experience in designing, developing and maintaining of Data warehouse applications using Informatica Power Center 9.x/8.x/7.x. (Repository Manager, Designer, server manager, Workflow Manager, Admin console, Workflow Monitor) and PowerExchange 8.x
• Strong knowledge of Entity - Relationship concepts, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Experience in all the phases of Software Development life cycle (SDLC).
• Experience in extracting data from various data sources like Oracle, DB2, Teradata, Sybase, SQL server and MS access and from non-relational sources like XML Files, flat files into staging area.
• Experience in creating Reusable Transformations, Mapplets, Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer, Union, XML Source Qualifier transformation, XML Parser, XML Generator and Rank Transformations using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions and packages.
• Experience in active data ware housing on the Teradata platform, extended use of Teradata Parallel Transport, TPump, FastLoad, BTEQ and migrating legacy systems into Teradata.
• Extensively worked on developing and debugging Informatica mappings, sessions and workflows.
• Involved in data modeling of the database using Erwin.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks at various levels like sources, targets, mappings and sessions.
• Experience in creating Worklets, Reusable Tasks (Sessions, Command and Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment and Control).
• Experienced in designing and maintaining UNIX shell scripts.
• Experience in working with business analysts to identify, review and understand requirements and translate them into ETL code.
• Have full system life cycle hands-on experience: analysis, designing, coding, testing, performance tuning, installing, technical documentation, maintaining and user training for small and large projects.
• Worked in a team and also independently with minimum supervision.
• Knowledge in using Business Intelligence tools like Cognos, Web Focus.
• Excellent analytical/communication skills and good team player.

TECHNICAL SKILLS:

Tools: Informatica Power Center 9.x/8.x/7.x (Repository Manager, Designer, server manager, Workflow Manager, Admin console, Workflow Monitor), PowerExchange 8.x, Toad, SQL Navigator, SQL Loader, Web Focus, Cognos

Operating Systems: Windows, MVS, Sun Solaris, HP: Unix, Red Hat Linux

RDBMS: Oracle 11g/10g/9i/8i, MS: Access, SQL Server 2008/2005/2003 , DB2,Teradata

Mainframe Utilities: XPEDITOR, FILE: AID, SPUFI, QMF, SyncSort, Changeman

Data Modeling: Erwin, Power Designer

Scripting: VB Script, Unix Shell Scripting

Languages: COBOL, ASSEMBLER, Java, C, PERL, HTML, PL/SQL, HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential, NY

Sr. Informatica Developer

Responsibilities:

• Involved in gathering requirements and acquiring application knowledge from Business Managers & Application Owners.
• Performed extensive data analysis along with subject matter experts and identified source data and implemented data cleansing strategy.
• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Extracted data from Flat files and Oracle and loaded them into Teradata.
• Loading data from different sources to Target Data warehouse.
• Trouble shooting and problem solving applications with Informatica Debugger.
• Used slowly changing Dimensions techniques to load the conformed dimensions.
• Worked with various Informatica client tools like Source Analyzer, Target designer, Mapping designer, Mapplet Designer, Transformation Developer, Repository Manager and Workflow Manager.
• Involved in data modeling of the database using Erwin.
• Developed, tested and implemented Unix Shell scripts, FTP, SFTP’s, file transfers, Teradata BTEQ, Fast Load, Mload, TPump, FastExport Oracle/DB2 stored procs & Bulk loads.
• Developed standard and re-usable Mapplets and Mappings using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, Update Strategy, XML Parser, XML Generator, XML Source Qualifier and filter.
• Created reusable transformations and used them in different mappings.
• Worked with XML files as source and targets.
• Created Workflows and used various tasks like Email, Timer, Scheduler, Control, Decision, and Session in the workflow manager.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Used Informatica debugger to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Created, Tested and debugged theStored Procedures, Functions, Packages and Triggers using PL/SQL.
• Did code walkthrough of all the designs with the team and made changes where required.
• Defined Target Load Order Plan for loading data into different Target Tables.
• 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.
• Migrated repository objects, services and scripts from development environment to production environment.
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.

Environment: Informatica Power Center 8.6.1/9.1, Oracle 11g, Teradata, XML/Flat Files, Toad, UNIX, Erwin

Confidential, CA

Sr. ETL Developer/Designer/Support

Responsibilities:

• Extensively used Informatica Client tools - Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Flat Files, Excel Files and Teradata.
• Used PowerExchange to extract data from Mainframe systems.
• Developed complex mapping using Informatica Power Center tool.
• Performed complex joiner, Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to load data into the target systems.
• Created Sessions, Tasks, Workflows and worklets using Workflow manager.
• Worked with Data modeler in developing STAR Schemas
• Involved in performance tuning and query optimization.
• Used TOAD, SQL Developer to develop and debug procedures and packages.
• Deploying the code between various environments (Dev, QA).
• Created pre sql and post sql scripts which need to be run at Informatica level.
• Used Teradata utilities like BTEQ, MLOAD, Fast Export and TPUMP.
• Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading.
• Involved in data modeling of the database using Erwin.
• Used Debugger to fix the defects/ errors and data issues.
• Used LSF Platform Computing for Job Scheduling.
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD.
• Monitored and improved query performance by creating views, indexes, hints and sub queries.
• Created List, Crosstab, Chart type reports using Cognos.
• Extensively involved in enhancing and managing Unix Shell Scripts.
• Developed workflow dependency in Informatica using Event Wait Task, Command Wait.
• Participated in team meeting and providing status to the team.

Environment: Informatica Power Center 8.6, PowerExchange, Oracle 10g, Teradata, SQL Server 2005, MS Access, SQL*Loader, Unix, Cognos, Putty, Erwin, SQL, PL/SQL, LSF Platform Computing

Confidential, WI

Informatica Developer

Responsibilities:

• Involved in designing Informatica mappings by understanding Business Requirements/Technical Requirement Document (TRD) and writing Technical Design Document (TDD).
• Involved in designing of Data Validation for accurate data loads.
• Worked on Informatica Designer, Workflow Manager, and Repository Manager for Migration of Code from Informatica Power Center Component.
• Worked on a number of key enhancement requirements and responsible for adding extra functionalities to some of the crucial modules.
• Developed ETL Mappings using various Informatica transformations like Expression, Lookup, Aggregate, Joiners, Router, Filter, Stored Procedure, SQL Transformation, Update Strategy etc.
• Tasked to review and evaluate proposed system design resolutions (such as table structure, table relationships) and determine feasibility and practicability in real time environment.
• Develop OLAP Reports using Cognos BI Tools.
• Created complex Stored Procedures, triggers, cursors, views and user-defined functions.
• Knowledge in all phases of SDLC and specifically worked on Define, Build, Test, Deploy and Post Production Phases.
• Involved in debugging of the mappings using Informatica Debugger by creating breakpoints to gain troubleshooting information about data and error conditions.
• Overriding the default query in the Source Qualifier by incorporating SQL queries and applying the business rules at the source itself to improve efficiency and avoid cumbersome transformations.
• Developed Error handling mechanism and delta logic in different mappings.
• Developed mappings using XML files as sources
• Worked on Push down Optimization to improve the mapping performance.
• Performance tuning the workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them.
• Scheduled different workflows using Informatica scheduler.
• Performed extensive unit and Integration testing.
• Developed Unit Test Cases to ensure successful execution of the data loading processes.
• Created various data marts from data warehouse and generated reports using Cognos.
• Was involved in Production support as required.
• Used type I and type II to update and insert the information in the data warehouse.
• Developed scheduling and automation of jobs.
• Developed FTP/SFTP process to move data in Flat files to receive/send from/to various systems.

Environment: Informatica 8.6, DB2, Oracle 10g, Flat Files, UNIX, Windows, Toad, Power Designer, Cognos

Confidential, MI

Informatica Developer/Analyst

Responsibilities:

• Participated in Requirement Gathering, Business Analysis, User meetings, discussing the issues to be resolved and translating user inputs into ETL design documents.
• Designed and developed Informatica mappings based on requirements.
• Analysis, Design and Development, testing and implementation of Informatica transformations and workflows for extracting the data from the multiple sources.
• Extensively used Informatica client tools-Designer, workflow manager and workflow monitor.
• Extracted the data from Oracle, DB2, Flat files and load the data in to Teradata database.
• Worked extensively on different types of transformations like Source Qualifier, Expression, Java Transformation, Aggregator, Router, filter, Update strategy, look up, Normalizer, stored procedure.
• Redesigned the ETL process.
• Written and modify SQL override in many mappings according to business requirements
• Used mappings parameters and variables for code reusability.
• Identified the performance bottlenecks and tuned Informatica mappings for better performance.
• Tuned Sessions Performance by partitioning the data flow in mappings to improve the performance.
• Checked session and error logs to troubleshoot problems, and also used debugger for problem trouble shooting.
• Assisted reports team to generate reports required for business users.
• Establish of automatic email notifications to the concerned persons.
• Worked on FTP connections to move the file to remote servers.
• Scheduled workflows for daily, weekly and monthly loads.
• Providing status on a weekly basis to the team.

Environment: Informatica Power Center 8.1/7.3, DB2, Oracle 10, SQL, PL/SQL, Flat files, COBOL, UNIX, Web Focus, Autosys

Confidential, IL

Developer

Responsibilities:

• Attending the business requirement gathering meetings and interacting with the system users for the requirements.
• Reviewing the Functional Requirements Document and preparing the technical design document.
• Utilized FILE-AID and SYNCSORT to develop test files and data.
• Developed JCL’s using utilities like SYNCSORT, IDCAMS, IEBGENER and IEFBR14.
• Database was referred using DCLGEN, SPUFI for DB2.
• Monitoring the jobs using CA7 scheduler.
• Involved in Production support, maintenance and Enhancement.
• Testing the system for BATCH jobs by preparing the JCLs.
• Preparing the Weekly status Reports, Production Support logs, Change control logs and Change Man control logs.

Environment: IBM3090, MVS, COBOL, CICS, DB2, IMS DB/DC, JCL, TSO/ISPF, SPUFI, SYNCSORT, XPEDITOR and FILE-AID.