PROFESSIONAL SUMMARY:

• Over 8 years of experience in Software Development Life Cycle (SDLC)/Data warehouse development life cycle involving Requirement Gathering/Analysis, Design, Development, Testing, Deployment and Production Support
• Experience working on OLTP and OLAP Data Modeling, Facts and Dimensions tables (SCD 1, 2 & 3) and Dimensional Modeling (Star Schema and Snow Flake Schema)
• Experienced in working with Business Analysts, Data Modelers and Data Analyst/Test Analyst.
• Having 4 years of experience in Informatica Confidential (ETL).
• Strong knowledge in Data Extraction, Transformations, Data Cleansing and Data Loading with ETL tool - Informatica ( Confidential 8.1, 8.6 and 9.6). Design and Implementation of ETL at Datawarehouse Projects and mentoring the team functionally and technically.
• Extensive experience working with heterogeneous databases such as Oracle 11g/10g, Microsoft SQL Server 2005/2008, IBM DB2 on different projects
• Experience in working with Multiple Environments (Windows-based, UNIX-based and Mainframe-based Data Warehouse).
• Experience in working with different data sources like Flat files, Cobol files, Oracle, csv file, Teradata, SQL server and other relational and non-relational databases
• Experience in creating the UNIX Shell scripts as part of file manipulation, Scheduling and text processing.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control)
• Working knowledge on Autosys, CA7 and Control - M.
• Working experience on different versions of Informatica Power center (9.x/8.x/7.x).
• Expertise in design and development of ETL mappings with various transformations available in Informatica Confidential and processed tasks using Workflow Manager to move data from multiple Sources into Targets
• Expertise in Mappings, Sessions, Workflows, Mapplets, Reusable Transformation, Shared Folders, Shortcuts, Reusable tasks and Work lets.
• Experience in Performance Tuning, identifying and resolving performance bottlenecks in various levels like Sources, Targets, Mappings and Sessions.
• Strong knowledge and experience in Mainframe technologies like COBOL, JCL, DB2, VSAM, CICS, ADABAS, SMART TEST, SORT, FILEAID, IMS-DB.

TECHNICAL SKILLS:

Hardware: OS/390, Z/OS.

Operating System : MVS, Windows, UNIX, MS-DOS.

ETL Tools: Informatica Power Center 9.x/8.x, Power Exchange9.1.0, (Designer, Transformations, Workflow Manager, Workflow Monitor, Source Analyzer, Repository Manager, Mapping Designer, Mapplets) Power Analyzer, OLAP, OLTP.

Languages : COBOL, JCL, Natural, SQL, PL/SQL, C.

Scripting Langauges: UNIX Shell Scripting

Database : DB2, Adabas, Oracle10g/9i, MS SQL Server 2008 / 2005, MS Access, SQL, PL/SQL

DB2 Load Utilities: SQL DEVELOPER, TOAD, AUTOSYS,TIVOLI, CA7

MF Tools & Utilities : File-Aid, SPUFI, QMF, Panvalet, Insync, Endevor, Control-M

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

Sr. Informatica Developer/ Lead

Environment: Informatica Power Center 9.5.1, Power Exchange 9.1.0, Oracle 11g, SQL server, DB2, UNIX, SQL SQL*Plus, SQL Developer, TOADResponsibilities:

• Onsite and offshore Lead/ co-ordination activities
• Look after over-all integration design with Reporting Teams
• Work with Client Data Modeler for DB Enhancements
• Extensively Worked on Shared Folders, Shortcuts, Mapplets, Reusable Transformations, Reusable tasks, Worklets.
• Enhanced existing mappings as per new requirement and for new release.
• Support planning and management.
• Coding for Project using Informatica & ORACLE
• Provided technical support for the Informatica environment.
• Migration of changes, enhancements, upgrades, etc. through the various environments
• Task Distribution and Team Management.
• Designed and documented ETL standards document.
• Preparing approach and design documents for each feature implemented in project.
• Developed SQL Overrides for the Source Qualifiers Based on the Business Requirements.
• Understanding the Salesforce forms & loading the form data using Cloud.
• Testing the Informatica Objects in QA before moving them into Production.
• Designed and developed COBOL programs, JCLs and ETL mappings in order to accommodate the data flowing into Data warehouse as part of Organizational level Merging/Acquisition and to migrate some of the Legacy system (Mainframe) ETL functionality to Informatica Power Center.

Confidential, IL

Informatica Developer/ Team Lead

Environment: Informatica 9.1, Teradata, Oracle, Unix

Responsibilities:

• Mentoring the team functionally and technically and assigning ticket to team members and delivered the tickets within SLA time.
• Data analysis.
• Performance tuning.
• Responsible for installation & configuration of Informatica Confidential (Client, Server & Repository Server).
• Installed and configured Confidential 9.0.1 and 9.1.0 on UNIX platform.
• Installed and configured Metadata Manager Service, Data Analyzer and Web Service Hub.
• Installed and configured Informatica Support Console 1.5 to proactively monitor the environment.
• Extensively worked on UNIX shell scripts (restart of servers, Disk space utilization, Informatica Server monitoring and UNIX file system maintenance and cleanup, and scripts using Informatica Command line utilities.)
• Creation and maintenance of Informatica users and privileges.
• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
• Created Groups, roles, privileges and assigned them to each user group.
• Worked on SQL queries to query the Repository DB to find the deviations from Company’s ETL Standards for the objects created by users such as Sources, Targets,
• Transformations, Log Files, Mappings, Sessions and Workflows.
• Worked on UNIX shell scripts to handle Job Control Process.
• Responsible for monitoring batch execution job schedules
• Testing the Informatica Objects in QA before moving them into Production.
• Designed and documented ETL standards document.
• Interfaced with the support team.
• Defined and implemented monitored requirements.
• Performed an upgrade of Informatica Confidential Standard edition.
• Provided technical support for the Informatica environment.
• Migration of changes, enhancements, upgrades, etc. through the various environments
• Ensure that all support requests are properly approved, documented, and communicated using the appropriate tools. As well as documenting common issues and resolution procedures.

Confidential, North America

Informatica Developer

Environment: Informatica Power Center /8.6/8.1, Oracle 10g, Teradata, SQL, UNIX, SQL SQL*Plus, SQL Developer, TOAD, Autosys,CA7, Tivoli, MS

Responsibilities:

• Created the Mappings and Mapplets using Confidential 8.6/8.1 Designer to extract and transform data from Mainframe Flat files to load into Oracle/Teradata DBs
• Transformations like Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank are widely used in InformaticaPowerCenter
• Extensively Worked on Shared Folders, Shortcuts, Mapplets, Reusable Transformations, Reusable tasks, Worklets
• Used Constraint Based loading & Target load ordering to efficiently load tables with PK-FK relation in the same mapping
• Created the Shell scripts and Stored Procedures for regular Maintenance and Production Support to load the warehouse in regular intervals and to perform Pre/Post Session Actions
• Implemented SCD methodology including Type 1, Type 2 to keep track of data changes.
• Debugger is used to test the data flow and fixed the mappings
• Developed Test cases, Unit tested and reviewed the test results along with the QA team.
• Developed many Scripts to fix the historic and erroneous data in many tables.
• Coordinate with offshore team members to make sure deliverable time-line was not affected.
• Trouble shooting of long running Sessions and fixing the issues.
• Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Session in the workflow manager.
• Involved in implementation/deployment of the projects. Help and coordinate with the team on technical issues
• Work with Quality control team to validate the test cases and test result documents.
• Worked on migrating the code from Informatica Confidential Versions 8.1 through version 9.5 and worked on updating the logic to accommodate the changes
• Supported production environments and users on a daily basis by responding to emergency requests
• Designed and developed COBOL programs, JCLs and ETL mappings in order to accommodate the data flowing into Data warehouse as part of Organizational level Merging/Acquisition and to migrate some of the Legacy system (Mainframe) ETL functionality to Informatica Power Center

Confidential

Sr. Developer

Environment: COBOL, JCL, DB2, File Aid, Endevor, Control-M

Responsibilities:

• Requirement Analysis and prepared Estimation, Low level design.
• Developed code based on requirement and performed Unit Testing and String testing
• Prepared the unit test plans, unit test results, String test Plans and Implementation plans.
• Provided 13/7 support for User acceptance testing by resolving defects raised in QC.
• Successfully implemented the code and provided second line support.