SUMMARY:

• 7+ years of experience in designing, developing, maintaining and building large business applications such as data migration, integration, conversion, data warehouse and Testing.
• 5+ years of experience in Informatica Development/Administrator
• 2+ years of experience in IDQ and Metadata Manager
• 3+ years of experience in Power Exchange
• 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 information technology, 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

WORK EXPERIENCE:

Confidential

Informatica Developer/Administrator

Responsibilities:

• Installed Informatica 10.x,9.x (10.1,9.6,9.5,9.1.1)
• Installed IDQ and Metadata Manager
• Created Model Repository, Profiling Ware house Repository and Content Manager Database
• Create folders, grant user access to Informatica Repository
• Applied Informatica Patches to the Informatica servers
• 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 and 8.x,IDQ,Metadata Manager,Power Exchange, Oracle 11g and 10g, SQL, IBM AIX, UNIX Shell Scripts, Remedy, Control-M, Toad, MS Visual Source

Informatica Cloud Developer/Administrator

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

Informatica Developer/Administrator

Responsibilities:

• Installed Informatica 8.x
• 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 tunning/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 in order 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.

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 Power center.

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

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) so as 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 Tera Data, SQL Server Oracle and flat files, applied proper transformation rules and loaded in to Data Warehouse.
• Involved in identifying bugs in existing mappings by analyzing 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 analyzed.
• 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.