SUMMARY

• 6+ years of experience in the development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Well - versed with ETL Informatica performance tuning process involving bottleneck identifications, analyzing thread statistics, optimizing components and using parallel partitions.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De-normalization Concepts.
• Involved in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, and SQL queries for extracting the data to system.
• Developed many complex mappings using various transformations i.e. Expression, Filter, Look-up, Joiner,
• Router, Aggregator, Stored Procedure, Normalizer, Transaction Control, Custom, HTTP, XML transformations etc.
• Possessing good knowledge in ETL Informatica Architecture about Nodes, Domain & Services. Also, working experience with Admin Console.
• Good knowledge of Teradata Architecture and proficient in creating various database objects Tables,
• Indexes, Views, Triggers, Macros, Stored Procedures etc.
• Hands-on experience with Teradata utilities such as BTEQ, Fast Export, Fast Load, Multi Load, TPT & T Pump.
• Proficient in writing efficient Unix Shell scripts. Developed various shell scripts to automate manual tasks & generate batch status reports.
• Imported the mappings developed in data quality (IDQ) to Informatica designer.
• Proficient in debugging and trouble-shooting of any technical and performance issues.
• Excellent written and verbal communication skills.
• Team player with good problem-solving and analytical skills. Enthusiastic to learn new tools and technologies.
• Ability to multi-task and lead a team in a fast-paced environment.

TECHNICAL SKILLS

ETL: Informatica Power Center 9.x

Software/ Applications: MS XP, MS Word, MS Excel, MS Access, Outlook, PowerPoint

Databases: SQL Server, Oracle 11g/10g

MS Suite and Tools: MS Vision, MS Word, MS Project, MS Excel, MS Outlook, MS Publisher and TOAD, Visio, Eclipse

Reporting Tools: Business Objects XI R2, Tableau 8/9/10, SSRS

Data Modelling Tools: ERwin 7.x

Programming GUI: C, C++, HTML, Unix

Operating System: Windows, Linux

Web/ Apps servers: IBM Web Sphere 4x, Sun iPlanet Server, IIS, Tomcat

PROFESSIONAL EXPERIENCE

Confidential, Birmingham, AL

ETL / Informatica Developer

Responsibilities:

• Used Informatica Power Center v9.6 for extraction, transformation and load (ETL) of data in the data warehouse.
• Productively used Informatica tools - Informatica Repository Manager, Informatica Power Center Designer, Informatica Workflow Manager and Informatica Workflow Monitor.
• Using the concept of Slowly Changing Dimensions, complex mappings were created. Involved implementation of Business logic and capturing the deleted rows in the source origination.
• Worked extensively with the connected lookup transformations with the dynamic cache enabled.
• Developed several reusable transformations and Mapplets, which were used in other mappings.
• Created sessions and extracted data from various sources.
• Transformed the data according to the requirement and loading into the data warehouse.
• Involved in creating various mappings in the Informatica power center designer.
• Used Informatica Power Center for extractions, transformation, and loading data from heterogeneous sources into the target databases.
• Worked extensively on different complex mappings using transformations like Source qualifier, expression, Router, filter, update strategy, Connected and Un-connected lookup, Normalizer, joiner, Aggregator, Update strategy.
• Extracted Data from different Source Systems like Oracle, Teradata and Flat files.
• Experienced in optimizing the SQL queries to improve the performance.
• Experience on Data Analysis for source and target systems and good understanding of Data Warehousing concepts, Dimensions, Facts and Star, Snowflake Schemas and ER modeling.
• Responsible for Unit testing, System and Integration testing.
• Extensively Used debugger in identifying bugs in existing mappings by analyzing data
• Identified and fixed performance bottlenecks and tuned the Informatica mappings for better Performance.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshootingexisting ETL bugs.
• Analyzed Session log files to resolve error in mapping and identified bottlenecks and tuned them for optimalperformance.

Environment: Informatica Power 9.6 (Workflow Manager, Workflow Monitor, Mapplets), Oracle, Teradata, SQL.

Confidential, RI

ETL / Informatica Developer

Responsibilities:

• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command,
• Involved in gathering and reviewing business requirements. Involved in designing the specifications, Design, Documents, Data modeling and design of data warehouse.
• Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
• Created the repository manager, users, user groups and their access profiles.
• Created connected and unconnected Lookup transformations to look up the data from the source and target tables.
• Demonstrated expertise utilizing ETL tools, including Informatica and ETL package design, and RDBMS systems like SQL Server, Oracle.
• Involved in Data Quality, Profiling, Validations, reference check and exception handling using Informatica Data Quality.
• Extensively performed Data Masking for preserving the referential integrity of the user data.
• Involved in the development of Informatica mappings and also performed tuning for better performance.
• Extensively worked on tuning (Both Database and Informatica side) and thereby improving the load time.
• Developed ETL's for Data Extraction, Data Mapping and data Conversion using SQL, PL/SQL and various ETL scripts.
• Automated the entire processes using UNIX shell scripts.

Environment: Informatica Power 9.6, ETL, SQL, RDBMS, PL/SQL, UNIX

Confidential

ETL / Informatica Developer

Responsibilities:

• Designed and developed Informatica Mappings to load data from different Source systems to Data Warehouse.
• Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for capturing delta loads and Populated Slowly Changing Dimensions using Informatica.
• Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different Mappings.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Worked with session logs, Informatica Debugger, and Performance logs for error handling.

Environment: Informatica Power Center 9.1 (Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager), PL/SQL, SQL Server, Unix.

Confidential

ETL / Informatica Developer

Responsibilities:

• Worked with business analysts, developers, and management professionals from various locations to gather requirements.
• Translated business requirements into technical specifications to build the Data Warehouse.
• Developed mappings in using informatica and oracle data integrator that catered to the Extraction, Transformation, and Loading from various source systems to target systems.
• Used Informatica tool to handle complex Mappings and extensively used the various Transformations like Source Qualifier, Aggregators, Lookups, Filters, Update Strategy, Expression, Sequence generator and Sorter etc.
• Created numerous Interfaces to load data from Flat files, CSV files and Oracle tables into staging tables and then into respective FACT/DIMENSION/Look-up Tables in Data Warehouse.
• Loaded data from different source systems to target warehouse using interfaces with Knowledge modules like LKM, IKM and CKM for data quality check.
• Used ODI in-built scheduler to schedule Scenarios/Load Plan's in production.
• Participated in all phases of project development, testing, deployment and support.
• Developed, implemented and enforced ETL best practices standards.

Environment: Informatica power center 8.6. Oracle Data Integrator 10g, oracle 10g, SQL server, TOAD, SQL Developer, UNIX