design data warehouse sql

Hi there, I have been working in the Hadoop framework for over 3 years now. Hadoop has changed a lot from what it was in the initial years. From a mere low cost solution for large dataset storing via HDFS and analysis via MapReduce to a myriad of applications that is constantly evolving. The most used tools in the Hadoop ecosystem now a days are Spark (in memory proccessor that is slated to be the replacement of Mapreduce), Hive (the default database for the hadoop ecosystem tools), Impala, R, pig, Hbase etc. But the actual set of big data tools depends on the exact requirement of the project and the expected outcome. I am currently working in a few big data projects in my company and can surely help you to in your project as a Big Data Architect. In fact in the current project in my company, I am doing the exact same thing i.e. We are calculating Economic Capital i.e. Risk Capital of Insurance firms and using diffrent models for the calcualtion. The Sprak engine reads all the data from the Hive table, then does the Model calculation in its in memory spark engine and the results are written in another Hive table in the form of an OLAP Cube. Our visualization tool (Tableau) reads from this Hive Cube and dispalys the data to the end business user. We are also using Oozie to schedule workflows. Let me know if you have any questions. Thanks, Souvik

I'm a BSc degree holder in computer science and a master degree holder in strategic management. I have worked on more than 1000 papers in report writing, Assignment delivery, content writing, Business plans, dissertation and thesis, white papers ,power point presentation design ,proofreading ,editing ,research ,proposal, typing, data entry etc .I have read and understood your requirement and I know you will never regret, thank you.

Dear, With more than 10 years experience, I'm available 24/24 to perform this data warehouse project quickly and efficiently... You'll pay at job success or approval. I'm hopping to be awarded this job. Sincerely, Balouki ADEWI

please share ur project detail i wll assure u 110 percent i will done u work .. i have good knowledge on oracle sql and plsql Good Understanding of RDBMS concept. Having very good knowledge of DML, DDL, TCL and DCL. In-depth knowledge in writing medium and complex queries using joins, sub-queries and grouping, aggregate function. Good knowledge on creating and maintaining the DB objects like indexes, Sequences, Views and DB links etc. Good knowledge of Joins & their types (Inner, outer,natural ). Have good understandin designing the constraints for table level, Colum level. Good knowledge of SQL functions and how to use in real scenario. Comfortable for creating for different type of table. Worked on Oracle software tool SQL*PLUS, sql developer. Good working knowledge of Explain Plan. Pl/sql skills. Having knowledge on pl/sql concept like variable, constraints, condition. Having good understanding of implicit Cursors & their attributes. Having good understanding of explicit Cursors & their attributes. Well understanding use of exception handling. Strong knowledge of stored procedure (function). Good in packages, triggers. Unix(basic). Filter commands like Grep, wc, head, tail, more, less. Process commands. Vi editor Job scheduling command crontab

Expertise in sql and plsql.

I have 4.5 years of experience with Tata Consultancy Services LTD. I know the concepts of Datawarehousing and sql queries. I have worked over many projects single handedly and also mentored some freshers into this field of datawarehousing. Kindly give me a chance to get your work done in strict timelines.