PROFILE SUMMARY:

• Around 7 years of experience of Technical experience in IT Industry, involving in implementation of the Decision Support Systems (DSS) and having Domain knowledge on Manufacturing.
• Good Experience in analyzing the data in source systems, define underlying data sources and preparing design documents
• Good Experience in preparing the ETL Design documents
• Good Experience in preparing the Mapping, Data sharing, Interface design documents
• 6+ Years Experience in Extraction/Transformation/Loading of the legacy data to Data Warehouse using Informatica PowerCenter 9.5.1/8.6
• 4+ Years Experience in Tidal Scheduling Tool.
• Proficient with Development techniques in both Informatica.
• Good experience in ETL Testing
• Experienced in developing mappings, sessions and workflows using Informatica PowerCenter 9.5.1/8.6
• Experienced in developing Tidal jobs and sequences using various stages and activities
• Good experience in coding Unix Shell scripts
• Good knowledge on Performance Tuning of Informatica workflows
• Experience on Enhancement and support Environment
• Good Knowledge on DWH Concepts
• Excellent inter - personal & communication skills.
• Involved in providing application knowledge transfer to new team members.
• Ability to handle multiple tasks and work independently as well as with team.
• Experience in handling issues, coordination production releases.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
• Comprehensive technical, oral, written and communicational skills

TECHNICAL SKILLS:

ETL Tools: Informatica (9.5.1/8.6)

BIGDATA ECOSYSTEM: Hadoop

OLAP Tools: Business Objects XIR2

Scheduling Tools: Tidal

Database: SQL, MySQL

Operating Systems: All versions of Microsoft Windows, UNIX

PROFILE SUMMARY:

Confidential

Informatica Developer and ETL Tester

• Involved in analyzing the source systems and preparing Analysis Design Documents.
• Performed CDC capture registrations
• Assisted in building the ETL source to Target specification documents by understanding the business requirements.
• Involved in Migrating the data from legacy Systems (consolidation four DB’s) to New System.
• Involved in preparing the ETL Design documents
• Involved in preparing the Mapping design documents
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Transformations, Informatica Repository Manager
• Involved in developing the mappings by using various transformations like SOURCEQUALIFIER,SORTER,AGGREGATOR,ROUTER,FILTER,LOOKUP,EXPRESSION,STORED PROCEDURE,SQL Transformation etc
• Reusable transformations and Mapplets are built wherever redundancy is needed
• Performance tuning is performed at the Mapping level as well as the Database level to increase the data throughput.
• Involved in developing re-usable components like re-usable transformations, mapplets.
• Developed workflows by using various tasks like command task,session,decision task and e-mail task
• Involved in preparing the Unit Test Cases for various mappings and workflows
• Involved in providing the technical and user documentation while moving the objects into test and production Environments
• Involved in effectively communicating with various stakeholders for gathering Business Requirements
• Involved in Integration, System Testing.
• Generated process flow designs
• Drafted standard operation procedures
• Developed and implemented strategies for the handling of errors by the ETL team
• Mentored DBAs and developers in the application of database standards and practices
• Monitoring of production inquiries and issues to ensure efficient resolution

Confidential

Informatica Developer and ETL Tester

• Extensively worked with Business analysts to understand the requirements like what calculations they want to view on Report.
• Analyzed and quantified the impact of projects on upstream / downstream systems.
• Developed Mappings using Transformations like Expression, Filter, Joiner and Lookups for better data messaging and to migrate clean and consistent data
• Developed mappings/sessions using Informatica Power Center 9.5.1 for data loading
• Created unit test cases to test data loads and check whether the components adhere to the technical design.
• Involved in the production support, watch the workflow monitor carefully to see all workflows and all Tasks are running properly and data is loading in the proper way and to the right targets and at the right time.
• Worked as Database Administer for this project for creating the Physical Model and Tables in Database from Logical using Erwin..
• Developed the Control Features for ETL’s
• Involved in MTP and MTI activites
• Created Shell script running workflows in UNIX environment.
• Communicated with business customers to discuss the issues and requirements.

Confidential

BO Developer and Tester

Responsibilities:

• Involved in generating the reports for the given Business Requirements.
• Involved in Developing the SSIS Packages.
• Involved in Preparing the Support Documents for the Production.
• Involved in setting up the schedules for various Business Objects Reports.
• Experienced in Developing various Charts, Graphs and drill down reports.
• Experienced in creating reports using Web Intelligence, schedule the reports as per the business needs and supporting.
• Experienced in creating Universes, resolving Loops, Traps and Testing the Universe.