Informatica Developer Resume Samples

Description :

1. Coventry Health Care is a diversified nationally managed health care company based on Maryland.
2. Coventry Health Care committed to provide high quality health care services at an affordable price.
3. 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.
4. Coventry Health Care is the third most successful prescription drug plan service in the United States.
5. Involved and understanding the Business requirements/ discuss with Business Analyst, analyzing the requirements and preparing business rules.
6. Design and Developed complex mappings by using Lookup transformation, Expression, Sequence generator, Update, Aggregator, Router, Stored Procedure to implement complex logics while create mappings.
7. Developed mappings using Informatica to load the data from sources such as Relational tables, Flat files, Oracle tables into the target Data warehouse.
8. Developed mappings/Transformation/mapplets by using mapping designer, transformation developer and mapplets designer using Informatica PowerCenter.

Experience

2-5 Years

Level

Junior

Education

IT Technology

Description :

1. Extensively worked on the Informatica Power Center 9.0 tools -Designer, Workflow Manager, Workflow monitor.
2. Extensively created mapping/Mapplets, reusable transformations using all the transformations like Joiner, lookup, filter, expression, stored procedure, aggregator, update strategy, worklets etc.
3. Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
4. Created various tasks like Session, Command, Timer and Event wait.
5. Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
6. 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.
7. 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.
8. Involved in preparing material and training Business users Implemented slowly changing Dimensions (SCD, Both Type 1 & 2).

Experience

2-5 Years

Level

Executive

Education

Software Engineering

Description :

1. 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.
2. 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.
3. Identifying the source to target mapping attributes under different source systems in BS Designed data models to support user's business requirements.
4. 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.
5. Used the Slowly Changing Dimensions wizard (type 2) to update the data in the target dimension tables.
6. Created sessions, database connections and batches using Informatica Server Manager/Work flow Manager.
7. Optimized mappings, sessions/tasks, source, and target databases as part of the performance tuning.

Experience

0-2 Years

Level

Executive

Education

IT

Description :

1. 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.
2. Providing technical support and guidance to the offshore team to address complex business problems.
3. Involved in gathering business requirements, logical modelling, physical database design, data sourcing and data transformation, data loading, SQL and performance tuning.
4. Defining the schema, staging tables, and landing zone tables, configuring base objects, foreign-key relationships, complex joins, and building efficient views.
5. 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.
6. Performed Query Optimization with the help of explain plans, collect statistics, Primary and Secondary indexes.
7. Used volatile table and derived queries for breaking up complex queries into simpler queries.

Experience

2-5 Years

Level

Junior

Education

Diploma

Description :

1. 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.
2. Worked on Informatica Power Center tools - Source Analyzer, Warehouse Designer, Mapping &Mapplet Designer, and Transformation Developer.
3. Converted existing PL/SQL Packages to ETL Mappings using Informatica Power Center.
4. Used Error handling strategy for trapping errors in a mapping and sending errors to an error table.
5. Implemented parallelism in loads by partitioning workflows using Pipeline, Round-Robin, Hash, Key Range and Pass-through partitions.
6. Worked on Exchange Management Console (EMC) or the Exchange Management Shell (EMS) related topics.
7. Extensively involved in performance tuning, recommending SQL queries for better performance.
8. Automated the process of starting and stopping dtlcacon/pwxccl process by creating a shell script.

Experience

2-5 Years

Level

Executive

Education

Databases

Description :

1. Gathering requirements and creating technical specifications based on client functional specifications Experience with high volume datasets from various sources like Oracle, Text Files.
2. Creating onetime data migrations of all conversions to the JDE Edwards enterprise one system Working with business units to identify mapping specifications.
3. Created the ETL test plans and implemented the Code Review, Formal Testing, and Specification Testing using the Test Director.
4. Implementing the standardized process to archive flat files and for loading indicator files.
5. Used the Informatica Data Exchange to connect to the Main frame's source and extract the data.
6. Utilizing the MS Access database for the conversions that are (one time data conversions) for translations that are in Excel or CSV format.
7. 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.

Experience

5-7 Years

Level

Management

Education

Diploma

Description :

1. Prepared the Technical Specs, Reverse Engineered Logical designs using Erwin, Flow diagrams and Timeline sheets to facilitate development of Informatica Flows.
2. Implemented Star Schema for de-normalizing data for faster data retrieval for Online Systems.
3. Designed and Developed Mappings, sessions and workflows in Informatica.
4. 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.
5. Explore prebuilt ETL metadata, including Informatica workflows and mappings and DAC metadata.
6. 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.
7. 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.
8. Designed and developed Informatica Mapping for data load and data cleansing.

Experience

5-7 Years

Level

Executive

Education

Diploma

Description :

1. Worked with business analysts for requirement gathering, business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.
2. Extensively worked on Power Center 9.1 Designer client tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
3. Worked on Teradata and oracle 11g databases.
4. Develop and execute load scripts using Teradata client utilities MULTILOAD, FASTLOAD and BTEQ.
5. Extensively worked on Transformations like Lookup, Joiner, SQL and Source Qualifier Transformations in the Informatica Designer.
6. Implemented Slowly Changing Dimensions (Type 1, Type 2 and Type 3).
7. Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
8. Modify and develop new ETL programs, transformations, indexes, data staging areas, summary tables, and data quality routine based upon redesign activities.

Experience

2-5 Years

Level

Executive

Education

Bachelor Of Engineering

Description :

1. Analyze the Impacts of the upgraded Source Systems on the existing Interfaces and Cognos based Applications.
2. Interact with the Business Analysts and System Architects for understanding the impacts on downstream Interfaces and Applications.
3. Worked Informatica Power Center tools like Source Analyzer, Mapping Designer, Mapplet and transformations.
4. 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.
5. AnalyzedMaterialized Views, which are basis for the Cognos cubes to find any discrepancies from the previous versions.
6. Coordinate with the downstream application teams to make sure the enhancement work is in line with the source systems.
7. Enhance the existing ETL to accommodate the upgraded changes and making sure it runs smoothly without affecting the overall process.
8. Configuring the command tasks, session tasks and Worklets to accommodate the new changes.

Experience

2-5 Years

Level

Junior

Education

Diploma

Description :

1. Understanding of the business requirements and translating them to data warehouse architectural design.
2. Involved in Dimensional Modeling to re-design the existing star schema and identified new facts and dimensions for the existing architecture.
3. Involved in the development of functional specifications and converting them into technical specifications.
4. Involved in preparing technical requirement documents which included both macro-level and micro-level design documents.
5. Extensively used Informatica PowerCenter 9.1 to create mappings to load the data warehouse from the OLTP systems.
6. Worked Extensively on Informatica tools -Repository Manager, Designer and Workflow Manager and Workflow Monitor.
7. Designed and developed mappings for exception management process for the fact tables.
8. Experience in working with Business Analysts to identify, study and analyze the requirements and translated them into ETL code in Requirement Analysis Phase.

Experience

7-10 Years

Level

Management

Education

Computer Engineering

Description :

1. Involved in designing Source to Target mapping documents and loading strategies as a part of requirements gathering.
2. 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.
3. Designed the procedures for getting the data from many source systems to Data Warehouse.
4. Developed mappings using Mapplets & various sources involving flat files, XML files and Relational tables.
5. Extensively used ETL to load Flat files, XML files, Oracle and legacy data as sources and Oracle, Flat files as targets.
6. Worked extensively with complex mappings using expressions, aggregators, filters, and lookups.
7. Worked on Power Center Designer tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
8. Involved in writing procedures, functions in PL/SQL.

Experience

2-5 Years

Level

Executive

Education

IT

Description :

1. Involved in gathering and reviewing business requirements.
2. Involved in designing the specifications, Design Documents, Data modeling and design of data warehouse.
3. 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.
4. Created the repository manager, users, user groups and their access profiles.
5. Created Logical & Physical models and used Erwin for data modeling and Dimensional Data Modeling.
6. Created complex mappings in Power Center Designer using Expression, Filter, and Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
7. Created connected and unconnected Lookup transformations to look up the data from the source and target tables.
8. Modeling and populating the business rules using mappings into the Repository for Meta Data management.

Experience

7-10 Years

Level

Management

Education

Bachelor Of Technology