PROFESSIONAL SUMMARY:

• 7+ Years of Professional experience in different areas of Data warehousing, RDBMS, Data modeling, Data extraction, Data acquisition, Analysis, Application design, Development and Implementation of data warehousing, business Intelligence system using Informatica Power Center, Data Conversion and various business applications in different platforms.
• InformaticaPowerCenter 9.1/8.6/8.5/8.1/7.1/6.1.1, Oracle 11g/10g/9i(SQL/PL SQL). Extensive experience in System Analysis, Design, Development, Implementation, Production Support and Maintenance of Data Warehouse Business Applications in Pharmaceutical, Finance and Insurance industries.
• Experience in Dimension Data Modeling concepts like Star Join Schema Modeling, Snow - Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling .
• Worked in Data Conversion of various data sources like Oracle, MS SQL Server, Oracle Apps, MS Access, Fixed Width and Delimited Flat Files, COBOL files and XML Files.
• Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Skills of understanding of Project Life Cycle and gathering requirements for ETL Development. Extensively worked on Informatica Designer Components - Source Analyzer, Warehousing Designer, Transformations Developer, Mapplet and Mapping Designer.
• Strong Experience on Workflow Manager Tools - Task Developer, Workflows & Worklet Designer and Managing, Scheduling, and Monitoring of Informatica workflows. Worked on all the transformations like Connected and Unconnected - Remote Lookup, Aggregator, Expression, Filter, Router, Update Strategy, Connected and Remote Stored Procedure and Sequence Generator, Sorter.
• Knowledge of Advanced Programming for data transformation (JAVA) Created ETL mappings using Informatica Power center to move Data from multiple sources like Flat files, Oracle, DB2 into a common target area such as Data Marts and Data Warehouse. Extensive knowledge with TeradataSQL Assistant.
• Developed Teradata BTEQ scriptsto Load data from TeradataStaging area to Data Warehouse, Data Warehouse to data marts for specific reporting requirements.
• Experience in PL/SQL Programming (Stored procedures, Triggers, Packages) using Oracle (SQL, PL/SQL), SQL Server and UNIX shell scripting to perform job scheduling.
• Quick learner with Analytical and logical programming skills and possess excellent presentation and interpersonal skills.
• Good communication and interpersonal skills and Strong understanding of ETL best practices. Assign work and responsible for providing technical expertise for the design and execution of ETL projects to onshore and offshore developers.

TECHNICAL SKILLS:

Operating Systems: Windows 2008/2007/2005/ NT/XP, UNIX, MS-DOS, IBM S/3,MVS/ESA

ETL Tools: Informatica Power Center 9.1/8.6/8.5/8.1/7.1 (Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager and Informatica server)

Databases: Oracle 11g/10g/9i/8i, DB2 v8.1, MS SQL Server 2008/2005.Netezza

Data Modeling tools: ERWIN 4.x and Concepts like Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

Languages: SQL, PL/SQL, UNIX Shell scripts, C, C++,Obiee.

Scheduling Tools: AUTOSYS

Development Tools: SQL *PLUS, TOAD, SQL Navigator.

Packages: MS Word, MS Excel, MS Project, MS Visio, MS PowerPoint

PROFESSIONAL EXPERIENCE:

Confidential, OHIO

Informatica ETL Developer/Support

Responsibilities:

• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center.
• Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data & used pager for notifying the alerts after successful completion.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
• Attended the QA Audit meetings and test artifacts review.
• Participated in the Integration testing and Unit Testing along with the Development team
• Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data & used pager for notifying the alerts after successful completion.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Automated the Informatica jobs using UNIX shell scripting.
• Closely worked with the reporting team to ensure that correct data is presented in the reports.
• Interaction with the offshore team on a daily basis on the development activities.
• Stored reformatted data from relational, flat file, XML files using Informatica (ETL).
• Extensively used SQL scripts/queries for data verification at the backend.
• Provided production support to various manuals and deployment.
• Monitored functional requirements and mapped all documents.
• Extensively worked in the performance tuning for mappings and ETL procedures both at mapping and session level.
• Coordinated and implemented Webstar ticketing in collaboration with technical teams.
• Monitored and examined performance of programs after implementation.
• Majorly acted as a priority one for production support of this Project.
• Responsibilities include creating the sessions and scheduling the sessions
• Recovering the failed Sessions and Batches.
• Preparing the documents for test data loading.

Environment: Informatica Power Center 9.5 .0.Power Exchange, Seibel Obiee,DB2 Exchange,, Oracle 11g, DB2, XML, TSQL,SQL Server, UNIX (AIX), UNIX Shell.

Confidential

Informatica ETL Developer

Responsibilities:

• Participated in design sessions where decisions are made involving the transformation from source to target.
• Responsible for developing various data extracts and loading routine using Informatica, Oracle stored procedure (pl and sql), packages, triggers,
• Managed and compile documentation for all ETL processes.
• Created detailed process flow designs and drafts high-level Standard Operation Procedures.
• Performed Informatica Administration tasks.
• Performed tuning for PL and SQL procedures, Views, and Informatica objects.
• Designed and implements the error handling strategy for ETL team.
• Monitored data warehouse month-end loads to ensure successful completion
• Mappings, Mapplets and Sessions for data loads And data cleansing. Enhancing the existing mappings where changes are made to the existing mappings using Informatica Power center
• Gather and analyze business requirements.
• Design logical and physical data models and data processing infrastructure.
• Provide production database support, enhance existing system and design and develop new systems.
• Monitor the usage of database space and performance.
• Performance optimization of the database and applications.
• Involved in ETL process from development to testing and production environments
• Developed mappings using various transformations like update strategy, lookup, stored procedure, router, joiner, sequence generator and expression transformation.
• Used Informatica Power Center Workflow Manager to create sessions, batches to run with the logic embedded in the mappings.
• Tuned mappings and SQL queries for better performance and efficiency.
• Performed Unit testing and validated the data.

Environment: Informatica Power Center 9.1Power Exchange, Erwin, Business Objects 6.5,Cogons, Tivoli, Oracle 9i, DB2, XML, TSQL, MS SQL Server 2005, UNIX (AIX), UNIX Shell.

Confidential, OHIO

ETL Informatica Developer

Responsibilities:

• Responsible to meet with business stakeholders and other technical team members to Gather and analyze application requirements.
• Involved in development of Logical and Physical data models that capture current state Developed and tested all the informatica Data mappings, sessions and workflows - involving several Tasks.
• Generated Adhoc reports Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server and Worked on integrating data from flat files like fixed width and delimited.
• Experience in analyzing business specification documents, developing test plans defining test cases, developing and XML test scripts.
• Future state data elements and data flow using Erwin.
• Developed end-to-end ETL processes for Trade Management Data Mart Using Informatica.
• Worked on source analyzer, Ware House Designer, Mapping and Mapplet Designer, Workflow manager and Workflow Monitor. Used Joiner, Aggregator, Expression, Router, Sequence Generator, Update Strategy and Lookup Transformation to manipulate data related to customers. Designed and developed Informatica
• Mappings, Mapplets and Sessions for data loads And data cleansing. Enhancing the existing mappings where changes are made to the existing mappings using Informatica Power center.
• Involving in extracting the data from Oracle and Flat files Developed and implemented various enhancements to the application in the form of Production and new production rollouts.
• Worked on identifying facts, dimensions and various other concepts of dimensional modeling which are used for data warehousing projects.
• Trained on building Conceptual, Logical and Physical data model. Responsible for Error handling, bug fixing, Session monitoring, log analysis .
• Responsibilities include creating the sessions and scheduling the sessions.
• Extensively worked on confirmed Dimensions for the purpose of incremental loading of the target database.
• Tuning of the mappings and SQL Scripts for a better performance.
• Involved in the optimization of SQL queries which resulted in substantial performance improvement for the conversion processes.
• Analyzed the various bottlenecks at source, target, mapping and session level.
• Generated ad-hoc reports as requested by the team lead using Business Objects free hand SQL. Helped in maintenance work related to reports.
• Good communication and interpersonal skills and Strong understanding of ETL best practices.
• Assign work and responsible for providing technical expertise for the design and execution of ETL projects to onshore and offshore developers

Environment: Informatica Power Center 9.2 Power Exchange, Erwin, Business Objects 6.5,Cogons, Tivoli, Oracle 9i, DB2, XML, TSQL, MS SQL Server 2005, UNIX (AIX), UNIX Shell.

Confidential, NEW YORK

ETL Developer

Responsibilities:

• Analyzed source data and gathered requirements from the business users. Informatica Power Center 8.5 is used to extract, transform and load data from different Operational data sources like Oracle as an ODS, DB2 and flat file.
• Coordinating with source systems owners, day-to-day ETL progress monitoring, Data warehouse Target schema design (star schema) and maintenance.
• DB2, SQL Server and worked with business users and developers to develop the Scalability and performance tune existing batch to handle large volumes.
• Scheduling of the jobs through Tidal and Crontab Responsible for all activities related to the development, implementation, administration and support of ETL processes for large-scale data warehouses using Power Center and Power Exchange.
• Tuning package components like Script Task, Data Flow task, Data Conversion, Slowly Changing Dimension, Look Up, Derived Column, Multicast, Sort, and Conditional split, Script Component, Configuration file.
• Experience working on performance tuning and optimizationof Teradata queries.
• Involved inDataMigrationbetween Teradata,MS SQL server,DB2 and OracleExperience in Database Programming,SQL,PL/SQL(Stored Procedures, Functions and Triggers) for faster transformations and Development using TeradataandOracle Used mapping Parameters and Variables to pass the values between sessions.
• Developed mappings with Transformations Mapplets confirming to the business rules.
• Testing and Data Validation - each extract process will be validated, and data elements within each file will be reviewed to ensure data quality prior to passing the file to Risk Management. Implemented Type I and II Slowly Changing Dimensions.
• Routines using Informatica Power Center and Oracle/Netezzaas the backend databases Worked onTeradatainsert, Update and Upset SQL to transform and Load Summary tables built on Core Data Warehouse using BTEQ.
• Created tasks like Timer Event Raise, Event Wait, Decisions, and Email. Document all the DTS packages implemented to move the data from source to target tables.
• Defined roles and responsibilities within the team and reviewing deliverables Data Enhancements and deliverables done to QA Environment Successfully.
• Automated Informatica flow of loading data by using Autosys scheduler with Followed Software Development Life Cycle process.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large-scale data warehouses using Power Center and Power Exchange Worked extensively on Oracle Installation, Oracle Version Upgradation, Migrations and Patching
• The present system generates reports by using Java application. Participated in the installation and configuration of Oracle BI EE 10.1.3.4.1 in the windows as well as the Linux environment Performance tuning of sources, targets, mappings and SQL queries in the transformations.
• Delegating work to team members Involved in data model reviews with internal data architect, business analysts, and business users with explanation of the data model to make sure it is in-line with business requirements.
• Reviewed the logical model with Business users, ETL Team, DBA’s and testing team to provide information about the data model and business requirements Designed reusable transformations and Mapplets to be re used with various mappings.
• Worked on Database Triggers, Stored Procedures, Functions and Database Constraints. Performing Unit, Integration and Regression testing and preparing Test Cases for the same. Coordinating work offshore team.

Environment: Informatica Power Center8.5v (Repository Manager, Designer Tools like Source Designer, Warehouse Designer, Mapping and Mapplet Designer, Workflow Manager, Workflow Monitor) Power exchange, DB2 8.0, Oracle 10g, UNIX Shell Scripting, Autosys .Java. Java scripts,Obiee.

Confidential, NORTH CAROLINA

Informatica Developer/Analyst

Responsibilities:

• Worked with different Informatica client Tools like Source Designer, warehouse designer, Mapping designer, Mapplet Designer, Transformations, Informatica Repository Manager and Informatica Servers
• Created design documents, technical specifications for Mappings and Sessions based on user requirements.
• Involved in data conversion using Teradata Utilities and loaded into Teradata tables Expertise in system analysis with the help of data collection and proposing solutions.
• Assisted Senior Technical Analyst in defining the strategies of systems and developing system requirements.
• Experience in Configuring Interactive Dashboards with Drill-Down capabilities using Filters and Dashboard prompts, Siebel Security Setup (groups, access privileges), Metadata objects and Web Catalog objects (Dashboard, Pages, Folders, Reports)
• Worked closelywithTesting team and helped in testing theInformaticamappings, workflows andTeradata scripts.
• Involved in analysis and requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Extensively Created different complex mappings using expressions, aggregators, filters, lookup and procedures to develop and feed in Data Warehouse and used Update strategy transformation to transfer data from source to data effectively.
• Responsible for creating Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Extensively used Multi-Load and Fast-Load utility to populate the flat file data into the Teradata database Worked on performance tuning and optimization of the Sessions, Mappings, Sources and Target Worked with the Business Analysts for requirements gathering, business analysis and testing.
• Used debugger to validate mappings and gain troubleshooting information about data and error conditions.
• Developed shell scripts to automate pre-session and post- session tasks. Experience developing software for SQL databases including MySQL, Oracle, MSQL and Netezz.
• Involved in creating scripts for various database objects related to the data model, which involve in creation of schema, tables, sequences, views, Materialized views, constraints, and indexes..
• Involved in designing of star schema based data model with dimensions and facts. Responsible for Performance tuning of Informatica code for better performance. Maintaining the Informatica servers and services for smooth development and production efforts.
• Contact Informatica tech support for resolving the issues we are not familiar with. Migrated Informatica folders, mappings, workflow, reusable objects from one environment to another and in the process of change control.
• Worked extensively on Oracle 11g, 10g, 9i, and 8i versions involving database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, cloning, space management and security
• Worked with pre and post sessions and extracted data from Transaction System into Staging Area. Repository Backup, Clear Cache and log files.
• Developed and maintained technical documentation for Informatica servers and repositories. Analyzed performance measures to fit the reporting needs of the company. Sound knowledge in migrating mappings from development to production.
• Experience developing software for SQL databases including MySQL, Oracle, MSQL. Extensively usedTeradataSQL Assistant to extract data from Datawarehouse.
• Develop data models according to company standards.
• Monitoring the existing ETL jobs and takes necessary actions as per the error
• Responsible for the development of system test plans, test case creation, monitoring Progress of specific testing activities against plan.
• Extensively used ETL to load data from Flat files. Used SQL, PL/SQL, and TOAD validating Data going in the Data Ware House.
• Tidal Enterprise Scheduler automates workloads on and across Autosys. Possess excellent documentation skills, prepared best practices document’s and have experience in data modeling and data modeling tools like Erwin.
• Proficient in using Informatica workflow manager, workflow monitor, server manager, PMCMD (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.
• Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems

Environment: Informatica Power Center 8.6, Oracle 10g/9i, TOAD, and Teradata, DB2 v8.1, PL/SQL, UNIX, Windows XP, Erwin 4x,cogons, UNIX Shell Scripts and DB2 Connect.

Confidential, BOSTON

ETL Informatica Developer

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering and project coordination. Design and Development of ETL routines using Informatica Power Center 8.1.
• Within the Informatica Mappings, usage of Lookups, Aggregator, Ranking, Maplets, connected and unconnected stored procedures / functions, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers was extensively done.
• Design and Development of data validation and load processes (using PL/SQL, SQL) and pre-session, post-session routines and batch execution routines using UNIX Shell Scripts. Implemented slowly changing dimensions.
• Analyze data-related system integration challenges and propose appropriate solutions.
• Develop data models according to company standards. Used DB2 Connect to extract multiple database source systems to single analytical system for large databases and also 24*7 Production support for data warehousing.
• Logical and Physical Data Modeling (relational and multi-dimensional) using ERWIN and used Power Plug to forward engineer to Informatica Repository Performance Monitoring and tuning of SQL using Explain Plans and Oracle Hints and tuning of Informatica mappings using SQL overrides and source filters and managing cache file allocations and sizes. Used TOAD to run SQL queries.
• Extensively used SQL*Loader to load data from flat files to database tables in Oracle. Involved in Data Extraction from Oracle and Flat Files using SQL Loader.
• Developed and tested all the informatica Data mappings, sessions and workflows - involving several Tasks.
• Generated Adhoc reports using Query studio in Cogon’s. Strong Experience writing SQL Queries, PL/SQL Procedures in Oracle Database, DB2 UDB. Implementation of stored procedures and packages utilizing PL/SQL for the enhancements of the existing application level data warehouse.

Environment: Informatica Power Center 8.1, Oracle 10g, Cognos, Unix (HP-UX 11.x), Sun Solaris (2.6), Windows 2K,UNIX Shell Scripts, PL/SQL, DB2 Connect, TOAD.