OBJECTIVE

• Continue working on Data Warehouse & Hadoop initiatives along with the innovation opportunities.
• Looking for a job opportunity that supports me to apply my skills and allow me to learn from this field in a business oriented organization.
• I have solid experience in building data warehousing designs and good knowledge to employ correct technical skills for successful completion of projects.

SUMMARY

• Over 12 years of experience in IT of which for past 10 years in Data Warehousing, BI implementation and support projects as Technical Lead, Designer and Developer with Primary focus on ETL designing, development, support with the tool Informatica Power center, Oracle & Teradata, Data Stage and Data Modeling.
• Extensive experience with Informatica power center, Oracle SQL, PL/SQL, Unix in implementing DW solutions for various business scenarios.
• Expert knowledge in working with Informatica Power Center 9.x/8.x/7.x (Designer, Repository manager, Repository Server Administrator console, Server Manager, Work flow manager, workflow monitor).
• Informatica Certified Developer for informatica powercenter 8.x.
• Hadoop and Big data Certified from Edvancer Eduventure with good understanding on various Hadoop components like Map reduce, Pig Latin, Hive, Hbase, Zoo Keeper, Sqoop, Flume etc.
• Have worked more than 9 Years at different Client locations in UK, Canada, USA across various business domains (Insurance, Health care, Media, Finance).
• Good knowledge of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De normalization.
• Experience in integration of various data sources with Relational Databases like Oracle, Teradata and Worked on integrating data from flat files.
• Extensive experience in using various Informatica Designer components like Source Analyzer, Mapping Designer, Transformation Developer, Mapplet Designer, Schedulers.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator, Normalizer, Union, and XML Source Qualifier.
• Proficient in ETL (Extract - Transform - Load) using Oracle andInformatica Power Center and experience on datastage and teradata tool.
• Extensive experience in error handling and problem fixing in Informatica.
• Designed complex Mappings and expertise in Performance Tuning.
• Experience in troubleshooting by tuning mappings, identify and resolve performance bottlenecks in various levels like source, target, mappings, and session.
• Involved in Implementing Slowly Changing Dimensions, Star Schema modeling, Snowflake modeling, FACT tables, and Dimension tables.
• Experience in Oracle9i/10g/11g, Teradata etc.
• Experience in SQL and PL/SQL to write Stored Procedures, Functions, and Packages based on project requirement.
• Excellent overall software Development life cycle (SDLC) experience, Conceptual and Logical Thinking, Goal oriented, self-motivated and able to work independently and as a member of a team.
• Excellent communication, analytical and interpersonal skills.
• Quick learner and adaptive to new and challenging technological environments.

TECHNICAL SKILLS

ETL Tools: Power Center 9.x/8.x/7.x, Data Stage 9.1

Databases: Oracle 11g/10g/9i, Teradata.

Reporting Tools: Business Objects, Tableau.

Data Modeling: Erwin 9.x.

Scheduling Tools: Crontab, Tidal

Languages: SQL, PL/SQL,VB,UNIX.

Development Tools: PL/SQL, SQL, Toad 8.x/9.x/10.x.

Operating Systems: UNIX (putty), Windows 2000/XP/2003.

Office Applications: MS-Office 2000/2003/2007, Visio.

Other Utilities: Teradata SQL Assistant, Service Now, CA Unicenter.

PROFESSIONAL EXPERIENCE

Confidential

ETL / Informatica Architect

Responsibilities:

• Working withbusiness analysts to identify, study and understandrequirements and translated them into ETL code in Requirement Analysis phase.
• Write detailed description of user needs, program function and steps required to develop interface for Kaizen Audit strategy.
• Designing for sales force data growth and performance management.
• Identifying repetitive data issues form sales force system and taking part of integration design as part of Kaizen data quality initiative.
• Experience in Informatica providing Data warehouse solutions using PowerCenter and data modeling with ERWIN tool.
• Providing Effort Estimation for new opportunities.
• Creating High Level Design and Detailed Designin the Design phase.
• Closely working with the production support team and data team to recover from issues and various defects that encounter while running the jobs and analyzing the data.
• Prepared release notes, Impact Analysis, Cut-Over Plan, Development & Production move checklist and code review reports for support central team for detailed code migrations.
• Involved in complete release management for UNIX, DB & ETL Migration of Application to Production Environment.
• Review of ETL code during Prodcution Migration to ensure TFS best practice is being followed.
• Tuned mappings using Power Center-Designer and used different logic to provide maximum efficiency and performance.
• Worked onPerformance Tuning,identifyingandresolving performance Bottlenecksin various levels like sources, targets, mappings and sessions.
• Involved inUnit testing, System testingto check whether the data loads into targets are accurate.
• Experience in support and knowledge transfer to the production team.
• Proficient in interaction with the business users by conducting meetings with the clients in Requirements Analysis phase.
• Extensive functional and technical exposure. Experience working on high-visibility projects.

Environment: Informatica 9x, Oracle 11g, Erwin, Sales force

Confidential

ETL / Informatica Techinical Lead

Responsibilities:

• Involved in different Enhancements Rentrak Digital integration, EU P&L Optimization, Market Insight Mitigation, Rentrak Rental External feed implementation, Cinema Score.
• Involved in requirement analysis, ETL design and development for extracting data from the heterogeneous source systems like Oracle, flat files, XML files and loading into Staging and Enterprise Data Warehouse.
• Responsible for converting Functional Requirements into Technical Specifications.
• Involved in data profiling for various External feeds during ETL integration.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Involved in using Erwin for physical and logical data modeling.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Ensuring compliance to project/client SLA, processes and guidelines.
• Support and Enhance to various data load/ETL scripts and interfaces in Horizon.
• Analysis on Existing System and Preparing High Level and Low Level Design.
• Planning, managing and controlling Project effort.
• Task prioritization and work distribution within the Team.
• Preparing and Managing Project schedule.
• Presenting weekly scorecard report to client management.

Environment: Data Stage 9.1, Teradata 14.0, SQL Server, Quality Center.

Confidential

Informatica Developer

Responsibilities:

• Involved on various Enhancements such as HR ETL Migration, FINDM Rollover Automation, CDS development, OEPG Optimization etc.
• Worked with the application users to understand their requirements, analyzing the requirement, documenting and getting sign off for the development team to start with the development effort.
• Worked with power center tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Designed Logical and Physical Modeling using Erwin Data Modeler tool.
• Analyzed the raw data from alliance partners, architecture and integration ETL design tool process data at different data warehouse layer.
• Standard Error trapping and reconciliation framework across interfaces.
• Involved in data modeling and design of data warehouse in star schema methodology with confirmed granular dimensions and Fact tables.
• Coordinate production change requests and production releases.
• Troubleshooting load failure issues and data quality issues on a day to day basis.
• Maintain the daily ETL schedule and recover the daily failures and generate the daily reports for users.
• Used Informatica Debugger to troubleshoot data and error conditions.
• Maintain documents for all the Development work done and error fixings performed.
• Analysis On Existing System and Preparing High Level and Low Level Design
• Batch Support and failure Resolution of Existing Systems
• Worked on Monthly, Quarterly and Yearly close process which was critical for finance close as per the deadline.
• Worked for data growth management and archival strategy.
• Performance Tuning,identifyingandresolving performance Bottlenecksin various levels like sources, targets, mappings and sessions to ensure the jobs are completing with in the SLA time.
• Responsible for determining the bottlenecks with Informatica Server and fixing the issues by cleaning the Informatica repository logs on timely basis.
• Regular Maintainace of Informatica Environment to avoid performance issues.
• Involved in developing reports using Business Objects.
• Used tools like TOAD and SQL navigator to run the queries and validate the data loaded into Marts and different other layers like Data Warehouse and Persistent Staging.

Environment: Informatica Power Center 9.1, oracle 11g, TOAD, UNIX, Windows XP Professional,CA Unicenter.

Confidential

ETL Developer / Onsite Co Coordinator

Responsibilities:

• Coordinated with Business Users for requirement gathering, business analysis to understand the business requirement and to prepare Interface Functional Specification and Interface Design Document to code ETL Mappings for new requirement changes.
• Extracted data from various heterogeneous sources like Oracle, DB2, MS Access Flat files.
• Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Involved in data cleansing operations prior to loading the data into staging from flat files.
• Responsible for support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 8.5.
• Involved in promoting the folders from Development Environment to Test Environment and from Test Environment to Production Environment.
• Used Informatica Power Center 8.5 for Extraction, Transformation and Loading data from source systems into the target data base.
• Involved in Batch support, Failure Resolution, Defect Analysis and Resolution.
• Involved in performance and tuning of the ETL processes .
• Developed PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.

Environment: Informatica 8.5, oracle 9i, Oracle, Star Team, Siebel 7.7, Siebel Analytics,Windows NT.

Confidential

ETL Informatica Developer

Responsibilities:

• Coordinated with Business Users for requirement gathering, business analysis to understand the business requirement and to prepare Technical Specification documents (TSD) to code ETL Mappings for new requirement changes.
• Involved in Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Involved in data cleansing prior to data staging from flat files.
• Implemented slowly changing dimensions Type 2.
• Set up batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Worked on test director to log user requests and track it..
• Estimation, Requirement Analysis and Design of mapping document and Planning for Informatica ETL.
• Designed and developed ETL process using Informatica tool of Enhancement requests.
• Used Informatica Power Center 7.1 for Extraction, Transformation and Loading data from heterogeneous source systems into the target data base.
• Analysis of Source, Requirement, existing OLTP system and Identification of required dimensions and facts from the Database.
• Supported Existing ETL components, Batch support for the nightly Jobs and ensuring completion of the job as per the agreed SLA timeline..
• Involved in performance and tuning of the ETL processes.
• ImplementedOracleDataIntegratorand architected the ODI interface.
• Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
• Configured and scheduled Pre and Post Session commands with Shell Scripts.

Environment: Informatica Power Center 7.1, Oracle 9i, Teradata, UNIX, Windows XP Professional, PVCS,Test Director, Business Object 6.1

Confidential

Informatica Developer

Responsibilities:

• Coordinated with the onsite team and gathering the user requirements.
• Created Technical design specification documents based on the functional design documents and the physical data model.
• Developed Informatica Mappings and Reusable Transformations for Daily, Weekly and Monthly Loading of Data.
• Worked on developing mappings and mapplets to extract and load the data from Oracle, Flat files.
• Created tasks like Session, Decision, Email, Command, Event Wait, Event Raise and Control tasks in preparing the Workflow..
• Handled creation, modification and documentation of Packages, Procedures, Functions and Indexes.
• Preparation of Test Data/Unit Testing /Integrated testing and generated various test cases.
• Maintained warehouse metadata, naming standards and data warehouse standards for future application development
• Involved in different Team review meetings, prepared project documentation, Program Specifications, Test Cases and Participated in the complete SDLC.

Environment: Informatica Power Center 7.1, Oracle 9i, Unix Shell Scripting(putty).

Confidential, Georgia

Informatica Developer

Responsibilities:

• Most of the transformations used were source qualifier, Aggregators, Connected & unconnected lookups, Filters & Sequence generators.
• Developed mappings using corresponding Source, Targets and Transformations, which were optimized for maximum performance.
• Written SQL overrides in source Qualifier according to business requirements
• Designed Sequential Workflow using Workflow Manager, Workflow Monitor for whole process.
• Created sessions and workflows for designed mappings.
• Involved in testing by preparing test cases and unit testing.
• Resolving Incidents, requests and change requests

Environment: Informatica Power Center 7.1, Quest Toad for Oracle, Oracle 9i, UNIX, Windows.