ETL Informatica Developer Resume Samples

Description :

1. Analyzing the relationships of flat files and extracting the analyzed systems, meeting with end users and business units to define the requirements.
2. Documenting user requirements, translating requirements into system solutions and developing implementation plan and schedule.
3. Extracting data from excel files, high volume of data sets from data files, Oracle, DB2, Salesforce.com (sfdc) using informatica ETL Mappings/SQL PLSQL scripts and loaded to data store area.
4. Developing data mappings between source systems and warehouse components.
5. Developing etl procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into etl procedures.
6. Developing and testing all the backend programs, informatica mappings and update processes.
7. Creating and monitoring batches and sessions using informatica Powercenter server.
8. Responsible to tune ETL procedures and star schemas to optimize load and query performance.
9. Extensively working in the performance tuning of the programs, ETL procedures and processes.
10. Writing documentation to describe program development, logic, coding, testing, changes and corrections.
11. Creating adhoc reports to users in Tableau by connecting various data sources.

Experience

5-7 Years

Level

Senior

Education

MBA

Description :

1. Using Informatica Power Center for extraction, transformation, and load (ETL) of data in the data warehouse.
2. Using Informatica Power Centre tools developed workflows using task developer, worklets designer, and workflow designer in workflow manager and monitored the results using workflow monitor.
3. Expertise in creating packages using SQL server integration services (SSIS).
4. Designing the SSIS packages to transfer data from flat files to SQL server using business intelligence development studio.
5. Working on optimizing and tuning the Teradata views and SQLs to improve the performance of batch and response time of data for users.
6. Using Informatica Power Center 9.6.1 to extract, transform and load data into Netezza data warehouse from various sources like Oracle and flat files.
7. Involving in analyzing/ building teradata EDW using teradata ETL utilities.
8. Using Informatica Power Exchange for loading/retrieving data from the mainframe system.
9. Analyzing the data sources and targets using Informatica data profiling option.
10. Applying slowly changing dimensions like type 1 and 2 effectively to handle the delta loads.

Experience

7-10 Years

Level

Senior

Education

Bachelor Of Engineering

Description :

1. Wrote Unix scripts to call the files from landing zone and process the files.
2. Created pre_etl scripts to validate the files and file format which we receive from the source system.
3. Extracted data from flat files applied business logic to load them in the staging database.
4. Developed mappings/reusable objects/transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center 8.6.1.
5. Wrote Oracle packages and functions to implement business rules and transformations after staging is done.
6. Worked with pre and post sessions, and extracted data from transaction system into staging area.
7. Used Informatica Power Center 8. 6. 1 for extraction, loading and transformation (ETL) of data in the data warehouse.
8. Implemented populate slowly changing dimension to maintain current information and history information in warehouse tables.
9. Used SSIS packages to load date from spreadsheet into the database and also used packages to move data between databases (Oracle, flat-files) on different servers.
10. Created SSIS packages to extract data from oltp to olap systems and scheduled jobs to call the packages and stored procedures.
11. Worked on different data sources such as Oracle, teradata, flat files etc.

Experience

2-5 Years

Level

Senior

Education

BS

Description :

1. Analyzing the business requirements with Business Analyst to develop ETL procedures that are consistent across all systems.
2. Involving in data modeling for SQL server databases to store data retrieved from flat files.
3. Normalizing and de-normalizing the flat files and loading them in SQL server.
4. Creating mappings/sessions and workflows for using Informatica version 9.5.
5. Installing, configuring and upgrading the Informatica powercenter TDM/ILM to 10.1 with all EBFS.
6. Installing and re-configuring and upgrading Informatica Powercenter Suite 
7. Using different types of tasks like decision, timer and event initial/bulk load process wait and command to maintain the dependencies between the sessions and load balancing within informatica workflow.
8. Working with various transformations like router, expression, SQL, lookup, normalizer, and aggregator in building complex mapping.
9. Involving in designing the procedures for getting the data from all the source systems to data warehousing system.

Experience

7-10 Years

Level

Senior

Education

BS

Description :

1. Interacted with the Business Analysts to understand the business & gather technical requirements.
2. Abstracted relational and delimited text file to local environment and developed the code in dev environment.
3. Automated and scheduled recurring reporting processes using Unix shell scripting and teradata utilities.
4. Checked the file formats for the source flat files using Unix shell scripts thereby ensuring input file formats are same as specified.
5. Created mapplet for error handling process to deal with null records.
6. Involved in devops migration/automation processes for building and deploying systems.
7. Developed code for landing environment and then for staging and finally developed incremental load populate the target tables for atomic model.
8. Extensively involved in writing SQL queries (sub queries and join conditions).
9. Worked on powercenter real time edition to run the real-time workflows.
10. This normalized model was used as a staging area for the dimensional model which was Netezza based data warehouse.
11. Worked on aginity workbench to process all the relational objects of Netezza.

Experience

7-10 Years

Level

Senior

Education

College

Description :

1. Involving in translating the business requirements to technical requirements.
2. Teaming up with enterprise information quality & governance office and business data stewards to provide summary results of data quality analysis, which will be used to make decisions regarding how to measure business rules and quality of the data.
3. Documenting at a functional level how the procedures work within the data quality applications.
4. Working on various Informática Power Center components like designer, workflow manager, workflow monitor, repository manager.
5. Extracting the data from various heterogeneous sources like Oracle, SQL Server, flat files and mainframe files.
6. Leading the design, development and implementation of the mdm decommissioning project using Informatica Powercenter that reduced development and implementation cost and time.
7. Workeing on several transformations such as filter transformation, joiner transformation, sequence generator transformation, aggregator transformation, source qualifier transformation, expression transformation, lookup transformation (connected and unconnected), joiner transformation, and router transformation, web services consumer transformation, normalizer transformation and java transformation in informatica power center.
8. Extensively using XML Parser, XML Generator and XML Source qualifier transformations where applicable.

Experience

10+ Years

Level

Consultant

Education

Bachelors Of Engineering

Description :

1. Translated the business requirements into Informatica mappings to build data warehouse by using Informatica designer, which populated the data into the target.
2. Created project plan for development ,Informatica powerexchange and production powercenter upgrade.
3. Worked on Informatica object migration using repository manager and monitoring Informatica repository backups.
4. Designed and developed the ETL frame work and processes using Informatica 9.6.1/8.6, to run on the domain, integration services and nodes.
5. Extracted data from various source systems like Oracle, XML and flat files and loaded into relational data warehouse and flat files.
6. Extensive experience in developing stored procedures, functions, views and triggers, complex SQL queries using QL server, TSQL and Oracle PL/SQL.
7. Performed metadata validation, reconciliation and appropriate error handling in etl processes.
8. Experience in BI/data warehouse projects involving informatica products.
9. Designed and developed complex mappings, from varied transformation logic like unconnected and connected lookups, router, filter, expression, aggregator, joiner, update strategy, stored procedure and more.

Experience

2-5 Years

Level

Junior

Education

MS

Description :

1. Analyzing the source data, coordinating with data warehouse team in developing relational model and participated in the design team and user requirement gathering.
2. Working as a developer in creating complex stored procedures, triggers, functions, indexes tables, views and other T-SQL code and SQL joins for applications. Developed various T-SQL.
3. Storing procedures, functions and packages, built Data Transformation Services (DTS) packages for ETL using DTS wizard, involved in designing er models (logical/physical) for Oracle database to store data retrieved from other sources including legacy systems.
4. Extensively using Informatica Power Center to extract data from various sources and load into staging database.
5. Solving T-SQL performance issues using query analyzer. Parsed the data from XMLs XSD file using XML. transformation. Participating in the detailed level and high-level design documentation of the ETL system and mapping of business rules.
6. Interacting with the business representatives for need analysis and to define business and functional specifications. Retrieving the data from MQ series sources.
7. Working on golden copy of master data management tool of informatica (Informatica MDM).
8. Expertise in the optimization of the performance of the designed workflows processes in informatica and to identify the bottlenecks in different areas after the full volume system run.

Experience

10+ Years

Level

Consultant

Education

Certification

Description :

1. Working with the Business Analysts to gather business requirements and implementing the same into a functional data warehouse design.
2. Involving in creating logical and physical design of data models using Visio.
3. Actively involving in requirements gathering and completing the life cycle of the project.
4. Extensively working on Informatica client tools - source analyzer, warehouse designer, transformation developer, mapplet designer, mapping designer, workflow designer, worklet designer and task developer.
5. Successfully loading data into different targets from various source systems like Oracle database, flat files, xml files etc. Into the staging table and then to the target database.
6. Creating different parameter files and changed session parameters, mapping parameters, and variables at run time.
7. Developing new and maintaining existing Informatica mappings and workflows based on specifications.
8. Creating mapplets, reusable transformations, worklets and used them in different mappings, workflows.
9. Using source qualifier, expression, aggregator, lookup, router, normalizer, sorter, stored procedure transformations to do necessary data calculations and manipulations according to the business rules and loaded data into target systems.

Experience

7-10 Years

Level

Senior

Education

BS

Description :

1. Involving in direct conversations with the business users and gather the requirements to how to handle the source data and design accordingly the ETL process.
2. Using Informatica power center 9.6.1 to extract the data from insurance application AS400 to transform and load the data into the enterprise data warehouse & data mart.
3. Developing the logical data models and physical data models with experience in forward and reverse engineering using Erwin.
4. Involving in Information administration including creating new users and groups, backing up the repository and domain as well as handling various upgrades.
5. Used Informatica B2B data exchange to handle EDI (electronic data exchange) for handling the payments for the scheduled dates.
6. Using major components like parsers, mappers and streamers in data transformation studio for conversion of XML files to other formats.
7. Implementing various data modeling schemas such as star schema and snowflake schema.
8. Using Informatica features to implement type II changes in slowly changing dimension tables.
9. Involving in the development of Informatica mappings and also tuned session by increasing block size for better performance.
10. Using different MDM concept for data transformation, normalization, error -detection and error-correction.
11. Implementing various process of data cleanup and data validation using Informatica data quality.

Experience

7-10 Years

Level

Senior

Education

MS