Top 20 Companies That Use ETL

2. Guidehouse

3. Deloitte

How Deloitte uses ETL:

• Designed multi-tier ETL processes for Data Staging, Data Cleansing and Data Population functions from Internal and External data sources.
• Developed the 105-table AAR3 database and approximately 120 ETL transformations to prepare the database for analytical platform.
• Created complex ETL mappings using XML transformation, Joiners, Filters, Routers for Finance Module.

Most common skills for Deloitte:

• Project Management
• Java
• Business Development
• Process Improvement
• Business Process
• Financial Statements

4. Intel

How Intel uses ETL:

• Led team consisting of data content experts, DBA, and programmers to deliver robust solution to ETL needs.
• Designed of ETL mappings for the CDC change data capture.
• Mentored and trained 30+ leads/engineers on ETL in JMP, SQL, VBA and other internal data extraction tools.

Most common skills for Intel:

• Linux
• Perl
• Debugging
• Windows
• RTL
• Python

5. Lincoln Financial Group

How Lincoln Financial Group uses ETL:

• Experience in creating ETL deployment groups and ETL Packages for promoting up to higher environments.

Most common skills for Lincoln Financial Group:

• Computer System
• Customer Service
• Annuities
• Customer Complaints
• HR
• Data Entry

6. Syms

Most common skills for Syms:

• Store Sales
• DB2
• Intellectual Property
• Customer Service
• Troubleshoot
• POS

7. Target

How Target uses ETL:

• Designed, developed, enhanced, and maintained ETL application that enticed customers to use lower-cost debit instead of credit-cards tender.
• Provide support to District ETL HR's and the Human Resource Business Partner.
• Conducted data requirement analysis for ETL process.

Most common skills for Target:

• Sales Floor
• Guest Service
• Customer Service
• Front End
• Drive Sales
• Stock Shelves

8. Amazon

How Amazon uses ETL:

• Used ODI 11g/12c for extraction, loading and transformation ETL of data in the data warehouse for sandbox.
• Created automated reports on inventory defect and associate behavioral trends using Amazon's Data Warehouse and proprietary ETL manager.
• Constructed and scheduled SQL query jobs using an in-house ETL Manager.

Most common skills for Amazon:

• Customer Orders
• Pallets
• Inventory Control
• Pallet Jack
• RF Scanner
• Problem Solve

9. Meta

Most common skills for Meta:

• Facebook
• Visualization
• POS
• API
• Twitter
• Java

10. GEICO

How GEICO uses ETL:

• Performed Database testing using SQL queries Tested the data load process using the Informatica Power Center ETL tool.
• Involved in the entire ETL process, creating SSIS packages to extract data from OLTP to OLAP systems.
• Create and maintain partitions for big tables and ETL data to archive database for reporting, BI and big data purpose.

Most common skills for GEICO:

• Customer Service
• Inbound Calls
• Arbitration
• Customer Inquiries
• Policy Coverage
• Insurance Coverage

11. Lumina Foundation

12. Pwc

How Pwc uses ETL:

• Worked with ETL team (DWH) to extract data into Tableau using custom SQL to filter data source.
• Developed front-end, metadata and ETL specification to support business requirements for reporting across the organization.

Most common skills for Pwc:

• Financial Statements
• Project Management
• Real Estate
• Sarbanes-Oxley
• Internal Controls
• ERP

13. Capital One

How Capital One uses ETL:

• Coordinated the efforts of DBAs, ETL, Unix administration, Information security, LAN, WAN, etc.
• Monitored and supported production ETL jobs until stabilization.
• Used Oracle SQL for ETL Processes, Data Mapping, Data Validation, Data Integrity and performed Data Cleansing.

Most common skills for Capital One:

• Customer Service
• Process Improvement
• Credit Card
• Customer Inquiries
• Java
• Inbound Calls

14. Ford Motor

How Ford Motor uses ETL:

• Designed in house ETL programs as per FORD ADS standards and practices and available resources for GCAMP Data ware housing application.
• Worked with business analysts and Sr. ETL developer in analyzing business requirements.
• Participated and facilitated in business review session including feasibility, operation and business perspective of ETL.

Most common skills for Ford Motor:

• Assembly Line
• Sigma
• Lean Manufacturing
• Customer Service
• Process Improvement
• ISO

15. Fidelity Investments

How Fidelity Investments uses ETL:

• Involved testing ETL transformations done using INFORMATICA tool and PL/SQL.
• Designed and built Access/VBA database for Annuity Sales Supervision Shell scripting to monitor ETL and move data between systems.
• Extract, transform and load (ETL) data from Essbase by coding SQL queries in Turbo Integrator (TI).

Most common skills for Fidelity Investments:

• Customer Service
• QA
• Process Improvement
• Project Management
• Inbound Calls
• Problem Resolution

16. Evolent Health

How Evolent Health uses ETL:

• Tested several DTS/SSIS packages for ETL data extraction and data loading.

Most common skills for Evolent Health:

• Maven
• Patient Education
• SQL Server
• VBA
• Extract Data
• Visio

17. Navient

How Navient uses ETL:

• Designed, developed ETL and extracted SAP BW Data for Reporting needs.
• Managed the performance and efficiency of the ETL environments to provide maximum system uptime.
• Developed automated solutions to replicate ETL tasks using SSIS.

Most common skills for Navient:

• Student Loans
• Customer Service
• Outbound Calls
• Inbound Calls
• Credit Reports
• Customer Accounts

18. Robert Half

How Robert Half uses ETL:

• Centralized and standardized the use of ETL tools which resulted in a reduction of software licensing costs.
• Created and maintained ETL processes using Microsoft SSIS.

Most common skills for Robert Half:

• Customer Service
• Expense Reports
• Payroll
• Journal Entries
• Data Entry
• QuickBooks

19. CGI Inc.

How CGI Inc. uses ETL:

• Performed GAP analysis of multiple data systems and discovered discrepancies that resulted in changes to ETL mappings and improved trending reports.

Most common skills for CGI Inc.:

• SharePoint
• Business Development
• QA
• SQL
• UI
• HTML

20. RELX

Most common skills for RELX:

• Saas
• Project Management
• Cloud
• Infrastructure
• Architecture