ETL Developer Resume Samples

Description :

1. Involved in understanding the business requirements and translate them to technical solutions.
2. Worked for preparing design documents and interacted with the data modelers to understand the data model and design.
3. Created new mappings and updating old mappings according to changes in Business logic.
4. Involved in migrating project from UAT to Production.
5. Setting up of the local Informatica environment on the client machines which included the connectivity and access to the data sources, taking the necessary steps to set up the Relational Connectivity variables in the Workflow manager etc.
6. Created XML targets based on various non XML sources.
7. Generated sequence numbers using Informatica logic without using the sequence generator.
8. Used SQL override to perform certain tasks essential for the business.

Experience

0-2 Years

Level

Entry Level

Education

Database

Description :

1. Project: Finance Transformation Program-Financial Processing.
2. Responsibilities: Design, Develop and execute test cases for unit and integration testing.
3. Hands on experience in ETL tool Scalable Architecture Financial Reporting(SAFR) an IBM tool.
4. Worked on creating Extract Views, Summary Views, Copy Input Views in SAFR ETL tool.
5. Created metadata like Logical Records, Physical files, Logical files which are required for Views.
6. Worked on mapping the fields of the Views from the Source LR of the View as per the business requirements.
7. Created dynamic fields and static fields while creating a View.
8. Worked on DB2 (SPUFI) to analyze the differences in the metadata and Views between the SAFR environments prior to merging of the SAFR environments as per the business requirements.

Experience

2-5 Years

Level

Junior

Education

Bachelor Of Engineering

Description :

1. Manually hand coded scripts to perform the Extract, Transform and the Load process on various platforms including MS SQL 7/2000 , Oracle 8i/9i, DB2/400.
2. Performed activities including execution of test plans, design of exception handling strategy and performance tuning.
3. Completed documentation in relation to Data Flow Diagrams DFD , mapping documents and high-level data models.
4. Managed detailed work plans and mentored peers and junior staff in both design and development of ETL Architecture.
5. Key member in defining standards for Informatica implementation.
6. Lead discussions and decision-making groups in determining needs for subject areas.
7. Functional experience and knowledge gained in General Ledger, Sales Order Processing, Supply Chain Management, Advanced Cost Accounting, Health Care Management subject areas of E1 J.D.

Experience

2-5 Years

Level

Executive

Education

Computer Engineering

Description :

1. Responsibilities: Involved in the Data warehouse Data modeling based on the client requirements.
2. Created Data Warehouse Data Modeling used by Erwin.
3. Involved in Preparing Detailed design and technical documents from the functional specifications Prepared low level design documentation for implementing new data elements to EDW.
4. Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
5. Managed and administered a Teradata Production and Development Systems Worked on loading of data from several flat files sources using Teradata MLOAD & FLOAD Updated numerous BTEQ/SQL scripts, making appropriate DDL changes and completed unit test.
6. Involved in writing views based on user and/or reporting requirements Involved in Design, develop and Test process for validation and conditioning data prior to loading into the EDW Created a generic email notification program in UNIX that sends the emails to the production support team if there are any duplicate records or error in load process.
7. Extensively worked on Mapplets, Reusable Transformations, and Worklets there by providing the flexibility to developers in next increments.
8. Extensively worked on Informatica to extract data from flat files and Oracle, and to load the data into the target database.

Experience

5-7 Years

Level

Executive

Education

Information Technology

Description :

1. Responsibilities: Based on the requirements created Functional design documents and Technical design specification documents for ETL Process.
2. Developed the PL/SQL Procedure for performing the ETL operation Interacted with business users, source system owners and Designed, implemented, documented ETL processes and projects completely based on best data warehousing practices and standards.
3. Extensively involved in Informatica Power Center upgrade from version 7.1.3 to version 8.5.1.
4. Designed, developed Informatica mappings, enabling the extract, transform and loading of the data into target tables on version 7.1.3 and 8.5.1.
5. Involved in performance tuning and fixed bottle necks for the processes which are already running in production.
6. Designed and developed a process to handle high volumes of data and high volumes of data loading in a given load window or load intervals.
   
7. Created Workflow, Worklets, and Tasks to schedule the loads at required frequency using Workflow Manager.

Experience

2-5 Years

Level

Executive

Education

Bachelor Of Technology

Description :

1. Responsibilities: Involved in full life cycle development including Design, ETL strategy, troubleshooting Reporting, and Identifying facts and dimensions.
2. Prepared the required application design documents based on functionality required Designed the ETL processes to load data from Oracle, Flat Files (Fixed Width), and Excel files to staging database and from staging to the target Oracle Data Warehouse database.
3. Involved in cleansing and extraction of data and defined quality process for the warehouse.
4. Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
5. Strong Experience on writing SQL Queries, Stored Procedures in Oracle Databases.
6. Developed shell scripts, SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
7. Created documentation on mapping designs and ETL processes.
8. Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.

Experience

2-5 Years

Level

Executive

Education

Engineering

Description :

1. Roles and Responsibilities: Monitoring activities for all the Production related jobs.
2. Resolving the issures on adhoc basis by running the workflows through breakfix area in case of failures.
3. Handling the daily and weekly status calls for the project.
4. Handling meeting related to Production Handover and internal.
5. Monitoring by checking logs and load details,Resolving issues related to long running jobs Implementing the performance tuning techniques in case of long running jobs.
6. Handling the weekly, monthly release activities.
7. Extensively work on triggers, Stored Procedures, Joins, sequences in SQL/PLSQL.

Experience

2-5 Years

Level

Executive

Education

Sociology

Description :

1. Responsibilities:- Develop Mappings and Workflows to load the data into Oracle tables.
2. Developed various transformations like Source Qualifier, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
3. Created Workflows, Tasks, database connections using Workflow Manager Developed complex Informatica mappings and tuned them for better performance Created sessions and batches to move data at specific intervals & on demand using Server Manager.
4. Include creating the sessions and scheduling the sessions Recovering the failed Sessions and Batches.
5. Involving in extracting the data from Oracle and Flat files Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance Understanding the Functional Requirements.
6. Preparation of Test Cases and Executing the Test Cases UAT Tool Involved in System Testing, Regression Testing, Security Testing.
7. Creating the ETL run book and actively participated in all phases of testing.
8. Responsible for identifying the missed records in different stages from source to target and resolving the issue.

Experience

10+ Years

Level

Management

Education

BS in Accounting

Description :

1. Worked on Extraction, Transformation and Loading of data using Informatica.
2. Involved in the design and development of all interfaces using Informatica Powermart tools.
3. Used Debugger to test the mappings and fix bugs.
4. Used Informatica to Extract and Transform the data from various source systems by incorporating various business rules.
5. Developed standards and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, sorter, union, and filter.
6. Created, updated and maintained the ETL technical documentation.
7. Managed Repository Users, Groups and Privileges.
8. Managed user connections and object locks.

Experience

5-7 Years

Level

Executive

Education

Business Administration

Description :

1. Tools: Informatica Power Center 8.6.x, Sql developer Responsibilities: Developed ETL programs using Informatica to implement the business requirements.
2. Communicated with business customers to discuss the issues and requirements.
3. Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
4. Performance tuning was done at the functional level and map level.
5. Used relational SQL wherever possible to minimize the data transfer over the network.
6. Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
7. Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
8. Mappings, Sessions, Workflows from Development to Test and then to UAT environment.

Experience

7-10 Years

Level

Consultant

Education

Dental Assistant

Description :

1. Responsibilities: Extracted data transformed and loaded into Oracle database according to the specifications.
2. Used various transformations like lookup transforming the Sales Force Data according to the business logic update strategy, router, filter, sequence generator, source qualifier/Joiner on data and extracted as per the technical specifications.
3. Created Mapplets using Mapplet Designer to reuse Mapplets in the mappings.
4. Experience in performing the analysis, design, and programming of ETL processes for Teradata.
5. EDI Standard Evolution and Migration Solution Speciation-Driven Transformation Used by Informatica to provide up-to-the-minute pre-built transformations in support of industry standards.
6. Created debugging sessions before the session to validate the transformations and also used existing mappings in debug mode extensively for error identification by creating break points and monitoring the debug monitor.
7. Improved the performance of the mappings by moving the filter transformations early into the transformation pipeline, performing the filtering at Source Qualifier for relational databases and selecting the table with fewer rows as master table in joiner transformations.
8. Created partitions, and SQL Over ride in source qualifier for better performance.

Experience

2-5 Years

Level

Junior

Education

Database

Description :

1. Responsibilities: Worked with business analysts for requirement gathering, business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.
2. Worked on complete life cycle from Extraction, Transformation and Loading of data using Informatica.
3. Analyzed the system for the functionality required as per the requirements and created System Requirement Specification document (Functional Requirement Document).
4. Involved in the development of the conceptual, logical and physical data model of the star schema using ERWIN.
5. Extensively used Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
6. Extensive experience in Design and Developing Informatica Packages for Equity Capital Market.
7. Designed and developed daily audit and daily/weekly reconcile process ensuring the data quality of the Data warehouse.
8. Developed various mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.

Experience

5-7 Years

Level

Consultant

Education

Dental Assistant

Description :

1. Interacted with users extensively in gathering the requirements and analyzing the needs of the end users.
2. Design, Develop and Deploy reports in MS SQL Server environment using SSRS-2008 Understanding the various complex reporting requirement of company and creating web reports using Reporting Services Extensively formatted reports into documents using SSRS Report Builderfor creation of Dashboards.
3. Developed reports using SSRS 20052008 to generate all daily, weekly, monthly and quarterly Reports based on the user business requirements.
4. Part of team for analyzing and implementing the physical design for the database.
5. Responsible for drafting and documentation for describing the metadata and writing technical guides.
6. Created Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic.
7. Analyzed and tuned complex Queries/Stored Procedures in SQL Server 2008 for faster execution and developed database structures.
8. Created and managed database objects (tables, views, indexes, etc.) per application specifications.

Experience

0-2 Years

Level

Entry Level

Education

Diploma

Description :

1. Responsibilities: Coordinated with Business Users for requirement gathering, business analysis to understand the business requirement and to prepare Technical Specification documents (TSD) to code ETL Mappings for new requirement changes.
2. Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
3. Involved in massive data cleansing prior to data staging from flat files.
4. Implemented slowly changing dimensions Type 2.
5. Set up batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
6. Extensively worked on Maestro to schedule the jobs for loading data into the targets.
7. Utilized SSIS (SQL Server Integration Services) to produce a Data Warehouse for reporting.
8. Estimation, Requirement Analysis and Design of mapping document and Planning for Informatica ETL.

Experience

2-5 Years

Level

Executive

Education

Bachelor Of Technology

Description :

1. Responsibilities: Managing the RDW Protocol Programs, to load the repair flat files provided by ASC repair centers.
2. Worked in Production Support environment for Major / Small / Emergency projects, maintenance requests, bug fixes, enhancements, data changes, etc.
3. Wrote conversion scripts using SQL, PL/SQL, stored procedures and packages to migrate data from ASC repair Protocol files to Oracle database.
4. Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.
5. Involved in Performance tuning of Oracle Databases, by creating Partitions and indexes on the database tables.
6. Improved the performance of the application by rewriting the SQL queries and PLSQL Procedures.
7. Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
8. Trouble shooting implementation / post implementation issues.

Experience

7-10 Years

Level

Management

Education

IT Technology

Description :

1. Responsibilities: Design, Develop and Implementation of ETL jobs to load internal and external data into data mart.
2. Worked closely with business team to gather requirements.
3. Developed the Source-Target Mapping for each Dimension and Fact tables.
4. Develop and modify ETL jobs to meet monthly and quarterly report needs.
5. Developed ETL processes to load data into fact tables from multiple sources like Files, Oracle, Teradata and SQL Server databases.
6. Extracted data from Oracle database transformed and loaded into Teradata database according to the specifications.
7. Used Teradata utilities like Multi Load, T Pump, and Fast Load to load data into Teradata data warehouse from Oracle and DB2 databases.
8. Wrote appropriate code in the conversions as per the Business Logic using BTEQ scripts and Solved Various Defects in Set of wrapper Scripts which executed the Teradata BTEQ, MLOAD, FLOAD utilities and Unix Shell scripts.

Experience

5-7 Years

Level

Executive

Education

Diploma

Description :

1. Responsibilities: Interacted with business representatives for requirement analysis and to define business and functional specifications.
2. Delivered responsibilities as Analyst and Programmer including interaction with Business Users to Gathering requirements, Created Technical Specifications, Design, Development and Maintenance.
3. Analyzed source data, extracted, transformed, and loaded data in to target data warehouse based on the requirement specification using Informatica Powercenter.
4. Developed data Mappings between source and target systems using Mapping Designer.
5. Involved in complete SDLC including analysis, design, development, implementation, QA and maintenance of various software applications.
6. Worked with various heterogeneous sources such as Oracle10g, Teradata and Flat Files to load the data into the target Oracle data warehouse.
7. Developed complex Informatica mappings using Filter, Sorter, Aggregator, Look up, stored procedure, Joiner, Router transformations for populating target table.
8. Written Scripts for Teradata Utilities (Fastexport, MLoad and Fast Load) Written PL/SQL stored procedures in Oracle and used in mapping to extract the data.

Experience

10+ Years

Level

Senior

Education

B.E. In Computer Science

Description :

1. Interpreted and comprehend business/data requirements from upstream processes.
2. Documented technical requirement specifications and detailed designs for ETL processes of moderate and high complexity.
3. Created and documented source-to-target mappings and ETL specifications Performed Root cause analysis and resolved complex issues.
4. Involved all phases of the project life cycle such as analysis, design, coding, testing, production and post-production.
5. Created detailed documentation including ETL source-to-target mapping, high level ETL architecture, ETL design, test cases, test scripts, and code migration.
6. Extensively working on Repository Manager, Informatica Designer, Workflow Manager and Workflow Monitor.
7. Created complex mappings, complex mapplets and reusable transformations in Informatica Power Center Designer.
8. Created transformations and used Source Qualifier, Application Source Qualifier, Normalizer, Aggregator, Expression, Sequence Generator, Filter, Router, Look up and Update Strategy, and Stored Procedure to meet client requirements.

Experience

0-2 Years

Level

Entry Level

Education

Bachelor Of Science

Description :

1. Responsibilities: Involved in analysis, design, development and enhancement of the application that applies business rules on the Transportation and Sales Data.
2. Created Logical and Physical Data Models for the Data Marts Transportation and Sales.
3. Created SSIS package to get data from different sources, consolidate and merge into one single source.
4. Created functional requirement specifications and supporting documents for business systems.
5. Extracted data from various sources like SQL Server 2005, DB2, .CSV, Excel and Text file from Client servers.
6. Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.
7. Created Mail Tasks with the error file attachments using package Variable.
8. Created and maintained Database Maintenance plans and also created logins and assigned roles and granted permissions to users and groups.

Experience

7-10 Years

Level

Management

Education

Business Administration

Description :

1. Responsibilities: Requirement gathering and Business Analysis.
2. Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
3. Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
4. Defined various facts and Dimensions in the data mart including Fact less Facts, Aggregate and Summary facts.
5. Reviewed source systems and proposed data acquisition strategy.
6. Designed and Customized data models for Data Mart supporting data from multiple sources on real time.
7. Designed the Data Mart defining Entities, Attributes and relationships between them.
8. Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.

Experience

0-2 Years

Level

Entry Level

Education

BSc In Computer Science