- Featured in:
-
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 Developer Resume Samples
No results found
Candidate Info
years in workforce
years at this job
Master of Business Administration
Computer Science
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
years in workforce
year at this job
Computer Science
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
years in workforce
year at this job
Computer Science
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
years in workforce
years at this job
Business Intelligence
Electronics And Instrumentation
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
years in workforce
years at this job
Information Technology And Informatics
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
years in workforce
months at this job
Computer Information Systems
Business Administration
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
years in workforce
years at this job
Big Data And Nosql
Big Data Using Hadoop
Master of Science
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.
More Informatica Etl Developer
Resumes
Informatica Etl Developer Resume Success Stories
