Informatica Developer Resume

PROFESSIONAL PROFILE:

A detailed ETL Informatica Developer with over 3 years of experience in gathering and analyzing requirements. Experienced in developing mappings performing Extraction, Transformation and load (ETL) of source data into derived master schema using various Power Center transformations - Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet mappings business logic. A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem-solving Skills.

KEY SKILLS:

Informatica Power Center 10.2
SQL
Extract, Transform, Load (ETL)
Data Warehousing
Oracle Database
Excel
Data Analysis
Data Migration

WORK HISTORY / EXPERIENCE:

Confidential

Informatica Developer

Responsibilities:

Designs mappings using various transformations like Filter, Joiner, Router, Expression, Union, Normalize, Sequence Generator, Update Strategy, Reusable Transformations, User Defined Functions
Expertise in Power Center Client tools including Repository Manager, Workflow Manager/ Workflow Monitor.
Create sessions, batches for incremental load into staging tables and scheduling them to run successfully daily.
Coordinates Performance Tuning of Informatica Power Center Mappings by identifying bottlenecks.
Elicits business requirements from customers.
Develops ETL programs using Informatica to implement the business requirements.
Fixed several SQL Query performance issues by examining execution plans, tuning indexes, creating plan guides, adding hint words.
Uses relational SQL to minimize the data transfer over the network.
Effectively uses Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
Performs Unit Testing, System testing to ensure accuracy of data loads from different databases and flat files into Confidential tables.
Conducts meetings with key stakeholders discussing strategies and roadmaps for Informatica Power Center Grid implementation.
Coordinates enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
Effectively works in Informatica version-based environment and uses deployment groups to migrate the objects.
Create Reports according to user Requirement.
Design workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
Reviews and analyzes functional requirements mapping documents, problem solving and troubleshooting.
Corrects invalid mappings and troubleshoot the technical problems of the database.
Maintains source and Confidential mappings, transformation logic and processes reflecting the changing business environment over time.

Confidential

Senior Specialist

Responsibilities:

Controlled access to property and facilities by following Best Practices, Procedures and Protocols
Directed interaction with law enforcement, fire department, Emergency Medical Services and other emergency management agencies during emergency situations
Prevented the loss of equipment, property and merchandise through the execution of loss-prevention strategies
Coordinated the development and documentation of investigations in Case Management system.
Leveraged technology by effectively utilizing surveillance cameras during investigations and prevented safety and security incidents.
Used multiple software applications like Witron Management System to schedule and monitor freight flow through the warehouse
Coordinated efficient movement of all trailers between stores carriers and distribution team

Confidential

Lead Associate

Responsibilities:

Identified customer needs, resolved customer issues and concerns, while promoting products and services.
Maintained the produce line, handled claims and returns, organized merchandise/supplies, and maintained a safe work environment.
Updated and maintained operating procedures, maintaining modular integrity, completed paperwork logs, and other required documentation.
Assigned tasks to team members provided specific work direction and monitored progress ensuring daily goals achieved.
Assisted with product quality control and collaborated with other team members, leaders and departments. Supported team members ensuring compliance with quality procedures.
Identified inefficiencies in work processes to improve production.
Trained team members to effectively utilize other aspects of the organization.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship