Informatica Developer Resume Sample

Informatica Developers design and develop data storage systems and perform related data extraction, transformation, and load functions for the organization. They analyze, integrate, and conduct quality tests for data warehousing systems and databases as well as develop and maintain up-to-date documentation. These technical experts have a bachelor's degree in computer science along with an Informatica Powercenter Data Integration or Data Quality certification. If you are really interested to work for this profile, you will need an informatica developer resume that highlights your relevant skills and experience in the best way possible and make you stand out from the competition.

It must showcase your expertise in analyzing technical requirements and database models, creating data mappings and SQL stored procedures or queries, ETL design and implementation, data warehousing and data quality checks, documenting Informatica systems, software and system development phases, Informatica Powercenter, Oracle and PL/SQL. To grab the attention of potential employers, highlight your exceptional communication, analytical thinking, problem-solving, time-management, team-working and multi-tasking skills.

Sample Informatica Developer Resume

Michael J. Jernigan
1239 North Street
Charlottesville, VA 22903
Phone No: 434-678-3420
Email: michaeljernigan@anymail.com

Career Summary:

Highly enthusiastic, dedicated, and professional Informatica Developer with more than 6 years of experience in designing data storage systems and performing ETL designing for data warehousing systems using Informatica tools and PL/SQL programming. Capable of analyzing business requirements and database models, developing technical documents as well as providing troubleshooting and production support for various Informatica systems. Possess excellent communication, analytical, project-management, problem-solving, multi-tasking and team-working skills.

Summary of Skills:

Thorough knowledge of Informatica based system development, ETL design, Powercenter Data integration and Quality, software design and development principles, data mapping and migration, data warehousing concepts, data replication and synchronization, SQL queries and stored procedures, Informatica data cleanup procedures, error handling and performance tuning, data analysis and debugging, test-driven environment
Working knowledge of data warehousing or ETL tools such as Informatica Power Center 8.6.1. and Data Stage, QlikView BI tool, Windows and Unix OS, Informatica PowerExchange, Informatica SOA and MDM
Clear understanding of SQL, PL/SQL, Oracle/ DB2 databases, XML, JavaScript, SQL Server as well as proficiency in using MS Office Suite applications
Strong leadership skills as well as the ability to work both independently and in cross-functional teams
Solid analytical skills with the ability to identify and resolve complex data problems
Effective communication and presentation skills with the ability to maintain effective relations with clients and team members
Ability to work in a fast-paced and deadline-driven environment as well as make effective decisions under pressure
Excellent organizational and project-management skills with the ability to perform multiple tasks simultaneously
Ability to keep up with the latest trends and advancements as well as respond to technical queries or requests from team members and users

Work Experience:
Informatica Developer
Scadea Software Solutions, Charlottesville, VA
February 2018-Present

Coordinating with the development team in analyzing user or functional requirements as well as designing and maintaining data storage systems accordingly using Informatica tool and SQL or PL/SQL coding
Designing, building, deploying, and supporting end-to-end ETL processes for data warehousing systems using Oracle SQL, PL/SQL, SQL Loader and Informatica Power Center as well as performing unit testing and troubleshooting functions for optimal performance and efficiency
Analyzing and troubleshooting data storage and other production issues as required as well as developing, testing and optimizing Informatica based ETL solutions that fulfill stringent performance requirements
Creating and maintaining up-to-date documentation outlining coding information, program logic, design, testing, implementation, troubleshooting and ETL processes related to Informatica systems
Performing data cleansing procedures and monitoring data integrity or accuracy, mappings and workflows in a cost-effective manner to identify data quality issues as required as well as designing and executing data quality improvement processes as required
Evaluating the integration of various data sources such as Oracle, SQL Server, VSAM and sequential files into staging areas as well as developing and implementing various data profiling and data quality rules or procedures using IDQ toolkit

Informatica Developer
GSS Tech Group, Charlottesville, VA
April 2016-January 2018

Led and guided development of ETL architecture as well as designing, coding and unit testing of ETL packages, triggers, stored procedures and SQL transactions and oversaw all data warehouse development phases and related application implementations as well as ensured completion of assigned projects within specified deadlines and budgets
Identified and removed bottlenecks in sources, targets, mapplets, mapping and transformations using debugger in Informatica Powercenter Designer as required as well as monitored tuning of star schemas, programs, ETL procedures or processes to optimize load and query performance
Developed ETL failure recovery strategies and monitored related workflows and loggings as required as well as utilized Informatica tool to provide data cleansing, data quality assurance and data masking for testing purposes
Worked with QA team in developing test plans and scripts for validating the accuracy, quality and integrity of ETL processes and participated in various mock data conversion tests to reduce implementation risks
Developed complex mappings in Informatica systems to load data from various sources as required as well as created ETL exception and validation reports after loading data into enterprise warehouses

Informatica Developer
PI System Inc., Charlottesville, VA
December 2013-March 2016

Assisted in developing ETL processes, mappings, data cleanup methods, scripts, stored procedures and related test plans using Informatica to load and integrate data successfully into the warehouses or targets as well as developed logical and physical data flow models for various ETL based applications
Debugged existing data mappings and created mapplets for reusability as required as well as participated in SQL code reviews and recommended solutions to project and management teams for enhancing ETL based programs
Assisted in establishing testing or quality assurance environments to check the quality and integrity of stored data on a regular basis and ensure error-free programming or system modifications as needed
Working collaboratively with other Informatica developers to design, develop and maintaining higher efficiency and performance of data storage systems and enterprise data warehouse or databases as well as oversaw the implementation of Informatica cloud data management products as per business or user requirements
Assisted in preparing and maintaining overall system documentation that included technical specifications, programming modifications, production problems and resolutions as required.

Certification:

Informatica PowerCenter Data Integration Certification 2013

Education:

Bachelor's Degree in Computer Science University of Virginia, Charlottesville,VA, USA 2012

Reference:
On Request.