- 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 Developer Resume Samples
No results found
Candidate Info
years in workforce
years at this job
Computer Science
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
years in workforce
years at this job
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
years in workforce
months at this job
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
years in workforce
months at this job
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
years in workforce
years at this job
Computer Science
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
years in workforce
months at this job
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
years in workforce
years at this job
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
years in workforce
months at this job
Bachelor of Science
Computer Applications
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
years in workforce
months at this job
Bachelor of Science
Computer Applications
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
years in workforce
years at this job
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
years in workforce
years at this job
Political Science
Informatica Developer & Business Systems Analyst
- Gathered and managed requirements to execute successful development of data warehouse solutions
- Member of both RUP and Agile teams in developer, analyst, project manager, and tester capacities
- Extracted data from various source systems and loaded into Schwab's data warehouse
- Developed mappings, workflows, and performed extensive troubleshooting in Informatica 9.5.1
- Oversaw and managed team resources to ensure deliverables met business requirements and deadlines
- Created and executed test plans to ensure delivery of high quality data to our business users
- Produced a training plan for future ETL developers and analysts at Schwab
- Responsible for tracking and reporting the data warehouse personnel budget on a weekly basis
Candidate Info
years in workforce
years at this job
Bachelor of Arts
Master of Arts
ETL Informatica Developer
Project Summary: This project is for reverse mortgage. Testing was done for loan origination, loan processing & loan closing activities of reverse mortgage.
- Used informatica workflow manager to execute the workflows and informatica workflow monitor to monitor the status of the workflows.
- Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
- Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation.
- Developed TestCases for ETL/ Data warehouse changes based on technical specifications and Mapping documents
- Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
- Validated Informatica extraction, transformation and loading process by writing SQL against Business rules.
Candidate Info
years in workforce
months at this job
Business
Complex Procedures And Queries To Extract Data
Informatica Developer
Responsible for the full lifecycle development, implementation and production support of the Oracle Data warehouse using Informatica Power Center
- Identified and defined business rules and transformation logic for various phases of the project
- Netezza Database tables were used as the sources with which various reusable transformations, parameters and Mapping variables were used based on the business strategies
- Worked on BTEQ script to provide batch to import and export data and generate reports.
- Created reusable Mapplets and Transformations to reduce the complexity in mappings and to handle repetitive tasks such as setting and getting Dimension details
- Worked on various Transformations like Connected and Lookup, Aggregator, Expression, Filter, Router, Update Strategy, Stored Procedure and Sequence Generator, Sorter
- Configured single-pass reading to reduce the number of times the Integration Service reads sources
- Optimized filters to maximize session performance, only process records that belong in the pipeline
- Interacted with the users and making changes to Informatica mappings according to the Business requirements.
- Created UNIX shell scripts for Informatica jobs automation
- Analyzed sales/spend data and provided quantitative analyses across markets, business units and functions
Candidate Info
years in workforce
months at this job
Electronics & Communication Engineering
ETL Informatica Developer
Analyse the data source and prepare the roadmap for data model that feed data warehouse through ETL system.
- Co-ordinate with global teams to gather requirements and prepare the design documents (HLD and LLD) as per the requirement.
- Developed complex ETL mapping, its corresponding sessions & workflows and assisted the offshore with troubleshooting and the best practices in software development.
- Developed the Visual Insight Dashboard in MSTR with freeform SQL as a quick solution for NONSQL background users.
- Automated jobs to ease maintenance.
Candidate Info
years in workforce
year at this job
Computing
Informatica Developer
Analysis and integration of legacy asset data to Asset Hub for business reporting.
- Involved in analysis of legacy data from different databases.
- Requirement gathering from users.
- Involved in design and ETL development.
- Involved in creating mapping, session, workflows.
- Create XML file using Informatica ETL.
- Peer design review and documentation of the ETL process.
- MQ series analysis to setup MQ between Informatica and asset hub.
Candidate Info
years in workforce
year at this job
Mca
Lead ETL Solution Designer / Informatica Developer
Designing of Aggregate Tables from Fact and Dimension by understanding the requirement of KPI Reports.
- Development of ETL using Informatica and Oracle.
- Handling daily status and issue call with client along with Team.
- Preparation of Technical Design Document for KPI's and Membership Extract Module.
- Preparing test cases and unit testing of developed ETL's.
- Leading Membership module understanding the requirement from Solution's onshore team.
- Data Profiling.
- Preparation of TSD and delegating the task to Junior team members.
Candidate Info
years in workforce
year at this job
OBIEE 11g/informatica Developer
Translate the business defined metrics and KPI's to OBIEE key Facts and Dimensions.
- Developed Informatica ETL mappings get data from Oracle source system to dataware house
- Developed incremental ETL mapping to get incremental data for nightly loads.
- Performance tuned source qualifier quires in Informatica mappings to get data faster.
- Design and development of OBIEE RPD, report and dashboards.
- Data Reconciliation and validation of OBIEE RPD, reports and dashboards with Business Users.
- Responsible for documenting the design and test results.
- Support and Maintenance of all OBIEE Reports, Dashboards and Applications.
Candidate Info
years in workforce
months at this job
Computer Application
ETL Informatica Developer
Involved in Analysis phase of the business requirement and design of the Informatica mappings.
- Used various transformations of Informatica, such as Source Qualifier Transformation, Expression Transformation, Look-up transformation, Update Strategy transformation, Filter transformation, Router transformation, Joiner transformation etc for developing Informatica mappings.
- Creating sessions and work-flows for the Informatica mappings.
- Configuring sessions for different situations including incremental aggregation, pipe-line partitioning etc.
- Creating mappings with different look-ups like connected look-up, unconnected look-up, Dynamic look-up with different caches such as persistent cache etc.
- Creating various mapplets as part of mapping design.
- Writing Oracle stored procedures and functions for calling during the execution of Informatica mapping or as Pre or Post session execution.
- Writing UNIX shell scripts for execution of the Informatica sessions and work-flows.
- Involved in designing the ETL testing strategies for functional, integration and system testing for Data warehouse implementation.
- Extensively involved in testing by writing some QA procedures, for testing the target data against source data.
Candidate Info
years in workforce
year at this job
Bachelor of Arts
Informatica Developer
Requirements gathering for developing the mappings and datamaps from client.
- Using Informatica power center 9.1 for implementing Texas Child Support project and developing mappings, workflows, sessions etc.
- Workings on different transformations for match and merge consolidation process.
- Worked on balancing process before and after merge consolidation process
- Worked on reusable sources, targets, transformations, mappings, sessions etc.
- Working on informatica power exchange to import mainframe files from admin systems
- Created datamaps with the copybook layouts provided by admins to import mainframe files and doing row test to test the files.
- Imported mainframe files into informatica power center from Informatica power exchange thru power exchange connections and locations
- Documenting and updating the deployment plan, test plans, design plans, production support plan etc.
- Providing oncall support to Infosys offshore team in development and production support.
- Resolving the defects provided by the QA team helping them understand the code and business.
Candidate Info
years in workforce
years at this job
Computer Technology
Computer Science
Data Warehouse / ETL Informatica Developer
- Part of the core team involved in design and development of the Oracle 11g Data Warehouse, for Capital Markets Front Office.
- Used the star schema to build numerous fact and dimension tables to store trades, positions, trading books, pnl attributions, prices etc for both real-time (T0) and end of day (T1) reporting.
- Worked on developing Informatica mappings (designer, workflow manager, workflow monitor etc). Extensively used mapplets, parameter files, autosys.
- Directly worked with trading desk, trade support and middle office to deliver required
- Led 2-3 people teams to bring in marketdata, risk numbers etc from various source systems.
- Worked extensively to support the 24x7 application by putting in data quality checks, control points, day over day validations to ensure data completeness and integrity.
- Worked on transition / migration projects involving derivative, cash products in sizeable hedging portfolios. Tasks included planning activities, identifying failure points, designing efficient ETL processes to seed millions of records.