Professional summary:

• Innovative thinking and strong problem solving and analytical capabilities.
• Certified Informatica developer.
• Skilled in SQL, PL/SQL, SQL Plus, TOAD, SQL Assistant.
• Extensive database experience and highly skilled in SQL, Oracle, MS SQL Server, DB2, Teradata, Sybase, Mainframe Files, Flat Files, MS Access.
• Created test plans, test data for extraction and transformation processes and resolved data issues following the data standards.
• Experienced in using IDQ tool for profiling, applying rules and develop mappings to move data from source to target systems.
• Experience in developing Transformations, Mapplets and Mappings using Informatica Designer to implement business logic.
• Strong knowledge and Experience in using Informatica Power Center 8.1/8.5/8.6/9.1 ETL tool.
• Strong Data analysis to ensure accuracy and integrity of data in the context of Business functionality.
• Strong understanding of Dimensional Modeling, OLAP, Star, Snowflake Schema, Fact and Dimensional tables and DW concepts.
• Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets and vice versa.
• Expertise in source to target mapping in Enterprise and Corporate Data Warehouse environments.
• Directly responsible for the Extraction, Transformation Loading of data from multiple sources into Data Warehouse.
• Over 7 years of IT experience in system analysis, design, development of software applications and experience in the field of ETL methodologies, business intelligence and data Warehousing principles and architectures including concepts, designs and usage of data warehouses and data marts.
• Proven ability to work efficiently in both independent collaborative environments with Excellent interpersonal and communication skills.

Technical skills:

Professional Experience:

Confidential

Sr. Informatica /IDQ Developer

Responsibilities:

• Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets
• Developed rules and mapplets that are commonly used in different mappings
• Used various transformations like Address validator, parser, joiner, filter, matching to develop the maps
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Worked on Power Center Tools like designer, workflow manager, workflow monitor and repository manager.
• Worked on multiple projects using Informatica developer tool IDQ of latest versions 9.1.0 and 9.5.1.
• Involved in migration of the mapps from IDQ to power center
• Applied the rules and profiled the source and target table's data using IDQ.
• Developed the mappings, applied rules and transformation logics as per the source and target system requirements.
• Worked on different environments with different source and target databases like Teradata, DB2, and SQL server.
• Developed the mapping to process multiple flat file as source and staged the data into teradata and DB2 databases.
• Responsible for migration of the work from dev environment to testing environment
• Responsible for solving the testing issues.

Environment: Informatica Power center 9.1/9.5-HotFix 4 , IDQ 9.1/9.5.1 Hotfix 2.0, SQL Server 2008, Teradata 13.1, DB2, IBM MainFrames, UNIX, Windows NT, SQL Assistant 6.2.1.

Confidential

Sr. Informatica Developer

Responsibilities:

• Used Informatica Power Center to create mappings for extracting data from various systems.
• Created complex mappings to deal with Continuous Surveillance CS for audit purposes. Continuous Surveillance tests have the requirement to be run on a regular basis weekly, monthly, quarterly etc.
• Used Mapping Designer, Workflow Manager, Workflow Monitor extensively to create, execute and monitor a mapping's run process.
• Worked extensively with various transformations like expression, filter, joiner, aggregator, lookup, rank, sequence generator, sorter, etc.
• Developed several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets Parameter files in Mapping Designer.
• Worked extensively on performance tuning of programs, ETL procedures and processes.
• Participated in upgrading informatica version from 8.6 to 9.1
• Worked on other types of tests including non CS and extracts.
• Worked on a special project called Cards Confirmation to create various programs for extracting data from various source systems.
• Developing Teradata Utility scripts like FastLoad, MultiLoad to load data from various source systems to Teradata.
• Used SQL tools like TOAD and SQL Assistant to run SQL queries and validate the data in the database.
• Reusing the single workflow for loading data from various regions' files with similar file structure using indirect loading as source type in session properties.
• Helped the team by working on Production Support. Was responsible for fixing failed tests in the Production Server.
• Helped other programmers to correctly and efficiently design their mappings/programs.
• Worked on information that is secure, accurate, consistent, organized, and timely as in an enterprise or corporate data warehouse.

Environment: Informatica 8.6/9.1-HotFix 4 , Oracle 11g, SQL Server 2008, Teradata 13, DB2, Sybase, IBM MainFrames, UNIX, Windows NT, TOAD 9.5, SQL Assistant 6.2.1, Power Exchange 9.1.

Confidential

Sr. Informatica Developer

Responsibilities:

• Collaborated with Business analysts and the DBA for requirements gathering, business analysis and designing of the data marts.
• Worked on dimensional modeling to Design and develop Star Schemas, identifying Fact and Dimension Tables for providing a unified view to ensure consistent decision making.
• Design ETL processes using Informatica tool to load data from Oracle source systems and Flat files into Oracle Target database
• Integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files, DB2, COBOL files XML Files.
• Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle 9i/10g.
• Extensively used Transformations like, Aggregator, Router, Joiner, Expression, Lookup, Update Strategy, and Sequence Generator.
• Used Informatica Repository Manager to create Repositories and users and to give permissions to users.
• Imported metadata from different sources such as Relational Databases, XML Sources and Impromptu Catalogs into Frame Work Manager
• Extensively worked in the performance tuning of ETL mappings and sessions.
• Wrote Shell Scripts for Informatica Pre-session, Post session Scripts.
• Written PL/SQL stored Procedures and Functions for Stored Procedure Transformation.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Performed Unit testing and verified the data.
• Involved Conducted and participated in process improvement discussions and recommending possible outcomes and focused on production application stability and enhancements.

Environment: Informatica Power Center 8.6, Flat files, XML files, Oracle10g, SQL Server, UNIX, PL/SQL, Windows 2005/08 .

Confidential

Informatica Developer

Responsibilities:

• Installed and configured Power Center 8.6 Client/Server components on Windows UNIX.
• Created reusable metadata by making the Shared Global Repository objects.
• Created, scheduled and monitored batches and sessions using Power Center - Server Manager.
• Involved in data migration procedure and mapped data from legacy systems to new existing systems for providing a design for data extraction and data loading.
• Worked with SAP and Oracle sources to process the data.
• Built variety of prototypes to Extract, Transform and Load data from and to SAP using Informatica Power Connect.
• Created SAP BW OHS source definitions in Informatica and configured work flow to run from SAP process chain.
• Determine Extraction and Loading techniques from and to SAP, also from Non-SAP sources to SAP using Informatica Power Exchange v8 for SAP Data Integration.
• Responsible to tune ETL procedures and Star Schemas to optimize load and query performance.
• Created and executed sessions batches using Server Manager to load the data into the target database.
• Developed interfaces using Shell Scripts to automate the bulk load update the processes.
• Worked on Database Triggers, Stored Procedures, Functions and Database Constraints.
• Wrote complex stored procedures and triggers and optimized them for maximum performance.

Environment: Informatica 8.6/HotFix 6, Oracle 10g, MS SQL Server, SQL, PL/SQL, UNIX, SAP, Windows 2005/08.

Confidential

ETL Developer

Responsibilities:

• Configured Informatica Repository Manager to manage all the repositories of various applications. Created users, user groups, security access controls.
• Planned and designed the flow process of the data stored in the repository, in the form of metadata.
• Designed and constructed the Star Schema. Wrote procedures, functions in PL/SQL.
• Designed and created mappings using Mapping Designer.
• Worked extensively on performance tuning by making changes to SQL in Source Analyzer.
• Used various Informatica transformations like expressions, filters, joiners, aggregators, routers and lookups to load better and consistent data into the targets.
• Used Mapping Designer to join tables from various databases like Oracle, SQL Server, and DB2.
• Designed and developed catalogs by creating links between the Fact table and the Dimension table to form a Star Schema.
• Used TOAD to FTP file moving processes to and from source systems.
• Created scheduling of jobs in Workflow Manager to trigger tasks on a daily, weekly and monthly basis.
• Wrote shell scripts to join or concat target files, to delete or remove one or more such files if not needed after joining, and etc.
• Monitored the production loads and fixed them, when necessary.
• Involved in the Performance Tuning of Informatica servers and other legacy databases.

Environment: Informatica 7.1/8.6, Oracle 9i/10g, PL/SQL, SQL Server, DB2, MS Excel, UNIX Shell Scripting, TOAD 8.5.

Confidential

ETL Developer

Responsibilities:

• Interacted with Business Analyst to understand the business requirements.
• Created users/groups and folders using Repository Manager.
• Extensively worked with Source Analyzer, Warehouse Designer, Transformation Designer, Mapping Designer and Mapplet Designer.
• Extracted Source Data using Informatica tools and stored procedures from source systems.
• Developed transformation logic and designed various Complex mappings using the Designer.
• Used Mapplets, Parameters and Variables to implement Object Orientation techniques and facilitate the reusability of code.
• Developed and executed UNIX scripts as pre/post-session commands to schedule loads, through SQL-loader utility.
• Involved in Fine-tuning the Informatica Code mapping and sessions , Stored Procedures, SQL to obtain optimal performance and throughput.

Environment: Informatica Power Center/ Power Mart 7.1/6.2, Oracle 9i/8i, SQL Plus, TOAD, IBM DB2 8.0, Erwin 4.0, Sun UNIX 8, Windows NT, PL/SQL Developer.

Confidential

ETL Developer

Responsibilities:

• Imported various Sources, Targets, and Transformations using Informatica Power Center Server Manager, Repository Manager and Designer.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
• Used heterogeneous files from Oracle, Flat Files, SQL server as source and imported stored procedures from oracle for transformations.
• Designed and coded maps, which extracted data from existing, source systems into the data warehouse.
• Used Dimensional Modeling Techniques to create Dimensions, Cubes and Fact tables.
• Written PL/SQL procedures for processing business logic in the database. Tuned SQL queries for better performance.
• Developed Informatica mappings, mapplets, sessions, batches. Designed and developed the sessions for the relevant mapping s or Informatica jobs and organized as sequential / concurrent batches. Scheduled the main batches as per the business rules using the Informatica scheduler /CRON job using UNIX shell scripting for some of the existing data jobs.
• Generated completion messages and status reports using Informatica Server manager.
• Tuned ETL procedures and STAR schemas to optimize load and query Performance.
• Coded, documented and tested the dimensional tables, ODS tables.
• Prepared Source-To-Target mappings for the dimensional tables, performed the unit testing and co-ordinate the tester during Unit-Testing, Assembly-Testing, Regression-Testing procedures and fixed the bugs, enhancements to the modules.

Environment: Informatica Power Mart 5.1, SQL,PL/SQL, Unix Shell Scripts, Oracle 8i, MS Access, SQL server 2000 ,Windows NT/2000.

Confidential

Database Developer

Responsibilities:

• Involved in a team in designing the database schema for the metadata for storing the informative queries that are generated dynamically.
• Involved in creation of schema objects like indexes, views, stored procedures and synonyms.
• Involved in writing triggers which internally call procedures and functions.
• Involved in testing the database for the queries that are generated and handled the performance issues effectively.
• Involved in documenting the entire technical process.

Environment: Oracle 8, PL/SQL, ERwin 3.5.2, SQL, Windows 2000.