Role : Data Architect / Bigdata Architect / Hadoop / senior data engineer/ senior Bigdata skills: oracle, SQL, Hadoop, bigdata , cloud era, Hive, data migration etc. 8+ years Data analysis/architecture experience in Waterfall and Agile Methodology in various domains (prefer Healthcare) in a data warehouse environment. Good knowledge of relational database, Hadoop big data platform and tools, data vault and dimensional model design. Strong SQL experience (prefer Oracle, Hive and Impala) in creating DDL’s and DML’s in Oracle, Hive and Impala (minimum of 8 years’ experience). Experience in analysis, design, development, support and enhancements in data warehouse environment with Cloudera Bigdata Technologies (with a minimum of 8-9 years’ experience in Hadoop, MapReduce, Sqoop, PySpark, Spark, HDFS, Hive, Impala, Stream Sets, Kudu, Oozie, Hue, Kafka, Yarn, Python, Flume, Zookeeper, Sentry, Cloudera Navigator) along with Informatica. Experience (minimum of 8 years) in working with Sqoop scripts, PySpark programs, HDFS commands, HDFS file formats (Parquet, Avro, ORC etc.), Stream Sets pipelines, jobs scheduling, hive/impala queries, Unix commands, scripting and shell scripting etc. Experience in migrating data from relational database (prefer Oracle) to big data – Hadoop platform is a plus. Experience eliciting, analyzing and documenting functional and non-functional requirements. Ability to document business, functional and non-functional requirements, meeting minutes, and key decisions/actions. Experience in identifying data anomalies. Experience building data sets and familiarity with PHI and PII data. Ability to establish priorities & follow through on projects, paying close attention to detail with minimal supervision. Effective communication, presentation, & organizational skills. Good experience in working with Visio, Excel, PowerPoint, Word, etc. Effective team player in a fast paced and quick delivery environment. Required Education: BS/BA degree or combination of education & experience. DESIRED Skill Sets: Demonstrate effective leadership, analytical and problem-solving skills Required excellent written and oral communication skills with technical and business teams. Ability to work independently, as well as part of a team Stay abreast of current technologies in area of IT assigned Establish facts and draw valid conclusions Recognize patterns and opportunities for improvement throughout the entire organization Ability to discern critical from minor problems and innovate new solutions Skill Data analysis/architecture experience in Waterfall and Agile Methodology in various domains (prefer Healthcare) in a data warehouse environment. Good knowledge of relational database, Hadoop big data platform and tools, data vault and dimensional model design. Strong SQL experience (prefer Oracle, Hive and Impala) in creating DDL’s and DML’s in Oracle, Hive and Impala analysis, design, development, support and enhancements in data warehouse environment with Cloudera Bigdata Technologies, along with Informatica Experience in migrating data from relational database (prefer Oracle) to big data – Hadoop platform is a plus. Job Type: Contract Pay: $70.00 - $90.00 per hour Benefits: Dental insurance Health insurance Vision insurance Schedule: 8 hour shift Monday to Friday Experience: total: 10 years (Required) oracle: 4 years (Required) SQL: 3 years (Required) cloud era: 3 years (Required) hadoop / Bigdata: 3 years (Required) data architect: 1 year (Required) Data warehouse: 1 year (Required) Willingness to travel: 100% (Required) Work Location: On the road