SUMMARY

• Over 9 years of IT experience in the field of ETL Development & Designing, Datawarehouse Development, Data Modeling, Business/Data analysis, Business Intelligence and development of application software in Web - Based environment, distributed n-tier and Client/Server environments.
• 9+ years of ETL and data integration experience in designing and developing ETL mappings/workflows and scripts using Informatica PowerCenter 9.x/8.x
• 9+ years of experience in design and development of ETL process from databases such as Oracle, Teradata, SQL Server,DB2, Sybase, XML and Flat files sources.
• 9+ years of Strong proficiency in writing SQL (including Teradata, ORACLE, SQL Server,DB2).
• 2+ years of experience in BIAPPS technical projects.
• 7+ years of extensive experience on Data Warehousing concepts like Star Schema, Snow Flake, Dimension and Fact tables and Slowly Changing Dimensions.
• Experience in implementing projects in Agile/Scrum.
• Experience on Informatica Data Quality 9x for data profiling, data enrichment and standardization.
• Captured the DQ metrics using the Profiles and Created scorecards to review data quality using IDQ.
• Extensive hands-on expertise in database programming languages like PL/SQL, BTEQ, tuning complex SQL queries and optimizing ETL Jobs.
• Extensive experience with ETL tool Informatica in Designing the Workflows, Worklets, Tasks and Mappings, scheduling and monitoring the Workflows and sessions using Informatica PowerCenter 10x, 9.x/8.x
• Experience in optimizing and performance tuning of Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets and Tasks.
• Designer, automated batch jobs through enterprise scheduling tools like Workload Manager.
• Good customer facing skills, involved in functional &non-functional requirements gathering from business users, analysts and support teams, designed and implemented ETL solutions.
• Documented Business &Technical requirements, Technical Design, Test plans, Implementation plans, Project turnover
• Has good experience in Oracle, Teradata and worked with different data sources like Flat files and databases.
• Has Good knowledge on Teradata Utilities like BTEQ, Fast load, and Multi load.
• Worked extensively on SQL using Joins, Indexes, Set Operators and advanced OLAP functions.
• Good understanding of Teradata Data Warehouse Architecture and Protection concepts like Fallback, Journals, RAIDs etc.
• Created & worked with Derived, Volatile and Global temporary tables
• Expertise in Technical Analysis, Design Document and Test Plan preparation
• Involved in the preparation of implementation plan for the project roll-out.
• Implemented large-scale release and enhancement projects.
• Providing post-Implementation support till the end of warranty period.
• Developed test strategies and plans for Unit, Integration, System and User Acceptance Testing.
• Developed ETL migration documents and operation manuals for migrating in various environments
• Extensive Knowledge of RDBMS concepts, SQL and PL/SQL
• Good Knowledge on APPWORX, Autosys tools for scheduling the jobs.
• Familiar with building end to end solution, onshore-offshore model and multi site development projects, System Integration, migration, maintenance and Support projects
• Team player and self-starter with good communication and inter-personal skills.

TECHNICAL SKILLS

Data Warehousing: Informatica PowerCenter 9.x/8.x (Source Analyzer, IDQ 9.6, Data Warehouse Designer, Mapping Designer, Mapplet, Transformations, Workflow Manager, Workflow Monitor, Worklets), Data cleansing, OLAP, Star Schema, Snowflake Schema, OLTP, SQL*Loader

Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Slowly Changing Dimensions, Master Data Management.

Front-end tools: TOAD 7.x, SQL Server Management studio

Databases: Teradata, Oracle 10i/9i, SQL Server 2005, DB2, Sybase

BI & Reporting Tools: Cognos

GUI: MS Excel, MS Word, Visio.

Programming: SQL, PL/SQL, UNIX Shell Scripting.

Environment: Windows 7/XP, Windows server 2008/2003, Linux

PROFESSIONAL EXPERIENCE

Confidential

Sr. Developer

Responsibilities:

• Designed and Developed Informatica Mappings from Scratch to Load the Data from various SORs to Staging system and Warehouse System.
• Customized out of box ETL mappings and developed new mappings to load the data from various source systems
• Applied slowly changing dimensions like Type 1 and 2 TEMPeffectively to handle the delta Loads.
• Prepared various mappings to load the data into different stages like Landing, Staging and Target tables
• Performance tuning of SQL queries in SQL overrides for better performance.
• Responsible for mapping migration, importing and exporting maps from different servers.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Created Custom ETL to pull data from Oracle, Sybase, SQL Server, Flat files
• Prepared SQL Queries to validate the data in both source and target databases.
• Created Test cases for the mappings developed and tan created integration Testing Document.
• Prepared the error handling document to maintain the error handling process.
• Scheduled Informatica jobs using APPWORX
• Experience in development of mappings in IDQ to load the cleansed data into the target table using various IDQ transformations, experience in data profiling
• Performed in creating tasks in the workflow manager and exported IDQ mappings and executed them.
• Worked on IDQ parsing, IDQ Standardization and matching
• Imported the mappings developed in data quality (IDQ) to Informatica designer.
• Closely worked with the reporting team to ensure that correct data is presented in the reports.

Sr. Developer

Responsibilities:

• Estimation, design, coding and implementation of smaller enhancements, production bug fixes, production control.
• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle and Delimited Flat files.
• Development of ETL using Informatica 9x
• Performance improvement of ETL processes by tuning and partitioning SQL queries.
• Performance improvement of ETL processes joining smaller heterogeneous sources with huge Teradata DWH tables by dynamic SQLs using SQL Transformation
• Performance improvement of change data captures (CDC) and bulk load ETL jobs to Teradata using BTEQ, MLOAD & Fast Load utilities.
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ
• Performed data profiling to understand the data pattern using Informatica IDQ.
• Coordination with Business & IT partners for requirements, schedules and project execution.
• Coordination with offshore development team for design, coding and testing.
• Preparing test scripts for system, integration, performance, and load testing.
• Executing test cases and setting up test environments for System Integration and User Acceptance Testing.
• Coordinating change releases like upgrades, patch, and implementation for hardware and software including but not limited to Informatica environments.
• Review and approvals for Informatica designs and project turnovers.
• Coordinating with internal / external clients and other support groups like FTP, DBA, Operations etc… for maintenance activities.
• Escalating issues based on severity, monthly SLA and Weekly Project Status Reports

Confidential

Sr. Developer

Responsibilities:

• Designed and Developed Informatica Mappings from Scratch to Load the Data from various SORs to Staging system and Warehouse System.
• Customized out of box ETL mappings and developed new mappings to load the data from various source systems
• Applied slowly changing dimensions like Type 1 and 2 TEMPeffectively to handle the delta Loads.
• Prepared various mappings to load the data into different stages like Landing, Staging and Target tables
• Performance tuning of SQL queries in SQL overrides for better performance.
• Responsible for mapping migration, importing and exporting maps from different servers.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Created Custom ETL to pull data from Oracle, Sybase, SQL Server, Flat files
• Prepared SQL Queries to validate the data in both source and target databases.
• Created Test cases for the mappings developed and tan created integration Testing Document.
• Prepared the error handling document to maintain the error handling process.
• Scheduled Informatica jobs using APPWORX
• Closely worked with the reporting team to ensure that correct data is presented in the reports.

Confidential

ETL Developer

Responsibilities:

• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle and Delimited Flat files.
• Development of ETL using Informatica 8.6.
• Applied slowly changing dimensions like Type 1 and 2 TEMPeffectively to handle the delta Loads.
• Prepared various mappings to load the data into different stages like Landing, Staging and Target tables.
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing the Mapping.
• Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Prepared SQL Queries to validate the data in both source and target databases.
• Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages in Oracle.
• Worked extensively on PL/SQL as part of the process to develop several scripts to handle different scenarios.
• Created Test cases for the mappings developed and tan created integration Testing Document.
• Prepared the error handling document to maintain the error handling process.
• Automated the Informatica jobs using UNIX shell scripting.
• Closely worked with the reporting team to ensure that correct data is presented in the reports.
• Involved in Coordinating with onsite and offshore team members.