Informatica developers are also called as ETL developers. These developers assist the company in data sourcing and data storage. Included in the Informatica Developer Resume are tasks such as – developing and implementing ETL processes, coding, and testing complex programs, recording all specifications that are needed in coding and development process, ensuring that standard requirements are met while performing technical analysis, and improving session performance.
The Informatica developers should be familiar with ETL tools and demonstrate quick and constant learning abilities; they should be flexible enough to adapt to the current developing technologies, these developers should also be familiar with various software and development practices and have the potential to validate huge amounts of data. Informatica developers normally have a degree in computer science or it’s associated, but some employers consider a strong programming background in lieu of an academic qualification.
Objective : Over 7 years of IT experience in Informatica PowerCenter in all phases of Analysis, Design, Development, Implementation and support of data warehousing applications using Informatica Power Center.
Skills : Informatica Power Center 9.x/8.x/7.1, PowerMart, Power.
Coventry Health Care is a diversified nationally managed health care company based on Maryland.
Coventry Health Care committed to provide high quality health care services at an affordable price.
The company provides a wide range of health plans, health insurance, and risk and fee-based manages care products and services to a broad cross section of individuals, employer and government-funded groups, government agencies, and other insurance.
Coventry Health Care is the third most successful prescription drug plan service in the United States.
Involved and understanding the Business requirements/ discuss with Business Analyst, analyzing the requirements and preparing business rules.
Design and Developed complex mappings by using Lookup transformation, Expression, Sequence generator, Update, Aggregator, Router, Stored Procedure to implement complex logics while create mappings.
Developed mappings using Informatica to load the data from sources such as Relational tables, Flat files, Oracle tables into the target Data warehouse.
Developed mappings/Transformation/mapplets by using mapping designer, transformation developer and mapplets designer using Informatica PowerCenter.
ETL- Informatica Developer Resume
Objective : 7+ years of experience in Software Development and Expertise in Informatica 9.x/8.x/7.x Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
Skills : Informatica Power Center, SDLC,ETL tools,OLAP,OLTP,PLSQL etc.
Extensively worked on the Informatica Power Center 9.0 tools -Designer, Workflow Manager, Workflow monitor.
Extensively created mapping/Mapplets, reusable transformations using all the transformations like Joiner, lookup, filter, expression, stored procedure, aggregator, update strategy, worklets etc.
Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
Created various tasks like Session, Command, Timer and Event wait.
Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
Extensively worked with the QA team to get the system and Integration testing done successfully and involved in ETL testing, Created Unit test plan and Integration test plan to test the mappings, created test data.
Involved in preparing material and training Business users Implemented slowly changing Dimensions (SCD, Both Type 1 & 2).
Sr. Informatica Developer Resume
Objective : Over 8+ years of overall IT exposure with InformaticaPowerCenterin all phases of Analysis, Design, Development, Implementation and support of DataWarehousing applications using InformaticaPowerCenter9.6.1, HBase, Pig, Hive, Hadoop, HDFS, Big Data. Experienced on working with Big Data and Hadoop File System (HDFS). Hands on experience in working with Echosystems like Hive, Pig, Sqoop, Map Reduce, Flume, Oozie.
Skills : Oracle 8i/9i/10g, Microsoft SQL Server 2008, MS Access Testing Tools HP Quality Center, Informatica 8.0/9.0, SQL Developer, MS Office, Windows, Linux, UNIX.
To develop a repeatable process with a designated business process owner that will enable Blue Shield to comply with the Massachusetts and Vermont registration and reporting requirements and to respond to similar mandates in other states.
Analyze requirements from Business users Perform data analysis for any requirement and provide source to target mapping rule document Data validation/profiling by writing complex SQL queries by joining several tables.
Identifying the source to target mapping attributes under different source systems in BS Designed data models to support user's business requirements.
Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL Power Center.
Used the Slowly Changing Dimensions wizard (type 2) to update the data in the target dimension tables.
Created sessions, database connections and batches using Informatica Server Manager/Work flow Manager.
Optimized mappings, sessions/tasks, source, and target databases as part of the performance tuning.
Jr. Informatica Developer Resume
Objective : Strong knowledge in Informatica Administration including Installation, up-gradation, Configuration, maintenance and troubleshooting Involved in the full development lifecycle from requirements gathering through development.
Skills : Informatica power center, shell scripting, Tidal, Oracle, SQL server, workflow manager, Autosys.
Involved in full Software Development Life Cycle (SDLC) - Business Requirements Analysis, preparation of Technical Design documents, Data Analysis, Logical and Physical database design, Coding, Testing, Implementing, and deploying to business users.
Providing technical support and guidance to the offshore team to address complex business problems.
Involved in gathering business requirements, logical modelling, physical database design, data sourcing and data transformation, data loading, SQL and performance tuning.
Defining the schema, staging tables, and landing zone tables, configuring base objects, foreign-key relationships, complex joins, and building efficient views.
Expertise in writing scripts for Data Extraction, Transformation and Loading of data from legacy systems to target data warehouse using BTEQ, Fastload, Multiload, and TPump.
Performed Query Optimization with the help of explain plans, collect statistics, Primary and Secondary indexes.
Used volatile table and derived queries for breaking up complex queries into simpler queries.
Informatica Developer III Resume
Objective : Around 7 years of professional experience in Information Technology with extensive experience in development of various projects using Data Warehousing tools like Informatica and databases like Oracle, SQL Server, Teradata and DB2 UDB. Strong experience with large and midsize data warehousing implementation using Informatica Power center/ power mart, Oracle , SQL server, UNIX and Windows platforms.
Skills : ETL, SQL, Data Warehouse, Pl/Sql.
Analyzed the requirements to identify the necessary tables that need to be populated into the staging database Created mappings using transformations like Source Qualifier, Aggregator, Expression, lookup, Router, Filter, Update Strategy, Joiner, Union, and Stored procedure, and XML transformations.
Worked on Informatica Power Center tools - Source Analyzer, Warehouse Designer, Mapping &Mapplet Designer, and Transformation Developer.
Converted existing PL/SQL Packages to ETL Mappings using Informatica Power Center.
Used Error handling strategy for trapping errors in a mapping and sending errors to an error table.
Implemented parallelism in loads by partitioning workflows using Pipeline, Round-Robin, Hash, Key Range and Pass-through partitions.
Worked on Exchange Management Console (EMC) or the Exchange Management Shell (EMS) related topics.
Extensively involved in performance tuning, recommending SQL queries for better performance.
Automated the process of starting and stopping dtlcacon/pwxccl process by creating a shell script.
Informatica Developer II Resume
Headline : Over 8 years used Informatica Client Tools - Designer, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager and Workflow Monitor. Creating ETL mappings using Informatica PowerCenter to move data from multiple sources such as XML, DB2, Teradata, MS SQL Server, flat files, and Oracle into a common target area such as data marts and data warehouse.
Skills : Informatica, Oracle.
Gathering requirements and creating technical specifications based on client functional specifications Experience with high volume datasets from various sources like Oracle, Text Files.
Creating onetime data migrations of all conversions to the JDE Edwards enterprise one system Working with business units to identify mapping specifications.
Created the ETL test plans and implemented the Code Review, Formal Testing, and Specification Testing using the Test Director.
Implementing the standardized process to archive flat files and for loading indicator files.
Used the Informatica Data Exchange to connect to the Main frame's source and extract the data.
Utilizing the MS Access database for the conversions that are (one time data conversions) for translations that are in Excel or CSV format.
Following a standard approach to creating shortcuts for sources in the shared folder (JD World) and targets in the shared folder (JDE One World), naming conventions, and abbreviations Creating applets and reusable transformations.
Informatica Developer I Resume
Headline : About 11 years of IT experience in Software Analysis, Design, and Development for various software applications in client-server environment in providing Business Intelligence Solutions in Data Warehousing for Decision Support Systems, OLAP, OLTP Application Development, and worked on the Database Application Development.
Skills : Informatica power center.
Prepared the Technical Specs, Reverse Engineered Logical designs using Erwin, Flow diagrams and Timeline sheets to facilitate development of Informatica Flows.
Implemented Star Schema for de-normalizing data for faster data retrieval for Online Systems.
Designed and Developed Mappings, sessions and workflows in Informatica.
Extracted, transformed data from various sources such as Flat files, Oracle 11g and transferred data to the target data warehouse Oracle 11g and XLS files.
Explore prebuilt ETL metadata, including Informatica workflows and mappings and DAC metadata.
Used Informatica and the Data Warehouse Administration Console (DAC) to configure ETL metadata and run an execution plan to load Oracle E-Business Suite (EBS) data into the OBAW.
Customized SDE andSIL mappings using Informatica Power Center Designer in order to add new columns to the Dimension/Fact table in Oracle Business Analytics Warehouse from Oracle EBS Source.
Designed and developed Informatica Mapping for data load and data cleansing.
Informatica Developer/Software Developer Resume
Objective : Over 7+ years of experience as an ETL Developer with the development of ETL's for Data warehouse/Data Migration using Informatica Powercenter version and SSIS (SQL Server Integration Services) ETL tools.
Skills : SQL, ETL, Informatica , Data warehousing , Data modeling, Testing, Unix, PL/SQL, Tableau, Cognos, Qlik view.
Worked with business analysts for requirement gathering, business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.
Extensively worked on Power Center 9.1 Designer client tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
Worked on Teradata and oracle 11g databases.
Develop and execute load scripts using Teradata client utilities MULTILOAD, FASTLOAD and BTEQ.
Extensively worked on Transformations like Lookup, Joiner, SQL and Source Qualifier Transformations in the Informatica Designer.
Implemented Slowly Changing Dimensions (Type 1, Type 2 and Type 3).
Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
Modify and develop new ETL programs, transformations, indexes, data staging areas, summary tables, and data quality routine based upon redesign activities.
Bachelor Of Engineering
Informatica Developer I Resume
Objective : 8+years of diverse experience in the field of Information Technology with emphasis on Data warehousing and specifically Informatica Power Center. Varied experience in Analysis, Design, Development of various business applications.
Skills : IT, Software Developer.
Analyze the Impacts of the upgraded Source Systems on the existing Interfaces and Cognos based Applications.
Interact with the Business Analysts and System Architects for understanding the impacts on downstream Interfaces and Applications.
Worked Informatica Power Center tools like Source Analyzer, Mapping Designer, Mapplet and transformations.
Facilitated meetings with Business users to explain the impacts of the Source System upgrades and gathered requirements for any enhancements needed for the existing Interface and Cognos applications.
AnalyzedMaterialized Views, which are basis for the Cognos cubes to find any discrepancies from the previous versions.
Coordinate with the downstream application teams to make sure the enhancement work is in line with the source systems.
Enhance the existing ETL to accommodate the upgraded changes and making sure it runs smoothly without affecting the overall process.
Configuring the command tasks, session tasks and Worklets to accommodate the new changes.
Informatica Developer/Engineer Resume
Summary : 8 years of experience in Analysis, Design, Development, Implementation, Modeling, Testing, and Support for Data Warehouse applications. PAS Founders Club Outstanding Performance.
Skills : Software Developer, ETL Developer.
Understanding of the business requirements and translating them to data warehouse architectural design.
Involved in Dimensional Modeling to re-design the existing star schema and identified new facts and dimensions for the existing architecture.
Involved in the development of functional specifications and converting them into technical specifications.
Involved in preparing technical requirement documents which included both macro-level and micro-level design documents.
Extensively used Informatica PowerCenter 9.1 to create mappings to load the data warehouse from the OLTP systems.
Worked Extensively on Informatica tools -Repository Manager, Designer and Workflow Manager and Workflow Monitor.
Designed and developed mappings for exception management process for the fact tables.
Experience in working with Business Analysts to identify, study and analyze the requirements and translated them into ETL code in Requirement Analysis Phase.
Informatica Developer/Analyst Resume
Objective : 8+ years of total IT experience in Software Development Life Cycle (SDLC) with strong background in Database Development and ETL Data Warehousing using Informatica PowerCenter.
Skills : Developer, Java, C, Engineer.
Involved in designing Source to Target mapping documents and loading strategies as a part of requirements gathering.
Worked with Kimball's Data Modeling concepts including data modeling, data marts, dimensional modeling, star and snowflake schema, fact aggregation and dimension tables, slowly changing dimensions and surrogate keys.
Designed the procedures for getting the data from many source systems to Data Warehouse.
Developed mappings using Mapplets & various sources involving flat files, XML files and Relational tables.
Extensively used ETL to load Flat files, XML files, Oracle and legacy data as sources and Oracle, Flat files as targets.
Worked extensively with complex mappings using expressions, aggregators, filters, and lookups.
Worked on Power Center Designer tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
Involved in writing procedures, functions in PL/SQL.
Informatica Developer Resume
Summary : Over 8 years of extensive experience in Information Technology with special emphasis on Design and Development of Data Warehousing using Informatica Power Center Involved in Full Life Cycle Development (Waterfall & Agile) of building a Data Warehouse on Windows and Unix Platforms.
Skills : Healthcare Insurance, Investment Banking, Financial, and Retail Industries.
Involved in gathering and reviewing business requirements.
Involved in designing the specifications, Design Documents, Data modeling and design of data warehouse.
Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
Created the repository manager, users, user groups and their access profiles.
Created Logical & Physical models and used Erwin for data modeling and Dimensional Data Modeling.
Created complex mappings in Power Center Designer using Expression, Filter, and Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
Created connected and unconnected Lookup transformations to look up the data from the source and target tables.
Modeling and populating the business rules using mappings into the Repository for Meta Data management.