ETL Developer Resume Samples

ETL developers load data into the data warehousing environment for various businesses. The job description entails the ETL developers to execute the following tasks – copying data, extracting data from business processes and loading them into the data warehouse, keeping the information up-to-date, taking responsibility of designing the data storage system, testing and troubleshooting before it goes live. Other duties include – ensuring smooth workflow, designing the best ETL process and drafting database design in various forms like star and snowflake schemas.

Though the ETL developers should have a broad technical knowledge, it is also mandatory for these developers to highlight in the ETL Developer Resume the following skill sets – analytical mind, communication skills, a good knowledge of various coding language used in ETL process, a good grasp of SQL, JAVA, data warehouse architecture techniques, and technical problem skills. To be considered for this position, candidates are expected to depict an engineering degree in computer science or IT.

 

ETL Developer Resume

Objective : Over 8+ years of experience in Information Technology with a strong back ground in Analyzing, Designing, Developing, Testing, and Implementing of Data Warehouse development in various domains such as Banking, Insurance, Health Care, Telecom and Wireless.

Skills : Microsoft SQL Server 2005, 2008, 2012, Oracle 10G and Oracle 11, SQL Server BIDS, Microsoft Visual Studio 2012, Team Foundation Server, Microsoft Visio, Toad for Oracle, Toad for Data Modeler, Peoplesoft CRM.

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.
Years of Experience
Experience
0-2 Years
Experience Level
Level
Entry Level
Education
Education
Database


ETL Developer/Analyst Resume

Objective : Experienced in cluster configuration set up for Hadoop, Spark Standalone, Cassandra database. Experienced in processing the large volume of data using the Hadoop MapReduce, Spark frameworks.

Skills : Spark, Scala, SparkSql, HDFS, Sqoop, MapReduce, Hive, Pig, Cassandra, DB2, ETL Datawarehouse, SQL.

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.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelor Of Engineering


Business Analysis & ETL Developer Resume

Objective : Over 12 years of IT experience and around 6 years of managing and leading multiple teams working on Business Intelligence, Data Modeling, Warehousing and Analytics. Proficiency with various Business Intelligence, Data Warehousing and OLAP technologies. Proficiency with Business intelligence systems study, design, development and implementation of applications and Client/Server technologies Proficiency with Data Modeling tools like Erwin to design the schema and do a forward/reverse engineer the model onto or from a database.

Skills : teradata, informatica, unix, mainframe.

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.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Computer Engineering

ETL Developer/Database Resume

Headline : Around 8+ years of extensive experience in ETL (Extract Transform Load), Data Integration, Data Profiling, Data Mapping, Data Warehousing using Informatica, Teradata and Oracle technologies. Experience in Data Modeling involving both Logical and Physical modeling using DM tools Erwin and ER Participated in full Software Development Life Cycle (SDLC) of the data warehousing project; project planning, business requirement analysis, data analysis, logical and physical database design, setting up the warehouse physical schema and architecture, developing reports, security and deploying to end users Extensive experience in Design, develop and test processes for loading initial data into a data warehouse Strong knowledge in Data Warehousing concepts, hands on experience using Teradata utilities (BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, Teradata Administrator, SQL Assistant, Pmon, Data mover), UNIX Very good understanding of Teradata UPI and NUPI, secondary indexes and join indexes.

Skills : informatica, teradata, Oracle, maestro, Unix Administration.

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.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Information Technology

SQL/ETL Developer Resume

Objective : Over 8+ years of extensive experience in the field of Information Technology. Experience in providing Business Intelligence solutions in Data warehousing and Decision Support Systems using Informatica. Work with data analysts and developers, Business Area, and Subject Matter Experts(SME) performing development activities across all phases of project development lifecycle. Apply data warehousing principles and best practices to development activities.

Skills : Microsoft Business Suite, SQL Server Management Studio.

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.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bachelor Of Technology

ETL Developer/SQL Developer Resume

Objective : Over 10 years of experience in Information Technology with a strong background in Database development and Data warehousing and nearly 8 years of experience in ETL process using Informatica Power Center, Good knowledge of Data warehouse concepts and principles.

Skills : SQL.

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.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Engineering

Informatica ETL Developer Resume

Objective : Over 8 years of IT experience with involvement in Analysis, Design and Development of different ETL applications and using Business Intelligence Solutions in Data Warehousing and Reporting with different databases on Windows and UNIX working frameworks. Strong experience in providing ETL solutions using Informatica Powercenter 9.x/8.x/7.x Highly proficient in integrating data from multiple sources involving Teradata, Oracle, Microsoft SQL Server, DB2 and files like Delimited, Fixed width & VSAM files.

Skills : Verbal and written communication, technical writing, database support, server scripting, data mining, computer architecture support, technical programming and integration skills, classroom instruction experience, project management, transportation industry exposure, medical field experience.

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.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Sociology

Lead ETL Developer Resume

Summary : A detail oriented professionalwith over 8 years of experience in Analysis, Development, Testing, Implementation and Maintenance of Data Warehousing/Integration projects and knowledge on administrator part as well. Extensive experience in gathering and analyzing requirements, Gap Analysis, Scope Definition, Business Process Improvements, Project Tracking, Risk Analysis, and Change ControlManagement.

Skills : Talend, ETL, SQL, Big Data.

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.
Years of Experience
Experience
10+ Years
Experience Level
Level
Management
Education
Education
BS in Accounting

Informatica ETL Developer Resume

Headline : Accomplished and results driven professional with years of experience and an outstanding record of accomplishments providing technology solutions that meet demanding time constraints. I exceed expectations on a consistent basis. Expertly develop scalable solutions that dramatically improve efficiency, productivity, and profitability.

Skills : Oracle 9x/10/x/11x, Informatica 7x/8/9x, PL/SQL, Oracle Warehouse Builder 10x/11x, Business Analysis, Data Warehousing.

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.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Business Administration

ETL Developer II Resume

Summary : Overall 6+ years of IT Experience in the areas of Data warehousing, Business intelligence, and SharePoint, covering different phases of the project lifecycle from design through implementation and end-user support, that includes; Extensive experience with Informatica Powercenter 9.5 (ETL Tool) for Data Extraction, Transformation and Loading. Reporting experience with tools like OBIEE 11g, Tableau. Analyzed Source Systems, Business Requirements, Identify and Document Business Rules for Decision Support Systems.

Skills : Tableau.

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.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Consultant
Education
Education
Dental Assistant

Junior ETL Developer Resume

Objective : Over 6+ years of experience in Analysis, Development, and Implementation of business applications including Development and Design of ETL methodologies using Informatica Power Exchange, Informatica Power Center, Pharmaceutical, Financial, and Telecom sectors.

Skills : Datastage, Informatica, Oracle, Data Warehousing, etl.

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.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Database

SSIS/ETL Developer Resume

Headline : Experience on Business Requirements Analysis, Application Design, Development, Testing, Implementation and maintenance of client/server Data Warehouse and Data Mart systems in the Healthcare, Finance and Pharmaceutical industries.

Skills : PL/SQL, Java, VB, SQL, Web Development, T-SQL, SSIS, data analysis, requirements gathering.

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.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Consultant
Education
Education
Dental Assistant

Programmer Analyst/ETL Developer Resume

Objective : More than 5 years of experience in IT as SQL Server Developer with strong work experience in Business Intelligence tools. Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop SQL Objects and maintain Stored Procedures and User defined functions.

Skills : Informatica, Oracle 10G.

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.
Years of Experience
Experience
0-2 Years
Experience Level
Level
Entry Level
Education
Education
Diploma

ETL Developer/Onsite Coordinator Resume

Objective : 8 years of experience in Analysis, Design and Development, Migration, Production support and Maintenance projects in IT Industry. 8 years of experience in ETL methodology for supporting Data Extraction, transformations, data quality checks and load processing in a corporate-wide-ETL Solution using Informatica PowerCenter, Informatica Data Quality, Informatica PowerExchange & Datastage. Experience in Design, Development, Migration, Implementation of Data Migration and Extraction Transformation and Loading (ETL) Application development projects.

Skills : Informatica Power Center, Oracle11g/10g, Core Java, Big Data, C,NET, VB.NET.

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.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bachelor Of Technology

ETL Developer/Team Lead Resume

Summary : Having 5+ years of in-depth experience in development, Implementation and testing of Data Warehouse and Business Intelligence solutions. Hands on ETL development experience using Informatica Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor, Repository Server manager. Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, system integration and user acceptance testing and Agile.

Skills : Informatica, Oracle 10G, Oracle 11g, Unix, Dollor Universe, Data Warehouse.

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.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
IT Technology

Application Programmer/ETL Developer Resume

Headline : 7 years of IBM Infosphere DataStage experience ranging from Design, Development, Test Support, Implementation and Production Support. Worked extensively on designing and developing parallel DataStage jobs in V [] Good experience in Data ware house designs, and data modeling, Star and snowflake schemas. Worked in detail with different stages in DataStage like Database connectors, Transformer, Lookup, Join, change capture and Aggregator and successfully ran jobs from medium to high complexity levels.

Skills : .

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.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Diploma

Sr. ETL Developer Resume

Summary : Over 8 years of experience in the IT industry with a strong background in software development and 7+ years of experience in Development, Architecture and Testing Business Intelligence solutions in data warehouse and decision support systems using ETL tool Informatica Powercenter [] and Power Exchange (PWX) and also some knowledge on DT Studio. Knowledge of IDQ and IDE. Good experience in shell scripts for Informatica pre & post session operations.

Skills : .

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.
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
B.E. In Computer Science

Oracle PL/ETL Developer Resume

Objective : Over 7 years of experience in IT industry with expertise in MSSQL, Oracle, Informatica and ETL tools. 6+ years of experience in the Development and Implementation of Data warehousing with Informatica, OLTP and OLAP involving Data Extraction, Data Transformation, Data Loading and Data Analysis. Experience in all phases of the Data warehouse life cycle involving Analysis, Design, Development and Testing of Data warehouses using ETL Logic.

Skills : .

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.
Years of Experience
Experience
0-2 Years
Experience Level
Level
Entry Level
Education
Education
Bachelor Of Science

ETL Developer III Resume

Summary : Experienced in analysis, design, development and implementation of business requirements with SQL Server Database System in the client/server environment.

Skills : .

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.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Business Administration

Data Analyst/ETL Developer Resume

Objective : 14 years of information technology experience with Requirements gathering, Analysis, Design, Configuration, Develop, Test, Administration and maintenance of ETL Processes with SAP Systems, non-SAP systems, Databases, and Data Warehouses.

Skills : SAP Data Services, SAP Data Migration, Data Warehouse, SAP ERP.

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.
Years of Experience
Experience
0-2 Years
Experience Level
Level
Entry Level
Education
Education
BSc In Computer Science