Job Description :
Job Title: Data Architect – f2f interview is mandatory
Location: Melville, NY
Duration: 3-6 months contract
Job Description:
· Evangelize Business & Information Architecture, translating data requirements to information strategy
· Create and maintain appropriate data architecture, data modeling, and reporting capability of Healthcare/product/device data
· Maintain appropriate documentation of data architecture, data modeling, ELT/ETL processes and reporting capabilities as well as providing oversight
· Provide thought leadership and supervision on all data exchanges
· Direct and manage ELT/ETL applications development
· Direct and manage a team of ELT/ETL developers
· 5+ years of experience of IT platform implementation in a highly technical and analytical role.
· 5+ years of development and/or DBA experience in Relational Database Management Systems (RDBMS) including 5+ years of hands-on experience in implementation and performance tuning MPP databases (Teradata, Vertica, Netezza, Greenplum, Snowflake
· Customer facing skills to drive discussions with senior personnel regarding trade-offs, best practices, project management and risk mitigation.
· Current hands-on implementation experience required
· Analyze on-premise transactional database environments such as DB2, Oracle, SQL Server, MySQL and/or Postgres, as well as MPP databases (Teradata, Netezza, Vertica Greenplum, Snowflake
· Consult for optimal design of database environments, analyzing complex distributed production deployments, and making recommendations to optimize performance.
· Develop innovative solutions to complex business and technology problems.
Qualifications:
· Strong experiences in Big Data technologies specifically: HDFS, Pig, MapReduce, Spark, HBase, Hive, Cloudera Navigator, Phoenix, Flume, Sqoop, Kafka, and others
· Experience in any one of the traditional Data Warehouse technologies (Informatica or Talend)
· Experience in multiple databases (Teradata, Oracle, DB2, SQL Server, MongoDB, Cassandra, HBase, CouchDB and other NOSQL databases
· Experience in Scala, JAVA, SQL, and shell scripting
· Experience working in Unix or Linux or Windows operating systems
· Experience in VISIO or any diagraming tool
· Experience in DevOps/DataOps processes and any one of the tools (Bamboo, Jenkins, RallyDev, Jira, etc
· Experience in developing designs for data consumption, semantic layer, and batch/speed/serving layer
· Strong experience in Cloud ecosystems pertaining to Big Data such as: AWS, Azure, & GCP
· Big data distribution and tooling experience: HDInsight, Cloudera, Hortonworks, Spark, Kafka, and others
· Experience delivering in agile methodologies
· Experience in coaching and mentoring junior technical resources
· Ability to clearly express technical complexity
· Health care industry experience is a plus
· Experience with development in regulated environment is a plus