SUMMARY:

• Over seven years of IT experience with professional work experience in Data Warehouse/Data Mart design, System analysis, development, Database design, SQL.
• Extensive experience in Data Warehousing, ETL (Extraction, Transformation, Loading) using Informatica Power Center.
• Expertise in implementing complex Business rules by creating robust mappings, Mapplet, and reusable transformations using Informatica Power Center and Power Mart.
• Working Knowledge on different data sources as Flat Files, Oracle, SQL Server, XML and Excel.
• Experience with complex mappings using Filter, Aggregator, Expression, Router, Lookup, Update Strategy, Sequence generator, Rank.
• Experience in creating Sessions, Workflows, and Worklet by using the Workflow Manager tools like Task Developer, Worklet and Workflow Designer.
• Excellent in creating the map, assigning workflow, testing the flow and monitoring the job.
• Used Debugger to validate the mappings and gain troubleshooting information about data and error conditions
• Experience in optimizing query performance, session performance and fine tuning the mappings for optimum performance
• Experience with pre - session and post-session SQL commands to drop indexes on the target before session runs, and then recreate them when the session completes.
• Knowledge of full life cycle development for building a Data Warehouse.
• Excellent problem solving skills with a strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet tight deadlines and work under pressure

TECHNICAL SKILLS:

RDBMS: Oracle (SQL, PL/SQL, Stored Procedures, Functions), MS-Access, Teradata, SQL Server,DB2

Data Base Tools: Toad, SQL Navigator 4.0, SQL Loader

Data Modeling: Erwin

Reporting tools: IBM Cognos, Tableau and SAP Business Objects

Languages: SQL

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Informatica Developer

Responsibilities:

• Primarily responsible to convert business requirements into system design.
• Further implemented system model in Informatica, comprehensively using the functionality of the tool.
• Used ETL to standardize data from various sources and load into Data Stage area, which was in Oracle
• Worked on Informatica Power Center tool - Source Analyzer, Warehouse designer, Mapping and Mapplet Designer, Transformations, Informatica Repository Manager and Informatica Workflow Manager.
• Extensively used ETL, SSIS and SSRS to load data from wide range of source such as flat files, XML to Oracle
• Informatica Designer tools were used to design the source definition, target definition and transformations to build mappings.
• Designed and Developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (Fact/Summary) data identified by dimensions using Informatica Power Center tool.
• Created the mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Monitored Workflows and Sessions using Workflow Monitor
• Extensively worked in the performance tuning of programs, ETL procedures and processes.
• Precise Documentation was done for all mappings and workflows.
• Used Debugger in troubleshooting the existing mappings

Confidential, Plano, TX

ETL Developer

Responsibilities:

• Developed various Mappings and Transformations using Informatica Designer
• Involved in design, development and maintenance of database for Data warehouse project
• Designed procedures for getting the data from other systems to Data warehousing system.
• The data was standardized to store data from various Business Units in data warehouse tables.
• Designed the ETL processes using Informatica, SSRS and SSIS tools to load data from MS SQL Server, MS Access & Oracle into the target Oracle 9i database.
• Used Mapping designer and Mapplet to generate different mappings for different loads.
• Used Server Manager to schedule and monitor different sessions of loading.
• Used the PL/SQL procedures for data extraction, transformation and loading.
• Performance Tuning of sources, targets, mappings and SQL queries in transformations
• Created various transformations like Joiner, Aggregate, Expression, Filter, update Strategy.

Confidential, Northbrook, IL

ETL Developer

Responsibilities:

• Used ETL methodology for complete processing of Data Extraction, transformations and loading steps, in a corporate-wide-ETL Solution using Informatica.
• Used several transformations like source qualifier, expression, lookup, aggregator, Joiner, sequence generator, router and update strategy transformations for complex mappings.
• Used Debugger in troubleshooting the existing mappings.
• Tuned Informatica mappings for better performance using different techniques to provide maximum efficiency and complete performance.
• Developed Shell Scripts to run batch jobs.
• Developed sessions using Server Manager for loading the data into target database.
• Monitored Workflows and Sessions using Workflow Monitor.
• Designed and developed catalogs that reflected business view of the data to enable other developers to design cubes and reports
• Modified power cubes and power play reports as per the requirement.
• Carried out precise documentation of all mappings, workflows and reports.