CAREER SUMMARY:

• Designed and developed Complex mappings from various Transformations like re - usable transformations, and Mappings/Mapplets, Unconnected / Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more, mappings using Stored Procedure’s, Normalizer, XML, External Procedure
• As a ETL Developer involved in designing and implementing Data Mart / Data Warehouse applications using /INFORMATICA 9.5.1 /9.x /PowerCenter / 8.x / 7.x / 6.x (Designer, Workflow manager, Workflow monitor and Repository Manager).
• Experience in Performance tuning of targets, sources, mappings and sessions.
• Experience in using Informatica version 9.01 advanced edition with add-ons for data profiling (Informatica Data Explorer) and metadata exchange. Collected metadata in Informatica metadata manager repository. Set up and lead usage of new Informatica features in the new Analyst and Developer Informatica client’s tools.
• Good knowledge on SDLC (software development life cycle) and good experience with unit testing and integration testing.
• Preparing the High level Design Specifications for ETL Coding and mapping standards.
• Extensive experience in OBIEE repository (Physical, Business Model and Mapping and Presentation layers) for both Stand-Alone and Integrated Siebel Analytics implementations.
• Experience with business object data integration, integration of various data sources like Oracle, SQL server and MS access, flat files, Teradata, and XML, EBCDIC files. Experience in Data Flux, ERWIN/ ER studio.
• Strong expertise in Relational data base systems like Oracle 8i/9i/10g, SQL Server 2000/2005, MS Access, design and database development using SQL, PL/SQL, SQL PLUS, TOAD,SQL LOADER.
• Experience with UNIX commands, VI editor and writing Shell scripts.
• Expertise Informatica B2B Data Transformation, DT and DX, pre-built transformations for most versions of industry standard messages including the following EDI standards and derivatives.
• Experience in Ralph Kimball Methodology, Logical Modeling, Physical Modeling, Dimensional Data Modeling, Star Schema, Snowflake Schema, FACT tables, Dimension tables change or transformed of unstructured data to well-formed XML.
• Expertise in OLTP/OLAP System study, developing Database schemas like star schema, snow flake schema Dimensional Data Modeling used in relational, dimensional modeling and slowly changing dimensions (SCD’s).
• Worked in Agile team setting to develop features for E-commerce sites with new technology platform .Have good knowledge of Facets.
• Performed ETL procedure to load data from different sources into data marts and Data Warehouse using Power Center.
• Experience in working with scheduling tools like Autosys and Control M. Experience with Informatica Web services / message queue.
• IDQ-Informatica Data Quality is used for Data Quality Analysis perspective provides subset of data, attributes details which gives what is wrong and what is being used. It has capability to generate various levels of reports/graphs based on data
• Experience with high volume datasets from various sources like Oracle, Text Files, and Netezza Relational Tables and xml targets
• Knowledge of reporting tool like OBIEE, Cognos, MicroStrategy and Business Objects.
• Experience in   Informatica  DAC  Tool for Customizing Data warehouses and Creating Task and Task Groups.
• Good experience on WebServices and experienced with Maplets in DT is ideal
• ETL experience in development of mappings and tuned existing mappings for better performance using Informatica   Power   Exchange , Informatica   Power   Center as per the business rules.
• HIPPA certified through HP.
• Expertise in writing Oracle PL/SQL Stored Procedures/Functions/Packages and cursors Triggers.
• SQL Tuning and creation of indexes for faster database access, better query performance in Informatica by creating Explain Plan, SQL hints for query and indexing the required columns.
• Develop, execute ETL test plans, Document ETL processing and generate required metadata.
• Develop a transformation by marking the relevant data directly on a sample of the data source, and mapping that data to a chosen XML schema
• Performed Informatica B2B Data Transformation maintains architectural separation of protocols, formats, and interfaces updates than competitors. And Informatica B2B Data Transformation’s universal deployment capability.
• Expertise in writing DDL, DML, DCL, and TCL commands
• Experience in creating reports using Oracle Business Intelligence 10x, and Siebel Analytic
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.

TECHNICAL SKILLS:

ETL Tools : Informatica 9.5.1/9.1/9. x/8.x/7.x/6.x (Power Centre, Power Mart, Power   Exchange )/ Informatica Identity Resolution (IIR), CARS, Pervasive, Netezza

Databases : Oracle 8i/9i/10g/11g/ Netezza/db2

Data modelling Tools : Erwin 4.5/4.0/3.x

Query Tools : SQL, SQL Server, SQL 2005 and 2008 PL/SQL, SQL*Plus, and TOAD

OLAP/Reporting Tools : OBIEE 10.1.3.x,Siebel Analytics   7.x,Oracle BI apps

Languages : UNIX/LINUX/DOS Scripting, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, LA, CA

Sr. Informatica Developer

Responsibilities:

• Driving the project starting from capturing business requirements, project development, acceptance testing and final implementation
• Understand the project requirements given by the Client, Co-ordinate with offshore team to translate technical specs to Informatica and Business rules.
• Implementing methods to validate that data supplied by external sources were loaded correctly into the awards database.
• Validating the data were loaded correctly, external data will be examined for signals that indicate the source might be incorrect.
• Rewriting the database that maintains information about agency awards programs, to enable the database and to support calculations using the new book of business concept. It will also simplify the process of adding new metrics and targets.
• Interacting with business users effectively to understand precise and accurate requirements.
• Reviewing the requirements with business, doing regular follow ups and obtaining sign offs
• Finalize resource requirements and building offshore ETL and reporting teams based on signed off business requirements.
• Providing clarifications to offshore team about technical specification documents including data transformation and business rules
• Effectively coordinating with offshore teams, Client BI team and business users to deliver the project on time
• working closely with the Client BI team for resolving technical issues, getting data models, ETL architectures and high level designs reviewed and any sort of technical support required
• Effectively coordinating with business users to complete acceptance testing within timelines and obtain sign offs.
• Working on data warehousing concepts/design with good understanding of the ETL and reporting processes
• Participate in cross-application integration testing and system testing and worked with team members in the defect resolution process
• Ensure that all timelines of loading/validating data are met with comparing host (mainframes) files
• Ensure smooth functioning of our development, QA and Worked with team members in the defect resolution process
• Collaborate with team members to resolve issues to assure the successful delivery of high quality ETL and BI Code.

Environment:Informatica9.X/PowerCenter9.5.1/8.6,PowerExchange,UNIX,ULTRAEDIT,WINSQL,WINSCP, MS ACCESS, Windows NT, Oracle 9i/10g,, DB2, MAINFRAMES, Erwin 4.0, SQL, PL/SQL, T SQL, TOAD, CARS,XML,MDM., Testlink, HP SERVICE MANAGER, LOTUS NOTES.

Confidential, Emeryville, CA

Sr. Informatica Developer

• Involved in gathering and reviewing business requirements. Involved in designing the specifications, Design Documents, Data modeling and design of data warehouse.
• Migration of mappings and transformation from one environment to another. Work with Dev team lead and business partners to clarify ETL requirements and business rules.
• Write INFA mappings using PC, PE 8.x. /PC 9.1.
• Design, develop, implement, and assist and in validating ETL processes.
• Create and execute unit test plans based on system and validation requirements.
• Troubleshoot, optimize, and tune ETL processes.
• Document all ETL related work per AAA DF methodology.
• Maintain existing code and fix bugs whenever needed.
• Ensure that all timelines of loading/validating data are met.
• Ensure smooth functioning of our development, QA, production, and staging environments.
• Used UNIX Putty to transfer, copy, and move and assign privileges to the files like read, write & execute. Used TOAD to develop oracle PL/SQL, DDL's, and Stored Procedures. Performance.
• Schedule and Run Extraction and Load process, monitor task and workflow using the Workflow Manager and Workflow monitor.
• Used Error handling strategy for trapping errors in a mapping and sending errors to an error table.
• Scheduling Informatica workflows using Informatica scheduling tool.
• Wrote UNIX shell scripts jobs to automate the workflows for batch processing.
• Used Informatica Load Plan option to maintain the order of target loading.
• Did unit testing and development testing at ETL level in my mappings
• Created Informatica mapping template with mapping Visio architect tool.

Environment: Informatica Power Center 9.1/8.6.1,Informatica B2B, DTD files, IDCOS, Oracle 10g/11g, Wins, PostgreSQL, PL/SQL, SQL*Plus, SQL Loader, HTML 4.0, MS SQL Server 2000, MS-Excel, XML, Flat files, Windows NT, HP-UX, Shell Scripting, WinSCP, Putty, smartFTP.

Confidential, Houston, TX

Sr. Informatica Developer

Responsibilities: 

• Extracted data from different sources like DB2, SQL server, flat files and loaded into DWH
• Coordinated with the Business System Analysts (BSA) for gathering the business requirements.
• Created documents for the entire lifecycle of the project including but not limited to understanding documents, design documents, execution instructions and handoff documents. 
• Extracted data from various source systems like flat files, database tables and XML files.
• Loaded data into heterogeneous systems acceptable by Legacy system Migration workbench (LSMW) to load into SAP.
• Created complex mappings using transformations like transaction control, java, update strategy, joiner, lookup, union, router, filter, expression etc.
• Wrote complex SQL queries, stored procedures using Oracle 10i/11i and UNIX shell scripts for achieving the ETL requirements.
• Involved in performance tuning of Informatica mappings, sessions and workflows.
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings and workflows and to keep track of the changes in the development, testing and production environments.
• Understanding of Power Center Architecture Informatica B2B Data Exchange.
• Scheduled workflows and sent automatic email messages that post the statistics of the data load.
• Created mappings, sessions and workflows in development environment and later moved them to testing and production environments. Recorded scripts and loaded data using QTP into SAP.
• Attended issue clarification meetings Coordinated with the offshore team for developing new requirements.

Environment: Informatica power center 9 .1, Power Center 8.6, Informatica   Power   Exchange 8.1, Oracle 11g/10g, PL/SQL, UNIX shell scripting, MDM (Meta data manager) sap.

Confidential, Sunnyvale, CA

ETL- Informatica Developer

Responsibilities:

• Excellent proficiency in data and object level Security in Siebel Analytics/OBIEE.
• Worked in customizing Siebel Analytics/OBIEE dashboards and reports.
• Involved in analysis and resolving the data issues related to Customer, Distributor and Transaction increments of the data warehouse.
• Involved in designing Error Handling strategy using Error detection/Notification/Re-Processing processes.
• Developed scripts for automating workflows using ksh and Bourne shell scripting.
• Involved in enhancing the current data model using Erwin 4.0 to accommodate the new EDW and Cross-Reference tables.
• Worked on setting up SSIS packages for data management from third party vendors.
• Development of Unix shell scripts to automate starting/recovering the Informatica workflows
• Involved in scheduling the Informatica workflows using Control-M.
• Implemented load parallelism using Informatica database partitioning.
• Performed Unit Testing and Integration Testing on the mappings.
• Lead a team of offshore resources and monitored the tasks assigned to them.
• Developed Mappings which loads the data in to Teradata tables with SAP definitions as Sources. Developed Error handling mechanism and delta logic in different mappings
• Unit tested the developed ETL scripts, created test SQLs, and handled UAT issues. Enhanced SQLs for performance tuning. Rolled out documentation for the ETL Process, Early Data Inventory, and Data Profiling.
• Supported the production implementation of the data warehouse, monitored jobs & fixed failed scripts
• Supporting all the multiple Platforms through high performance environment provided by Power Center, Power Exchange.

Environment: Informatica Power Center 7.1/8.1, Power Exchange 8.1, Metadata Manager, Sybase, SAP, BTEQ, Java, OBIEE 10.1.3.3, Oracle BI Applications, Power Connect, SQL Server 2005, XML, Oracle 10g, SSIS, Erwin 7.0, DB2 on Mainframe.

Confidential, Denver, CO

Informatica Developer

Responsibilities:

• 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...
• Created various stored procedures for removing the indexes before the data is loaded, rebuilt the indexes after the load has been completed. Designed and developed sophisticated workflows and data transformations involving Informatica B2B components dx (Data Exchange) and DT (Data Transformation).
• Used session partitions, dynamic cache memory, and index cache to improve the performance of Informatica server. Participated in data modeling and process flow using Erwin Tool.
• Wrote Shell scripts to schedule batches on Cron Jobs.
• Used Informatica scheduler to run the workflows on UNIX box and monitored the results.
• Used pmcmd command line tool to schedule sessions/batches and stop the server.
• Generated various kinds of reports in OBIEE and Involved in production support.

Environment: Informatica Power Center 7.x, Oracle 9i/10g, Shell Scripting, SQL, Facets, PL/SQL, TOAD, OBIEE 10.1.3.3.

Confidential

ETL Developer

Responsibilities:

• Studied the project requirement and designed the project.
• Analyzed the sources, Targets, Transformed the data and Mapped the data and loading the data into Targets using Informatica.
• Experience in Development the Mappings using needed Transformations in Informatica Tool according to technical specifications.
• Developed various mappings to load data from various sources using different transformations like Router, Aggregator, Joiner, Lookup, Update Strategy, Expression and Sequence Generator to store the data in target table.
• Developed various clients of Mappings.
• Testing and maintaining of Informatica Mappings.
• Resolving if any issues in transformations and mappings with the help of technical specifications.
• Involved in Unit Test cases.
• Created tables, views, synonyms and sequences. Used SQL Loader for data loading.
• Optimized queries using rule based & cost based approach.
• Used SQL Loader for data loading.
• Modified existing forms, reports, and graphs as per the enhancement.

Environment: Informatica Power Center 6.2, Oracle, SQL/PLSQL, TOAD, and Windows NT, Windows 98, UNIX