Home > San Jose jobs > San Jose computer/technical

Posted: Saturday, August 5, 2017 12:03 AM


About the Job

Job Description

Job #: 764971

Apex Systems is currently supporting a Data Warehouse Engineer in Santa Clara, CA for one of our top clients. If you're interested, please send your resume to Allison at


The Enterprise Data Warehouse team is responsible for delivering data solutions that support all lines of business across the organization. This includes providing data integration services for all batch data movement; managing and enhancing the current data warehouse and dependent data marts; and providing support for analytics and business intelligence consumers.


  • Manage the end-to-end lifecycle for new data migration, data integration, and data services oriented solutions
  • Engage with partners in testing, release management, and operations to ensure quality of code development, deployment and post-production support
  • Analyze design specifications, documentation, and requirements surrounding the EDW technology components
  • Create high-level designs based on an understanding of the functional needs of projects or internal business clients
  • Ensure design of new solutions leverages existing software components where feasible
  • Generate SQL DDLs and physical tables for the purpose of loading target data stores
  • Develop ETL packages to extract, transform and load source to target stores using SAP BODS tool
  • Define and implement scheduling of jobs using Redwood scheduler
  • Write and perform unit testing of software components and integration programs
  • Execute unit tests to ensure that the software complies to functional requirements
  • Tune for performance ETL packages and target data stores based on expected use
  • Establish and maintain software and document change management policies and procedures
  • Experience in financial and credit card domains preferred

• Location: San Jose / South Bay, Santa Clara, CA

• Post ID: 71889113 sanjose is an interactive computer service that enables access by multiple users and should not be treated as the publisher or speaker of any information provided by another information content provider. © 2017