SUMMARY:

• 8 years of experience in IT development as Informatica developer/administrator
• 7+ years of experience in designing, developing, maintaining and building large business applications such as data migration, integration, conversion, data warehouse and Testing as an Informatica Developer/ Administrator.
• 2 years of experience in Informatica cloud, Informatica MDM and IDQ.
• Expert in all phases of Software development life cycle(SDLC) - Project Analysis, Requirements, Design Documentation, Development, Unit Testing, User Acceptance Testing, Implementation, Post Implementation Support and Maintenance.
• Business Requirements review, assessment, gap identification, defining business process, deliver project roadmap including documentation, initial source data definition, mapping, detailed ETL development specifications and operations documentation.
• Expertise in data warehousing, ETL architecture, Data Profiling.
• Experience in working with various versions of Informatica PowerCenter 10.x,9.x,8.x,7.x-Client and Server tools.
• Expertise in tuning the performance of mappings and sessions in Informatica and determining the performance bottlenecks.
• Experience in creating pre-session and post-session scripts to ensure timely, accurate processing and ensuring balancing of job runs.
• Experience in integration of various data sources like SQL Server, Oracle, Tera Data, Flat files, DB2 Mainframes.
• Strong experience in complex PL/SQL packages, functions, cursors, triggers, views, materialized views, T-SQL, DTS.
• Expert in troubleshooting/debugging and improving performance at different stages like database, workflows, mapping.
• Thorough Knowledge of different OLAP’s like DOLAP, MOLAP, ROLAP, HOLAP.
• Involved in writing Unit test cases for complex scenarios.
• Experience in creating UNIX shell scripts and Perl scripts.
• Knowledge in design and development of Business Intelligence reports using BI tools Business Objects, Cognos and knowledge in microstrategy.
• Knowledge in Installation and configuration of Informatica server with SQL server, oracle and able to handle the Informatica administrator tasks like Configuring DSN, creating Connection Strings, copying & moving mappings, workflows, creating folders etc.
• Experience includes thorough domain knowledge of Business Financial system, Banking, healthcare applications, Insurance & Reinsure, Pharmacy claims systems, Telecom Industry.
• Enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills and leadership capabilities with high level of adaptability.

TECHNICAL SKILLS:

Data Warehousing: Informatica PowerCenter 10.x,9.x,8.x and 7.x, PowerExchange for DB2, Metadata Reporter Data Profiling, Data cleansing, OLAP, OLTP, Star & Snowflake Schema, FACT & Dimension Tables, Physical & Logical Data Modeling

BI Tools: Business Objects XIR2, Cognos 8.x,10.x

Databases: SQL Server, Oracle 11g/10g/9i, Sybase, Teradata, My SQL, MS-Access, DB2 8.0/7.0

Languages: C, C++, XML, SQL, T-SQL, PL/SQL, UNIX Shell Scripting

Operating System: HP-UX, IBM-AIX, Sun Solaris, SCO-UNIX, LINUX, Windows

Other Tools: MS Visual Source Safe, PVCS, Autosys, Control M, Remedy, Mercury Quality center, Star Team.

DB Tools: SQL*Plus, SQL*Loader, Export/Import, TOAD, SQL Navigator, SQL Trace

PROFESSIONAL EXPERIENCE:

Confidential, CA

Informatica Administrator/developer/cloud

Responsibilities:

• Installed Informatica 10.1,9.x (10.1,9.6,9.5,9.1.1)
• Installed IDQ and Metadata Manager
• Created Model Repository, Profiling Warehouse Repository and Content Manager Database
• Create folders, grant user access to Informatica Repository
• Applied Informatica Patches to the Informatica servers
• Worked with Informatica Cloud to create Source /Target connections, monitor, synchronize the data in salesforce.
• Worked with Informatica cloud for creating source and target objects, developed source to target mappings.
• Involved in analysing, defining, and documenting data requirements by interacting with the client and Salesforce team for the Salesforce objects.
• Involved in extracting, transforming and loading data Accounts, Contracts, Reservations, Owner interactions tables from various source systems to Salesforce.com and reverse data feed from Salesforce for CRM telesales.
• Developed common routine mappings. Made use of mapping variables, mapping parameters and variable functions.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Union, Expressions and Aggregator transformations.
• Developed Slowly Changing Dimension for Type 2 SCD
• Used mapplets for use in mappings thereby saving valuable design time and effort
• Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, worklets and workflows.
• Written procedures, Queries to retrieve data from EIDW and implemented in NIDW.
• Worked with Session Logs and Workflow Logs for Error handling and Troubleshooting in all environment.
• Responsible for Unit testing and Integration testing of mappings and workflows.
• Created Jobs and Job streams in Control-M scheduling tool to schedule Informatica, SQL script and shell script jobs.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Performed Configuration Management to Migrate Informatica mappings/sessions /workflows from Development to Test to production environment.

Environment: Informatica PowerCenter 10.x/9.x, IDQ, Metadata Manager, Power Exchange, Oracle 11g and 10g, SQL, IBM AIX, UNIX Shell Scripts, Remedy, Control-M, Toad, MS Visual Source

Confidential, CA

Informatica Administrator/developer

Responsibilities:

• Installed Informatica 9.x (9.5.1,9.1.1)
• Upgrade Informatica from 9.1.1 to 9.5.1
• Create folders, grant user access to Informatica Repository
• Applied Informatica Patches to the Informatica servers
• Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build the DataMart.
• Developed a standard ETL framework to enable the reusability of similar logic across the board. Involved in System Documentation of Dataflow and methodology.
• Developed mappings to extract data from SQL Server, Oracle, Flat files and load into DataMart using the PowerCenter.
• Developed common routine mappings. Made use of mapping variables, mapping parameters and variable functions.
• Written shell scripts in UNIX to execute the workflow
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, Workflows and database tuning.
• Involved in generating reports from Data Mart using Cognos.
• Defects were tracked, reviewed and analysed.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.

Environment: Informatica PowerCenter 9.x, SQL Server 2010/2005, Oracle 11g, SQL, PL/SQL, IBM AIX, UNIX Shell Scripts, Cognos, Erwin, STAR team, Remedy

Confidential, FL

Informatica Administrator/developer

Responsibilities:

• Installed Informatica 9.1,8.6.1
• Upgrade Informatica from 8.5.1 to 8.6.1
• Create folders, grant user access to Informatica Repository
• Applied Informatica Patches to the Informatica servers
• Written SQL Queries, Triggers, PL/SQL Procedures, Packages and UNIX Shell Scripts to apply and maintain the Business Rules.
• Checked performance tuning/debugging at different levels like workflows, mappings, database etc.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Created testing metrics using MS-Excel
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Performed Configuration Management to Migrate Informatica mappings/sessions /workflows from Development to Test to production environment.
• Generated reports using Cognos.
• Performed System Testing, Regression Testing, Acceptance Testing, Functional Testing and Stress Testing.
• Created reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports
• Prepared detailed functional specifications, design models, and system workflows from which software applications are developed and implemented.
• Documented code consistently throughout the development process by listing a description of the program, special instructions, and any changes made in database tables on procedural, modular and database level.
• Assisted in the development of enterprise systems making specific determinations about system performance, reliability, and scalability.
• Worked on with requests for support to troubleshoot and/or maintain production systems.
• Conducted system analysis and development to keep information systems current with changing technologies.

Environment: Informatica PowerCenter 8.x, Informatica Power Exchange, SQL Server, Teradata, Oracle 11g, DB2, SQL, PL/SQL, Mainframes, Sun Solaris, UNIX Shell Scripts, Business Cognos 8, Erwin, Autosys, Remedy.

Confidential

Informatica Administrator

Responsibilities:

• Worked as a Team Administrator
• We are testing the Informatica code according to the new releases
• We are handling 3 test environments for testing the code in parallel.
• Transformed data from source system to target.
• Writing the queries on metadata level to figure it out the standards
• Implementing the standards in the release basis.
• Migration of objects from Dev-SIT, SIT - PPE and PPE - PROD
• Handling the issues in the Informatica level
• Creation of folders/user permissions.
• Handling other Informatica administration activities
• Upgrading the Informatica Repositories from 6.x to 7.x.
• Giving L2/L3 Support for all applications.
• Giving 24/7 Production Support for all application.
• Involved and resolving the issues (Tickets) in Informatica PowerCenter.

Environment: Informatica PowerCenter 8.x and 9.x, Oracle 10g, Teradata, PL/SQL, SQL Server, Flat files, SQL loader, UNIX Shell Scripts, Cognos.

Confidential

ETL Developer

Responsibilities:

• Designed technical layout considering Standardization, Reusability, and Scope to improve if need be.
• Documented the purpose of Data Warehouse (including transformations, mapplets, mappings, sessions, and batches) to facilitate the personnel to understand the process and in corporate the changes as when necessary.
• Developed complex mappings to extract source data from heterogeneous databases Teradata, SQL Server Oracle and flat files, applied proper transformation rules and loaded in to Data Warehouse.
• Involved in identifying bugs in existing mappings by analysing data flow, evaluating transformations using Debugger.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Worked closely with Production Control team to schedule shell scripts, Informatica workflows and PL/SQL code in Autosys.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Defects were tracked, reviewed and analysed.
• Conducted UAT (User Acceptance Testing) with user community
• Developed K-shell scripts to run from Informatica pre-session, post session commands. Set up on Success and on Failure emails to send reports to the team.

Environment: Informatica PowerCenter 8.x, Oracle 10g, SQL Server 2000, Erwin, XML, TOAD, HP - Unix, Dendrite Webforce, Cognos Report Net.