Summary

• 8 years of IT experience in Analysis, Design, Testing, Development and Implementation of client/server applications
• Strong experience in performing ETL operations like Data Extraction, Data Transformation and Data Loading with Informatica Power Center/Power Mart 8.6.0/8.1.0/7.1.
• Worked intensively with Informatica Powercenter Designer. Strong knowledge on Source Analyzer, Warehouse designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Extensively used Informatica Workflow manager and Workflow monitor for creating and monitoring workflows, worklets and sessions.
• Extensively worked on Informatica PowerCenter Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier.
• Identified the Facts and Dimensions using Erwin Data modeling tool to represent the Star Schema Data Marts.
• Strong in database concepts with PL/SQL, Oracle and Teradata.
• Experience in UNIX Shell Scripting and Dollar Universe for scheduling the jobs.
• Experience in testing/validating the Source, Stage and Target End-to-End .
• Extensive experience in Informatica Power Center/Power Mart to implement Data Marts which involved creating debugging and executing Informatica Mappings, Sessions, Tasks and Workflow.
• Experience in databases like Oracle 9i/8i, my SQL, MS SQL Server 2005/2000, DB2 and Teradata.
• Extensive Experience on Production Support.
• Hands on experience in Production Support and Maintenance by resolving issues to meet all Data Warehouse service Level agreements SLAs .
• Exposure to full project life cycle development for implementation and integration.
• Teradata Basics Certification.
• Oracle Certified Professional.
• Experience in Onsite-Offshore model.
• Expertise in Developing Datastage jobs in Parallel Extender using different stages like Transformer, aggregator, lookup, Source dataset, external filter, Row generator, and column generator.
• Experience of using different databases like Oracle/DB2/SQL Server/Netezza.
• Excellent analytical and SQL writing skills to address different business scenarios.
• Strong problem solving skills, ability to develop strategies for clients and provide detailed documents to clients.
• Experienced in gathering of User requirements and responsible to provide efficient end-user training and designing report specifications.

Technical Skills

PROFESSIONAL EXPERIENCE

Confidential

Role: ETL Developer

Responsibilities:

• Knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling Star Schema and Snow Flake Schema .
• Experience in designing/developing mapping using Source Qualifier, Lookup, Filter, Expression, Router, Update Strategy, Rank, Sequence Generator etc.
• Experience in developing Workflows, Worklets, sessions and tasks to effectively manage the Load and also create and control workflows, tasks and sessions. worked on Query Optimization and ETL performance tuning for improving the performance of the data warehouse.
• 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.
• Supported the BI team by extracting operational data from multiple sources, merging and transforming the data to facilitate enterprise-wide reporting and analysis and delivering the transformed data to coordinated data marts.
• Extensively developed Oracle PL/SQL stored procedures using TOAD to implement different business logics and perform backend testing Oracle 9i to verify the transactions and business logic.
• Created and tested UNIX shell scripts to automate SQL scripts and stored procedures.
• Extract data from data from DB2 database for ETL processing.

Environment: Informatica Power Center 8.6.1/8.1.1, DB2 UDB, Teradata ,UNIX Scripting KSH Windows 2000, Power Exchange 8.6.1, IDE8.6.0, IDQ8.6.0

Confidential

Role: ETL Developer

Responsibilities:

• Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across application and systems.
• Used Meta Data Manager to gather data from different applications and flat files for users to do impact analysis of the changes in the source systems.
• Developed and documented Informatica mappings and Informatica sessions as per the business requirement.
• Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Filter, Sequence, Router, Update Strategy, Lookup transformations.
• Generated PL/SQL scripts and UNIX Shell scripts for automated daily load processes.
• Extensively performed unit testing and system or integration testing.
• Maintained Development, Test and Production mapping migration using Repository Manager.
• Extensively involved in performance tuning at source, target, mapping, session and system levels by analyzing the reject data.
• Created and configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Developed ETL code, control files, metadata, and lineage diagrams for ETL programs.
• Unit testing and System Testing of Informatica mappings and Workflows.
• Created reusable sessions and executed them to load the data from the source system using Informatica Workflow Manager
• Extracted client information data and history from Flat files, Oracle, SQL Server transformed and loaded into Oracle staging area.
• Loading of data from different source systems into Oracle Target database.
• Wrote shell scripts to work with flat files, to define parameter files and to create pre and post session commands.

Environment: Informatica Power Center 8.6.1, DB2 UDB, UNIX Scripting KSH Windows 2000, Power Exchange 8.6.1, IDE8.6.0, IDQ8.6.0

Confidential

Role: Informatica Developer

Responsibilities:

• Coordinating offshore team, planning and review of deliverables.
• Responsible for documenting user requirements and translated requirements into system solutions
• Used shell scripting to check if the flat files have come in on the correct path and triggering the informatica jobs from UNIX server.
• Evaluating the Consistency and integrity of the model and repository.
• Designed and built Data Marts for home and business divisions.
• Installed and configured Informatica Server and Power Center 7.2. Migrated the
• Metadata changes to the Informatica repository.
• Responsible for Data Import/Export, Data Conversions and Data Cleansing.
• Created Informatica mappings with SQL procedures to build business rules to load data.
• Used Transformations for data joins, complex aggregations external procedure calls.
• Worked on Informatica Power Center 7.2 tool - Source Analyzer, Data warehousing designer, Mapping Designer Mapplets, and Transformations.
• Various kinds of the transformations were used to implement simple and complex business logic. Transformations used are: Remote Procedure, Connected Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregators, Filters, Sequence Generator, etc.
• Integrated sources from different databases and flat files.
• Designed mappings with multiple sources using Informatica Designer tool.
• Implemented various performance tuning concepts to enhance the jobs performance.
• Logical and Physical Warehouse Designing using Erwin Tool.
• Extensively used Star schema for designing the data warehouse.
• Responsible for various discussions with end user to analyze Meta data.
• Designed and Developed the ETL mapping and load strategy documents.
• Designed the ETL Mapping Documents for development team members for their implementations.
• Worked on Informatica - Source Analyzer, Data warehousing designer, Mapping Designer Mapplet, and Transformations.
• Designed and developed Informatica mappings for data loads and data cleansing.
• Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy and others.
• Designed and developed the Workflow and worklets for all load process.
• Worked on OBIEE reports to do Enhancements.

Environment: Informatica Power Center 7.2, Power Exchange 8.6.1, IDE8.6.0, IDQ8.6.0, Teradata, TOAD, XML, Windows NT, Erwin, OBIEE

Confidential

Role: ETL Developer

Responsibilities:

• Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across all application and systems.
• Documentation of technical specification, business requirements, functional specifications for the development of Informatica mappings to load data into various tables and defining ETL standards.
• Worked on Informatica Power Center 7.1.3 tool - Source Analyzer, warehouse designer, Mapping Designer Mapplets, and Transformations.
• Created and configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Extensively involved in performance tuning at source, target, mapping, session and system levels by analyzing the reject data.
• Maintained Development, Test and Production mapping migration using Repository Manager.
• Extensively performed unit testing and system or integration testing.
• Generated PL/SQL scripts and UNIX Shell scripts for automated daily load processes.
• Extensively worked in Oracle SQL Query performance tuning and created DDLs, database objects like Tables, Indexes and Sequences etc., by working closely with DBAs.
• Developed several forms and reports in the process. Also converted several standalone procedures/functions in PL/SQL to packaged procedure for code reusability, modularity and control.
• Designed tables, indexes and constraints using TOAD and loaded data into the database using SQL Loader.
• Worked on OBIEE reports to do Enhancements.
• Tuning of informatica jobs with oracle as backend database

Environment: Informatica 7.1.3, Business Objects, Oracle 8.1.7.4, SQL Plus, PL/SQL, TOAD 7.1, UNIX, Windows XP, OBIEE