ETL Developer Resume

SUMMARY:

Highly motivated and result oriented Informatica Developer with 3 years of experience. Seasoned development professional well - versed in extraction, transformation and loading management.
Experienced in designing and development of complex and reusable mappings using Lookup, Joiner, Aggregator, Stored procedure, Update Strategy and various other transformations.
Vast knowledge in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control). Collaborative team player with excellent project management skills, interpersonal skills, self-starter, and eager to learn.

TECHNICAL SKILLS:

SQL: Informatica Power Center 10.1

Data extracting: ETL processes

Team player: Creativity

Public speaking: Troubleshooting and Debugging

PROFESSIONAL EXPERIENCE:

Confidential

ETL Developer

Responsibilities:

Experience in full project life cycle - from analysis to production implementation and support with emphasis on identifying the source and source data validation, developing logic and transformations as per the requirement, and creating mappings and loading the data into Data Warehouse.
Creates Informatica Mappings, Sessions, Worklets, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from multiple source systems into targets.
Performs tuning of mappings/session at database and Informatica level improving ETL load Timings.
Designs ETL packages to load data from data warehouses and migrate it to text files.
Optimize and tunes data to increase functionality and ensures data integrity by using the multi-dimensional star schema data warehouse style to ETL data.
Tests programs and databases; correct errors and makes necessary modifications to enhance ETL processes.
Data Warehousing ETL experience of using Informatica 10.0.1/ Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
Successful Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor).
Experience with dimensional modelling using star schema and snowflake models.
Understands business rules based on High Level document specifications and implements the data transformation methodologies.
Vast experience in Designing and developing mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, etc.
Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship