PROFESSIONAL SUMMARY:

• 8 years of extensive experience in ETL Extract Transform Load , Data Integration and Data Warehousing using Informatica Power Center Oracle PL/SQL Teradata technologies
• Knowledge on Data Profiling using Informatica Developer tool.
• Knowledge in Business Intelligence and Data Warehousing Concepts with emphasis on ETL and System Development Life Cycle SDLC .
• Proficiency in design and developing the ETL objects using Informatica Powercenter with various Transformations like Joiner, Aggregate, Expression, SQL, Lookup, Filter, Update Strategy, Stored Procedures, Router, Rank, normalizer transformations etc.
• Extensively created and used various Teradata Set Tables, Multi-Set table, global tables, volatile tables, temp tables
• Used various DDL and DML commands. Very good understanding of Teradata UPI and NUPI, secondary indexes and join indexes.
• Ability to exercise independent judgment and creative problem-solving techniques in a highly complex environment using technology and/or integrating diverse user systems
• 2 years of experience in developing UNIX scripts
• Knowledge in Data Modeling Logical, Physical, Star Schemas with Erwin
• System Testing, Regression Testing, and User Acceptance Testing and ensured that the code is legible. Other activities include archiving the test logs and publishing the User Acceptance test logs to the respective stake holders

TECHNICAL SKILLS:

PROJECT EXPERIENCE

Confidential

Role: Sr. Informatica/ETL Developer

Responsibilities:

• Worked with various stakeholders for the project including business analysts for requirement gathering, and translated the business requirements into technical specifications to build the Enterprise data warehouse
• Worked on Power Center 9.1 Designer client tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Extensively worked on Transformations like Lookup, SQL Joiner and Source Qualifier Transformations using Informatica Designer.
• Created mappings using Unconnected Lookup, newly changed dynamic Lookup Sorter, Aggregator, and Router transformations for populating target table in an effective approach for the application.
• Worked on performance tuning of the ETL processes. Optimized/tuned mappings for better performance and efficiency.
• Used Informatica debugger to test the data flow and fix the mappings
• Modified and develop ETL programs, indexes, data staging areas, transformations, summary tables based upon redesign activities.
• Loaded data to and from Flat files and databases like Oracle.
• Responsible for transportation of mappings, sessions, workflows, and maplets from one environment to other as needed.
• Developed UNIX Shell scripts to archive files after performing extraction and data load into Warehouse.
• Used Informatica Power exchange 9.1 for Change Data Capture CDC .
• Involved in Monitoring sessions using the workflow monitor, which were scheduled, running, completed or failed as well as Debugged mappings for failed sessions
• Defined Target Load Order Plan and to load data correctly into different Target Tables.
• Involved in Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.

Environment: Informatica Power Center 9.1, Power Exchange 9.1, Oracle 11g, SQL Plus, Toad, UNIX

Confidential

Role: Informatica Developer

Responsibilities:

• Involved in full Software Development Life Cycle SDLC - Business Requirements Analysis, preparation of Technical Design documents, Data Analysis, Logical and Physical database design, Coding, Testing, Implementing, and deploying to business users.
• Designed and developed ETL Mappings using Informatica to extract data from Mainframe DB2 tables, flat files and Oracle, and to load the data into the target database
• Developed ETL into data marts for data elements from staging.
• Defined Target Load Order Plan and Constraint based loading for loading data correctly into different Target Tables.
• Utilized SQL tools like TOAD to run SQL Queries to validate the data.
• Responsible for creating, updating and maintaining ETL technical documentation.
• Defining the schema, staging tables, foreign-key relationships, complex joins and checking proper normalization.
• Involved in gathering business requirements, logical modelling, physical database design, data sourcing and data transformation, data loading, SQL and performance tuning.
• Created, updated and maintained ETL technical documentation as required.
• Involved in Informatica PowerCenter Migrations, Repository Backup/Restores and Upgrades.
• Developed Informatica mappings to load the data mart and monitored them. The mappings involved the use of transformations like Router, aggregator, filter, Joiner, Union, Normalizer and Sequence generator
• Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Modified existing mappings for enhancements per new business requirements mappings to load into staging tables then to target tables in EDW.
• Created mapplets to use in different mappings

Environment: Informatica PowerCenter 7.1.3, Oracle10g, PL/SQL, UNIX Shell Scripting, SQL Plus, TOAD.

Confidential

Role: Informatica Developer

Responsibilities:

• Designed and deployed overall ETL strategy including CDC, SCD's, Partition Management, Materialized Views and other complex mapping logics.
• Involved in designing logical and physical database designing using ERWIN tool.
• Developed shared objects in Informatica for source/target/lookup transformations, developed complex mappings, sessions/workflows/worklets, database connections
• Assisted QA Team member in developing the test cases for the project and reviewed them
• Worked closely with the Requirements Manager and business Analysts on the requirements collection process.
• Designed the ETL process and scheduled the stage and mart loads for the data mart.
• Debugged and Troubleshooted Informatica Mappings.
• Entered metadata descriptions at both the transformation and port level in complex mappings
• Established Best Practices and plan for continuous improvement of processes

Environment: Informatica 8.5.1, Oracle 10g, Informatica Power Center 8.1.1, Teradata, Erwin 4.5, Oracle Applications, Flat files, PL/SQL, TOAD 9.0, SQL, UNIX, Quality Center 9.0