Informatica Etl 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 ETL Developers convert a company's standard processes, like stored procedures and functions, into Informatica. Example resumes for this position list such responsibilities as interacting with business analysts and on-site coordinates for requirement analysis, creating mappings according to use cases by following the ETL specifications, and creating ETL Design documents with the help of use cases and user interface documents, business rule documentation, and PDM. No formal education is required for this position, though candidates who can show adequate experience with business and technical applications and some sort of postsecondary education on their resumes will be considered.

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

1

Informatica ETL Developer

Extensively developed various mappings to perform ETL of source data into the OLAP/data warehouse.

  • Worked with SQL, PL/SQL procedures and functions, stored procedures and packages within the mappings.
  • Tuned Informatica mappings and sessions for optimum performance.
  • Assisted the other ETL developers in solving complex scenarios and coordinated with source systems owners with day-to-day ETL progress monitoring.
Candidate Info
2
years in
workforce
2
years
at this job
MBA
Master of Business Administration
Computer Science
2

Informatica ETL Developer

The PDI project is built in the process of expanding the scope of Information Factory. The Project acquires and Integrates Member, Eligibility, Claims, Benefits and Accumulations data from Proclaim into the Information Factory. The Effort included stage, integrate and positioning the data making it available for the downstream data consumers.

  • Created Data Maps / Extraction groups in Power Exchange Navigator for legacy IMS Parent sources.
  • Staged Data from legacy Proclaim IMS system into Oracle 11g Master Tables
  • Performed CDC capture registrations
  • Assisted in building the ETL source to Target specification documents by understanding the business requirements
  • Developed mappings that perform Extraction, Transformation and load of source data into Derived Masters schema using various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in the mappings
  • Reusable transformations and Mapplets are built wherever redundancy is needed
  • Performance tuning is performed at the Mapping level as well as the Database level to increase the data throughput
  • Designed the Process Control Table that would maintain the status of all the CDC jobs and thereby drive the load of Derived Master Tables.
  • Used Teradata utilities like BTEQ, fast load, fast export, multiload for data conversion.
  • Created Post UNIX scripts to perform operations like gunzip, remove and touch files.
Candidate Info
8
years in
workforce
1
year
at this job
Computer Science
3

INFORMATICA ETL Developer

  • Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
  • Extracted data from SAP system to Staging Area and loaded the data to the target database by ETL process using Informatica Power Center.
  • Performed the performance and tuning at source, Target levels using Indexes, Hints and Partitioning in DB2, ORACLE and Informatica.
  • Designed and developed various PL/SQL stored procedures to perform various calculations related to fact measures.
  • Converted the PL/SQL Procedures to Informatica mappings and at the same time created procedures in the database level for optimum performance of the mappings.
  • Investigating and fixing the bugs occurred in the production environment and providing the on-call support.
  • Performed Unit testing and maintained test logs and test cases for all the mappings.
  • Maintained warehouse metadata, naming standards and warehouse standards for future application development.
  • Parsing high-level design specification to simple ETL coding along with mapping standards.
Candidate Info
3
years in
workforce
1
year
at this job
BS
Computer Science
4

Veterans Administration, D.c. - Lead Sql/informatica ETL Developer

The five lines of business for VBA are Compensation and Pension, Loan Guaranty, Education, Vocational Rehabilitation/Education and Insurance Services having individual data marts. The OLTP systems are VETSNET, BDN and the various data marts are CPMR, BIRLS, and VOR.

  • Worked as an Adhoc developer and created reports for Adhoc request from individual senators and congressmen, the press, GAO, inspector general offices and VA secretary using the EDW.
  • Worked on End to End analysis of the EDW to report the questions/clarifications of Adhoc requests with supporting data and findings.
  • Created high performance Sql scripts to reduce the time taken for producing ongoing Adhoc reports monthly and weekly.
  • Thoroughly tested the Sql scripts by validating the data and cross comparing the data across five lines of business for adhoc reports
  • Shared the business/technical knowledge gained within the team in adhoc meetings, peer code reviews, VOR/BIRLS code reviews
  • Worked on defect fixes in VOR to produce business solution using ETL (Informatica) tool. Offered various approaches in brain storming session, so as to decide the best approach for a FIX.
  • Worked on converting some of the PL/Sql scripts into Informatica mappings.
  • Worked on building informatica mappings for the HAIISS project - VHA -Essence data mart.
Candidate Info
5
years in
workforce
2
years
at this job
MS
Business Intelligence
Electronics And Instrumentation
5

Informatica ETL Developer

Designed extensive ETL mappings with Informatica Designer

  • Worked with filter transformations and flat files to identify source and target bottlenecks
  • Worked with various transformations including router transformation, update strategy, expression transformation, lookup transformation, sequence generator, aggregator transformation and sorter transformation
  • Used Oracle to write SQL queries that create/alter/delete tables and to extract the necessary data
  • Used UNIX to navigate around the system and check for specific files, the files’ content, change permissions and see who the current users are
Candidate Info
7
years in
workforce
4
years
at this job
BA
Information Technology And Informatics
6

Informatica ETL Developer

Automate PL/SQL scripts using Informatica within a framework

  • Parameterize hard-coded values
  • Implement PL/SQL requirements or rules into the ETL tool
  • Participate in Design Reviews for the overall Automation Framework and Architecture
Candidate Info
10
years in
workforce
6
months
at this job
BS
Computer Information Systems
MBA
Business Administration
7

Senior Informatica ETL Developer

Develop and maintain data marts on an enterprise data warehouse to support various UHC defined dashboards such as Imperative for Quality (IQ) program.

  • Designated owner and accountable for major tasks and took responsibility for actions and outcomes to ensure timely and cost-effective results for our team.
  • Coach new team members on technical tools such as Informatica Designer, Workflow Manager, Workflow Monitor and UHC Data Models.
  • Analyze data and build reports using Informatica data profiling tool & Toad for Data Analyst tool so that UHC members can make informed decisions.
  • Set and follow Informatica best practices, such as creating shared objects in shared for reusability and standard naming convention of ETL objects, design complex Informatica transformations, mapplets, mappings, reusable sessions, worklets and workflows.
  • Evaluate business requirements to come up with Informatica mapping design that adheres to Informatica standards.
  • Implement performance tuning on a variety of Informatica maps to improve their throughput.
  • Work with peers from various functional areas to define IT wide processes like code reviews, unit test documentation and knowledge sharing sessions.
  • Collaborate and work with business analysts and data analysts to support their data warehousing and data analysis needs.
Candidate Info
15
years in
workforce
3
years
at this job
C
Big Data And Nosql
C
Big Data Using Hadoop
MS
Master of Science

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!