Informatica Resume Sample

These are some examples of job descriptions we have handpicked from real Informatica resumes for your reference.

Informatica Developer

  • Working with business analysts to gather business requirements and implementing the same into a functional data warehouse design.
  • Worked with Power centre designer tool in developing mappings and mapplets to extract and load data from flat files and oracle to oracle.
  • Developed complex mappings in Informatica to load data various sources using different transformations like Source Qualifier, lookup (connected and unconnected) Expression, Aggregate, Update Strategy, Sequence Generator, joiner, filter.

Informatica Developer

  • Involved in requirement gathering and developed design for the integration of Cansys with PDCS system.
  • Created technical design document and Source to Target mapping document as per the design.
  • Extracted data from flat files, oracle database and staged into a single place and applied business logic to load them in the central oracle database.
  • Used Informatica Power Centre 9.6 for extraction, transformation and load (ETL) of data in the data warehouse.

Informatica Developer

  • Examined the workflow log files and assigning the ticket to the Informatica support based on the error.
  • Identified and fixed the Bottle Necks and tuned the Mappings and Sessions for improving performance.
  • Designed and developed ETL Mappings to extract data from flat files, MS Excel and Oracle to load the data into the target database.
  • Supported migration of ETL code from development to QA and QA to production environments.

Informatica Developer

  • Created mapping and mapplets using various transformations like Joiner, Filter, Aggregator, Lookup, Application Source Qualifier, Router, Sorter, Rank, Normalizer and Update Strategy.
  • Identified and resolved performance issues in Informatica Power Center mappings and workflows.
  • Developed the Technical Specifications based on the Functional Specification understanding the business rules and requirements.
  • Designed and implemented complex data transformation mappings using Informatica Power Center.

Informatica Developer

  • Install and Configure High Availability (HA) for Domain, Repository Service and Integration Service.
  • Creating Users, Groups, Roles and grant privileges to the users. Create folders, Relational and Application connections and configure the ODBC connectivity.
  • Participated in team meetings and proposed ETL Strategy and provide them best practices.

Informatica Developer

  • Involved in implementing the Land Process of loading the customer Data Set into Informatica MDM from various source systems.
  • Enrollment and Maintenance EDI data from employer groups to various health insurance payer.
  • Working closely with the client on planning and brainstorming to migrate the current RDBMS to Hadoop.
  • Migration of informatica jobs to Hadoop sqoop jobs and load into oracle database.

Informatica Developer

  • Developed and tested all the backend programs, Informatica mappings and update processes.
  • Extracted data from our cloud sources (Hive HUE) . HDFS system would dump the files into our cloud known as kafka que which is called as Hive Prod HUE.
  • Used Hue version- 2.6.1-2 Web interface to query the data.
  • Used Aginitiy AMP to generate Natural keys by the combination of multiple foreign keys.

Informatica Developer

  • Interacted with data modeler and business analyst to understand the requirement and the impact of the ETL on the business.
  • Developed ETL design documents to develop mappings. Also prepared strategy to load historical and incremental loading of the mapping.
  • Designed and developed complex ETL mapping for type-1 and type-2 dimensions and complex fact tables.

Informatica Developer

  • Involved with business to gather requirements for building data warehouse, reports etc.
  • Developed several Informatica mappings and mapplets to extract data from various sources such as flat files, database etc., and load the data into Data Warehouse using various transformations & reusable transformations like source qualifier, joiner, rank, update strategy, expression, union, sort, lookup, sequence generator, and router transformation etc.
  • Scheduled Sessions and Batches on InformaticaServer using Server Manager.
  • Performed SQL tunning and Informatica mappings to improve the performance of the jobs to provide maximum efficiency and performance.

Informatica Developer

  • Understanding the SQL Stored Procedures and implement the same into a functional database design.
  • Implemented the all subject areas into the data marts to generate the reports and build dash boards on it.
  • Used all major ETL transformations to load the tables through Informatica mappings.
  • Implemented Cursors into the stored procedures for frequent commits to avoid large data loading failures.

Informatica Developer

  • Participated in business requirements analysis, gap analysis, data mapping, data modeling and creating design documents.
  • Utilized the Informatica Data Quality (IDQ 8.6 8.6) application and performs data profiling necessary to resolve issues uncovered and related to source data.
  • Applied Business rules that identify the relationships among the data using Informatica Data Quality (IDQ 8.6 8.6).
  • Modified existing Informatica Data Quality (IDQ 8.6 8.6) Workflows to integrate the business rules to certify the quality of the Data.

Informatica Developer

  • Performance tuning to decrease the load time by 60 % by using partitioning and optimization techniques.
  • Newly developed mapping are giving desired result as per customer expectation.
  • With newly designed process reduced data load time from 7 Hours to 2 Hours.
  • Created shell scripts for automation of file transfers, decoding files and scheduling the workflow runs.

Leave a Comment

Your email address will not be published. Required fields are marked *

Read previous post:
Maintenance Mechanic Resume Sample

These are some examples of job descriptions we have handpicked from real Maintenance Mechanic resumes for your reference. Maintenance Mechanic...

Close