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
- provided by Dice