PROFESSIONAL SUMMARY:

• Around 8+ years of total IT Experience in analysis, design, development, implementation and troubleshooting in the area of ETL Tool Informatica.
• More than 3 years of experience in Windows XP/NT, UNIX (Sun Solaris, Linux, HP - UX), AIX using Kimball and Immon to solve the business problems.
• Proficient in all phases of software development life cycle (SDLC) including requirements definition, data conversion, system implementation, maintenance and acceptance testing.
• Proficient in writing complex PL/SQL Packages, Stored Procedures, Triggers, Performance tuning, Application tuning and Query Optimization using Hints, Explain plan, TKPROF.
• Designed complex ETL mappings, reusable transformations using Regular Expressions, Dynamic Lookups, and Update Strategies for slowly changing dimensions, critical performance tweaking stages with partitioning, persistent cache, and extensive use of mapplets for common sub routines.
• Extensive experience in handling ETL using Informatica Power Center/Power Mart 8.X/7.x/6.x/5.x., Oracle 10g and Unix Shell Scripts.
• Expertise in data loads using Oracle, Sql Server and IBM Netezza.
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Strong Experience in using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Extensively used Informatica Repository Manager and Workflow Monitor.
• Strong experience in developing complex mappings using various transformations like Unconnected and Connected lookups, Router, Aggregator, Sorter, Ranker Joiner, Stored Procedure, Update Strategy and Re-usable transformations.
• Strong experience in developing Workflows, Worklets, sessions and tasks to effectively manage the Load.
• Excellent knowledge in identifying performance bottlenecks and tuning the Informatica Load for better performance and efficiency.
• Experience on Data Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis
• Experience in the Planning, Analysis, Design, Implementation and Maintenance in different domains of Financial and Insurance, Tele-Communication, Health and Retail Oriented companies
• Experience in providing On Call (24*7) Support for Production Problem Resolution (Resolve Production issues and problems in an expedited manner)

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.1/8.6/7.1/6.2.2/ Power Connect and Power Exchange, Power Mart 6.x/5.1, BODI

Data modeling Tools: Erwin 4.2

RDBMS: Oracle 11g/10g/9i/, SQL Server 2005, Flat files, COBOL Files.

Data warehousing methodologies: Dimensional modeling - Star schema, snow flake schema

Other Tools & Utilities: Dimensional modeling - Star schema, snow flake schema

Languages: SQL, PL/SQL, TSQL

Scripting Languages: Shell Scripting.

Operating Systems: Windows XP/NT, UNIX (Sun Solaris, Linux, HP-UX), AIX

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

ETL Informatica Developer

Responsibilities:

• Prepared High Level Design and Low Level Design based on Functional and Business required documents of the project.
• Involved in understanding of Business Processes, grain identification, identification of dimensions and measures for OLAP applications.
• Involved in developing Data Warehouse using Star schema
• Prepared Technical specification documents for Informatica.
• Extract data from flat files, Oracle and SQL Server to load the data into the target database.
• Designed ETL process using Informatica Tool to load from Sources to Targets through data Transformations.
• Update the Various CRM View tables using Informatica to match with the data provided by the Data mentors, the vendor that currently provide address standardization, validation, person matching and house holding for the CRM View system.
• Involved in creating the mapping documents with the transformation logic for implementing few enhancements to the existing system.
• Involved in writing PL/SQL stored procedure for performing update/delete DML operations on the CRM table.
• Developed and modified UNIX shell scripts to reset and run Informatica workflows using pmcmd on Unix Environment..
• Extensively used pmcmd command to invoke the workflows from Unix shell scripts
• Involved in creating Informatica components for the HOLD database, the ETL processing database used to load and transform data in preparation for loading to the reporting database.
• Involved in creating the Informatica code using various transformations, for the DO Not Mail logic which tells whether the persons are marked mail able or not.
• Mentored other team members on the development & support of HL7 interfaces for clinical applications.
• Worked across teams and the businesses to gather/clarify the requirements and translate them into mapping/design document.
• Developed re-usable components in Informatica, Oracle and UNIX..
• Automation and scheduling of UNIX shell scripts and Informatica sessions and batches using Autosys..
• Created Autosys JIL scripts, Control files, Parameter files and UNIX Environmental files.
• Used debugger to test the mapping and fixed the bugs.
• Created sessions, sequential and concurrent batches for proper execution of mappings using server manager.
• Migrated development mappings to QA and Production environment.
• Tuned performance of Informatica session for large data.

Environment: Informatica Power Center 9.0.1/8.6.1, PL/SQL, Oracle 11g/10g, Erwin, Autosys, SQL Server 2008, Teradata, UNIX

Confidential, Des Moines, IA

Sr Informatica Developer

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing, and rollout to the field user and support for production environment.
• Involved in understanding of Business Processes, grain identification, identification of dimensions and measures for OLAP applications.
• Responsible for developing, support and maintenance for theETL(Extract, Transform and Load) processesusingInformatica power center.
• Extensively used all the features of Informatica Versions 9.x and 8.x including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Involved in Migrating repository and mapping from Informatica 8.6.1 to 9.0.1.
• Worked with DataStage Director for testing and monitoring the executable jobs

  Worked with DataStage Manager to import and export job and job executables for back up and also move jobs from one environment to other.♣

• Good understanding of relational database management systems like Oracle, TeraData, DB2, and SQL Server and extensively worked on DataIntegration using Informatica for the Extraction transformation and loading of data from various database source systems and mainframe Cobol and VSAM files.
• Extract data from flat files, Oracle, DB2 and SQL Server 2008 & MS SQL Server 2005/2008 and to load the data into the target database.
• Worked withRepository Manager,Designer,Workflow ManagerandWorkflow Monitor, also imported and created Source Definitions usingSource Analyzer and Target Definitions using Warehouse Designer.
• Developed complex mappings using corresponding Source, Targets and Transformations like update strategy, lookup, stored procedure, SQL, sequence generator, joiner, aggregate, Java and expression transformations in extracting data in compliance with the business logic
• Extensively used Informatica Power center and created mappings using transformations to flag the record using update strategy for populating the desired slowly changing dimension tables.
• Implementation experience of CDC ( Change Data Capture) using stored procedures, triggers and using informatica power exchange..
• Querying and analyzing multiple databases and handling the errors as per the client specifications.
• Involved in Performance tuning and Scheduled workflows using autosys job plan.
• Created Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Wrote stored procedures inPL/SQLand UNIX Scriptsfor automated execution of jobs
• Involved in Unit and System Testing of ETL Code (Mappings and Workflows)
• Implemented best practices suggested by Informatica to simplify deployment Process.
• Worked with PMCMD to interact with Informatica Server from command mode and execute the shell scripts.
• Wrote documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Center 8.6.1, Workflow Manager, Workflow Monitor, PL/SQL, Oracle 10g/9i, Erwin, Autosys, SQL Server 2005, UNIX AIX, Toad 9.0

Confidential, Santa Ana, CA

ETL Informatica Developer

Responsibilities:

• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA
• Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems(oracle 10g,DB2,SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, sql, router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools
• Documented Informatica mappings in Excel spread sheet.
• Tuned the Informatica mappings for optimal load performance.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Analyzed, identified, fixed bad data and Imported data fromSalesForce - CRM to Oracle. Upstream data integration and migration processes in predefined schemas.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager. Informatica Web-services and web-portal applications.
• Have generated reports using OBIEE 10.1.3 for the future business utilities.
• This role carries primary responsibility for problem determination and resolution for each SAP application system database server and application server.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• Constantly interacted with business users to discuss requirements.

Environment: Informatica Power Center Designer 8.1, Informatics Repository Manager, Teradata, OBIEE Oracle10g/9i,DB2 6.1, Erwin, TOAD, Unix- SunOS, PL/SQL,SQL Developer

Confidential

Informatica Developer

Responsibilities:

• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Designed ETL specification documents for all the projects.
• Created Tables, Keys (Unique and Primary) and Indexes in the SQL server.
• Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.
• Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.
• Extensively used the Add Currently Processed Flat File Name port to load the flat file name and to load contract number coming from flat file name into Target.
• Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Implemented Informatica recommendations, methodologies and best practices.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Involved in Unit, Integration, System, and Performance testing levels.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Center 7.1, Oracle 10g, SQLServer2008, IBM ISeries (DB2), MS Access, Windows XP, Toad, Cognos 8.4.1., SQL developer.