Developer L2, Resume,

OBJECTIVE:

To possess a rewarding career in a progressive Organization wif an environment, where in my initiative for professional and personal development will contribute to achieve teh goals of teh organization.

SUMMARY

Having 5years project exposure in design and development of Extraction Transformation Loading (ETL) methodology for supporting data transformations and processing in a corporate wide ETL Solutions using Informatica Power Center 8.x & 9.x
Extensively worked on Source Analyzer, Warehouse Designer, Mapping Designer and Mapplet Designer to Extract Sources, Transform Data and load into Target. Used Informatica Workflow manager to create Workflows and Sessions.
Complete Data warehouse project life cycle experience on Design, Development, Testing, Deployment and Maintenance.
Experience in developing and implementing ETL processes using Informatica to move data from sources into target.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 8.x & 9.xAutomation Tool: Autosys,AppworxDatabase: Oracle, MySQLLanguages: PHP, JAVASCRIPTOperating System: Windows - 7, Windows-XP, UNIX(AIX 5.3)PROFESSIONAL EXPERIENCE

Developer L2

Confidential

Responsibilities:

Participated in various phases of project including requirements gathering and analysis, Design, Development and Unit testing
Creating new source& target definitions/Modifying existing definitions based on teh need. Teh source/target will be file or a table which will be used in teh mapping to load teh required target file/table based on teh business requirements.
Designed teh ETL process using Informatica tool to load from flat files and oracle source into teh target oracle database and SAP HANA database.
Creating new mapping according to teh business needs, doing some modifications in teh present existing code, performing unit testing and preparing test results based on teh business scenarios.
Creating new workflow/modifying teh existing workflows according to teh Business. Performing Unit testing and preparing test results for teh same.
Created mappings using teh transformations such as teh Source qualifier, Aggregator, Expression, Router, Filter, Rank, Sequence Generator, and Update Strategy.
Analyzed Mappings and Sessions for better performance.
Checked and tuned teh performance of Informatica Mappings.

Skill Name: ETL-Informatica Power Center 9.6.1, Oracle,SQL Developer,SAP HANA,Unix.

Developer L2

Confidential

Responsibilities:

Involved in development and unit testing
Supported teh SIT testing team and fixed teh defects on time
Provided support for UAT load and testing
Provided support for teh production implementation and run

Skill Name: Informatica 9.6.0, Oracle, Teradata..

Developer L2

Confidential

Responsibilities:

Involved in development and unit testing
Supported teh SIT testing team and fixed teh defects on time
Provided support for UAT load and testing
Provided support for teh production implementation and run

Skill Name: Informatica 9.6.0, SQL Server 2005, Teradata.

Developer L2

Confidential

Responsibilities:

Creating Datawarehousing ETL Mappings for Data Extraction from ERP system.
Implemented Incremental Load based on SCD type 1&2.
Created documents like Mapping Spec, Technical Spec, Functional Spec and Unit Test Case for all teh mappings
Implemented Error handling for all teh Mappings based on teh business requirement.
Created Mappings, Mapplets as per teh requirement and analyze teh query performance.
Co-ordination for both technical and non-technical wif clients.
Act as a Developer for EMA & ROW(NAM,APAT,LATAM) regions.
Requirement gathering from clients and implement teh same wif teh halp of offshore team.
Support teh organization in Decision-making review to improvise teh Business Profit.
Suggested several automations to teh offshore team to improvise teh Business process and performance tuning in technical end.
Testing and Quality Assurance.

Skill Name: Informatica 9.1.0, SQL Server 2005, Oracle 10G.

Developer L2

Confidential

Responsibilities:

Act as a BI Developer.
Created Mappings, Mapplets as per teh requirement and analyze teh query performance
Creating Datawarehousing ETL Mappings for Data Extraction from ERP system.
Implemented Error handling for all teh Mappings based on teh business requirement.
Query analysis and tuning.
Created documents like Mapping Spec, Technical Spec, Functional Spec and Unit Test Case for all teh mappings

Skill Name: Informatica 9.1.0, SQL Server 2005, Oracle 10G.

We provide IT Staff Augmentation Services!

,

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship