Position Title: Data Warehouse Engineer Reports to: Manager, Data Warehouse Engineering
Irvine/Las Angeles area. GC/Citizen only Position Summary: The Data Warehouse Engineer will work within the Enterprise Data Warehouse (EDW) team to install, update, maintain, monitor and support the Enterprise Data Warehouse/Enterprise Business Intelligence tools, applications and databases to support all client Business units. The individual will work closely in a team consisting of other data warehouse engineers, business analysts, business intelligence engineers, system analysts, quality assurance engineers and database administrators in developing data warehouse solutions to meet stated requirements, develop detailed specifications and unit test plans for implementation. Since EDW works with multiple business units to create cross functional solutions, the Data Warehouse Engineer must be able to interface with various business units to understand the requirements and prepare documentation to support development. The individual must be capable of understanding the complex object design and the underlying data model of the system. The individual must be comfortable with developing data-centric applications using Netezza, Informatica, able to develop ETL packages, and is expected to develop queries and stored procedures involving complex database structures. The individual must have excellent communication skills, work well in a team environment, enjoy solving complex problems and be able to work in a fast paced environment. Position responsibilities: • Design and develop Enterprise Data Warehousing solutions including Netezza, Informatica and MS SQL server. • Install update, maintain, monitor and support Data Warehouse/BITools in support of all KBB Business units. • Create and maintain stored procedures, triggers, views and constraints to support systems and databases. • Assess new initiatives to determine the work effort and estimate the necessary time-to-completion. • Create test plans and scenarios for development unit testing. • Work with peers to carry out unit testing of new development. • Document new development, procedures or test plans as needed. • Participate in data builds and deployment efforts. • Participate in projects through various phases. • Performs other related duties as assigned. Essential skills, knowledge and abilities: • Strong experience with Informatica • Experience with data warehouse appliance is preferred (i.e. Netezza) • Good experience with MS SQL Server 2008 • 3+ years of experience in data warehousing tools and technique (i.e. Kimball) • Ability to work in a fast-paced, team oriented environment. • Ability to complete the full lifecycle of software development and deliver on time. • Ability to work with end users to gather requirement and convert that to working documents. • Strong interpersonal skills with a heads-up programming attitude. • Bachelor's degree (B. A.) from four-year college or university preferred. Non-essential skills, knowledge and abilities: • Experience with Agile and Scrum development process desirable. • Experience with MicroStrategy is a plus. *Thanks and Regards* *Puja Thakur **Ι** Hevar Systems, Inc* Ph: 469-648-0685 Email: *ptha...@hevar.com <ptha...@hevar.com>* Fax: 866-542-2082 • Toll Free: 800-972-4760 Ext 801 1333•Corporate Drive • Suite# 102• Irving• Texas -75038 DISCLAIMER : This e-mail transmission may contain confidential or legally privileged information that is intended only for the individual(s) or entity(ies) named in the e-mail address. If you are not the intended recipient, please reply to ptha...@hevar.com <vibh...@hevar.com>, so that arrangements can be made for proper delivery, and then please delete all copies and attachments. Any disclosure, copying, distribution, or reliance upon the contents of this e-mail, by any other than the intended recipients, is strictly prohibited -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to oraapps+unsubscr...@googlegroups.com. To post to this group, send email to oraapps@googlegroups.com. Visit this group at http://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/d/optout.
