informatica developer Resume Examples

informatica developer
Build My Resume

Andrew Smith

Phone: (000) 000-0000
Email: [email protected]
Address: 287 Custer Street, Hopewell, PA 00000

Professional Summary

A technical aficionado, with core passion towards learning new technologies and passionate towards Data science & Artificial intelligence.
In to the software profession for the past 7 years and have my fair pick of exposure to various technologies with the core concentration on ETL - Informatica.
Currently realigned my professional stream with the Data science. 

Employment history

Jun. 2019 – Present Leschton, California
Informatica Developer, Koelpin-Boehm
Projects Handled : AXA Insurance-UK, AIG Insurance-Japan

  • Spearheaded a team of 7 people to effectively monitor, analyze and reduce production ticket volume .
  • Deputed to client location(Tokyo, Japan) where  endeavoured my potentiality to fulfill the customer requirement. 
  • Research, recommend, code, and administer application bug fixes.
  • Requirement gathering, feasibility study to enhance the existing functionality. 
  • This resulted in less number of production tickets, increased client's application stability and reduced application down times. 
  • Build, test and optimize Informatica mappings to load data Continuous outstanding performer and received client recognized appreciation.
  • Collaborated with business analysts to understand and define requirements.
  • Proposed technical feasibility solutions for new functional designs and suggested options for performance improvement of technical objects.
  • Interact with customers or clients about the project status and solve their technical issues if any.
  • Report project metrics based on parameters like system health, outage analysis, incident categorization, SLA matrix, future scope etc to Client periodically.
  • Research, recommend, code, and administer application bug fixes. Provided continued maintenance and development of bug fixes and patch sets for existing web applications.
  • Prepare detail documentation of existing IT process flow to achieve greater clarity between existing IT process & business requirements/expectations.
Jan. 2017 – Mar. 2017 O'Connellborough, Kansas
Informatica Consultant, Kshlerin, Murray and Cormier
Projects Handled - Farmers Insurance, USA

  • Build, test and optimize Informatica mappings to load data.
  • Design and develop informatica mappings and workflow according to the business requirements.
  • Debugging of existing mappings to identify bugs or code gaps.
  • Responsible for daily batch monitoring of all the Informatica stand alone jobs and DAC execution plans.
  • Monitor all performance metrics for various production systems and identify root cause for all technical issues and recommend solution. Creation of Adhoc reports based on business requests.
  • Developing shell scripts for file transfer automation. Verifying that data is transformed correctly according to various business requirements and rules.
  • Validating that all projected data is loaded into the data warehouse without any data loss and truncation.
  • Making sure that ETL application appropriately rejects, replaces with default values and reports invalid data.
  • Validation of data load in data warehouse within prescribed and expected time frames to confirm improved performance and scalability.
  • Developing validation scripts in Oracle SQL to validate the different ETL steps (Source to Target data migration)

Jan. 2014 – Jun. 2014 Lake Florentino, Kansas
Warranty Administrator, Monahan Group
  • Research, recommend, code, and administer application bug fixes. Provided continued maintenance and development of bug fixes and patch sets for existing web applications.
  • Prepare detail documentation of existing IT process flow to achieve greater clarity between existing IT process & business requirements/expectations
  • Build, test and optimize Informatica mappings to load data. Design and develop informatica mappings and workflow according to the business requirements.
  • Debugging of existing mappings to identify bugs or code gaps.Responsible for daily batch monitoring of all the Informatica stand alone jobs and DAC execution plans.
  • Monitor all performance metrics for various production systems and identify root cause for all technical issues and recommend solution. Creation of Adhoc reports based on business requests.
  • Developing shell scripts for file transfer automation. Verifying that data is transformed correctly according to various business requirements and rules.
  • Validating that all projected data is loaded into the data warehouse without any data loss and truncation.
  • Making sure that ETL application appropriately rejects, replaces with default values and reports invalid data.
  • Validation of data load in data warehouse within prescribed and expected time frames to confirm improved performance and scalability.
  • Developing validation scripts in Oracle SQL to validate the different ETL steps (Source to Target data migration)
  • Responsible for requirement gathering, user meetings, discussing the issues to be resolved and translated the user inputs into ETL design documents.
  • Designed and developed new change requests in Informatica.
  • Design of ETL process to extract data from various heterogeneous sources like Oracle RD, flat files.
May. 2013 – Oct. 2013 West Zacherytown, New Hampshire
Graduate Engineer Trainee, Corkery and Sons
  • Core expertise lies in the Data Base Management of Gas Analysis system warehouse.
  • Design and develop PLSQL scripts for adhoc data fix and data cleanup. Preparation of adhoc reports from Oracle database using SQL based on business requirement.
  • Loading of data using SQL Loader to application database.
  • Involved in the group for the material management. Worked for several national & international projects like Reliance Cement company (Maihar &Kundanganj, India), Jk Cement plant(Fujairah), Ultra Tech(Arakkonam, India) for their billings through the data base. 
  • Preparation of BOM (Bill of Material).
  • Data Cleansing, Integration and Data Transformation .
  • Material Management
  • Maintaining the packaging and dispatch records of the finished products in database.

Education

Nov. 2012
Bachelor of Technology: Information Technology
  • Langworth Institute - Schaeferburgh, Hawaii
Aug. 2012
Bachelor of Engineering: Electrical & Electronics
  • South Georgia University - South Felecialand, Maine
Apr. 2008
Higher Secondary: Bio/Maths
  • West Howell - East Hilmaport, South Carolina
Sep. 2006
Matriculation: Science/Maths
  • Lueilwitz Academy - O'Konfort, Connecticut

Certifications

Skills

Python programming
DAC Scheduler
Informatica power Center
OBIEE
Oracle sql
Data stage
Machine Learning
Probablity & Statistics
Use This informatica developer Resume Template

Not in love with this template? Browse our full library of resume templates

boy

Build your resume in 15 minutes

Use professional field-tested resume templates that follow the exact resume rules employers look for.
Build My Resume

Related Resumes & Cover Letters

More Job Descriptions for :

1

informatica developer

  • Spearheaded a team of 7 people to effectively monitor, analyze and reduce production ticket volume .
  • Deputed to client location(Tokyo, Japan) where  endeavoured my potentiality to fulfill the customer requirement. 
  • Research, recommend, code, and administer application bug fixes.
  • Requirement gathering, feasibility study to enhance the existing functionality. 
  • This resulted in less number of production tickets, increased client’s application stability and reduced application down times. 
  • Build, test and optimize Informatica mappings to load data Continuous outstanding performer and received client recognized appreciation.
  • Collaborated with business analysts to understand and define requirements.
2

informatica developer

  • Prepare the coding in Informatica using BRD.
  • Prepare the queries in SQL server based on the business criteria in mapping document.
  • Unit testing of the required components.
  • Interact with customers or clients about the project status and solve their technical issues if any.
3

informatica developer

  •  CA7 changes
  •  Data Retention jobs testing.
  • Development and Testing of Split Process metadata.
  • Issue Resolution of Production/QA/UAT defects
  • Involved in set up of NDM and CA7 on servers.
  • Walk through of support document of the customer
4

informatica developer

  • Proposed end to end solution and better design approach
  • Involved in Estimation, Requirement Analysis, Design, Client Reviews, Knowledge Transition, Task Management and Project Management Activities
  • Performed design and development of Informatica cloud mappings for Fact and Dimension load as part of Functional Releases
  • Lead the team for Test Execution of the SIT/UAT cycles which involved planning the load schedule, managing the loads, timely status reporting to all the stake holders, documentation and reporting the issues faced and handover to Production team
  • Received outstanding award from Deloitte for successfully delivering this project with utmost perfection & leading as well as shaping the project wherever required
5

informatica developer

  • SAS/UNIX Developer: Worked on enormous SAS and UNIX scripts. In recent past have been involved in developing the scripts to improvise the existing solutions in both SAS and UNIX. 
  • Sybase Developer: Extensively worked with database objects like Procedures , Indexes , Cursors etc in terms of creation and debugging both.
  • Informatica Developer: Apart from the Application Maintenance I extensively worked as an Informatica developer in my team and have handled more than 20 enhancement Projects.
  • SSIS Developer: Involved in building jobs on SQL Server and  SQL Server administration related to the SSIS packages and the SQL Server Agent in MS SQL SERVER 2000/05/08.

Other Great Resumes & Cover Letters from this Industry:

Suggested Reading:

Related Articles

Resume Design Tips and Tricks

Resume Design Tips and Tricks

Creating a resume that stands out from the rest doesn’t have to be rocket science. With just a few tips and tricks, you can make your professional resume a shining...

Read more