Big Data Developer

Location: Columbus OH NEED ONLY LOCALS Local already in Ohio is required. They want the person to be in Columbus, OH, I highlighted what to focus on, 2 bullet points mainly. Very long term, with the Dept of Medicaid. So if they have healthcare or Medicaid insurance experience, that would be nice to have. REQUIRED Skill Sets: 8+ years of experience with Informatica Power Center on Data Warehousing or Data Integration projects Proven ability to write high-quality code 7+ years of experience with Expertise implementing complex ETL logic 3+ years of experience Develop and enforce strong reconciliation process Accountable for ETL design documentation 5+ years of Strong SQL experience (prefer Oracle) 5+ years of Good knowledge of relational database, data vault and dimensional model design 3+ years of Basic knowledge of UNIX/LINUX shell scripting Utilize ETL standards and practices towards establishing and following centralized metadata repository Computer literacy with Excel, PowerPoint, Word, etc. Effective communication, presentation, & organizational skills Ability to establish priorities & follow through on projects, paying close attention to detail with minimal supervision Required Education: BS/BA degree or combination of education & experience Familiar with Project Management methodologies like Waterfall and Agile Perform other duties as assigned Analysis, Design, development, support and Enhancements of ETL/ELT in data warehouse environment with Cloudera Bigdata Technologies (Hadoop, MapReduce, Sqoop, PySpark, Spark, HDFS, Hive, Impala, StreamSets, Kudu, Oozie, Hue, Kafka, Yarn, Python, Flume, Zookeeper, Sentry, Cloudera Navigator) along with Informatica, Oracle SQL/PL-SQL, Unix commands and shell scripting; 2+ years of Strong development experience in creating Sqoop scripts, PySpark programs, HDFS commands, HDFS file formats (Parquet, Avro, ORC etc.), StreamSets pipeline creation, jobs scheduling, hive/impala queries, Unix commands, scripting and shell scripting etc. 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