Informatica Developer Resume Samples

HIGH QUALITY

The best examples from thousands of real-world resumes

EXPERT APPROVED

Handpicked by resume experts based on rigorous standards

DIVERSE EXAMPLES

Tailored for various backgrounds and experience levels

Informatica Developers, also known as ETL Developers, assist in maintaining relevant sources of data and ensuring that said data is being stored properly. Included on sample resumes for this position are tasks like developing and implementing ETL processes using Informatica client tools, creating and maintaining shell scripts for pre and post session operations, and improving session performance through error handling. While a bachelor's degree in computer science or its equivalent is a resume requirement for this position, a degree may be forgiven in lieu of a strong programming background.

For more information on what it takes to be a Informatica Developer, check out our complete Informatica Developer Job Description.

Find out what is the best resume for you in our Ultimate Resume Format Guide.

1

Informatica Developer

Developed complex informatica mappings to load the data from various sources using different transformations like source qualifier, connected and unconnected lookup, update Strategy, expression, aggregator, joiner, filter, normalizer, rank and router.

  • Implemented Type 1 and Type 2 methodologies in ODS tables loading to keep historical data in data warehouse.
  • Designed Incremental loading process to load data into staging tables.
  • Created Worklets, Workflow and Tasks to schedule the loads at required frequency using Workflow Manager.
  • Worked with Pre-Session and Post-Session UNIX scripts for automation of ETL jobs. Also involved in migration/conversion of ETL processes from development to production.
  • Created reusable email tasks in Workflow manager for process exception handling.
  • Participated in user meetings, gathered Business requirements & specifications for the data warehouse design. Translated the user inputs into ETL design docs.
Candidate Info
2
years in
workforce
2
years
at this job
BA
Computer Science
2

Informatica Developer

Developed complex informatica mappings to load the data from various sources using different transformations like source qualifier, connected and unconnected lookup, update Strategy, expression, aggregator, joiner, filter, normalizer, rank and router.

  • Implemented Type 1 and Type 2 methodologies in ODS tables loading to keep historical data in data warehouse.
  • Designed Incremental loading process to load data into staging tables.
  • Created Worklets, Workflow and Tasks to schedule the loads at required frequency using Workflow Manager.
  • Worked with Pre-Session and Post-Session UNIX scripts for automation of ETL jobs. Also involved in migration/conversion of ETL processes from development to production.
  • Created reusable email tasks in Workflow manager for process exception handling.
  • Participated in user meetings, gathered Business requirements & specifications for the data warehouse design. Translated the user inputs into ETL design docs.
Candidate Info
2
years in
workforce
2
years
at this job
3

Informatica Developer

Analyzed the source data and business related to it so that the new data sources can be seamlessly integrated to the existing data warehouse.

  • Finalized business requirements with business stakeholders / users.
  • Primary responsible for deploying the changes from logical data model to physical modeling.
  • Analyzed and quantified the impact of projects on upstream / downstream systems.
  • Trained and mentored peers on standards, processes, methodologies, Erwin.
  • Performed extensive analysis of existing / new data to satisfy business requirements.
  • Performed reverse-engineering from Informatica codes, UNIX shell scripts, Teradata BTEQ scripts, stored procedures, metadata to understand the existing process, data and relationships.
  • Planned and designed the Oracle schemas, designing database objects like partitions, tables, views, indexes, sequences, constraints, packages, procedures, functions and database triggers.
Candidate Info
3
years in
workforce
9
months
at this job
4

Informatica Developer

Analyzed the source data and business related to it so that the new data sources can be seamlessly integrated to the existing data warehouse.

  • Finalized business requirements with business stakeholders / users.
  • Primary responsible for deploying the changes from logical data model to physical modeling.
  • Analyzed and quantified the impact of projects on upstream / downstream systems.
  • Trained and mentored peers on standards, processes, methodologies, Erwin.
  • Performed extensive analysis of existing / new data to satisfy business requirements.
  • Performed reverse-engineering from Informatica codes, UNIX shell scripts, Teradata BTEQ scripts, stored procedures, metadata to understand the existing process, data and relationships.
  • Planned and designed the Oracle schemas, designing database objects like partitions, tables, views, indexes, sequences, constraints, packages, procedures, functions and database triggers.
Candidate Info
3
years in
workforce
9
months
at this job
5

Informatica Developer

This project was designed for integrating various Data Marts that targeted specific Business processes including Marketing, Generation, Transmission and Distribution etc. The data warehouse has been designed using Erwin adopting Star Schema methodology. Cognos was used to analyze business decisions and to build long-term strategic plans.

  • Developed various Mappings with the collection of all Sources, Targets, and Transformations using Informatica Designer
  • Developed Mappings using Transformations like Expression, Filter, Joiner and Lookups for better data messaging and to migrate clean and consistent data
  • Extracted data from various sources across the organization (Oracle, SQL Server and Flat files) and loading into staging area
  • Created and scheduled Sessions and Batch Process based on demand, run on time, or run only once using Informatica Workflow Manager and monitoring the data loads using the Workflow Monitor
  • Participated in Testing and performance tuning by identifying bottlenecks in mapping logic and resolving them, setting cache values and creating partitions for parallel processing of data
  • Developed Reports in Cognos Impromptu and Power play
Candidate Info
5
years in
workforce
2
years
at this job
BA
Computer Science
6

Senior Informatica Developer

Worked closely with business users during the requirements gathering phase, created technical specification documents as per the requirements.

  • Extract and transform data from multiple sources such as SAP, Oracle, SQL Server, flat file etc., and load into Oracle and Neteza tables which were used for reporting and salesforce analytics.
  • Created Complex mappings using Connected and Unconnected Lookups, Aggregate, Update Strategy, Stored Procedure, Java, Normalizer and Router transformations for populating target table in efficient manner.
  • Create, design and implement the core ETL methodologies using Star and Snowflake schema.
  • Created unit test cases to test data loads and check whether the components adhere to the technical design.
  • Created and scheduled worklets, configured email notifications. Set up Workflow to schedule the loads at required frequency using Power Center Workflow Manager, Generated completion messages and status reports using Workflow Manager.
  • Involved in performance tuning at various levels including Target, Source, Mapping, and Session for large data files.
  • Used SQL tools like TOAD to run SQL queries to view and validate the data loaded into the warehouse and troubleshoot data issues.
  • Conducted knowledge transfer sessions with client resources and documented Data Mappings/ Transformations as per the business requirements.
Candidate Info
10
years in
workforce
11
months
at this job
7

Senior Informatica Developer

Worked closely with business users during the requirements gathering phase, created technical specification documents as per the requirements.

  • Extract and transform data from multiple sources such as SAP, Oracle, SQL Server, flat file etc., and load into Oracle and Neteza tables which were used for reporting and salesforce analytics.
  • Created Complex mappings using Connected and Unconnected Lookups, Aggregate, Update Strategy, Stored Procedure, Java, Normalizer and Router transformations for populating target table in efficient manner.
  • Create, design and implement the core ETL methodologies using Star and Snowflake schema.
  • Created unit test cases to test data loads and check whether the components adhere to the technical design.
  • Created and scheduled worklets, configured email notifications. Set up Workflow to schedule the loads at required frequency using Power Center Workflow Manager, Generated completion messages and status reports using Workflow Manager.
  • Involved in performance tuning at various levels including Target, Source, Mapping, and Session for large data files.
  • Used SQL tools like TOAD to run SQL queries to view and validate the data loaded into the warehouse and troubleshoot data issues.
  • Conducted knowledge transfer sessions with client resources and documented Data Mappings/ Transformations as per the business requirements.
Candidate Info
11
years in
workforce
2
years
at this job
8

Informatica Developer

[company name] is a global leader in providing security, storage and systems management solutions.The project is to support Business Executives to get real time sales order information to make quick decisions. [company name] has data in different databases such as DB2, Sybase and Siebel. [company name] has different data staging areas, OLTP (Online Transaction Processing), legacy system mainframe (Total Systems) and Siebel. The project created a Warehouse from different systems and then created different Data Mart to answer different query reports.

  • Designed and developed ETL processes to extract data from the source systems and load into the Data Warehouse both in production and development environments.
  • Using Informatica PowerCenter created mappings and mapplets defining the transformation logic according to the business rules for the loads.
  • Created transformations such as Joiners, Lookups, Filters, Aggregator, Sequence Generators, according to the business rules.
  • Developed strategies for integrating data from various source systems and for initial and daily loads.
  • Tuning the Informatica maps and SQL's for optimal load performance.
  • Created sessions and batches using Informatica Workflow Manager and monitored with Workflow monitor
  • Involved in the production support, watch the workflow monitor carefully to see all workflows and all Tasks are running properly and data is loading in the proper way and to the right targets and at the right time.
  • Analysis and resolution of all data related production issues
Candidate Info
6
years in
workforce
6
months
at this job
BS
Bachelor of Science
MA
Computer Applications
9

Informatica Developer

[company name] is a global leader in providing security, storage and systems management solutions.The project is to support Business Executives to get real time sales order information to make quick decisions. [company name] has data in different databases such as DB2, Sybase and Siebel. [company name] has different data staging areas, OLTP (Online Transaction Processing), legacy system mainframe (Total Systems) and Siebel. The project created a Warehouse from different systems and then created different Data Mart to answer different query reports.

  • Designed and developed ETL processes to extract data from the source systems and load into the Data Warehouse both in production and development environments.
  • Using Informatica PowerCenter created mappings and mapplets defining the transformation logic according to the business rules for the loads.
  • Created transformations such as Joiners, Lookups, Filters, Aggregator, Sequence Generators, according to the business rules.
  • Developed strategies for integrating data from various source systems and for initial and daily loads.
  • Tuning the Informatica maps and SQL's for optimal load performance.
  • Created sessions and batches using Informatica Workflow Manager and monitored with Workflow monitor
  • Involved in the production support, watch the workflow monitor carefully to see all workflows and all Tasks are running properly and data is loading in the proper way and to the right targets and at the right time.
  • Analysis and resolution of all data related production issues
Candidate Info
6
years in
workforce
6
months
at this job
BS
Bachelor of Science
MA
Computer Applications
10

Informatica Developer

Worked as ETL Lead/Architect for Hewlett-Packard(hpshopping.com) EDW system.

  • Involved in all phases of the project life cycle including requirement gathering, analysis, design, coding, testing and implementation.
  • Interpreted and comprehend business/data requirements from upstream processes
  • Documented technical requirement specifications and detailed designs for ETL processes of moderate and high complexity.
  • Created and documented source-to-target mappings and ETL specifications.
  • Created scripts for FTPing files, data manipulation and validations.
  • Designed ETL processes for optimal performance
  • Performed root cause analysis and resolved complex issues.
  • Designed and performed all activities related to migration of ETL components between environments during development and deployment (Eg. Dev to SIT, SIT to UAT and UAT to PROD repositories).
  • Created high-level design documents, data mapping documents and data flow diagrams for WRET System.
Candidate Info
2
years in
workforce
2
years
at this job

Your Resume, Made Easy.

You are looking for your dream job and need a resume? My Perfect Resume is your solution and takes the hassle out of resume writing. Create the perfect job-worthy resume effortlessly in just a few clicks!