CAREER OBJECTIVE:
To convert every opportunity into in the area of Application Development and Support.
SUMMARY:
- An IT professional with 4.3 years of experience in IT industry in Informatica and Data Warehousing.
- Currently working as an ETL Developer as Technology Analyst for BP Project in Confidential
- Strong Knowledge of Informatica, Data Warehouse Concepts
- Worked on Informatica Power Center tool for data conversion from variety of source systems.
- Dealt with various transformation logic like Lookup, Aggregator, Joiner, Source Qualifier, Router, Expression, Update Strategy, Filter and more while designing and developing complex mappings and mapplets.
- Knowledge & Hands on experience on Unix, writing SQL queries.
- Excellent analytical skills in understanding the client Organizational Structure
- Knowledge of working with tool like Toad.
- Excellent communication and interpersonal skills.
TECHNICAL SKILLS:
DATAWARE HOUSING TOOLS: INFORMATICA
LANGUAGES: SQL, PL/SQL, SQL Server, NET, J2EE
DATABASE: Oracle 9i, Visual Basic.
OPERATING SYSTEMS: UNIX, Windows XP/ 2000/2003/2007.
TOOLS: INFORMATICA, TOAD, APPWORX, PVCS, TIDAL
SOFT SKILLS AND STRENGTH:
- Quick learner with good analytical and problem solving skills, motivated to success with the desire to tackle challenging problems.
- An energetic and focused team player
- Strong interpersonal and communication skills with ability to maintain effective working relationships.
- A result - oriented person.
PROFESSIONAL EXPERIENCE:
Confidential
ETL Developer
Responsibilities:
- Designing the mapping Once requirements are given
- Creating QA (Question) log w.r.t requirement
- Understanding the Requirement
- Developing the mapping,session,Worklow(ETL Data Flow)
- Performing the Unit Testing
- Creating Design Document
- Executing the Workflows
- Unit Test case preparation, Coding and Unit Testing.
- Involved in Preparing and maintaining process documents (Code Review, Test Cases, Migration Document and Design Document).
- Involved in Code Migration
- Quality check for code and Test Results.
Confidential
ETL Developer
Responsibilities:
- Designing the mapping
- Developed Jobs through Tidal for Scheduling
- Developed Unix Scripts
- Extraction order, Source to Target Mapping.
- ETL Process flow and dependencies.
- Unit Test case preparation, Coding and Unit Testing.
- Involved in Preparing and maintaining process documents (Code Review, Test Cases, Migration Document and Design Document).
- Quality check for code and Test Results.
Confidential
ETL Developer
Responsibilities:
- Designing the mapping
- Developed Appworx Chains and modules
- Developed Unix Scripts
- Extraction order, Source to Target Mapping.
- ETL Process flow and dependencies.
- Unit Test case preparation, Coding and Unit Testing.
- Technical and data flow Documentation for the above listed applications and Manage & Perform Work Product Review for each deliverable from Offshore.
- Involved in Preparing and maintaining process documents (Code Review, Test Cases, Migration Document and Design Document).
- Quality check for code and Test Results.
- Suggesting best practices to ETL developers to improve performance of the code.
- Deployment of new releases on live.
