SURE SHOT INTERVIEW FOR THE RIGHT CANDIDATE - 100% CLOSABLE
*Please contact me at [email protected] or Call me @ 804 486 9914* Is your #1 goal to please our customers? Are you computer savvy? Do you love working in a fast paced environment? Are you ready to work for a company that rewards you for hard work and dedication? If you answered YES to all these questions, Value-Add Consulting Inc has the position to kick start your career! Our Client is in need of a *ETL Developer (Consultant)* & *Microstrategy Consultant* with the following skills. *1) POSITION TITLE: ETL DEVELOPER 2) POSITION TITLE: MICROSTRATEGY CONSULTANT * *ETL DEVELOPER* Role: ETL Developer (Consultant) Location: Mountain view, CA Duration: 6months Overview: We are looking for a Data Warehouse Engineer - ETL to help build and maintain the critical warehouse. This role will create batch processes that generate content which propagate to production databases. The ideal candidate will have a deep understanding of technical and functional designs for Database, Data Warehousing, Reporting, and Data Mining areas. This job plays a key role in data/web analytics platform development/support, projects, and systems design and development. This team is accountable for ensuring that the overall functional and technical design of work processes and applications meet business and functional requirements. In addition, the work must be sustainable and conform to operation infrastructure. Job Responsibilities: * Contribute at a mid to senior level to the data warehouse design and data preparation batch processes by implementing a solid, robust, extensible design that supports key business flows. * Build and maintain code to populate our data warehouse with data loaded from production databases. * Perform all of the necessary data transformations to populate data into a warehouse table structure that is optimized for reporting. * On-going Warehouse Maintenance - Quickly assess the impact of production system changes to the existing analytics and implement changes to the warehouse ETL and reporting code to ensure consistent and accurate reporting. * Design, build and maintain batch processes that derive data from Data warehouse database and propagate it into production environment. * Establish efficient design and programming patterns for engineers as well as for non-technical peoples. Qualifications: * 5+ years experience working extensively with SQL, including the ability to write, analyze, and debug queries * Experience with Data Warehouse design, ETL (Extraction, Transformation & Load), architecting efficient software designs * 5+ years using Informatica as an ETL development tool * Experienced implementing data warehouses using Oracle (PostgreSQL, MySQL is a plus). * Strong familiarity with data warehouse best practices. * Knowledge of database modeling and design in a data warehousing context * Problem solving and meta-data skills, analyze query plans, indexes, and locking behavior. * Proficiency in scripting languages (Shell, Python, Perl). * Ability to work in a team environment, interacting with multiple groups on a daily basis (very strong communication skills). * Ability to communicate ideas and solutions to non-technical people * Ability to efficiently QA your own work to ensure that processes you built generate high quality output. * Exceptional problem solving skills. * Experience working with Web Technologies (i.e java, xml, cookies, tomcat, php, etc) *MICROSTRATEGY CONSULTANT* Role: Microstrategy Consultant Location: Mountain view, CA Duration: 6months Overview: We are looking for a Data Warehouse Engineer - BI to help build and maintain the enterprise data warehouse. This role will create batch processes that generate content which propagate to production databases. The ideal candidate will have a deep understanding of technical and functional designs for Database, Data Warehousing, Reporting, and Data Mining areas. This job plays a key role in data/web analytics platform development/support, projects, and systems design and development. This team is accountable for ensuring that the overall functional and technical design of work processes and applications meet business and functional requirements. In addition, the work must be sustainable and conform to operation infrastructure. Job Responsibilities: * Develop and maintain BI reports, dashboards and end-user applications * Design, develop and implement BI systems enabling non-technical users to leverage data for strategic decision-making. * Utilize various reporting tools to deliver insights to targeted audiences * Develop extensible components on top of BI tools in line with business priorities, e.g. Flash/Flex-based components in Report Services, portal integration, and standard object creation (templates, filters, prompts, etc.). * Stay up to speed on the latest technologies and facilitate plans to incorporate new features in overall product usage. * Be involved in full lifecycle development and implementation enterprise data warehouse, BI reporting and analytical services. * Develop ad hoc interfaces enabling end-users to generate their own reports. * Resolve user-identified functional and technical issues relating to Data Mart and reporting services. * Establish efficient design and programming patterns for engineers as well as for non-technical peoples. Qualifications: * 5 years of MicroStrategy report development, administration, and implementation experience. * 5 years of intensive experience in the analysis, design implementation and support of complex applications and/or BI solutions * Strong hands-on data warehousing experience with BI concepts and tools such as Teradata, Hyperion, Business Objects, Microstrategy and SAS * 3+ years of experience with very large (multi-terabyte) databases preferred * Solid understanding of systems engineering (to ensure high performance BI architecture using CPU, memory, storage, caching, etc. efficiently * Ability to write and understand scripting languages (UNIX Shell Scripts, Perl, Python) * Proficiency with dashboards, reporting data models, security/access controls, integration, scalability/tuning, quality assurance and configuration management * Experience designing data models, metadata, cubes and drill through reports * Demonstrated knowledge of DW data population techniques for target structures such as Star Schemas, Snowflake Schemas, and 1-3NF data models. * Ability to translate a relational data model into a dimensional model on a database platform * Strong SQL programming skills & Strong relational database knowledge * Possesses a broad understanding of the current and future architecture * 5 years experience working extensively with SQL, including the ability to write, analyze, and debug queries. * Experience with Data Warehouse design, ETL (Extraction, Transformation & Load), architecting efficient software designs. * Experienced implementing data warehouses using Oracle (PostgreSQL, MySQL is a plus). * Ability to work in a team environment, interacting with multiple groups on a daily basis (very strong communication skills). Our Recruiter will initiate a phone call to you and give you immediate consideration should your resume meet the job requirements. The above position is active and urgent, Therefore you can expect immediate consideration & we will hire as soon as possible. Value-Add Consulting (VAC) is a full service IT Consulting Company founded by professionals with hands on experience in Project Management, Technology, Consulting and Recruiting. Thanks & Regards, *Robin* Value-Add Consulting, Inc *Manager – Recruitment & Staffing* È: 804 486 9914 -: [email protected] Web: http://www.value-addconsulting.com Please contact me at* **[email protected]*<[email protected]>or Call me @ *804 486 9914*** Value-Add Consulting (VAC) is a full service IT Consulting Company founded by professionals with hands on experience in Project Management, Technology, Consulting and Recruiting. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "ORACLE DWH DBA" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/ORACLE-DWH-DBA?hl=en -~----------~----~----~----~------~----~------~--~---
