Employment History

Confidential

Sr.ETL Informatica Developer

Responsibilities:

• Involved in full life cycle design and development of Data warehouse.
• Interacted with business analysts, data architects and application developer to develop a data model.
• Prepared the required application design documents based on functionality required.
• Created logical and physical data modeling using Erwin 4.5.
• Created Entity Relationship ER diagrams based on requirements.
• Extensively worked with Designer tools like Source Analyzer, Target designer, Mapping designer, Mapplet designer, Transformation Developer.
• Responsible for developing several complex mappings for processing the feeds and data transformation.
• Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Designed and developed the logic for handling slowly changing dimension table's load by flagging the record using update strategy for populating the desired.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases.
• Optimized the existing applications at the mapping level, session level and database level for a better performance.
• Developed PL/SQL procedures, functions to facilitate specific requirement.
• Optimized and Tuned SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts.
• Analyzed WSDL interactions with Oracle On Demand to push as well as pull data via Informatica.
• Conversant in WSDL requests and responses for data manipulation in Oracle On Demand CRM system.
• Import of WSDLs in Informatica using Web Service Consumer transformations.
• Customized WSDLs as per the Business and project requirements.
• Accustomed to the user interface of Oracle On Demand to search and use CRM application. Possess knowledge of CRM concepts like Account, Contact, User, Book etc.
• Designed and developed UNIX Shell scripts for creating, dropping tables which are used for scheduling the jobs.
• Involved in migration of mappings and sessions from development repository to production repository.
• Developed and maintained technical documentation regarding the extract, transformation and load process.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Involved in production support working with various mitigation tickets created while the users working to retrieve the database.
• Interacted with customers to educate them regarding the products.
• Investigated and fixed problems encountered in the production environment on a day to day basis.
• Co-ordinate between different teams across circle and organization to resolve release related issues.

Environment: Informatica Power Center 8.6, OLAP, Oracle 10g, TOAD, Erwin 4.5, SQL, PL/SQL, SSIS, SQL Server 2005, XML, Windows 2003 server/XP, Unix.

Confidential

ETL Developer

Responsibilities

• Responsible for Business analysis and requirements gathering from the Business users.
• Involved in Designing Logical and Physical Data modeling using Erwin Tool.
• Involved in creating the design and Mapping specifications for the ETL process based on Functional specifications.
• Sound Knowledge on Informatica power center client tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Extensively worked on Designer tools like Source Analyzer, Target designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Developed mappings using Informatica Power Center Designer to transform and load the data from source systems to Staging and Staging to target database.
• Worked on various types of transformations like Expression, Joiner, Update strategy, Aggregator, Filter, Lookup and Router.
• Involved in designing, developing and testing of the ETL strategy to populate data from various source systems Oracle, flat files, SQL Server feeds using Informatica.
• Created Mapplets to reduce the development time and complexity of mappings and better maintenance.
• Developed Source to Staging and Staging to Dimension mappings.
• Developed Source to Staging and Staging to Fact mappings
• Developed staging jobs where in using data from different source formatted, Cleaned, Summarized, aggregated and transformed into data warehouse.
• Developed ETL design for initial and incremental loads.
• Implemented performance tuning logic on Targets, Sources, Mappings, Sessions to provide maximum efficiency and performance.
• Identifying and Removing Bottlenecks in order to improve the performance of Mappings and Workflows.
• Used different transformations for data transformation.
• Created stored procedures for dropping and recreating indexes on target tables.
• Involved in Enhancements and Maintenance activities of the data warehouse including performance tuning.
• Migrated mappings from Dev to Test and Test to Production.
• Performed Unit testing and created Unix Shell Scripts and provided on call support.
• Preparation of UTP Unit Test Plan with all required validations and test cases.
• Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.
• Created various tasks like sessions, decision, timer control to design the workflows based on dependencies.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Responsible for customers interaction for building application development.
• Involved in production support and done knowledge transfer to team members.

Environment: Informatica Power Center 8.6 , OLAP, SQL Server 2005/2008, Oracle 10g, PVCS, Erwin 4.0, UNIX, Windows 2000, DAC, Oracle 10g, TOAD, SSIS, SQL, PL/SQL ,UNIX, Windows 2000, DAC.

Confidential

ETL/Informatica Developer

Responsibilities:

• Involved in analysis of source systems, business requirements and identification of business rules in building the Data marts/Data Warehouse.
• Interacted with users, documented user requirements, and translated requirements into system solutions and designed ETL processes and job schedule plans.
• Defined the technical requirements for ETL processes and created design document and source-to-target mapping document.
• Developed complex Mappings to load data from external sources like Flat Files, XML, Oracle, SQL Server, DB2 UDB using Informatica Power Center 7.1.4/6.2 designer to the Staging and Data Warehouse database.
• Created Mappings using data transformations like Source Qualifier, XML Source Qualifier, Expression, Sorter, Aggregator, Filter, Lookup, Update Strategy, Sequence Generator, Normalizer, Stored Procedure, Joiner, Rank, Router and Transaction Control transformations.
• Used connected, unconnected lookup, static and dynamic cache to implement business logic and improve the performance.
• Used partitioning in Sessions to improve the performance of the database load time.
• Created Session Tasks, Worklets and Workflows comprising of different mappings to control the flow of data in to Data Warehouse based on the success of the previous session or worklets.
• Implemented Error Handling strategy for trapping errors from Date validation, Data type mismatch and Lookup failures.
• Implemented versioning by having date range fields and version flags to maintain full history data in Type II Slowly Changing Dimensions.
• Tested the existing mappings and redesigned the mappings to improve the performance and the efficiency of the design logic.
• Designed and developed various Analysis Reports using Business Objects with different type of charts.
• Performed various operations like scheduling, publishing and retrieving reports from corporate documents using the business objects reporting.
• Created sessions and used pre and post session properties to execute scripts and to handle errors.
• Interacted with customers such that to build analyzes and relationship programs and processes.
• Performed unit test, string test and user testing by developing test cases and test scripts.

Environment: Informatica Power Center 7.1.4/6.2, OLAP, Oracle 9i, PL/SQL, SQL Server 2000/2005, DB2 UDB, Teradata Stored Procedures, Transact SQL , SSIS, MS Access, MS Visio, ERWIN, TOAD, XML, Windows XP, Unix, Shell Scripting, Business Objects 6.2.

Confidential

Informatica Developer

Responsibilities:

• Prepared the required application design documents based on functionality required
• Designed the ETL processes using Informatica to load data from Oracle, DB2 and Flat Files to staging database and from staging to the target database.
• Implemented the best practices for the creation of mappings, sessions and workflows and performance optimization.
• Dimension Data Modeling using Erwin.
• Involved in migration of mapping and sessions from development to production repository.
• Extensively used Informatica and created mappings using data transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.
• Designed and developed the logic for handling slowly changing dimension tables load by flagging the record using update strategy for populating the desired.
• Involved in cleansing and extraction of data and defined quality process for the warehouse.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions, index cache to manage very large volume of data.
• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Involved in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Involved in the Interaction with customers to educate them regarding various products.
• Involved in production support working with various tickets created while the users working to retrieve the database.

Environment: Informatica Power Center 8.6, Business Objects 6.5, OLAP, Oracle 10g/9i, TOAD, Erwin 4.5, SQL, PL/SQL, SQL Server 2005, SSIS, XML, Windows XP, HP UNIX, Test Director/Quality Center

Confidential

ETL/Informatica Developer

Responsibilities:

• Interacted with the Business Personnel to analyze the business requirements and transform the business requirements into the technical requirements.
• Prepared technical specifications for the development of Informatica ETL process to load data into various target tables
• Develop logical and physical data modeling that capture current state/future state data elements and data flows using Erwin.
• Defined ETL standards for ease of debugging and maintenance.
• Administered and worked with various Informatica client tools.
• Created mappings using different data transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator etc.
• Developed Mapplets and Worklets for reusability.
• Implemented CDC using Informatica Power Exchange.
• Implemented weekly error tracking and correction process using informatica.
• Implemented audit process to ensure Data warehouse is matching with the source systems in all reporting perspectives.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Extensively used Stored Procedures, Functions and Packages using PL/SQL.
• Developed Teradata Tpump scripts to load data from pipe delimited files to Teradata staging area.
• Developed Teradata BTEQ scripts to Load data from Teradata Staging to Enterprise Data warehouse.
• Worked on Teradata Global temporary and volatile tables.
• Worked with Teradata DBA team to create secondary indexes required for performance tuning of Data mart loads and reports.
• Created maestro schedules/jobs for automation of ETL load process.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Involved in customers interaction for application development.
• Involved in developing test data/cases to verify accuracy and completeness of ETL process.
• Involved in Unit testing, User Acceptance Test to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Actively involved in the production support and also transferred knowledge to the other team members and Created Business objects functionality from Analytical database to Transactional data warehouse. Create reports using Business Objects full client and Web Intelligence.

Environment: Informatica Power Center8.5 Repository Manager, Designer Tools like Source Designer, OLAP, SQL Server 2005, Warehouse Designer, Mapping and Mapplet Designer, Workflow Manager, Workflow Monitor , Oracle 10g, UNIX Shell Scripting, ERWIN 4.x.

Confidential

ETL Developer

Responsibilities:

• Interacted with business users and business analyst to understand requirements and system requirement specification document.
• Designed logical physical data modeling for data warehouse data marts with star schema and Snow flake Schema.
• Extracted data from DB2 and Oracle source systems and loaded into flat files using Informatica.
• Designed incremental loading process to load data into staging tables.
• Worked with active data transformations in Informatica power center like Filter, Aggregator, Joiner, Rank, Router, Sorter, Source qualifier, and Update Strategy transformations.
• Designed and developed complex mappings using various transformations like unconnected and connected lookup's, Expression, Sequence generator and more.
• Implemented slowly changing dimensions according to the requirements.
• Used Workflow manager for creating, testing and running sessions and Batches.
• Optimized existing applications at the mapping level, session level and target level for better performance.
• Developed PL/SQL procedures, functions to facilitate specific requirement.
• Configured the sessions using Workflow manager to have multiple partitions on source data and to improve performance.
• Involved in Unit testing, User Acceptance Test to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Identified and removed bottlenecks in order to improve performance of mappings and workflows.
• Developed shell scripts for informatica pre-session, post-session scripts.
• Developed test plans and test scripts to test the data based on the business requirements.
• Responsible for testing ETL jobs before test to production migration.
• Interacted with the customers for the development the software products.

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

Confidential

Informatica 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.
• Implemented Type I and II Slowly Changing Dimensions.
• Worked on delimited flat file sources.
• Created reusable data transformations and Mapplets and used them in complex mappings.
• Created different transformations for loading the data into target database using e.g. Source Qualifier, Joiner Transformation, Update Strategy, Lookup transformation, Rank transformation, Expressions, Aggregator, and Sequence Generator.
• Used mapping Parameters and Variables to pass the values between sessions.
• Developed mappings with Transformations and 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.
• Created tasks like Timer Event Raise, Event Wait, Decisions, and Email.
• Involved with escholar CDW to integrate education related data.
• Data Enhancements and deliverables done to QA Environment Successfully.
• Performance tuning of sources, targets, mappings and SQL queries in the transformations.
• Designed reusable transformations and Mapplets to be re used with various mappings.
• Performing Unit, Integration and Regression testing and preparing Test Cases for the same.
• Defined roles and responsibilities within the team and reviewing deliverables.
• Delegating work to team members.
• Coordinating work offshore team.

Environment: Informatica Power Center 7.1, Oracle 9i, PL/SQL, SSIS, Windows, ERWIN, PL/SQL Developer, UNIX, Windows NT, HTML.

Confidential

Reports Developer/Analyst

Responsibilities:

• Database Design and Application programming.
• Integration/System Testing of the application.
• Was involved in quality related activities like defect tracking.
• Writing Database Packages, Stored Procedures and Triggers.
• Support and maintenance of the Application Database.
• Used different transformations like router, aggregator etc for data transformation.
• Database servers and backup server's installation.
• Support of Production, Development and Test Environments of Oracle and Sybase Databases for multiple applications.
• Troubleshooting and Performance tuning of SQL Servers and applications.
• Backup and Recovery procedures for Production and Development servers.
• Running DBCC and fixing database consistency and allocation errors.
• Creating databases, tables, indexes, new logins, users etc.
• Monitoring performance of Oracle database.
• Physical resource management: device and segments creation.
• Creating stored procedures and triggers.

Environment: Oracle 8i, ETL, Developer 2000, PL/SQL, Designer 2000, Windows 95.