Post job

20 jobs that use ETL the most

What jobs use ETL the most?

1. Data Warehouse Consultant

How data warehouse consultant uses ETL:

  • Design and manage reference data and master data programs: design and implement RDM and MDM solutions.
  • Enhance applications with SQL, PL/SQL API for insurance coverage premiums and claims business rules.
  • Involve to develop procedures, functions, packages and triggers for enforcing the business rules using PL/SQL.

Most common skills for data warehouse consultant:

  • Data Quality
  • ETL
  • Oracle Sql
  • Data Warehouse
  • Provisioning
  • PL/SQL

2. Ssis Developer

How ssis developer uses ETL:

  • Manage different versions of complicate code and distribute them to different teams in the organization utilizing TFS.
  • Develop an ASP.Net application to input and manage a production schedule, production statistical analysis and trend reporting.
  • Create routines for importing data utilizing XML, CSV and comma delimitate files.

Most common skills for ssis developer:

  • Ssis Packages
  • ETL
  • SSRS
  • T-SQL
  • SQL Server Analysis
  • Database Objects

3. Database Tester

How database tester uses ETL:

  • Manage departmental inventory and troubleshoot testing, reporting and inventory issues.
  • Promote Unix/Informatica application releases from development to QA and to UAT environments.
  • Work with SQL and PL/SQL procedures.

Most common skills for database tester:

  • ETL
  • SQL Server
  • Regression Test Cases
  • Test Plan
  • Regression
  • Back-End

4. Data Warehouse Specialist

How data warehouse specialist uses ETL:

  • Lead system maintenance, upgrade, ETL, scheduling, and installation of client software, holding accountability for performance.
  • Report procedures against SSAS are constructed and ExcelWriter templates are developed to automate and replace existing manually generate, client-contract reports.
  • Determine data extraction and transformation require to support reporting requirements.

Most common skills for data warehouse specialist:

  • Data Warehouse
  • ETL
  • Data Warehousing
  • Business Intelligence
  • Architecture
  • Data Analysis

5. Enterprise Integration Manager

How enterprise integration manager uses ETL:

  • Create, manage and distribute project plans, meeting agendas, risks, and action items on a SharePoint site.
  • Used Microsoft SharePoint to manage company's distribution of documentation and write guides about its functionality.
  • Manage application solution architecture and ensure utilization of environment configuration management processes.

Most common skills for enterprise integration manager:

  • API
  • ETL
  • Enterprise Application Integration
  • Application Development
  • Data Integration
  • Business Process

6. Senior Database Developer

How senior database developer uses ETL:

  • Complete continuous improvement projects to further automate, fix issues and increase efficiency across database, ETL and business line processing.
  • Involve in DBA responsibilities such as managing users and permissions, creating audit triggers, and overlook the daily back up.
  • Major focus on SQL and PL/SQL application development using packages, store procedures, functions, triggers and views.

Most common skills for senior database developer:

  • ETL
  • Database Development
  • Java
  • Data Warehouse
  • PL/SQL
  • Database Design

7. Data Warehousing Specialist

How data warehousing specialist uses ETL:

  • Manage the migration from the QuickPlace document repository to the SharePoint repository.
  • Create ODS; ELT and DDL scripts for source and target databases.
  • Support ETL processes using a variety of technologies.

Most common skills for data warehousing specialist:

  • Data Warehouse
  • Data Warehousing
  • ETL
  • Unix
  • Extraction
  • Business Rules

8. Database Developer

How database developer uses ETL:

  • Coordinate with DBA in creating and managing tables, indexes, db links and privileges.
  • Create shell scripts in UNIX to automate the data loading process and to cleanse the flat file inputs.
  • Design, develop and manage DB2 database scripts for building and migrating the database for banking software customers.

Most common skills for database developer:

  • ETL
  • C++
  • Java
  • Microsoft SQL Server
  • Database Development
  • PL/SQL

9. Data Warehouse Developer

How data warehouse developer uses ETL:

  • Help in set up the SharePoint server, deploy reports and create, manage subscriptions and data driven subscriptions.
  • Achieve significant performance improvement in reducing response time of queries by rewriting and tuning SQL statements embed in PhP code.
  • Develop MapReduce jobs in Java API to parse the raw data and store the refined data.

Most common skills for data warehouse developer:

  • ETL
  • Java
  • Hadoop
  • Data Warehouse
  • Visualization
  • Data Analysis

10. Database Development Project Manager

How database development project manager uses ETL:

  • Implement and automate existing manual process, to create CRF by creating new database objects in SQL and macro in excel.
  • Work on T-SQL for transaction data management.
  • Develop new and maintained/update existing DTS packages.

Most common skills for database development project manager:

  • Microsoft SQL Server
  • PL/SQL
  • Ssis
  • ETL
  • Database Development
  • Project Management

11. Data Integrity Specialist

How data integrity specialist uses ETL:

  • Manage multiple imaging-relate projects across both radiology and cardiology service lines, both inpatient and outpatient, to completion.
  • Implement both translations and perspectives within the SSAS solution.
  • Perform numerous presentations on DB2 UDB to application development team.

Most common skills for data integrity specialist:

  • ETL
  • Java
  • Data Quality
  • Customer Service
  • SQL Server
  • Customer Satisfaction

12. Business Owner/Engineer

How business owner/engineer uses ETL:

  • Lead the QA team in Singapore at a very early stage in career.
  • Design, develop and manage projects to assure that call center technicians are in compliance with the customer SLAs.
  • Manage Jenkins security by providing specific access to authorize developers/testers using project base matrix authorization strategy.

Most common skills for business owner/engineer:

  • Business Intelligence
  • Visualization
  • Python
  • Data Analysis
  • ETL
  • Power Bi

13. Data Migration Specialist

How data migration specialist uses ETL:

  • Manage the migration from the QuickPlace document repository to the SharePoint repository.
  • Manage multiple imaging-relate projects across both radiology and cardiology service lines, both inpatient and outpatient, to completion.
  • Design and create a complete ETL system using SSIS incorporating newly available transforms and methods.

Most common skills for data migration specialist:

  • ETL
  • SQL Server
  • Data Analysis
  • Data Extraction
  • Data Conversion
  • Master Data

14. Database Analyst/Developer

How database analyst/developer uses ETL:

  • Perform QA to ensure the quality are attained, production of appropriate and brief documentation files for end users.
  • Lead quality assurance planning for multiple concurrent projects relative to overall system architecture or trading system changes/new developments.
  • Design, code, test and debug business logic for software applications using T-SQL per define technical specifications.

Most common skills for database analyst/developer:

  • Microsoft SQL Server
  • ETL
  • Ssis
  • PL/SQL
  • Data Analysis
  • Database Design

15. Senior Sql/Report Developer

How senior sql/report developer uses ETL:

  • Manage dashboard and request security/privileges in the analytics catalog manager.
  • Create SSIS packages to process XML data; design and programme auditing processes for enterprise databases.
  • Develop various T-SQL store procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations.

Most common skills for senior sql/report developer:

  • Power Bi
  • ETL
  • SSRS
  • Ssis Packages
  • T-SQL
  • Database Objects

16. Data Modeler

How data modeler uses ETL:

  • Lead efforts to analyze data for source/target mappings, create T-SQL scripts for data processing.
  • Involve in data governance processes relate to data quality and information management, managing the metadata repository etc.
  • Accomplish at designing dashboards and data summaries for technical and non-technical audiences and facilitating implementation of business strategies and missions.

Most common skills for data modeler:

  • ETL
  • Data Analysis
  • Data Architecture
  • Physical Data Models
  • Data Warehouse
  • Tableau

17. Application Integrator

How application integrator uses ETL:

  • Manage multiple database platforms for potential performance issues, while conducting research and resolution with attention to detail and thorough documentation.
  • Develop EDI systems for multiple GXS/GE clients worldwide.
  • Supervise the designed and development of the EDI process.

Most common skills for application integrator:

  • Application Integration
  • Architecture
  • Java
  • XML
  • ETL
  • FTP

18. SQL Developer

How sql developer uses ETL:

  • Manage migration of SQL 2005 databases to SQL 2008 R2.
  • Work with dynamic T-SQL queries, DDL, DML statements for creating objects, making updates and managing user permissions.
  • Coordinate with DBA in creating and managing table, indexes, table spaces, triggers, db links and privileges.

Most common skills for sql developer:

  • Database Objects
  • T-SQL
  • SSRS
  • ETL
  • SQL Server Analysis
  • Java

19. Reports Developer

How reports developer uses ETL:

  • Work with dynamic T-SQL queries, DDL, DML statements for creating objects, making updates and managing user permissions.
  • Used Java script to perform checking and validations in the JSP pages.
  • Create different types of reports including: standard, cross-tab, conditional, dynamic, and integrate sub-reports.

Most common skills for reports developer:

  • BI
  • ETL
  • SSRS
  • Power Bi
  • PL/SQL
  • Visualization

20. Business Intelligence Developer

How business intelligence developer uses ETL:

  • Used TFS for managing versions of the code with in the development team.
  • Develop VBA base application to automate testing of report output and test scenarios.
  • Manage security privileges for each subject area and dashboards according to user requirements.

Most common skills for business intelligence developer:

  • Power Bi
  • Business Intelligence
  • Analytics
  • Dashboards
  • ETL
  • Visualization

Other skills