FIND PERSONALIZED JOBS
Sign up to Zippia and discover your career options with your personalized career search.
Sorry, we can't find that. Please try a different city or state.

Data Warehouse Consultant

This job has expired and is no longer available.
APPLY NOW
Apply Now
×
FIND
PERSONALIZED JOBS

Sorry, we can't find that. Please try a different city or state.

CONTENT HAS
BEEN UNLOCKED
Close this window to view unlocked content
or
find interesting jobs in

Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

Sign Up

SIGN UP TO UNLOCK CONTENT

or

The email and password you specified are invalid. Please, try again.

Email and password are mandatory

Forgot Password?

Don't have an account? Sign Up

reset password

Enter your email address and we will send you a link to reset your password.

Back to Log In

Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

Sign up to save the job and get personalized job recommendations.

Sign up to dismiss the job and get personalized job recommendations.

or

The email and password you specified are invalid. Please, try again.

Email and password are mandatory

Already have an account? Log in

reset password

Enter your email address and we will send you a link to reset your password.

Back to Log In

Company Saved

Answer a few questions and view jobs at that match your preferences.

Where do you want to work?

Job Saved

See your Saved Jobs now

or

find more interesting jobs in

Job Dismissed

Find better matching jobs in

Your search has been saved!

Top 50 Data Warehouse Consultant Skills

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

These are the most important skills for a Data Warehouse Consultant:

1. Data Warehouse

demand arrow
high Demand
Here's how Data Warehouse is used in Data Warehouse Consultant jobs:
  • Supported Quarterly Alignment and Targeting process from Data Warehouse and Reporting perspective.
  • Worked in several data warehouse projects in the telecommunication and entertainment industries.
  • Key contributor on enterprise-wide Data Warehouse, Master Data Management projects.
  • Served as primary point of contact for data warehouse integrated release projects
  • Analyzed and gathered business requirements for the Data Warehouse solution.
  • Designed and constructed corporate data warehouse infrastructure.
  • Realigned data warehouses for corporate acquisition.
  • Tuned and optimized Data Warehouse performance.
  • Developed Data Warehouse End User Application Tools and a Decision Support System (DSS) for advanced power users.
  • Created PL/SQL packages to migrate customer related tables to new unique key in the data warehouse.
  • Worked as a consultant at DaimlerChrysler in the Sales and Marketing Data Warehouse unit.
  • Handled data governance and stewardship for ResCap data domains and corporate data warehouse.
  • Involved in the data warehouse fact and dimension tables design using star schema.
  • Design of the second phase of the Click Stream Data Warehouse Analysis.
  • Involved in full life cycle design and development of Data warehouse.
  • Involved in the implementation of data warehouse solution.
  • Provided technical leadership and architecture design expertise for multiple FDIC projects including multiple large departmental data warehouses and analytical solutions.
  • Led development and integration of data warehouses, operational and analytical applications.
  • Delivered and sign-off of deliverables pertaining to the Operations Data warehouse.
  • Automated backups of the staging and Data Warehouse dev,UAT and Production databases and backup retention policy.

Show More

2. ETL

demand arrow
high Demand
Here's how ETL is used in Data Warehouse Consultant jobs:
  • Involved in designing ETL batch production process and developed production support guide documents including process dependency.
  • Supervised seven senior ETL developers.
  • Streamlined existing architectures and ETL processes to enhance operational reporting needs with the creation of Operational data store (ODS).
  • Created ETL transformation design rules, conducted code reviews and guided development team to successfully deploy ETL solutions.
  • Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures.
  • Worked with upper level management to define and enforce ETL architecture, strategy and data warehouse efficiency.
  • Developed using Data Modeler + SQL Developer and ODI 11.1 topology, ETL, scheduler, agent.
  • Led analysis and integration (ETL) in the successful deployment of data warehouses on Oracle 9i.
  • Evaluated architecture, Fault Tolerance, Data Quality, Quality Assurance methodology, and ETL metadata.
  • Managed large teams of ETL developers to develop large data stores and data warehouses.
  • Improved ETL performance and maintained data flow volumes in excess of 10GB per day.
  • Transformed 0NF mainframe extracts to 1NF in Staging ETL and again to 2NF/3NF in ODS ETL.
  • Devised reusable template system for Informatica PowerMart 6.1 that facilitated rapid ETL development.
  • Performed reverse engineering of GE's consumer data warehouse hand coded ETL and converted into Ab-initio ETL graphs.
  • Involved in the error checking and testing of the ETL procedures and programs of Informatica session log.
  • Played role in design of scalable, reusable, and low maintenance ETL templates.
  • Analyzed existing ETL tools, Reporting logics to check for bugs when reported.
  • Analyzed ETL processes used to replicate Informix data to the Oracle ODS.
  • Developed the ETL jobs by using core java(which is an Standard templates used by Freddiemac).
  • Developed and implemented ETL processes using Informatica with DB2 EEE * Developed data models and dimensional datamarts using ERwin and Cognos Powerplay

Show More

3. Pl/Sql

demand arrow
high Demand
Here's how Pl/Sql is used in Data Warehouse Consultant jobs:
  • Developed and Implemented Operational Data Store that gets populated incrementally using dynamic PL/SQL packages.
  • Implemented custom transformation using PL/SQL packages for Data reconciliation.
  • Extracted business rules from existing documentation and ETL process written in Pro C, PL/SQL, shell script and PERL.
  • Created PL/SQL scripts, Cursors, Triggers, Functions, Packages and involved in Performance tuning of the databases.
  • Involved in analyzing the bugs, performance of PL/SQL Queries and provided solutions to improve the same.
  • Involved to develop procedures, functions, packages and triggers for enforcing the business rules using PL/SQL.
  • Developed PL/SQL procedures, functions using Dynamic SQL, PL/SQL tables, BULK Load features.
  • Enhanced applications with SQL, PL/SQL API for insurance coverage premiums and claims business rules.
  • Coded many complex Oracle queries and PL/SQL.
  • Developed PL/SQL procedures, functions.
  • Coded ODI interfaces, scenarios, packages, with calls to Python, PL/SQL, SQL, Bash scripts.
  • Developed an automatic load process for a MS-Access application into Oracle leveraging SQL-Loader, Oracle PL/SQL, Perl and ksh scripts.
  • Developed many shell scripts, PL/SQL programs for various activities, user views for accessing the data and many Brio reports.
  • Developed advanced queries, analytical SQL, PL/SQL packages, procedures and functions for insurance claims and premiums applications.
  • Created frameworks for ETL processes that developers could modify to suit their needs for Informatica and PL/SQL.
  • Involved in data warehousing applications support using Informatica, PL/SQL, Unix Shell scripting, & ESSBASE.
  • Developed various bulkload and update procedures and processes using SQL * Loader and PL/SQL.
  • Supported PL/SQL and Informatica production load processes.
  • Developed PL/SQL stored procedures for pre and post session commands and used indicator files to run tasks in workflows.
  • Advanced SQL and PL/SQL: dynamic sql, pipelined functions, xpath, xquery, xsql, xml parser.

Show More

4. Informatica

demand arrow
high Demand
Here's how Informatica is used in Data Warehouse Consultant jobs:
  • Tuned and modified existing Informatica mappings for Performance enhancement testing.
  • Created Sessions/Batches in Informatica server manager to execute mappings.
  • Loaded various Key Performance measures (KPI) FACT tables and multiple dimension tables for RMS using Informatica PowerCenter 8.1.1.
  • Involved in the creation of new users and controlling and administering the access privileges to Informatica Power Analyzer.
  • Tuned performance of Informatica mappings using components like Parameter files, Variables and Dynamic Cache.
  • Resolved many performance bottle necks of database and Informatica mappings.
  • Developed ETL process using Informatica Power Center on Oracle 10g.
  • Designed Informatica Mappings for populating the dimensions and fact tables.
  • Used Informatica to build and handle code.
  • Monitored daily DAC and Informatica loads.
  • Worked with data profiling on different datasets using Informatica.
  • Developed the Informatica mappings/wfs based on the documented TSD, unit test and deploy the code.
  • Developed complex mappings & mapplets in Informatica to load the data using different transformations.
  • Impact analysis for the changes scheduled in the release using Informatica meta data Manger.
  • Derive lineage between the source and target table structures using Informatica Meta data manager.
  • Defined UNIX Batch scripts for automation of execution of Informatica workflows.
  • Created and monitored workflows/sessions using Informatica Server Manager/Workflow Monitor to load data into target SAP.
  • Remediated QA issues: debugged MS SQL Server and Oracle SQL; Oracle stored procedures; and Informatica workflows.
  • Created and Scheduled Workflows based on demand, run on time, run only once using Informatica Workflow Manager.
  • Tested Informatica 8.6 with all functionalities for migration of Informatica 6.2/7.1.2 to 8.6.

Show More

5. Update Procedures

demand arrow
high Demand
Job type you want
Full Time
Part Time
Internship
Temporary

6. Business Requirements

demand arrow
high Demand
Here's how Business Requirements is used in Data Warehouse Consultant jobs:
  • Designed and developed data models of the Products based on the business requirements gathered using in-house developed Product Modeling tool.
  • Gathered business requirements, advised developers, constructed logical and physical data models, mentored admins and documented processes.
  • Consulted with client business experts, gathered and defined business requirements; wrote business and technical functional specifications.
  • Analyzed the business requirements and translated into dimensional data models by using extended star schema techniques.
  • Performed business requirements gathering, documentation, data cleansing and extraction, report design and implementation.
  • Developed and designed transformation logic and aggregate table needs to satisfy business requirements.
  • Developed Aggregations, partitions and calculated members for cube as per business requirements.
  • Worked with Director of Decision Support on business requirements and designed functional specifications.
  • Involved in gathering business requirements for making new data warehouse reports.
  • Developed Technical specification guidelines from business requirements.
  • Translated business requirements into technical specifications.
  • Created technical specification to transfer business requirements to ETL team, and unit testing, integration testing plans.
  • Reviewed RDUR business requirements and implemented data warehouse to load large data from insurance companies Argus and Vista.
  • Designed load strategies and sequencing for the sessions based on the business requirements and dependencies.
  • Worked with subject matter expert to gather business requirements, defined business rules and logic.
  • Participated in the meetings with end users to gather business requirements.
  • Analyzed and gathered business requirements for the data import process.
  • Involved in business meeting and directly interacted with business users and converted business requirements into design specs..
  • Reviewed all business requirements and ensured the requirements were being met through the entire project lifecycle.
  • Gathered and documented business requirements (BRDs) and produced several project deliverables.

Show More

7. Unix

demand arrow
high Demand
Here's how Unix is used in Data Warehouse Consultant jobs:
  • Developed UNIX scripts to extract data from tables and place the data into Excel format in an on demand basis.
  • Developed Oracle PL/SQL packages, procedures and functions and UNIX shell scripts in accordance with the internal software standards.
  • Designed dimensional data models, developed SQL and UNIX scripts to automate extraction and loading of data.
  • Created CRON JOB files to sequentially schedule batch processing for the project from a UNIX shell.
  • Created various UNIX shell scripts for scheduling various data cleansing scripts and loading scripts.
  • Implemented and automated processes using Unix Shell Scripting to execute SQL, PL/SQL scripts.
  • Developed UNIX shell scripts to automate file manipulation and data loading procedures.
  • Automated the load process using UNIX shell scripts.
  • Developed UNIX scripts and modified Perl scripts.
  • Maintained batch processes using UNIX Shell Scripts.
  • Created workflows for incremental loading of data into atomic and mart layers which used parameter files created by UNIX scripts.
  • Install and Administer Informatica 8.1/7.1 and create Oracle 10g/9i database on Unix.
  • Designed and developed several ETL Scripts using Informatica, Unix Shell Scripts.
  • Developed UNIX scripts and PERL scripts for pre data manipulation.
  • Installed Informatica server on both windows and UNIX platforms.
  • Played a key role in implementing and migrating Audience Measurements code/data into Redshift Database from Netezza Database using Unix shell scripting.
  • Involved in developing UNIX Korn Shell wrappers to automate various Ab Initio jobs.
  • Involved in developing UNIX Shell script and scheduling jobsusing OpCon job scheduler.
  • Developed and modified UNIX shell scripts to reset and run Informatica workflows.
  • Source Platforms worked with (Mainframe, As400/ISeries, Windows, Unix, VM, SQL, Active Directory .)

Show More

8. Windows XP

demand arrow
high Demand

9. SQL

demand arrow
high Demand
Here's how SQL is used in Data Warehouse Consultant jobs:
  • Developed data reconciliation SQL queries to validate the overall data migration.
  • Designed and implemented a SQL server disaster recovery process.
  • Created complex conditions (Dates), Prompts and free hand custom SQL to create Derived tables in the universe.
  • Ensured quality of the data being populated in the data marts through execution of SQL against the data mart tables.
  • Scheduled the DTS package for migration data from old system to MS SQL 2005.
  • Performed installation, configuration and upgrades to multiple SQL Servers on Windows 2000.
  • Planned, designed and implemented in-depth unit and system tests using SQL.
  • Reconciled data for transformation from SQL 2000 to SQL 2005 using SSIS.
  • Worked and Implemented Rules/Mappings Microsoft SQL Server Master Data Services.
  • Created SQL stored procedures and triggers in SQL server 2005.
  • Experience in SQL tuning using Hints, Materialized Views.
  • Created the Tabular SQL to create the customized reports.
  • Conduct Joint development and work sessions to collaborate with the team and fix architecture issues and sql fixes and testing.
  • Design and develop SSIS packages to export SQL Server data to Excel,Flat files for reporting.
  • Integrated agricultural statistics into Winfield farm seed MSSQL 2005 data mart.
  • Create SSIS Packages to migrate data from / to Azure Cloud (Azure SQL Database) , Azure Blob Storage.
  • Developed Oracle PLSQL backend database procedures, UNIX shell scripts, workflow command scripts for maintenance of the data store.
  • Used SSMA for Oracle to import from Oracle into Sql Server.Data profiling of Oracle DB by running Oracle SQL queries.
  • Create SQL Server Agent jobs for loading Datawarehouse,Staging,Reporting extracts on a daily basis.
  • Publish reports to sharepoint and reportserver and adhoc reporting using t-sql and report builder 3.0.

Show More

10. Workflow

demand arrow
high Demand
Here's how Workflow is used in Data Warehouse Consultant jobs:
  • Generated completion messages and status reports using Workflow manager.
  • Involved in Production Monitoring using Workflow Monitor.
  • Performed unit testing and created unit testing document and process flow documents for workflows that fall under different subject areas.
  • Modified the existing ETL code (Mappings, Sessions and Workflows) and Perl scripts as per the user requirements.
  • Identified and removed bottlenecks to improve the performance of Mappings, Sessions and Workflows using partitioning.
  • Created Session, Event, Command, and Control Decision and Email tasks in Workflow Manager.
  • Involve in ETL development which involved creating new mappings, workflows to meet the requirement.
  • Review and approve technical ETL specifications, maps and customized workflows/sessions.
  • Used Workflow Manager to create session task and other tasks.
  • Write Perl scripts to schedule workflows and run ETL jobs.
  • Upgraded all the mappings and created new workflows from Informatica 7.1.3 to 8.5.1 according to the rules/ conventions of 8.5.1.
  • Created workflows and used various tasks like Email, Event-wait and raise, decision in workflow manager.
  • Used Workflow monitor to monitor tasks, workflows and also to monitor performance.
  • Created workflows and worklets for designed mappings.
  • Participated in the installation and customization of Livelink web-based knowledge management and workflow processing software for a local telecom company.
  • Prepared Sessions, Workflows, Worklets for Mappings in Informatica.
  • Created Workflows in the Workflow designer and Executed Tasks such as Sessions, Commands, etc using Informatica 7.1 Workflow manager.
  • Involved in creating Workflows, Worklets and Configured Sessions, Used pmcmd command of Informatica in UNIX scripts.
  • Defined workflow architecture and created many workflows, worklets & tasks / sessions using the workflow manager.
  • Used Workflow Manager to create worklets and workflows and Workflow Monitor to monitor the workflows.

Show More

11. Schema

demand arrow
high Demand
Here's how Schema is used in Data Warehouse Consultant jobs:
  • Involved in Logical and Physical design of Data warehouse/Staging Schema.
  • Delivered a start schema based data warehouse logical design.
  • Star Schema design and implementation of uniform dimensions.
  • Worked with a business analyst and a DBA to design and implement a star schema for the employee productivity data warehouse.
  • Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
  • Analyzed and created Facts, Dimension tables and Data warehousing data marts in Star join schema.
  • Created new snow flake dimensions in HR star schema and loaded them according to business logic.
  • Designed the ETL architecture and load strategy for a multiple fact table star schema.
  • Developed star schema for the legacy and next generation data warehouse on MySQL.
  • Involved in Design and Modeling using Star Schema and Snowflake Schema using Erwin.
  • Led technical design of data warehouse model employing star schema dimensional model.
  • Created document based dynamic schema based on relational SQL Server based schema.
  • Participated in Designing of Dimension model (STAR Schema).
  • Designed star schema in support of gas deal accounting initiative.
  • Modeled the data warehousing data marts in Star join schema.
  • Designed and developed data marts using Start Schema.
  • Created Mondrian schema for ROLAP based reports
  • Led Enterprise Data Warehouse initiatives to deliver Hotel, Gaming and Enterprise dimensional database schemas.
  • Create synonyms for schemas, DB links between databases, tables, view etc.
  • Design of Datawarehouse and data marts with Star schemas and Snowflake architecture and Kimball Dimensional Modeling.

Show More

12. Toad

demand arrow
high Demand
Here's how Toad is used in Data Warehouse Consultant jobs:
  • Generated fact, dimension, and support tables using TOAD and DDL scripting.
  • Validate the required data at the database level by using tool Toad.
  • Created DDLs and used TOAD to create relational sources and targets, for use in Informatica.
  • Used Toad for analysis and maintained Database using DLLs, DMLs.
  • Used Informatica PowerCenter 7.1, PowerDesigner 9.5, Toad Xpert, Cognos ReportNet, Oracle 9.2, Oracle 11i, HP-UX

Show More

13. Metadata

demand arrow
high Demand
Here's how Metadata is used in Data Warehouse Consultant jobs:
  • Configured interactive dashboard with drill-down capabilities using global and local filters, metadata objects and web catalog objects.
  • Developed end-to-end reporting solution encompassing metadata, reporting, web access, and publication and subscription services.
  • Maintained Warehouse Metadata, Naming Standards and Warehouse Standard for Future Development.
  • Published and maintained the business rules in the corporate metadata repository.
  • Led efforts for design of EIW ETL metadata model/repository/population processes.
  • Managed and maintained the Enterprise MetaData Repository.
  • Involved in the creation and customization of FDA's UFFDM File Submission System, developed metadata and created various reports.
  • Created and managed the ETL Mapping Document to document the underlying relationships of the metadata.
  • Managed the Metadata associated with the ETL process used to populate the Data Warehouse.
  • Designed metadata to transition from mainframe tax system to new MSSQL + ADO.NET system.
  • Assisted in the design and Maintenance of the Metadata environment.
  • Collected metadata of the source systems.
  • Created SCD Type1 and Type2 mappings Maintained warehouse metadata, naming and warehouse standards for future application development.
  • Coded incoming data quality cardinality validation in staging and metadata capture in ODS.
  • Maintained a corporate Metadata Repository - EMeTA a web based metadata service.
  • Designed a metadata-based framework for Data Warehouse Reference data.
  • Developed metadata repository (rpd) that consists of Physical, BMM and Presentation layer.
  • Install and develop metadata dashboard and reports in Informatica Power Analyzer 5.0.2.
  • Created complete Python + PL/SQL metadata pre- and post-processing using ODI.
  • Deployed Informatica MetadataExchange for migrating source and targets in Informatica.

Show More

14. Teradata

demand arrow
high Demand
Here's how Teradata is used in Data Warehouse Consultant jobs:
  • Elicited requirements, designed, developed and tested reports/extracts using Teradata utilities in UNIX.
  • Worked with ET, UV, WT Tables, error handling and performance tuning in Teradata queries and utilities.
  • Extracted data from source systems to a data mart running on Teradata using utilities like MLOAD and FastLoad.
  • Worked closely with DBA in performance issues, while extracting the data from Teradata.
  • Created and deployed staging, relational and dimensional database in Teradata and BO.
  • Developed the Macros in Teradata to capture the changed data in Source.
  • Configured Teradata 4700 3 node system from the ground up.
  • Prepared the Teradata Macros to Implement the SDCR.
  • Experience in handling large data using Teradata Aster.
  • Prepared test cases for Teradata Scripts.
  • Developed file feed Teradata capabilities within EDW to extract and archive data on a consistent basis from different internal systems within Highmark
  • Designed and developed of a data warehouse solution Designed and implemented ETL/Teradata process and UNIX shell.
  • Created Teradata connections according to the requirement to extract data from Teradata source.
  • Implemented functional and technical design documents to present to the client for the Informatica process for the Teradata extracts.
  • Involved in integrating with Teradata sources to create, update and delete salesforce objects upon business requirements.
  • Prepared and ran the sql scripts to validate the data in Teradata warehouse.
  • Developed Teradata Multi Load scripts and Fast Export scripts.
  • Developed Teradata Bteq scripts for DB interactions.
  • Loaded Dimension and fact tables sourced from External data sources like SAP,Teradata,SAP BW.
  • Executed the Teradata macros to update Xmap values in Teradata Ware house.

Show More

15. DB2

demand arrow
average Demand
Here's how DB2 is used in Data Warehouse Consultant jobs:
  • Validated data integrity of Product Models using mainframe tools such as QMF, SPUFI, DB2Menu and DB2 Command Center.
  • Designed and developed voice pick near real time interface for retrieving messages from queue and loading into DB2 DWH.
  • Performed the ongoing delivery, migrating client mini-data warehouses or functional data-marts from DB2 to Oracle environment.
  • Developed production job streams to extract DB2 data for the quarterly financial client server profit reporting system.
  • Created UNIX shell script to extract data from various sources such as DB2 and Oracle.
  • Provided real time bi-sync replication solution between Oracle & DB2 databases using GoldenGate.
  • Project Lead & DBA for Data Migration, and Data Replication from DB2.
  • Transformed enterprise data warehouse architecture that included migration from DB2 to Oracle.
  • Developed Cobol2/DB2 programs to populate the data warehouse.
  • Integrated data from IMS databases to DB2.
  • Developed data warehouse extract routines using DB2 and/or Cognos Impromptu for internal customers including Government Programs, Actuary and Member Services.
  • Designed and developed databases for data warehousing projects in Teradata, Oracle, SQL Server, GreenPlum, and DB2/UDB.
  • Served on team to design enterprise data warehouse schema and to implement DB2 solution for sales and market- ing group.
  • Retail data warehouse for IBM/Profits in an MVS/390 DB2/Cobol environment.
  • Used Power connect to access DB2 tables and data.
  • Update COBOLDB2 program for OMNIPlus related changes.
  • Project Environment: Informatica Power Center (6.2.2, 7.1.3), DB2, Oracle 11i, UNIX, Windows XP.
  • Perform ETL development for a large national health care company using Informatica, Oracle, Teradata, DB2, and SQL.
  • Design, develop and implement over 1000+ of complex ETL Informatica processes, DB2 stored procedures, Teradata BTEQ scripts.
  • Debugged many problems involved with DB2, COBOL and CICS using different tools such as Expeditor, Intertest and OmegamaII.

Show More

16. BI

demand arrow
average Demand
Here's how BI is used in Data Warehouse Consultant jobs:
  • Demonstrated ability to identify business and data requirements and convert high level requirements into conceptual and logical data models.
  • Stabilized the database environment upon arrival, building all basic operational infrastructure while actively deploying BI products.
  • Updated the connections for around 150 universes in each test cycle and upgraded the BO 3.1 reports to BI 4.0 reports.
  • Defined logical classes, objects and hierarchies for analysis and drilling on hierarchies in the WebI reports.
  • Hosted SSIS knowledge transfer, data quality issue meetings with the client on a weekly/biweekly basis.
  • Prepared the required Motorola's Capability Maturity Model (CMM) Level 4 documents.
  • Designed and developed the jobs using Orchestrate which has the parallel extender ability.
  • Followed standard Back up policies to make sure the high availability of cluster.
  • Used combination of time interval and record count for checkpoints as data boundary.
  • Coordinated technical staff to support file availability and test loads.
  • Modified Crystal 9.2 reports used to display exhibits.
  • Converted binary, BCD etc.
  • Code migration, Integration Testing, UAT of BI and ETL code 6.
  • Supported and advised on full MS-BI stack development, primarily related to Army's Force Risk Reduction (FR2) program.
  • Developed and reviewed the Standardization, Scrubbing, Matching and Survivorship rules in order to get best of the breed record.
  • Created Abinitio queues that will work as intermediary data source for internal applications reading the same source.
  • Created and published the reports on Webi 2.5 to make them accessible through the corporate Intranet.
  • Name of the applications are Persistent Data Warehouse, Phoenix Business Intelligence, Biopharm Dashboard.
  • enhance & maintain the reporting application build with Oracle BI Apps - Sales & Marketing Analytics for MyFieldPoint project.
  • Designed and developed Custom BI analytical repository/metadata (.rpd) using Siebel Analytics Admin tool.

Show More

17. Cognos

demand arrow
average Demand
Here's how Cognos is used in Data Warehouse Consultant jobs:
  • Trained the users on the new features in ReportNet/Cognos8.
  • Designed relational and dimensional models using Framework Manager and generated reports from the data marts using cognos Report Studio.
  • Implemented package level security in framework manager and report level security in Cognos connection.
  • Generated reports using Cognos Impromptu tools querying database.
  • Involved in the Installation, Configuration and Administration of Cognos Impromptu Administrator and Access Manager, Netscape Directory Server, Upfront.
  • Install & Troubleshoot IBM Cognos TM1 9.5.1 & 10.2 Server, Architect, Perspectives, Contributor and Web.
  • Designed, developed reports using Cognos 8.4 Report Studio and Modeling using Framework Manager.
  • Served as the Cognos Architect and Administrator and as the Data Warehousing Administrator.
  • Plan, design, Implement and maintain reporting applications using Cognos.
  • Scheduled and distributed reports using schedule management on the Cognos portal.
  • Migrated reports from Cognos Impromptu to Report Net 1.1.
  • Scheduled reports using Cognos scheduler as needed.
  • Created standard and Ad hoc reports using Cognos Impromptu Designed catalogs and defined User Classes, Security and Privileges.
  • Developed and implemented Cognos reporting solution; 20+ reports (70% using crosstabs) and 75 users.
  • Power play Transformer 7.4, SQL HTML, Cognos data manager, Informatica 8.5, Erwin 4.0.
  • Worked with IBM Cognos 10.2.1 BI, Maximo Asset Management & Oracle 11g.
  • Provided access to users based on their assigned roles thru Cognos access manager.
  • Created reporting tables for Cognos Involved in production Support (24/7).
  • Scheduled the reports using Cognos Scheduler and Cognos connection.
  • Developed a Cognos Custom Java Authentication Provider module that integrated Cognos API seamlessly with corporate authentication source in a real-time way.

Show More

18. Olap

demand arrow
average Demand
Here's how Olap is used in Data Warehouse Consultant jobs:
  • Analyzed existing systems profiling usage and capacity trends for SQL and Oracle OLTP and OLAP oriented data bases and warehouses.
  • Installed, configured, created aggregations, OLAP cube and tested the performance against AS/400 data.
  • Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
  • Create OLAP models for reporting and developing some reports for testing purpose.
  • Worked on Database architecture of OLTP and OLAP applications.
  • Created, designed and developed OLAP cubes.
  • Deployed and processed OLAP Cubes.
  • Used the SAS for Sales Reports & OLAP tool to build the front-end cube and reports to access the Database.
  • Utilized SSRS to create the UI based on OLAP data.
  • Developed both complex and ad-hoc queries and deliver via Business Objects reports, Analysis Services OLAP cubes and Excel pivot tables.
  • Created flowcharts indicating input data sets, ODDs, Data & OLAP Tables and the mapping processes.
  • Key Accomplishments: Selected to team to create proof-of-concept and then source OLAP tools.

Show More

19. XML

demand arrow
average Demand
Here's how XML is used in Data Warehouse Consultant jobs:
  • Imported an XML file to Designer, did some modifications, used in the Mappings and exported into an XML file.
  • Developed complex mappings to load data from Source System (RDBMS), XML files and flat files.
  • Created XML templates and UNIX scripts to extract data from the tables.
  • Worked with XSD and XML files generation through ETL process.
  • Use of XML versions of various informatica objects during code/object migration between different environments.
  • Developed continuous flow graphs that will run in a continuous mode to publish XML messages to the TIBCO bus.
  • Integrated Oracle reports with Java API's Generated the Oracle Reports using different data providers like XML data.
  • Created ETL packages using datasources like SQL server, Flat Files, CSV, Excel and XML Files.
  • Experience in creating master and child packages,using package configurations (XML,SQL Server)and SSIS logging.
  • Performed Unit testing and load testing for Webservice and xml mappings.
  • Key Projects Amerada Hess Corporation: Co-authored whitepaper on emerging wireless web and VoiceXML for Amerada Hess Corporation.

Show More

20. Repository

demand arrow
average Demand
Here's how Repository is used in Data Warehouse Consultant jobs:
  • Developed a common data repository for personnel data previously stored in non-integrated legacy systems.
  • Performed security and user management repository backup using the same tool.
  • Maintain Development, Test and Production Repositories using Repository Manager.
  • Managed meta-data repository to track requirements through multiple systems.
  • Created folders and folder permissions in Repository manager.
  • Created Repository using Repository Manager.
  • Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
  • Implemented the security in the repository for the data level and object level security the Presentation Level.
  • Created the repository manager, users, user groups and their access profiles.
  • Involved for creating the backup of the repository.
  • Export the Universe and documents to the Repository.
  • Published all the reports to the repository.
  • Created various customized Repository Reports using Cognos Impromptu, Transformer and Multi-Dimensional reports using Power Play.
  • Created Repositories and Users and groups assigning privileges to users Using Informatica Repository Manager.
  • Worked Extensively on Informatica tools -Repository Manager, Designer and Server Manager.
  • Involved in Informatica repository Management.
  • Used Datastage Manager to Export/Import contents of the repository and to create server routines to implement execution logic.
  • Involved in Installing Informatica and creating the Repository.
  • Worked Extensively on Repository Manager, Designer and Workflow Manager and Workflow Monitor.
  • Involved in multi-source Extraction Transformation and loading into the Repository using Informatica.

Show More

21. Source Systems

demand arrow
average Demand
Here's how Source Systems is used in Data Warehouse Consultant jobs:
  • Translate business-reporting requirements into data warehouse architectural design and analyzing legacy source systems and target data models to design ETL process.
  • Applied dimensional model and data warehouse methodologies to numerous source systems for business intelligence initiatives and reporting solutions.
  • Reviewed multiple data source systems and recommended data acquisition and transformation strategy.
  • Generate Email Notifications and to load data from different Source systems like flat files and Oracle databases.
  • Involved in data mapping activities from source systems to target with Business Analysts and Data modelers.
  • Extracted data from various source systems like Oracle, SQL Server, and Flat Files.
  • Extract the data from different Source systems and keep in to staging area.
  • Analyze source systems and business requirements and create functional and technical design documents.
  • Developed ETL strategies and techniques for CMF population from multiple source systems.
  • Project Architect/Tech Lead/Pharmaceutical * Created and developed staging and data mart models for 3 HR source systems.
  • Designed and developed extract, transform and load (ETL) processes from customers' source systems into Birst warehouse.
  • Created Inbound and Outbound Integration between EBS and other source systems (Manhattan, Shortscope,E80 and Logility).

Show More

22. Lookup

demand arrow
average Demand
Here's how Lookup is used in Data Warehouse Consultant jobs:
  • Used active/passive transformations and connected/unconnected lookup to design mapping.
  • Used Script component, Lookups, Merge join, Derived column, FTP Task in my project.
  • Cleansed Data warehouse data by designing SSIS package (Fuzzy Grouping, Fuzzy Lookup).
  • Involved in Performance tuning by finding bottlenecks like lookups for better performance.
  • Involved in re writing many existing SQL/lookup codes for performance improvements.
  • Utilized single sources and multiple targets as well as detached lookups.
  • Developed transformations and code lookups for mappings using PL/SQL.
  • Implemented framework for Reference/Lookup data changes,Automation of Applying Database Change Request scripts to the target DB.
  • Implemented Semantic views, Slowly changing dimensions, lookups and complex business logics.
  • Used the best transformation techniques for key lookups using CTAS technique and etc.

Show More

23. Test Cases

demand arrow
average Demand
Here's how Test Cases is used in Data Warehouse Consultant jobs:
  • Documented processing times for each module, developed test cases and used them to run through each process.
  • Review and help create test cases to perform Functional Testing, Security Access Testing and Regression testing.
  • Build database queries and test cases for the testing team to test the reports.
  • Involved in Testing like writing Test Plans, Test Cases and Test execution.
  • Performed unit testing of the mappings developed and documented the test cases.
  • Devised test cases to ensure captured mappings were correct.
  • Involved in Testing for preparing Unit Test cases.
  • Involved in writing test cases for BODI jobs.
  • Worked on test cases and test plans.
  • Documented all my assignments Wrote useful test cases and involved in unit testing of mappings that I developed.
  • Prepare test cases, perform testing and documentation in Mercury Quality Center tool for production migration approvals.

Show More

24. DBA

demand arrow
average Demand
Here's how DBA is used in Data Warehouse Consultant jobs:
  • Trained DBA group on performance tuning techniques, identifying locking, and baseline and capacity planning tasks for increasing application performance.
  • Worked with large team of 20+ people including business analysts, DBA's, Java, Oracle and MicroStrategy developers.
  • Create Test Track Pro (TTP) tickets and assign tasks to DBA, Data Modeler, and developers.
  • Involved in Interaction with DBA team for creation of primary and secondary indexes on Data warehouse tables.
  • Work with DBA's and systems support personnel in elevating and automating successful code to production.
  • Coordinate with DBA teams, Users and Business Analysts for Code deployments in Production.
  • Involved in Production Support and worked closely with DBA's in performance issues.
  • Developed strategies for data acquisitions and assist DBA in archive and recovery efforts.
  • Provide resolutions / feedback to data experts for the data to be corrected.
  • Served as Development DBA, supporting a development team of 75 developers.
  • Worked closely with DBA/Architect in designing architecture to handle Terabytes of data.
  • Provided Microsoft SQL Server DBA support for decision support systems being replaced.
  • Worked closely with DBA's in performance issues.
  • Collaborated with DBAs and other technical professionals to design and implement data solutions.
  • Performed DBA/analysis duties on a multi-tera byte data warehouse.
  • Interacted and coordinated closely with the DBAs in resolving the database issues that lead to production job failures.
  • Trained and mentored existing DBA and development teams in scalability and cloud based impacts of future company directions.
  • Collaborate with DBAs to resolve database performance issues on both source and target databases.
  • Managed a large team of Oracle dbas both onshore and offshore.
  • Involved with the DBA in performance tuning of the Informatica sessions and workflows.

Show More

25. Data Analysis

demand arrow
average Demand
Here's how Data Analysis is used in Data Warehouse Consultant jobs:
  • Conducted information and data analysis, ETL design, development and implementation and overall performance tuning.
  • Delivered solutions spanning data analysis, data validations, and Business Intelligence Solutions.
  • Performed Data analysis work for new and existing business requirement.
  • Performed data analysis, gap analysis and mapping requirements.
  • Performed Data Analysis and Profiling.
  • Conduct data analysis of source system to learn data relationship, parse business rule to perform data profiling and data cleansing.
  • Build the CAA Data Analysis and Reporting environment, document business requirements, profile data, and produce reports.
  • Led development teams of up to five developers on data analysis, migration and reporting projects.
  • Worked on Data Extraction, Data Transformations, Data Loading, Data Conversions and Data Analysis.
  • Conducted data modeling, data analysis and designed Star and Snowflake schema design.
  • Performed data analysis using SSAS and SQL to uncover data relationships.
  • Performed Data Analysis for new source systems.
  • Updated the existing personell data analysis system to using SSAS and SSRS 2008.
  • Co-authored Scenario Driven Architecture Assessment Methodology for Large Data Analysis Systems with Edmon Begoli of ORNL and Bill Inmon.

Show More

26. Aggregator

demand arrow
average Demand
Here's how Aggregator is used in Data Warehouse Consultant jobs:
  • Used most of the transformations such as the Source qualifier, Aggregators, lookups, Filters, Sequence and Update strategy.
  • Worked extensively with complex mappings to create Fact tables and summary tables using expressions, aggregators, filters and lookups.
  • Implemented Aggregator, Joiner, Sorter, Router, Lookup, Update Strategy and Stored procedure transformations to optimize mappings.
  • Worked on different stages in PX like Join, Lookup, Funnel, Filter, Merge, Aggregator and Transformer.
  • Used various stages of Parallel Jobs such as aggregator, sort, transformer, sequential file and lookup file.
  • Worked with mappings using expressions, aggregators, filters, lookup, update strategy and stored procedures transformations.
  • Created Transformations such as Lookup, Expression, Aggregator, Router, Union, Joiner Transformations.
  • Used various transformations like unconnected lookup, connected lookup, aggregator, rank, joiner, stored procedure.

Show More

27. Solaris

demand arrow
average Demand
Here's how Solaris is used in Data Warehouse Consultant jobs:
  • Warehouse is Oracle on Solaris.

Show More

28. Session Log

demand arrow
average Demand

29. Source Qualifier

demand arrow
average Demand

30. Complex Mappings

demand arrow
low Demand
Here's how Complex Mappings is used in Data Warehouse Consultant jobs:
  • Developed Transformation logic and designed various complex Mappings in the Designer.
  • Developed complex mappings using multiple sources and targets in different databases, flat files.
  • Developed informatica workflows, using different transformations and translating business logic to complex mappings.

Show More

31. Datastage

demand arrow
low Demand
Here's how Datastage is used in Data Warehouse Consultant jobs:
  • Worked with DataStage Manager for importing metadata from repository, new job, categories and creating new data elements.
  • Implement approved changes to SQL scripts and IBM InfoSphere DataStage Projects using the Designer Client software.
  • Designed and developed Several DataStage ETL Mappings to populate the data into dimensions and fact tables.
  • Performed Import and Export of DataStage components and table definitions using DataStage Manager.
  • Implemented type I & II slowly changing dimensions tables and DataStage Jobs.
  • Implemented IBM WebSphere DataStage and Quality Stage 8.1 as an ETL tool.
  • Created master controlling sequencer jobs using the DataStage Job Sequencer.
  • Designed and developed ETL jobs using DataStage 8.7.
  • Design and develop Datastage jobs, Sequencers, Shared containers and routines to implement business requirements and design specifications.
  • Developed user defined Routines and Transformations by using Datastage Basic.
  • Design, develop and implement new ETL processes using DataStage, Shell Script, Syncsort, Oracle, and PL/SQL etc.
  • Prepared technical specifications to develop Datastage ETL jobs to load data into various tables confirming to the business rules.
  • Designed, developed and implemented EDI mapping utilizing Datastage TX to format various complex data formats.
  • Developed Datastage jobs to extract the data from source tables and load into staging area.
  • Participated in Oracle, Informatica and DataStage TX performance enhancement to increase ETL load performance.
  • Carried out the following activities: Design and Development of SQL queries and DataStage Jobs.
  • Developed shell script to run the Datastage jobs.
  • Design and Develop Datastage ETL jobs and test cases on Teradata.
  • Batch Processing Design and Implementation of Reports Batch jobs using PL/SQL and Ascential Datastage.
  • Developed several interfaces using Ascential Datastage v 5.2 Data warehouse Involved in Requirement analysis of the Data warehousing requirements.

Show More

32. Visio

demand arrow
low Demand
Here's how Visio is used in Data Warehouse Consultant jobs:
  • Collaborated with leaders in disparate divisions to facilitate change management and drive project toward a coordinated strategic solution.
  • Designed a development framework to supports SCD implementation with Mid-Point revisions.
  • Provided primary support for divisional DataMart applications.
  • Utilized VISIO to document and present complicated data diagrams, from source to target.
  • Implemented Marketing Expense data mart processes for three Eurasian divisions.
  • Implemented OTS project and Supervision Archival project.
  • Handled data provisioning following the merger of Lutheran Brotherhood and Thrivent Corporation.
  • Presented seminar on EDW history and best practices to staff of the Computational Sciences and Engineering Division of ORNL.
  • Integrated engineering test data into 24 terabyte Oracle data warehouse for Seagate s disk engineering division.
  • Used MS Visio to create diagrams for use in such documents.

Show More

33. UAT

demand arrow
low Demand
Here's how UAT is used in Data Warehouse Consultant jobs:
  • Provide expertise in identifying, evaluating and developing procedures that are cost effective and meet user requirements.
  • Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
  • Hired, supervised, motivated and evaluated personnel.
  • Designed and Implemented MicroStrategy infrastructure involving 43 Servers (Windows and Linux) for DEV, UAT and Production environments.
  • Performed Unit Testing, Integration Testing and User Acceptance Testing (UAT) for every code change and enhancement.
  • Created many materialized views for evaluating the net changes and used the same in incremental loading.
  • Involved in managing the code deployment to UAT, Performance and production.
  • Evaluate portfolio strategies to minimize risk and stay ahead of competitors.
  • Coordinated with the end users for integration and UAT test environments.
  • Evaluate new technical solutions for business problems and make proposals.
  • Exported the universe to UAT, Test and Development environments.
  • Evaluated and recommended ETL tools for SSA.
  • Led ETL tool vendors' evaluation project.
  • Coordinated with users during UAT.
  • Supported the UAT phase for the project.
  • Project Design and Development of People System Reporting to generate reports that will help to manage Personnel Evaluation System.
  • Developed programs and evaluating, analyzing, and designing proposed Web based OLAP Reports using Cognos Impromptu.
  • Migrated the mappings and workflows from development to system test environment and supported the UAT.
  • Analyze and evaluate data sources and bug fix for ETL tasks/Informatica mappings.
  • Involved in pre-deployment activities and was part of regressing and UAT.

Show More

34. Mapplet Designer

demand arrow
low Demand
Here's how Mapplet Designer is used in Data Warehouse Consultant jobs:
  • Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.

Show More

35. EDW

demand arrow
low Demand
Here's how EDW is used in Data Warehouse Consultant jobs:
  • Developed recommendations for new design solutions and/or process improvements for existing EDW and reporting environments.
  • Lead the strategic Data Integration initiative to replace Legacy system with the modern oracle retail merchandising application and SIEBEL-CRM with EDW.
  • Developed and documented all load processes for both initial load and incremental load into the Enterprise Data warehouse (EDW).
  • Created Hive queries that helped market analysts spot emerging trends by comparing fresh data with EDW reference tables and historical metrics.
  • Prepared the Source to stage and Stage to EDWNI mapping documents and provided to the offshore team for the Development.
  • Engineered data flow process to integrate JD Edwards supply chain data into Oracle Strategic Network Optimization (SNO) application.
  • Performed also in a DBA capacity in the maintenance of the EDW.
  • Support EDW which serves over 1000 users by receiving data from POS systems, TIBCO, SAP and Main Frame.
  • Designed and developed reusable EDW Architecture for high volume transactional and mission-critical business processes.
  • Reviewed/Developed Informatica ETL mappings/workflows and SQL that populates EDW.

Show More

36. Source Data

demand arrow
low Demand
Here's how Source Data is used in Data Warehouse Consultant jobs:
  • Extracted source data using power exchange from legacy systems such as VSAM and ADABA files, and implemented CDC.
  • Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
  • Involved in writing and tuning complex SQL queries for data extraction for outbound interfaces from Source Databases.
  • Analyzed the source data (Flat Files) and Created Packages based on Source data.
  • Prepare detail design documents, define new tables and data elements, source data mapping.
  • Worked closely with DBA to solve the source database (Oracle) issues.
  • Analyzed source data and gathered requirements from the business users.
  • Analyzed source data for data quality assurance.
  • Analyzed source data to determine what was required in the new data mart and met standards based on BRDs.
  • Source data is extracted from POS systems, Manugistics and Experian.

Show More

37. Autosys

demand arrow
low Demand
Here's how Autosys is used in Data Warehouse Consultant jobs:
  • Created multiple schedules using AutoSys for automating daily and nightly cycles.
  • Created batch files for scheduling the jobs on AutoSys.
  • Created and maintained AutoSys jobs to automate load processes.
  • Provided specifications to create various Autosys jobs to process the feeds starting File Watcher till Report generation.
  • Worked extensively on scheduling jobs end to end using Autosys.
  • Used Crontab mainly and sometimes AutoSys for job scheduling.
  • Create and maintain Autosys and Control-M job schedules.
  • Co-authored Autosys standards and FAQ for the team.
  • Used Autosys for scheduling the jobs.
  • Provide ETL execution support during UAT Skills Used Environment: Datastage, DB2, Unix, Rapid SQL, Autosys, ClearQuest
  • Created run books for job information which is scheduled on Autosys Involved in finding the production status by using Autosys commands.
  • Involved in testing Informatica Workflows individually and end-to-end (Integration) using Autosys jobs.
  • Involved in writing Autosys Jils for Box jobs as well as cmd jobs.

Show More

38. AIX

demand arrow
low Demand
Here's how AIX is used in Data Warehouse Consultant jobs:
  • Used PuTTY to connect to UNIX/AIX systems, and to make changes to files using the vi editor.
  • 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

39. Ssrs

demand arrow
low Demand
Here's how Ssrs is used in Data Warehouse Consultant jobs:
  • Developed web-based business intelligence various reports Crystal Reports and SSRS for sales penetration data.
  • Worked with stored procedures to support conversion of laboratory metrics from a Cold Fusion platform to SSRS.
  • Designed of reports with Reporting Services (SSRS) and perform ETL operations with (SSIS).
  • Used SSRS to create and manage a number of complex reports according to user specifications.
  • Created report snapshots to improve the performance of SSRS.
  • Designed and built SSRS reports.
  • Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
  • Designed and implemented parameterized and cascading parameterized reports using SSRS.

Show More

40. Update Processes

demand arrow
low Demand
Here's how Update Processes is used in Data Warehouse Consultant jobs:
  • Involved in the development and testing of individual data marts, Informatica mappings and update processes.

Show More

41. Obiee

demand arrow
low Demand
Here's how Obiee is used in Data Warehouse Consultant jobs:
  • Created modified logic to load Historical Data into data warehouse so users can get AS OF DATE data from OBIEE Answers.
  • Design the OBIEE Repository (RPD) for Physical layer, BMM layer and Presentation layer using OBIEE Administrator tool.
  • Worked on integrating and configuring BI Publisher with OBIEE, created and customized several SOL reports in BI Publisher.
  • Create Inventory Transaction Register report using OBIEE 11g and Testing/Data Validation of same.
  • Design, implement and maintain analysis, reports and dashboards using OBIEE.
  • Enable user and row level security using OBIEE Administrator tool.
  • Worked on improving Campaign reports in BI tool OBIEE.
  • Detail Responsibilities: Understanding and translating the business requirement to technical requirements for Med School Dashboard in OBIEE 11g.
  • Designed and implemented BI reporting using OBIEE 10g and Cognos 8.

Show More

42. Bteq

demand arrow
low Demand
Here's how Bteq is used in Data Warehouse Consultant jobs:
  • Worked on BTEQ Scripts to transport data from aggregate tables to EDW.
  • Developed ETL scripts using BTEQ to load various Aggregate tables.
  • Converted Unix-Oracle scripts to Unix-BTEQ scripts.
  • Developed Unix-BTEQ scripts and tested.
  • Designed various financial reports in NCR's Basic Teradata SQL (BTEQ) 4GL reporting tool for UNIX.
  • Worked on loading of data from several flat files sources using Teradata BTEQ, MLOAD & FLOAD.
  • Developed Unix- Bteq dependency scripts and tested.
  • Used Teradata Utilities like MLOAD, FASTLOAD, FASTEXPORT, BTEQ, WINDDI and SQL Assistant 12.0.
  • Developed ETL process and utilize Teradata BTEQ, SQL Assistant, fastexport, Tpump, fastload and multiload.

Show More

43. Backend Programs

demand arrow
low Demand
Here's how Backend Programs is used in Data Warehouse Consultant jobs:
  • Developed and tested all the backend programs, Informatica mappings and update processes.

Show More

44. Update Strategy

demand arrow
low Demand
Here's how Update Strategy is used in Data Warehouse Consultant jobs:
  • Used the update strategy to effectively migrate data from source to target.

Show More

45. QA

demand arrow
low Demand
Here's how QA is used in Data Warehouse Consultant jobs:
  • Created a reusable QAT mapping that could compare counts on up to 16 measures and SQL statements from a parameter file.
  • Supported migration of ETL code from development to QA and then from QA to production.
  • Synchronized and rectified all the exiting issues with the DEV, QA and PROD environment.
  • Tested the target data against source system tables by writing Some QA Procedures.
  • Created database staging tables for running the QAS batch for Postal Address Validation.
  • Supported QA Testing and fixed any issues if found.
  • Resolved issues and bugs raised by QA team
  • Created, configured and managed databases in a typical 4-tier environment (dev, test, QA, production).
  • Involved with migrating ETL code from Dev to QA and from QA to production.
  • Deployed Informatica objects to QA and UAT environments and tested in each environment.
  • Integrated Dashboards with dynamic data using live office, QAAWS and BI webservices.

Show More

46. Ssas

demand arrow
low Demand
Here's how Ssas is used in Data Warehouse Consultant jobs:
  • Developed, tested, and deployed the solution utilizing Microsoft SSIS and SSAS.
  • Aggregated data from business data sources in a multidimensional cube using Microsoft SSAS.
  • Developed Cubes using SQL Analysis Services (SSAS).
  • Designed Dimensional Modeling using SSAS packages for End-User.
  • Developed Multi dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).

Show More

47. Ensure Conformity

demand arrow
low Demand

48. Business Logic

demand arrow
low Demand
Here's how Business Logic is used in Data Warehouse Consultant jobs:
  • Performed in-depth analysis and documentation of business logic and requirements.
  • Extracted data form flat files and oracle database, applied business logic to load them in the central oracle database.
  • Staged Incoming data from different sources and applied various transformation rules according to business logic required by End User.
  • Imported Sources and Targets to create Mappings based on business logic and developed Transformations using Power center Designer.
  • Experience in defining Hierarchies based on Business logic and creating drill down reports.
  • Designed/developed Stored Procedures for data mappings to implement complex business logics and called from Informatica Stored Procedure Transformations.

Show More

49. Sequence Generator

demand arrow
low Demand

50. Different Transformations

demand arrow
low Demand
Here's how Different Transformations is used in Data Warehouse Consultant jobs:
  • Created Informatica Mappings and Mapplets using different transformations.

Show More

Data Warehouse Consultant Jobs

NO RESULTS

Aw snap, no jobs found.

20 Most Common Skills For A Data Warehouse Consultant

Data Warehouse

27.9%

ETL

9.4%

Pl/Sql

8.5%

Informatica

6.3%

Update Procedures

6.2%

Business Requirements

5.6%

Unix

4.8%

Windows XP

4.1%

SQL

3.8%

Workflow

3.6%

Schema

2.4%

Toad

2.4%

Metadata

2.3%

Teradata

2.2%

DB2

2.1%

BI

2.0%

Cognos

1.9%

Olap

1.5%

XML

1.5%

Repository

1.4%
Show More

Typical Skill-Sets Required For A Data Warehouse Consultant

Rank Skill
1 Data Warehouse 21.9%
2 ETL 7.4%
3 Pl/Sql 6.6%
4 Informatica 5.0%
5 Update Procedures 4.8%
6 Business Requirements 4.4%
7 Unix 3.8%
8 Windows XP 3.2%
9 SQL 3.0%
10 Workflow 2.8%
11 Schema 1.9%
12 Toad 1.9%
13 Metadata 1.8%
14 Teradata 1.7%
15 DB2 1.6%
16 BI 1.6%
17 Cognos 1.5%
18 Olap 1.2%
19 XML 1.2%
20 Repository 1.1%
21 Source Systems 1.1%
22 Lookup 1.1%
23 Test Cases 1.1%
24 DBA 1.0%
25 Data Analysis 1.0%
26 Aggregator 0.9%
27 Solaris 0.9%
28 Session Log 0.9%
29 Source Qualifier 0.9%
30 Complex Mappings 0.9%
31 Datastage 0.9%
32 Visio 0.7%
33 UAT 0.7%
34 Mapplet Designer 0.7%
35 EDW 0.7%
36 Source Data 0.7%
37 Autosys 0.7%
38 AIX 0.6%
39 Ssrs 0.6%
40 Update Processes 0.6%
41 Obiee 0.5%
42 Bteq 0.5%
43 Backend Programs 0.5%
44 Update Strategy 0.5%
45 QA 0.5%
46 Ssas 0.5%
47 Ensure Conformity 0.5%
48 Business Logic 0.5%
49 Sequence Generator 0.5%
50 Different Transformations 0.5%
{[{skill.rank}]} {[{skill.name}]} {[{skill.percentageDisplay}]}%
Show More

16,962 Data Warehouse Consultant Jobs

Where do you want to work?

To get started, tell us where you'd like to work.
Sorry, we can't find that. Please try a different city or state.