Previous Job
Previous
SQL Developer
Ref No.: 18-10833
Location: Cincinnati, Ohio
Start Date: 09/17/2018
 Data Developer:
 
 
Primary Skill: Strong SQL skills and experience. Should be able write queries and joins for complex business conditions in a most optimized way.
 
 
  • Develop functional understanding of the business and apply towards building business facing marts
  • Design, develop, code and document Data Marts, analyze current Data Mart structure to identify existing tables and functional design.
  • Build Data Models using combination of various warehousing concepts like Snowflake, Star Schema, etc.
  • Knowledge of Big Data landscape as demonstrated through experience or certification. E.g., Hadoop, Spark, Hive, Pig, Impala.
  • Working Experience in ETL Tools like DataStage, Informatica and procedures including PL/SQL.
  • Build new aggregates based on current and future business needs.
  • Build new tables based on current and future business needs and populate the data mart via queries, jobs etc.
  • Implementing ETL process for integration of data from disparate sources leveraging Hadoop Open Source frameworks.
  • Design and implement a scalable and high-performance search engine for queries on unstructured data.
  • Build distributed, reliable and scalable data pipelines to ingest and process data in real-time.
  • Works cross-functionally to address issues and emerging needs in software systems.
  • Rigorously tests software in preparation for deployment.
  • Works on problems where analysis of situations or data requires a review of a variety of factors.
  • As a seasoned, experienced professional with a full understanding of area of specialization, he/she resolves a wide range of issues in creative ways.
  • Works on problems of diverse scope where analysis of data requires evaluation of identifiable factors.
  • Demonstrates good judgment in selecting methods and techniques for obtaining solutions.
  • Coordinates release of work product into production environment.