SUMMARY:

• IT professional with 3+ yrs. of experience in ETL tools (Informatica, Cognos Data manager), SQL, PL/SQL, Oracle DB, Teradata, Tableau, UNIX.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Expertise in Data Warehouse/Data mart, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Designed and developed informatica mappings using various transformations like lookups, Router, Filter, Expression, Aggregator, Joiner and Update Strategy, mapplets and Reusable Transformations.
• Proficient in developing Slowly Changing Dimension mappings of type I, II in informatica.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Experience in understanding business/ process requirements and translating them to technical requirements.
• Knowledge in Full Life Cycle development of Data Warehousing.
• Exposure to Domains like Core Banking, financial and production.
• Excellent technical, logical, code debugging and problem solving capabilities and easy grasping of new things.
• Used R studio reporting tool to generate reports, graphical representation.
• Experience with coordinating and leading onsite-offshore development.
• Excellent communication, learning, problem solving and conceptual skills, ability to work effectively in a team environment.

TECHNICAL SKILLS:

Languages: C, C++, java, SQL, PL/SQL, Python

Databases: MS SQL Server 2008/2005, oracle 11g/10g, DB2 v8.1

Operating Systems: Windows XP/7, UNIX

ETL: Informatica 9.1.0/8.6, Cognos DM

Reporting Tools: R Programming, Tableau

Data Modeling: ER Studio

Web Technologies/ Tools: HTML, XML, Visual Studio

PROFESSIONAL EXPERIENCE:

Confidential

Senior Data Warehouse/ETL/Informatica Technical Lead

Responsibilities:

• Extensive interaction with customer on wide range of things ranging from requirements elicitation design reviews to code reviews.
• Working with business users and business analyst for requirements gathering and business analysis.
• Converted business requirement into high level and low level design.
• Designing and customizing data models for Data warehouse supporting data from multiple source and real time.
• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Designed ETL specification documents for all the projects.
• Created Tables, Keys (Unique and Primary) and Indexes in the SQL server.
• Understanding of relational and dimensional data modeling techniques
• Developed various builds using different transformations in Designer to load the data from source to targets.
• Extraction, transformation and loading were done in the project to create a new Data mart which is used further for generating reports.
• Created Various Fact Build and Dimension builds to load by using various transformations like
• Look Ups and Templates.
• Created various Workflows, Job Streams and sessions to ensure the data has sustained correctly.
• Unit testing of Builds developed in Development environment.
• Created detailed Unit Test Document with all possible Test cases/Scripts.
• Conducted code reviews developed by my team mates before moving the code into QA.
• Provided support to develop the entire warehouse architecture and plan the ETL process.
• Modified existing mappings for enhancements of new business requirements.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Involved in production support.
• Written SQL Scripts and PL/SQL Scripts to extract data from Database and for Testing Purposes.
• Supporting daily loads and work with business users to handle rejected data.
• Also used database to test the data while mapping from source to target and after loading in the target.
• Created DDL script for table creation and modification.

Environment: Informatica 9.6, Oracle 11g DB SQL, Cognos Data Manager, MS SQL server, Oracle SQL Developer 1.5.5

Confidential

ETL Informatica Developer

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements.
• Develop mappings/Reusable Objects/Transformations/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter 9.1.0 for loading the Enterprise Data Warehouse by transforming the data into business needs.
• Developed extraction, transformation and loading of data from CSV files, RDBMS tables, Flat Files into Teradata tables as per given requirements and specifications.
• Writing Stored Programs (Procedures & Functions) to do Data Transformations and integrate them with Informatica programs and existing applications.
• Coordinating between QA teams in completing System Testing & technical testing on time within the iterations along with business users.
• Participated in User Acceptance Testing along with business users and get the approvals
• Worked with the DBA's to promote the code between Dev, QA and Production environments.
• Co-ordinated with informatica admins & release coordinators moving the ETL components between Dev, QA, Production Environments
• Worked with production issues like bottlenecks, data validation and report errors while being ON CALL production support.

Environment: Informatica 9.1, Teradata V14, SQL, PL/SQL, MS Office Suites, Windows XP, UNIX, HP Quality Centre 9.5 ALM, Tableau, Control-M

Confidential

ETL Informatica Developer

Responsibilities:

• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Involved in Unit Testing and Resolution of various Bottlenecks came across.
• Implemented various Performance Tuning techniques.
• Involved various levels of testing (Unit, Functional and Integration) & Responsible for QA the end product for attaining the 100% quality.
• Involving in business meetings to gather requirements from different sources performing as a good team player.

Environment: Informatica 9.1.0, Teradata V14, SQL,PL/SQL, MS Office Suites, Windows XP, UNIX,HP Quality Centre 9.5 ALM, Control M