SUMMARY:

• Highly efficient and skilled, with proven IT experience in Various RDBMS, Data warehouse/Data marts, ETL, Reporting, Dimensional Data Modeling (Kimball Star/Snowflake methodologies) OLAP Tools and Client Server applications.
• Excellent communication skills, both written and verbal. Solution oriented, with strong attention to detail and the ability to analyze and problem solve.
• Dependable and consistent with regard to meeting deadlines and exceeding expectations.

AREAS OF EXPERTISE:

• Netezza
• Oracle 8i/9i/10g/11gMS SQL Server, SSISInformatica 6.1/7/8.6/9.1 SAS Data IntegratorCognos Data ManagerCognos 8 BI, SSRS, OBIEE 10gER Studio, ErwinOracle Data Modeler
• Data Integration/Reporting
• Data Modeling (Star/Snowflake)
• Data Analysis

PROFESSIONAL EXPERIENCE:

Confidential

Sr. ETL Developer (Informatica)

Responsibilities:

• Involved in review of analytics requirements and translating business requirements into technical considerations for Data Warehouse and Reporting.
• Used Informatica Power Center Source Analyzer, Target Designer, Mapping Designer and Transformation Developer, as well as Workflow Manager and Task Developer for extracting, transforming and loading to and from flat file, Netezza, Oracle and SQL databases.
• Created Informatica Mappings using various transformations, including Filters, Expressions, Lookups, Joiner, SQL, and Update Strategy to bring data from Source systems to Staging areas, then from Staging areas into Dimension and Fact tables.
• Used Informatica guidelines in implementing performance tuning techniques to decrease load times.
• Created Mappings, Sessions and Workflows designed to capture run, load, and error statistics to populate into a separate table.
• Created Mappings using Web Service calls to pull Solutions By Text data, as part of texting service for customers. Also created multiple re - usable Sessions in order to make use of existing Mapping logic selection criteria to ensure that all customers received the correct account and marketing messages.
• Frequently used Pre-/Post-Session Tasks, Email, Command, Event Wait and Decision Tasks, as well as Variables and Parameters on Unix server.
• Used Change Data Capture methods in implementing incremental logic, as well as Type1 and Type2 SCD to maintain history.
• Performed Unit Testing and made use of Debugger utility to ensure the integrity and quality of Target data.
• Frequently created and/or updated Technical Documentation related to various projects.
• Assisted with creation of Ad-hoc reports using Cognos 8 Query Studio, as needed or when the opportunity to help arose.

Confidential

Sr. ETL Developer (Informatica)

Responsibilities:

• Performed analysis of data in conjunction with SMEs in order to determine ETL requirements.
• Created Mappings for populating data into Dimension and Fact tables from the source systems.
• Created Mapplets and re-usable transformations for re-usable business sources.
• Utilized Command Task and Event-Wait functionality to ensure all Staging jobs complete before running Dimension and Fact loads.
• Scheduled Sessions and batches on the Informatica Server using Informatica Server Manager.
• Implemented tuning logic on targets, sources, Mappings and Sessions to provide maximum efficiency and performance.
• Performed unit testing to validate Reports and Mappings.
• Created Mappings and Mapplets using Filters, Aggregator, Lookups, Expression transformation, Sequence Generator, Sorter, Joiner and Update Strategy transformations.
• As QA Admin, used Repository Manager for deployment between DEV, QA, and UAT environments before ETL jobs finally moved to Production. Also created and managed appropriate Parameter files on Unix server.
• Developed custom Reports/Ad-hoc queries using OBIEE Answers and assigned them to application specific dashboards.
• Used Filters (global and local) and provided customized Prompts in OBIEE to avoid excessive data showing up in the Reports.
• Configured Intelligence Dashboards in OBIEE 10g by including embedded content such as links/images & HTML objects.
• Used Pivot Table and Chart views to enhance the presentation.
• Assisted with end-user training (both managers and business users) with excellent documentation support.

Confidential

Sr. ETL Developer (Informatica)

Responsibilities:

• Extensively used Informatica Power Center for extracting, transforming and loading from Oracle and non-Oracle databases.
• Worked on Informatica tool Source Analyzer, Mapping Designer, Transformation Developer and Workflow Manager.
• Created sessions with Pre- and Post-session Tasks for both Sources and Targets, including making use of Session Variables and Parameters when needed.
• Used Informatica performance enhancement techniques to decrease ETL load times.
• Extensively used almost all the transformations including Joiner, Filter, Router, Lookup and Sequence Generator.
• Developed Informatica Mapplets, Mappings, and re-usable transformations for load to Oracle Data Warehouse.
• Analyzed data coming from source to check for irregularities and to identify dirty data to apply suitable transformations in the Mappings for data cleansing, where needed.
• Involved in translating business requirements and the design of Mapping documents, as well as scheduling of Sessions and Workflows.
• Extensively used ETL to load data from disparate source systems such as Flat files into Staging table and Target database.

Confidential

ETL Developer (Informatica)

Responsibilities:

• Extensively worked with Power Center Designer, Workflow Manager and Workflow Monitor.
• Used Informatica Designer to create and manipulate Source and Target definitions, Mappings, and Mapplets, including re-usable and non-reusable transformations.
• Extracted data from Oracle, MS SQL Server and Flat files for loading into Oracle data warehouse.
• Used various transformations such as Source Qualifier, Joiner, Update Strategy, Aggregator and both Connected and Unconnected Lookup.
• Used Workflow Monitor; reviewed session logs if errors occurred.
• Implemented SCD methodology including Type1, Type2 and Type3 when needing to track history.
• Tuned mappings for optimal performance using Informatica Guidelines.
• Documented the number of source/target rows and analyzed rejected rows, reloading when necessary.
• Performed extensive Unit Testing to assure integrity and quality of ETL jobs.

Confidential

ETL Developer (Informatica)

Responsibilities:

• Participated in preparation of Source to Target Mapping documents for the ETL process.
• Worked with Data Quality analysts to identify data quality issues.
• Fine-turned mappings using Informatica guidelines for better performance.
• Identified bottlenecks and performed troubleshooting of long running sessions, making changes when needed.
• Loaded data from legacy systems, as well as both Relational and Flat file Sources, into both Relational and Flat file Targets.
• Responsible for implementing Incremental Load mappings using Mapping Variables and Parameter Files.

Confidential

ETL Developer (SSIS/Informatica)

Responsibilities:

• Involved in Analysis and Development of Warehouse Applications.
• Created and ran Sessions to load Target databases, while ensuring clean data loading into the Warehouse.
• Developed Mappings for Purchase Orders, Accounts Receivable and Accounts Payable Facts, as well as Dimension tables for Vendors, Products and Product Categories, etc.
• Used Expression, Filter, Lookup, Joiner, Sequence Generator, Stored Procedure, Update Strategy and Rank transformations, as required.
• Optimized Mappings, Sessions and Source and Target databases as part of performance tuning.
• Created SSIS ETL jobs and performance tuned them.
• Converted SSIS ETL jobs to Informatica Mappings.

Confidential

ETL Developer (Informatica)

Responsibilities:

• Participated in requirements gathering, design, development, coding, testing, debugging, and documentation of a corporate Data Warehouse schema.
• Worked with team to research and evaluate alternative solutions and make recommendations.
• Created Informatica Mappings to load Staging, Fact and Dimension tables.
• Created Informatica Workflows with Decision and Email Tasks.
• Created Sessions with Pre- and Post-session Tasks.
• Used performance tuning techniques to decrease load times.
• Developed file handling from FTP server.
• Created new tables and corrected data in Oracle Database as required.