Top Data Warehouse Specialist Skills

Below we've compiled a list of the most important skills for a Data Warehouse Specialist. We ranked the top skills based on the percentage of Data Warehouse Specialist resumes they appeared on. For example, 18.6% of Data Warehouse Specialist resumes contained Data Warehouse as a skill. Let's find out what skills a Data Warehouse Specialist actually needs in order to be successful in the workplace.

The six most common skills found on Data Warehouse Specialist resumes in 2020. Read below to see the full list.

1. Data Warehouse

high Demand
Here's how Data Warehouse is used in Data Warehouse Specialist jobs:
  • Coordinated efforts to develop an enterprise data warehouse, integrating data marts.
  • Implement strategies for data warehouse additions and enhancements.
  • Developed and managed phased data warehouse development plans.
  • Involved with tuning PL/SQL stored procedures to decrease the time needed to complete the Data Warehouse conversion and extraction of data.
  • Develop, implement and maintain Data Warehouse and BI reporting to support Sales, Marketing, Finance and Operation business teams.
  • Created data model, mapped data elements to their source elements, created ETL transformations necessary to load the data warehouse.
  • Designed and developed the data warehouse in Oracle 10g, including fact tables, dimensions, hierarchies, aggregate tables.
  • Design and implementation of ETL (Extract-Transform-Load) processes as nightly feeds from legacy and enterprise systems to data warehouses.
  • Authored a monthly newsletter distributed to Western New York Schools outlining new development and upcoming projects for the Data Warehouse.
  • Developed data warehouse data object repositories for OLAP reporting or ETL file movements and created data conversion interfaces.
  • Monitored critical data loads, backing out erroneous data and reloading previous day data into the Data Warehouse.
  • Provided ETL production support and worked on the Corporate Data Warehouse (UDB database) upgrade project.
  • Coded and tested countless data-fix Mappings to clean up previous-to-my-involvement dirty data in the Data Warehouse.
  • Worked on Oracle's Warehouse Builder for Extraction, Transformation and Loading the data warehouse.
  • Designed and implemented near real-time data warehouse for Portfolio reporting using Oracle Streams.
  • Mapped data between source systems, data warehouses, and data marts.
  • Design create and maintain a Data Warehouse and Bi environment.
  • Provided technical lead for Disney's first Data Warehouse.
  • Worked on creating a data warehouse for DAS.
  • Web development, database, data warehouse

Show More

2. Pl/Sql

high Demand
Here's how Pl/Sql is used in Data Warehouse Specialist jobs:
  • Used SQL loader and Oracle PL/SQL.
  • Designed and implemented PL/SQL stored procedures to correctly calculate insurance premiums for an insurance company.
  • Developed customized derivation and validation procedures to assure data accuracy using PL/SQL programming.
  • Documented technical requirements by understanding the existing PL/SQL Stored Procedures and production jobs.
  • Involved in Data extraction/Transformation/Cleaning/Loading has been implemented using SQL Loader and PL/SQL.
  • Provide analysis, validation and synchronization PL/SQL scripts for system data initialization.

Show More

3. ETL

high Demand
Here's how ETL is used in Data Warehouse Specialist jobs:
  • Program the extraction and transformation procedures using Extract Transformation Load (ETL) tools or other required stored procedures.
  • Migrated all MVS Focus data mart ETL applications to SAS ETL processes and eliminated FOCUS from Levi MVS environment.
  • Developed and supported data modeling, daily CDC and ETL processes between the JDE source and data marts.
  • Performed Unit Level testing and quality assurance testing on ETL scripts ensuring data consistency with an existing application.
  • Performed ETL development in MS SQL Server 2000 and analyzed technical and functional designs to ensure top performance.
  • Developed UNIX shell scripts for handling files, automating ETL processes and performing data quality checks.
  • Created procedures, design and test templates for BO universe, report, and ETL processes.
  • Analyzed and understand failures of ETL jobs to improve by fixing or create new process.
  • Maintained multiple hierarchies throughout all aspects of ETL and Business Object reports and universes.
  • Optimized a new ETL algorithm which is about 20x faster than old one.
  • Lead team of five personnel, mentoring them on the nuances of ETL.
  • Created source system mappings to the ETL programs using Oracle PL/SQL.
  • Create batch scripts and shell scripts to efficiently automate ETL processes.
  • Analyzed technical and functional designs to improve ETL operations.
  • Created scheduled ETL loads using windows bat scripts.
  • Designed and implemented the ETL process using PLSQL.
  • Designed all ETL related tasks and activities.
  • Worked on ETL specification, design and implementation using Informatica.
  • Modified ETL applications in a complex datawarehouse environment.
  • Project utilized ETL process and web services to collect data and use BO and Microstrategy to display data.

Show More

4. Business Requirements

high Demand
Here's how Business Requirements is used in Data Warehouse Specialist jobs:
  • Follow Business Requirements Document (BRD) to develop codes for projects independently and be accountable.
  • Utilize Agile methodology to elicit and analyze reporting requirements and translate business requirements into sustainable and efficient visualizations and reports.
  • Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements.
  • Participated in the identification, understanding, and documentation of business requirements, including the applications capable of supporting those requirements.
  • Project work included gathering and documenting business requirements for various Business Intelligence applications, creating, testing, and implementing solutions.
  • Developed the logical and physical model from the conceptual model developed using a tool Erwin by understanding and analyzing business requirements.

Show More

5. Database

high Demand
Here's how Database is used in Data Warehouse Specialist jobs:
  • Tuned SQL generated by MicroStrategy, coordinating with database administrators and other agencies including MicroStrategy Support.
  • Designed, audited and implemented logical and physical data models for various databases.
  • Designed, developed and administered database applications in MS-Access.
  • Performed optimization at both database and procedure levels.
  • Worked with LAN and database administrative management.
  • Designed integrity constraints for databases.
  • Supported and upgraded Training Server application, customized Access reports database, and nightly FTP file transfers.
  • Create database objects, troubleshoot and optimize performance, analyze data usage to minimize system redundancy.
  • Created a proposal recommending a full rewrite of the application and restructuring of the database system.
  • Performed database migration and database server tuning in support of customer benchmark for JP Morgan- Chase.
  • Worked extensively with SQL stored procedures to process data in database and for reporting.
  • Front end database was linked to the back end database using external tables.
  • Created tables on the back end database saved on the shared file system.
  • Created and maintained multiple instances of the Executive dashboard database.
  • Manage and maintain SQL and Access databases.
  • Worked on the database design changes.
  • Created OLAP and relational databases.
  • Managed Hyperion Solutions Essbase OLAP data systems supporting 65 databases, with data cubes for Sales, Finance, and Operations.
  • Provide database administrative support for the PM, COR, and DoD customers transitioning to Networx.
  • Worked on requirements database in Microsoft Access, created reports, forms and queries.

Show More

Job type you want
Full Time
Part Time
Internship
Temporary

6. Informatica

high Demand
Here's how Informatica is used in Data Warehouse Specialist jobs:
  • Maintained schedule and delivery using Informatica.
  • Developed data load and synchronization through Informatica Cloud to MSSQL 2012.
  • Scheduled and monitored the Informatica Server Manager daily batches and sessions.
  • Experience in Informatica Work Flows and Mappings.
  • Administered Informatica Server, Informatica repositories, maintained repository security.
  • Utilized source analyzer, designer, mapping, and workflow monitor informatica tools
  • Design and create efficient Informatica mappings and sessions to perform data transformation.
  • Worked extensively on all Informatica issues and middleware issues.
  • Performed Informatica upgradation from 8.6 to 9.1.
  • Migrated Peoplesoft SQR'S to Informatica jobs for MAC US, MAC CAN, and JOBCOST data load process.
  • Lead Datawarehouse needs of INC Research using Oracle Data Integrator, Informatica, SQL, Pl/Sql, and OBIEE tools.

Show More

7. SQL

high Demand
Here's how SQL is used in Data Warehouse Specialist jobs:
  • Modified complex applications to incorporate parameter lists using dynamic SQL.
  • Led efforts to analyze data for source/target mappings, created T-SQL scripts for data processing.
  • Created SQL scripts for Extraction, Transformation and loading of various data marts.
  • Created and Enhanced SQL Server T-SQL procedures for different project needs.
  • Document business processes utilized for data loads to SQL server.
  • Developed SQL scripts to test and load data.
  • Tuned Oracle SQL and Mappings for better performance.
  • Performed performance testing within SQL Query Analyzer.
  • Received training in MS SQL Server v2005.
  • Implemented resolution using SQL/PL SQL, KSH, MS ACCESS and MS Excel
  • Worked on MSSQL 2012 MDM solution.
  • Developed and designed daily, period-end, quarter-end and year-end actuarial reports using Powerbuilder and SQL.
  • Write ad hoc SQL reports for compliance and analysis by management.
  • Worked on Crystal Reports to create custom SQL reports.

Show More

8. Complex Mappings

high Demand
Here's how Complex Mappings is used in Data Warehouse Specialist jobs:
  • Developed Transformation logic and designed various complex Mappings in the Designer.
  • Tuned complex mappings to achieve faster data loads to the data warehouse.
  • Designed complex mappings involving target load order and constraint based loading.
  • Developed complex mappings using multiple sources and targets in different databases, flat files.
  • Worked with complex mappings having an average of 15 transformations.
  • Developed transformation logic and designed various complex Mappings and Mapplets using the Designer.

Show More

9. Unix

high Demand
Here's how Unix is used in Data Warehouse Specialist jobs:
  • Created/modified unix scripts, created stored procedure and enhanced performance.
  • Fair exposure to analyzing/troubleshooting and providing technical support for Unix/Oracle applications and their interfaces.
  • Developed Unix scripts for transforming data into different databases.
  • Lead data migration tester for conversion from IBM CIS to Epic Chronicles database in both Hyperspace and UNIX text environments.
  • Streamlined the entire suite of UNIX scheduled jobs (over 450 jobs) in Unicenter-CA.
  • Downloaded the data files from the UNIX servers on to encrypted hard drives for shipping.

Show More

10. Ssis

high Demand
Here's how Ssis is used in Data Warehouse Specialist jobs:
  • Assisted warehouse supervisors/managers in generating various reports and research.
  • Support enhancements and bug-fixes in Data Security Warehouse (DSW) in Microsoft SQL Server and SSIS.
  • Experience implementing SSRS and SSIS, and performing Windows maintenance and upgrades.
  • Provide backup assistance to the Help Desk for internal users.
  • Assisted the Manager of Test Scoring, as needed.
  • Assist senior management in budget and workload planning.
  • Trained developers and management on SSIS packages.
  • Provided assistance to my manager in writing a book on the Goldengate process.

Show More

11. Architecture

high Demand
Here's how Architecture is used in Data Warehouse Specialist jobs:
  • Functioned as subject matter expert (SME) for recommending BI requirements and design standards from EDW architecture to development processes.
  • Provided architecture plans that supported over fifty reports, cubes and web-content applications.
  • Designed as -is and to -be data architectures for email content warehousing.
  • Get hands on knowledge on the working of Goldengate and its architecture.
  • Worked with business owners, analysts, solution engineers, development teams and infrastructure services to communicate application and data architectures.
  • Designed a methodology to support Case Tools Implementations IEF/Composer, including coding standards, quality control and data movement architecture.

Show More

12. Olap

high Demand
Here's how Olap is used in Data Warehouse Specialist jobs:
  • Developed documents and training procedures for VB reporting applications incorporating MS OLAP Server data cubes.
  • Designed and maintains an MS OLAP Server with 13 cube definitions.
  • Designed and developed customized prototypes to support sales of DSS/OLAP software.
  • Provided support of Excel OLAP based Pivot Tables and SSRS reports.
  • Developed relational data model and OLAP data model for system.
  • Developed backup strategies specifically for a 24x7 OLAP environment.
  • Administered Cognos Impromptu reporting and PowerPlay OLAP.

Show More

13. Ssrs

high Demand
Here's how Ssrs is used in Data Warehouse Specialist jobs:
  • Designed reports for time management system and migrated reports from Access to MS SSRS.
  • Developed Tableau, Cognos, and SSRS structures and dashboards for end-user reports.
  • Create ad-hoc queries, MS Excel Macros, VBA/Access/Crystal/SSRS reports.
  • Consolidated existing SSRS reports to Micro Strategy reports without losing the functionality.
  • Consolidated existing SSRS reports to Micro Strategy reports without losing the functionality.
  • Utilized SSRS to construct reports for on-demand, end-user consumption/distribution.

Show More

14. DB2

average Demand
Here's how DB2 is used in Data Warehouse Specialist jobs:
  • Sourced data from DB2 production database to provide accurate and timely information distributed via web portal applications utilized globally.
  • Developed detailed analysis of Data warehouse DB2 for creating Database and DataMarts.
  • Created both logical and physical data designs with Oracle or DB2 as the specified target.
  • Participated on project team for corporate database upgrades for both DB2 and SQL Server.
  • Created physical data models (PDM) for DB2 9.2 and Oracle 11g databases.
  • Developed DB2 process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Oracle Validation process.

Show More

15. Data Analysis

average Demand
Here's how Data Analysis is used in Data Warehouse Specialist jobs:
  • Performed data analysis, data architecture and data modeling using Erwin Data Modeler.
  • Perform system analysis, data analysis or programming, using a variety of computer
  • Provided technical support of process through data analysis.
  • Develop SQL Query Analyzer scripts for data analysis, compliance reporting, and ETL.
  • Provided technical support and guidance of process through data analysis and knowledge transfer.
  • Performed Participating/Non-participating provider data analysis.

Show More

16. Metadata

average Demand
Here's how Metadata is used in Data Warehouse Specialist jobs:
  • Trained business users to update metadata sections independently.
  • Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
  • Created various session and repository variables and initialized them in the Initialization Blocks to change metadata dynamically as the environment changes.
  • Validated critical and non-critical data quality requirements by looking at log tables and metadata between source flat files and staging/destination tables.
  • Involved in maintaining and updating Metadata Repository with details on the nature and use of applications/data transformations to facilitate impact analysis.
  • Involved in maintaining and updating Metadata Repository with details on the nature and use of applications/data transformations to facilitate impact analysis.

Show More

17. Suite

average Demand
Here's how Suite is used in Data Warehouse Specialist jobs:
  • Worked on JasperSoft Professional Suite to create Jasper Reports for POW, CRIS and REEIS.
  • Created test cases and test suites using Selenium IDE and Selenium Remote Control.
  • Coach end-users in Crystal Reports, Brio KnowledgeShare and MS Office Suite.
  • Conducted user interviews, gathered Requirements, analyzed the Requirements and managed changes using Rational Suite.
  • Developed numerous maps using ArcInfo Suite and performed data conditioning.
  • Produced and delivered C-suite level data reporting.

Show More

18. Teradata

average Demand
Here's how Teradata is used in Data Warehouse Specialist jobs:
  • Used ERWIN for data modeling, PL/SQL, Teradata utilities and Shell scripting.
  • Developed multiple TeraData user defined functions to enhance SQL performance.
  • Used TeraData to create and run multiple audit reports used on a daily and weekly basis by the Subscriber Reporting department.
  • Assisted in Batch processes using Fast Load, BTEQ, UNIX Shell and TeradataSQL to transfer cleanup and summarize data.
  • Tested data from TERADATA to check for data quality issues.
  • Worked with Teradata14.1 load utilities (Fast Load, MLOAD, Fast Export and TPT)

Show More

19. Microstrategy Web

average Demand
Here's how Microstrategy Web is used in Data Warehouse Specialist jobs:
  • Planned and implemented web log analysis tools including NetTracker, Informatica and Microstrategy Web Business Analyzer 6.

Show More

20. XML

average Demand
Here's how XML is used in Data Warehouse Specialist jobs:
  • Developed archival process using Oracle stored procedures and partitioning to assemble fully self-contained XML documents.
  • Designed and implemented innovative path index method for handling hierarchical coding and generic XML data.
  • Developed database program to generate XML configuration file for Adobe Flex application
  • Performed XML data Validations using customized and available source XSD Validation Frameworks.
  • Designed universal internal data auditing by storing data changes in XML
  • Worked extensively with XML schema generation.

Show More

21. Toad

average Demand
Here's how Toad is used in Data Warehouse Specialist jobs:
  • Performed testing and Data Validation of data in reports against the databases using SQL Developer and Toad.
  • Developed SQL queries in SQL Server management studio, Toad and generated complex reports forth end users.
  • Use TOAD and/or DB2 to analyze data and come up with solutions on redesigning table structures.
  • Developed Complex SQL queries to validate actual business result for various source and target table and database using TOAD and Oracle.
  • Test and analyze stored procedures and triggers using Toad, and other database tools resulting in accurate and efficient data processing.
  • Manage the data by using ATG BCC tool and generate the reports as per the business requirements by using TOAD.

Show More

22. Ssas

average Demand
Here's how Ssas is used in Data Warehouse Specialist jobs:
  • Developed standards for SSIS, SSAS and SSRS creation and version control using Team Foundation Services (TFS).
  • Trained developers on SSIS and SSAS.
  • Report procedures against SSAS were constructed and ExcelWriter templates were developed to automate and replace existing manually generated, client-contracted reports.
  • Implement Project Management reporting framework using SSAS including cubes for analysis and progress reviews.
  • Developed SSRS reports based solution for the SSAS database documentation and data warehouse data dictionary.
  • Initiated SSAS projects, dimension definition and MDX execution in business oriented environment.

Show More

23. Datastage

average Demand
Here's how Datastage is used in Data Warehouse Specialist jobs:
  • Participated in Implementing the Industry standard procedures for maintenance, monitoring, backup and recovery operations for the DataStage applications.
  • Provided hands-on participation, technical guidance and to support existing Data warehouse applications, involving DataStage, Quality Stage.
  • Used DataStage Manager for importing metadata from repository, new job categories and importing table definitions from database tables.
  • Designed and developed DataStage parallel jobs which involve extraction, transformation and loading of data for separate interfaces.
  • Designed and developed parallel jobs using DataStage Designer as per the mapping specifications using appropriate stages.
  • Used DataStage Designer to import metadata into repository and to import/export jobs into different projects.

Show More

24. Powerplay Transformer

average Demand
Here's how Powerplay Transformer is used in Data Warehouse Specialist jobs:
  • Developed Business Intelligence solutions using OLAP cubes using Cognos Powerplay Transformer and published them over the ReportNet for management reporting.

Show More

25. User Acceptance

average Demand
Here's how User Acceptance is used in Data Warehouse Specialist jobs:
  • Conducted User Acceptance Testing for various projects keeping track of issues and resolutions.
  • Performed User Acceptance Testing for initial OmniPlus system conversion and periodic software upgrades/enhancements.
  • Managed tasks associated with testing by coordinating with end-users and coordinate user acceptance testing.
  • Performed user acceptance testing and documented detailed results.
  • Conducted technical and business client training and guidance during user acceptance testing and scheduled maintenance and plan cycles.
  • Conduct User Acceptance Testing of tagging requirements using browser tools, analyzing network traffic and server calls to Adobe and WebTrends.

Show More

26. Technical Support

average Demand
Here's how Technical Support is used in Data Warehouse Specialist jobs:
  • Provided technical support to both business team and user departments for all projects.
  • Worked with Senior Management and Department Heads to assess and institute company-wide technical support policies and procedures.
  • Provided network/system hands-on technical support locally with our 7 departmental in-house servers.
  • Provided efficient Support to the users at technical support role for supported applications as part of the team operations.
  • Trained and provided technical support for users in the operation of the program and promoted usage throughout the firm.
  • Provided telephone help desk technical support for users of the Navy Drug Screening Program Software (NDSP).

Show More

27. Project Management

low Demand
Here's how Project Management is used in Data Warehouse Specialist jobs:
  • Performed basic project management tasks including planning, estimating, status reporting and scope management.
  • Apply strategic planning, prioritization, and project management skills toward consistently achieving critical deadlines while maintaining high quality standards.
  • Performed basic project management tasks including planning, estimating, status reporting and scope management.
  • Project Management, Prioritization, Report/Data Extract needs, Issues/Resolution tracking.
  • Project management and primary customer interface for team projects.
  • Established scrum/agile project management methodology.

Show More

28. CRM

low Demand
Here's how CRM is used in Data Warehouse Specialist jobs:
  • Develop and Maintain the system for the CRM related business functions.
  • Analyzed existing Global CRM and re-designed new Enterprise Data Warehouse system to integrate dairy business with existing wholesale business.
  • Performed database development enhancing existing CRM, Portal, and logistics applications.
  • Provided comprehensive application support for Epiphany CRM.
  • Restructured database and created CRM strategy
  • Modified and Created a Z version of SAP custom CRM program to load Territory Hierarchies and Marketing Attributes.

Show More

29. DB

low Demand
Here's how DB is used in Data Warehouse Specialist jobs:
  • Preserved data integrity in DB2 Tables, performed problem determination, corrected data, and created SAS jobs to monitor data.
  • Designed Business Objects Universes and created 'proof of concept' data mart applications in the MVS/DB2 environment to support migration.
  • Implemented and tuned DB2 UDB on multiple EMC 5430 RAID devices with shared disk architecture.
  • Performed numerous presentations on DB2 UDB to application development team.
  • Sourced data from RDBMS using SQL.
  • Created and maintained following Peoplesoft App Engine extract programs (ING file, HRDB file, Time and Labor files).
  • Analyzed the data from both the Retek Merchandising System (RMS) and the Legacy (DB2) system.
  • Collaborate with DBAs on SQL tuning for logical view definitions to improve performance.

Show More

30. QA

low Demand
Here's how QA is used in Data Warehouse Specialist jobs:
  • Key Roles: QA tested double byte enabled software QA tested training manuals, manuals, and other documentations.
  • Analyzed business requirements, system requirements, data mapping requirement specifications interacting with client, developers and QA team.
  • Performed database QA/QC and integrity validation against all databases to ensure reliability of data.
  • Migrated repository objects, scripts from development environment to QA and Production environment.
  • Maintained QA team capacity planning, utilization and assignment allocation.
  • Coordinated all QA activities and enhancements using Agile Methodology.

Show More

31. DTS

low Demand
Here's how DTS is used in Data Warehouse Specialist jobs:
  • Developed and maintained SQL Server jobs, DTS packages and Transact-SQL stored procedures and scripts to create and maintain warehouse-resident tables.
  • Prepared the quality assurance testing environment for testing of all DTS Packages and the user application.
  • Developed multiple DTS Packages following the prescribed DTS Framework facilitating the processing of stored procedure groups.
  • Created SQL Server 2000 DTS packages for PeopleSoft HR and PeopleSoft Finance Data Extracts.
  • Performed Unit Testing on all DTS Packages and the user application.
  • Created a Windows Service to facilitate batch processing calling custom DTS packages on file creation events.

Show More

32. Data Management

low Demand
Here's how Data Management is used in Data Warehouse Specialist jobs:
  • Transitioned to Data Manager -Support role to initiate multiple process enhancement projects in Data management.
  • Provide data management specifications and study related documentation from document creation and updates.
  • Designed security roles and authorization pertaining to material master data management.
  • Build effective Data Management vendor relationships for all assigned studies.
  • Drive process change to facilitate efficient Data Management performance.
  • Developed standards for data management and training developers.

Show More

33. Linux

low Demand
Here's how Linux is used in Data Warehouse Specialist jobs:
  • Installed and configured Linux operating system.
  • Manage Installation and system administration on Linux.
  • Participated in the process to institute import data from Amazon Web Service (AWS) to Oracle on a Linux platform.
  • Build a LINUX RHEL5 server with Oracle 10g Installed and database created to support the newly upgraded mail application server.
  • Installed Oracle 10g on Linux server in RAC environment and migrated the data from Oracle 9i to 10g.
  • Developed Chef recipes for both Linux and Windows.

Show More

34. Asp.Net

low Demand
Here's how Asp.Net is used in Data Warehouse Specialist jobs:
  • NET, ASP.NET, Visual C++
  • Integrated MS SSRS reports with ASP.Net time management system.

Show More

35. Essbase

low Demand
Here's how Essbase is used in Data Warehouse Specialist jobs:
  • Served 484 users in 29 Essbase access groups.

Show More

36. Production Environment

low Demand
Here's how Production Environment is used in Data Warehouse Specialist jobs:
  • Upgraded MicroStrategy to the latest version on both Development and Production Environments.
  • Deployed solution to development, test, and production environment.
  • Involved in evaluating various products from technical specifications viewpoint Responsible for deploying the mapping from development to production environment.

Show More

37. SAS

low Demand
Here's how SAS is used in Data Warehouse Specialist jobs:
  • Set up data staging and disaster recovery systems - Dell PowerVault MD1000 enclosures.
  • Developed the SAS enterprise guide data research and ad hoc reports and stored procedures.
  • Pinpoint and troubleshoot problems with WANs, LANs, and Servers; develop disaster recovery plans.
  • Designed the analysis strategy for Customer Satisfaction Survey data and develop SAS macros for automatically reporting process.
  • Establish and maintain detailed disaster recovery communications and command and control plans through a change management process.
  • Provide technical analysis, and lead system integration for internal SAS applications and other software applications.

Show More

38. Sybase

low Demand
Here's how Sybase is used in Data Warehouse Specialist jobs:
  • Performed Sybase & Oracle database benchmarks on SGI servers ranging from 4 to 32 CPUs.
  • Designed the SYBASE database and developed many stored procedures for validating the data.
  • Implemented SYBASE Replication as warm backup solution.
  • Monitored market data and post processing data from over 140 external data providers to ensure accuracy within Sybase relational database.
  • Assisted with architecture and programming of data access layer using Sybase stored procedures for Workers Compensation Quota Forte-based application.
  • Captured information and supported data transformation processing via meta-model from Sybase Workers Compensation database to internal and external systems.

Show More

39. Business Units

low Demand
Here's how Business Units is used in Data Warehouse Specialist jobs:
  • Led strategic planning and project execution for the organization for all business units.
  • Develop and maintain business reports, dashboards and dashboard widgets which are used by different business units.
  • Created and/or supervised the creation of standard reports for the various business units within the medical center.
  • Validated various Crystal Reports in several of the company's business units.
  • Worked with a number of business units to help develop processes and procedures relating to the IT area's involvement.
  • Worked with analysts and business units to review data sources and redesigned data preparation process.

Show More

40. Data Entry

low Demand
Here's how Data Entry is used in Data Warehouse Specialist jobs:
  • Handled documentation/information management operations; responsible for performing data entry, research and analysis, market research and database management.
  • Assisted in all aspects of information management and data entry for the Community United Way Campaigns and financial/internal operations.
  • Post data conversion development of collection database through enhanced data entry, object inventory, and digital photography.
  • Compiled patient information replacing lead, secured Project with data entry team, completed federally funded project
  • Developed stored procedures and triggers to facilitate consistent data entry into the database.
  • Demonstrate accurate typing and data entry skills to ensure timely data and statistical reporting.

Show More

41. DBA

low Demand
Here's how DBA is used in Data Warehouse Specialist jobs:
  • Provided feedback on current application user interface design and checks and balances to enforce standards in support of decentralized data management.
  • Identified sources of industry and competitive information, including industry associations, primary and secondary market research and customer feedback.
  • Collaborated with DBA's on performance tuning, indexing/partitioning strategies and data security.
  • Exchanged ongoing feedback, reinforcing achievements and supporting targeted interventions for teachers and students.
  • Resolved communication equipment failures utilized on a broadband network for SNA/TCP-IP and Ethernet protocols.
  • Presented and disseminated technical reports and key benchmarks/feedback to key stakeholder and senior leadership.

Show More

42. MDX

low Demand
Here's how MDX is used in Data Warehouse Specialist jobs:
  • Develop, debug and optimize SQL, T-SQL, XML, MDX queries and stored procedures, functions, triggers.
  • Created calculated Measures using MDX implementing business requirement.
  • Created management reports with SSRS as well as SQL and MDX queries.

Show More

43. Javascript

low Demand
Here's how Javascript is used in Data Warehouse Specialist jobs:
  • Utilize OBIEE Dashboard to convert existing dashboard of reports previously developed using JavaScript.
  • Created visual marketing ads using Google Earth, KML, Google Maps Mash-ups with Google Maps JavaScript API.
  • Used JavaScript functions to automate predictable data entries, replacing a tedious method in Excel.
  • Provide advanced-level support for users with a focus in JavaScript, jQuery, CSS, and advanced troubleshooting.

Show More

44. AIX

low Demand
Here's how AIX is used in Data Warehouse Specialist jobs:
  • Used PuTTY to connect to UNIX/AIX systems, and to make changes to files using the vi editor.
  • Crated wrapper shell scripts and symbolic links on AIX UNIX.
  • Developed ETL solutions for Federal Government Health Care contractor using Informatica 8.6, IBM DB2, and AIX UNIX shell scripting.
  • Managed (trained two Developers into DBAs) and designed a data warehouse conversion from Redbrick to Oracle 8ion IBM AIX.
  • Developed custom Korn shell scripts on AIX platform to perform data loads in DB2 EEE parallel database environment.
  • Designed tables for Oracle databases in AIX machine to store 2 Tera bytes Data Warehouse information.

Show More

45. Html

low Demand
Here's how Html is used in Data Warehouse Specialist jobs:
  • Designed and implemented a web portal for report requests and tracking utilizing ASP.Net, C#, and HTML.
  • Provided documents for depository, developed HTML code for customized interface, meeting Exec's needs.
  • Generated standard company reports in HTML and PDF formats.
  • Created and updated Active Server Pages (ASP) / HTML reports for Marine Corps users.
  • Developed and managed online registration components (Certain, HTML, CSS) of events.
  • Worked with HTML5, CSS, JavaScript, Node.js and ExtJS to develop rapid prototypes for client feedback.

Show More

20 Most Common Skill for a Data Warehouse Specialist

Data Warehouse22.4%
Pl/Sql11.7%
ETL10.2%
Business Requirements9.8%
Database9%
Informatica5.2%
SQL4.6%
Complex Mappings3.2%

Typical Skill-Sets Required For A Data Warehouse Specialist

RankSkillPercentage of ResumesPercentage
1
1
Data Warehouse
Data Warehouse
18.6%
18.6%
2
2
Pl/Sql
Pl/Sql
9.7%
9.7%
3
3
ETL
ETL
8.5%
8.5%
4
4
Business Requirements
Business Requirements
8.1%
8.1%
5
5
Database
Database
7.5%
7.5%
6
6
Informatica
Informatica
4.3%
4.3%
7
7
SQL
SQL
3.8%
3.8%
8
8
Complex Mappings
Complex Mappings
2.6%
2.6%
9
9
Unix
Unix
2.2%
2.2%
10
10
Ssis
Ssis
2.1%
2.1%
11
11
Architecture
Architecture
2%
2%
12
12
Olap
Olap
2%
2%
13
13
Ssrs
Ssrs
1.7%
1.7%
14
14
DB2
DB2
1.7%
1.7%
15
15
Data Analysis
Data Analysis
1.5%
1.5%
16
16
Metadata
Metadata
1.4%
1.4%
17
17
Suite
Suite
1.4%
1.4%
18
18
Teradata
Teradata
1.2%
1.2%
19
19
Microstrategy Web
Microstrategy Web
1.2%
1.2%
20
20
XML
XML
1.1%
1.1%
21
21
Toad
Toad
1%
1%
22
22
Ssas
Ssas
1%
1%
23
23
Datastage
Datastage
1%
1%
24
24
Powerplay Transformer
Powerplay Transformer
0.8%
0.8%
25
25
User Acceptance
User Acceptance
0.8%
0.8%
26
26
Technical Support
Technical Support
0.8%
0.8%
27
27
Project Management
Project Management
0.8%
0.8%
28
28
CRM
CRM
0.8%
0.8%
29
29
DB
DB
0.7%
0.7%
30
30
QA
QA
0.7%
0.7%
31
31
DTS
DTS
0.7%
0.7%
32
32
Data Management
Data Management
0.7%
0.7%
33
33
Linux
Linux
0.6%
0.6%
34
34
Asp.Net
Asp.Net
0.6%
0.6%
35
35
Essbase
Essbase
0.6%
0.6%
36
36
Production Environment
Production Environment
0.6%
0.6%
37
37
SAS
SAS
0.6%
0.6%
38
38
Sybase
Sybase
0.6%
0.6%
39
39
Business Units
Business Units
0.6%
0.6%
40
40
Data Entry
Data Entry
0.6%
0.6%
41
41
DBA
DBA
0.5%
0.5%
42
42
MDX
MDX
0.5%
0.5%
43
43
Javascript
Javascript
0.5%
0.5%
44
44
AIX
AIX
0.5%
0.5%
45
45
Html
Html
0.5%
0.5%

40,886 Data Warehouse Specialist Jobs

Where do you want to work?