ETL Developer

Engineering & Development Mumbai, India


Description

Internet Brands is currently seeking an ETL Developer to join our Health vertical, specifically working on brands such as WebMD and Demandforce. The ETL Developer will be responsible for the design, development, and implementation of next-generation database support and new products. Day to day duties will include: data modeling and schema design; ETL architecture, development, documentation, and optimization; generation and analysis of reports ;establishing best practices for data systems; and collaborating with the DBA group on performance tuning and data partitioning

Time: 2 PM to 11 PM IST

Responsibilities:

  • Design and develop in traditional relational databases such as Postgres as well as non-traditional databases such as Hadoop or Vertica.
  • Analyze business requirements, design, and implement required data models and ETL processes on your own
  • Participate in data architecture and engineering decision-making/planning.
  • Create an enterprise-level data inventory regardless of source, format, structure.
  • Connect and integrate individual datasets for better analysis and transparency between the data.
  • Translate complex technical subjects into terms that can be understood by both technical and non-technical audiences.
  • Collaborate with the database development team and provide technical direction/guidance on the design and implementation of data solutions.
Requirements
  • BS or MS in Computer Science or related field, or 5+ years of database development experience
  • Experience with ETL tools such as Pentaho.
  • Excellent knowledge of SQL and Hadoop.
  • Good Unix shell scripting.
  • Database design and optimization.
  • MySQL, PostgreSQL.
  • Hive for distributed databases.
  • Spark for Data Analytics.
  • Linux, Unix, BSD.
  • Experience with large and high transaction database architectures.