Informatica / ETL Developer Resume

SUMMARY

Performing Extract Transform Load (ETL) processes using Informatica Power Center. Proactive, resourceful, and professional with success in designing, developing, and debugging codes. Ability to utilize skills where excellent services are required.

TECHNICAL SKILLS

ETL Power Center 10.2
Data Validation.
Data Mapping.
SQL.
Data Migration.
Test Solutions.
Business Intelligence.
EDI Data.
Troubleshooting.
Data Integration.
Debugging/Problem Solving.
Team player.
Detail Orientated.
Organization.
Strong work ethics.
Excellent Communication.
Oracle Database.
Customer Service.

PROFESSIONAL EXPERIENCE

Confidential

Informatica / ETL Developer

Responsibilities:

Identify ways to increase production support efficiency, using Performance tuning to ensure data accuracy and meeting clients requirements as well as providing customer satisfaction.
Using data integration to find solutions that allow flow of operations without involving development resource resulting to quick data load turnaround time into production environment.
Perform data validation, error checking, troubleshooting, and keeping schema/data in existing application database environments in sync.
Organize extensive usage of database links, partition data/index structures materializing views, and all data replication.
Review workflow session output to ensure data populated is accurate and meets customer requirements.
Develop and maintain proper data extraction processes for business solution which ensure accurate result for product enhancement.
Design ETL processing using Informatica Power Center ensuring data retrieved meet projects’ requirements.
Review the designs, code, and test session runs of other developers and provide recommendations for improvement or optimizations.
Design data mart to support Business Intelligence, perform SQL updates as well as ensuring data mapping meets accuracy and business requirements.
Using various transformations like expressions, router, lookup, aggregator, union, joiner, update strategy transformation to process mappings and validating data output for accuracy.
Correct invalid mappings, identity error codes and troubleshoot technical problems of the database.
Review and analyze functional requirements mapping documents, problem solving and troubleshooting.
Correct invalid workflows and troubleshoot the technical problems of the database.
Conduct data analysis to support customer requests including reconciliation of submissions, using debugger to review data accuracy before loading into database to ensure company goals and client requirements are met.
Using Informatica Power Center to coordinate performance tuning by identifying bottlenecks and ensuring the issues are resolved.

Confidential

IT Account Manager

Responsibilities:

Streamlined maintenance, user supports, training, installations, providing solution design satisfying clients’ needs.
Performed operational quality problem resolution, systematic improvements, initiated corrective actions, adjustments, and maintenance as appropriate.
Advocated the needs and expectations of the client ensuring compliance and achieving customer satisfaction.
Prepared weekly report to include Key Performance Indicators (KPIs), customer participation (exception resolution, carrier rate and contract issues, issue log tracking), actions and commitment for resolution.
Maintained and established business relationship between the internal and external company and customers.
Worked with other IT development team and ensured compliance with customer’s expectations, quality standards of data consistent with data management best practices.
Maintained customer portfolio by proactively managing customers’ daily activities.

Confidential

IT Market Representative

Responsibilities:

Tracked data and worked with team to achieve quota goals which improved company revenue.
Analyzed data trends, demographics, pricing strategies and other information, which improved marketing and sales performance.
Created and presented performance reports to customers, managers and executives showing data trends and areas of growth for customers and the organization.
Developed strategies and approaches for various products, services, special promotions, and sponsored events, which grew client base.
Developed and effectively executed, innovate and comprehensive company’s marketing programs and strategies for service improvement leading to company - wide growth.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship