ETL - Informatica Developer Resume - Hire IT People

SUMMARY:

Over all ten years of working experience and Five years of IT experience in Design, Analysis, Application Development, Implementation and Maintenance in Client/Server architecture, (ETL) Informatica Power Center 6, 7.1.3, 8.1,8.6 Windows NT, Oracle 8.0/8i/9i/10G and Testing of Client/Server.
Excellent communication, interpersonal, strong problem solving and teamwork skills.

TECHNICAL SKILLS:

Operating Systems: Windows 2000 Pro, Windows XP Pro, Unix

Languages: C, C++, Java

RDBMS / Database: Oracle 8.0/8i/9i,10G, 11G,My SQL, MS - Access.

4GL Tools: PL/SQL

ETL Tool: Informatica Power center 6.1/7.1/8.1/8.5/8.6

Testing Tools: QTP, Test Director, Win Runner, Load Runner

PROFESSIONAL EXPERIENCE:

Confidential

ETL - Informatica Developer

Responsibilities:

Using Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and code the process of data flow from source system to data warehouse.Created Task(Sessions, email)using Task developer, Workflows Using Workflow Designer
Reading Workflow Log Files, Session Log Files and tune the data as needed.
Used update Strategy, Sorter, Joiner, Source qualifier, Router in the mapping.
Created Naming Standards, Unit testing of Mappings and verifying ETL load results with business requirements and create the Document of PRC and RAD’s using internal application(shared Place) eRoom.
Report the status using BI Product Backlog application.

Environment OS: HP - UX, Windows XP Database: Oracle 9.1 Tool: TOAD, ETL Informatica Power Center 8.6, Microsoft Visio 2003 & 2007, Putty,WN SCP, MS-Excel, MS-Word.

Confidential

Informatica Developer

Responsibilities:

Using Informatica client tools - Source Analyzer, Target designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and code the process of data flow from source system to data warehouse.
Created Tech specs and Test Plan. Documentation of various processes
Interaction with Client and collecting requirements from users.
Exporting & Importing the Mappings, Workflows during Migration of Development Environment to System Environments, Production Environments.
Created Source definitions, Source Tables, Target definitions and Target Tables.
Used aggregator, lookup, expression, filter in the mapping.
Created Task (Sessions) using Task Developer.
Created Workflows Using Workflow Designer.
Created Worklets Using Worklet Designer.
Reading Workflow Log Files, Session Log Files.
Used Update Strategy, Sorter, Joiner, Source qualifier, Router in the mapping.
Monitor Workflows and Tasks using Workflow Monitor.
Created Naming Standards, Unit testing of Mappings and verifying ETL load results with business requirements.

Environment OS: HP - UX, Windows XP Database: MS SQL Server 2005 Tool: TOAD, ETL Informatica Power Center 8.6, Microsoft Visio 2003 & 2007, Putty,WN SCP, MS-Excel, MS-Word.

Confidential

Informatica Developer, Data Analyst, Oracle Developer, Tester

Responsibilities:

Using Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and code the process of data flow from source system to data warehouse.
Development and maintenance of complex Power Center Mappings. Developing mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like, Expression Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sorter. Implementing Slowly Changing Dimensions Type I & II in different mappings as per the requirements.
Using Debugger to troubleshoot the mappings.
Creating Workflows, Work let using Workflow Manager.
Creating new mappings and updating old mappings according to changes in Business logic using Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status.
Daily Processing of defense personal medical record data and ownership of generated report.
I involved in creating and reviewing test plan and test cases according to business requirements. Performed manual testing of queries according to UI specification. Reported bugs using MS-Excel, MS-Word.
Used Unix Operating System and developed basic UNIX shell scripts.
Determine the options and recommended solution for populating domain counts for the DMSSMT Tables.
Using TOAD as the oracle tool to separate the values from the source tables and send them to a temp table for the application modifications.
Attend the triage meeting with developers and business people.
Performing major role in understanding the business requirements and designing and loading data into data warehouse (ETL).

Environment OS: HP - UX, Windows XP Database: Oracle 9i/10G/11G, PL/SQL Tools: TOAD, ETL Informatica Power Center 6.1, 7.1,8.1,8.6, Microsoft Visio 2003 & 2007, Putty, WS FTP, MS-Excel, MS-Word.

We provide IT Staff Augmentation Services!

Etl - Informatica Developer Resume

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship