Previous Job
Previous
PLSQL with Strong UNIX
Ref No.: 16-10086
Location: Mountain View, California
JD-
Experience with relational databases including SQL queries, database definition, and schema design -Experience with one or more programming languages (Python, Java, C++, etc.) -Experience writing and maintaining extract, transform, and load scripts (ETLs) which operate on a variety of structured and unstructured sources Preferred Qualifications (like SQL loader) -Experience designing data models and data warehouses • -Experience with Unix or GNU/Linux systems including shell scripting -Experience working with and developing for non-technical users (defining requirements, explaining technical concepts to non-technical business users, etc) -Understanding of fundamental computing concepts including data structures and algorithms (including trees, graphs, file formats, algorithmic complexity) -Familiarity with non-relational data storage systems (NoSQL and distributed database management systems) -Good to have knowledge on Google big data systems :
*PLX,Dremel,GoogleSQL,reading/writing data from/to recordio,columnio,csv files using NoSQL queries.
*Google scheduler (Xenon).
-Strong oral and written communication skills, including the ability to communicate complex findings in a structured and clear manner to a non-technical audience
Responsibilities:
-Design, develop and support data warehouses, dashboards and reporting tools for operational and business impact data.
-Write extract, transform and loads (ETL) to automate routine data collection and reporting processes using a variety of traditional as well as large-scale distributed data systems.
-Work with Business Analysts and other non-technical business users to understand their analytical needs, document and prioritize requirements, and to help them effectively use the data and analytical tools that the team has developed.
-Write and review end-user documentation and technical documents, including requirements and design documents for existing and future data systems