Jobs that use data warehouse the most include data warehouse consultant, data warehousing specialist, and data warehouse specialist.
What jobs use Data Warehouse the most?
1. Data Warehouse Consultant
How data warehouse consultant uses Data Warehouse:
- 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. Data Warehousing Specialist
How data warehousing specialist uses Data Warehouse:
- 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
3. Data Warehouse Specialist
How data warehouse specialist uses Data Warehouse:
- 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
4. Cognos Consultant
How cognos consultant uses Data Warehouse:
- Manage SSIS jobs for weekly and monthly refresh.
- Implement QlikView desktop and publisher, manage user authentication, establish publisher tasks, streamline loading procedures and review log.
- Implement different techniques in DMR cubes development to improve performance on OLAP databases.
Most common skills for cognos consultant:
- Dashboards
- Data Warehouse
- SQL Server
- Drill-Through
- Cognos BI
- Windows XP
5. Senior Development Consultant
How senior development consultant uses Data Warehouse:
- Lead various EDI relate projects for banks, logistic partners, customers.
- Manage internal, external systems/application of healthcare software within assign areas from inception to successful implementation in private medical practices.
- Implement identity management web services API in SOA environment.
Most common skills for senior development consultant:
- Java
- Data Warehouse
- JavaScript
- SR
- Data Analysis
- Scrum
6. Contractor-Project Manager/Consultant
How contractor-project manager/consultant uses Data Warehouse:
- Lead professional services engagements from assessment analysis to completion by partnering directly with healthcare providers to enhance revenue collection and efficiency.
- Serve as the project leader for major ERP deployment.
- Interface with various client and contracting resources to align tasks, activities, and QA software testing.
Most common skills for contractor-project manager/consultant:
- Project Management
- Data Warehouse
- Process Improvement
- SQL
- Management System
- Business Process
7. Data Warehouse Architect
How data warehouse architect uses Data Warehouse:
- Design dimensional data models, develop SQL and UNIX scripts to automate extraction and loading of data.
- Report procedures against SSAS are constructed and ExcelWriter templates are developed to automate and replace existing manually generate, client-contract reports.
- Design and build PL/SQL code to extract, transform and load the data into the star schema objects.
Most common skills for data warehouse architect:
- Analytics
- Data Warehouse
- Business Intelligence
- Power Bi
- Data Warehousing
- Data Quality
8. ETL Architect
How etl architect uses Data Warehouse:
- Manage and execute various BO reporting projects within organization.
- Create a JAVA application to handle the Informatica workflow restart-ability.
- Support migration of ETL code from development to QA and then from QA to production.
Most common skills for etl architect:
- Data Warehouse
- Microsoft SQL Server
- Data Architecture
- BI
- Data Analysis
- Unix
9. Senior Database Consultant
How senior database consultant uses Data Warehouse:
- Fix grid control alerts on the database and monitor the database using grid control including managing of templates.
- Conduct shell scripting on UNIX and LINUX servers.
- Write complex SQL queries, advance PL/SQL, triggers, materialize views, dynamic SQL, UTL_FILE and handle exceptions.
Most common skills for senior database consultant:
- Oracle Sql
- SQL Server
- DB
- Data Warehouse
- OLAP
- OLTP
10. Programmer Analyst-Consultant
How programmer analyst-consultant uses Data Warehouse:
- Manage the SDLC of internal and B2B projects and EDI integrations.
- Manage company's databases, ERP systems and overall security on a daily basis.
- Utilize UNIX to FTP payroll files from corporate to mainframe for processing and log files to be process.
Most common skills for programmer analyst-consultant:
- SQL Server
- C Net
- Oracle Sql
- Data Warehouse
- Cobol II
- CICS
11. ETL Developer
How etl developer uses Data Warehouse:
- Support and maintain production Cognos web portal to manage the OLAP cube and folders.
- Implement Perl scripts to load the financial information and to automate frequent reports for the users.
- Coordinate with DBA in creating and managing table, indexes, table spaces, triggers, dB links and privileges.
Most common skills for etl developer:
- SQL Server
- Data Warehouse
- Unix
- Data Analysis
- BI
- Data Quality
12. Senior Programmer Analyst Lead
How senior programmer analyst lead uses Data Warehouse:
- Maintain, debug, and manage PC base manufacturing/planning/costing systems to ensure accurate forecasting, scheduling, and production planning.
- Provide complete support from deployments to troubleshooting and debugging of applications in all environments including QA, UAT and production.
- Process the incoming XML to need objects.
Most common skills for senior programmer analyst lead:
- Data Warehouse
- PL/SQL
- Java
- Web Services
- DB2
- Windows
13. Database Consultant
How database consultant uses Data Warehouse:
- Deploy and manage VMware horizon view on CISCO UCS for VDI deployemet.
- Create encrypted passwords in UNIX and Linux servers by using SQL crypt utilities.
- Develop Java wrapper to eliminate database passwords from UNIX shell scripts to enhance security.
Most common skills for database consultant:
- Oracle Sql
- DB
- Data Warehouse
- PL/SQL
- Microsoft SQL Server
- OLTP
14. Cognos Developer
How cognos developer uses Data Warehouse:
- Manage continuous integration, configure the servers using Jenkins.
- Create query logic base on DB2.
- Enhance existing dashboards and scorecards using KPIs and enabling drill functionality.
Most common skills for cognos developer:
- Dashboards
- Data Warehouse
- SQL Server
- Drill-Through
- Cognos BI
- Report Development
15. Assistant Systems Engineer
How assistant systems engineer uses Data Warehouse:
- Implement jobs in Linux to automate the file-extraction process on the client server side.
- Perform responsibilities of collecting and understanding business requirements for an internal TCS project to automate the report generations.
- Design a website using HTML and CSS for a hospital to handle health insurance claims and issues.
Most common skills for assistant systems engineer:
- Java
- Web Application
- Data Warehouse
- PL/SQL
- C++
- HTML
16. Senior ETL Developer
How senior etl developer uses Data Warehouse:
- Develop custom interface for executing and managing SSIS packages.
- Create UNIX scripts to create data files and FTP it to windows/ TM1/ Linux servers for reporting.
- Extract data from various relational databases, application systems, flat files, XML documents, and load into data warehouse.
Most common skills for senior etl developer:
- Data Warehouse
- Unix
- SQL Server
- Informatica Powercenter
- PL/SQL
- Informatica Workflow
17. Onsite Coordinator
How onsite coordinator uses Data Warehouse:
- Provide technical training in Unix, SQL and functional training for team to enhance performance and achieve the targets.
- Mentore freshmen through experience on COBOL, JCL, VSAM, DFSORT and ICETOOL on mainframe platforms to create well-written codes.
- Front development using ATG DSP, JSTL JSP, JQuery, JavaScript, AJAX etc.
Most common skills for onsite coordinator:
- Payroll
- Data Warehouse
- Java
- Test Cases
- PL/SQL
- UAT
18. Contract Application Developer
How contract application developer uses Data Warehouse:
- Implement a centralize configuration system for managing application settings, consisting of a desktop application with a WCF backend.
- Integrate dynamic data using existing xml web services.
- Modify existing CSS and JavaScript code to format the alignment of text in a PDF generate report.
Most common skills for contract application developer:
- Web Application
- Java
- JavaScript
- Data Warehouse
- PL/SQL
- HTML
19. Informatica ETL Developer
How informatica etl developer uses Data Warehouse:
- Support and maintain production Cognos web portal to manage the OLAP cube and folders.
- Used various transformations like expression, union, source qualifier, aggregator, router, store procedure, lookup transformations.
- Work on transformations such as source qualifier, joiner, lookup, rank, expression, aggregator and sequence generator etc.
Most common skills for informatica etl developer:
- Unix
- Informatica Workflow
- SQL Server
- Data Warehouse
- PL/SQL
- Toad
20. Data Warehouse Developer
How data warehouse developer uses Data Warehouse:
- 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
Other skills
- DBA career
- DEA career
- DJ career
- DMV career
- DOD career
- DOE career
- DOT career
- Dashboards career
- Data Acquisition career
- Data Analysis career
- Data Analytics career
- Data Collection career
- Data Entry career
- Data Governance career
- Data Integrity career
- Data Management career
- Data Processing career
- Data Quality career
- Data Warehouse career
- Database career
- Database Administration career
- Database Backup career
- Database Design career
- Database Management career
- Database Objects career
- Database Systems career
- Dealership career
- Debugging career
- Defective Products career
- Defense Counsel career
- Delinquent Accounts career
- Delivery Dates career
- Delivery Orders career
- Delivery Route career
- Delivery Schedules career
- Delivery Sequence career
- Delivery Truck career
- Delivery Vehicle career
- Delphi career
- Demand Planning career
- Demolition career
- Dental Care career
- Dental Procedures career
- Dependability career
- Derivative career
- Design Concepts career
- Design Development career
- Design Drawings career
- Design Process career
- Design Projects career
- Design Reviews career
- Design Software career
Updated December 28, 2023