Software Engineer Database (2130)

Required Skills :

• 4+ years of experience with SQL (MySQL) a must.
• 2+ years of Hands-on experience working with Cloudera Hadoop Distribution platform and Apache Spark.
• Strong understanding of full dev life cycle, for backend database applications across RDBMS and distributed cloud platforms.
• Experience as a Database developer writing SQL queries, DDL / DML statements, managing databases, writing stored procedures, triggers and functions and knowledge of DB internals.
• Knowledge of database administration, performance tuning, replication, backup, and data restoration.
• Comprehensive knowledge of Hadoop Architecture and HDFS, to design, develop, document and architect Hadoop applications. Working knowledge of SQL, NoSQL, data warehousing & DBA along with Map-Reduce, Hive, Impala, Kafka, HBase, Pig, and Java.
• Experience processing large amounts of structured and unstructured data, extracting, and transforming data from remote data stores, such as relational databases or distributed file systems.
• Working expertise with Apache Spark, Spark streaming, Jupyter Notebook, Python or Scala programming.
• Excellent communication skills, ability to tailor technical information for different audiences. Excellent teamwork skills, ability to self-start, share insights, ask questions, and report progress.
• Working knowledge of the general database architectures, trends, and emerging technologies. Familiarity with caching, partitioning, storage engines, query performance tuning, indexes, and distributed computing frameworks.
• Working knowledge & understanding of data analytics or BI tools - like looker studio, Power BI, or any other BI tools is a must.

Additional Desired Skills :

• Added advantage if you have exposure to advance technology components like – caching techniques, load balancers, distributed logging, distributed queries, queueing engines, containerization, html / CSS optimization, mobile app & web server optimization, cloud services.
• Strong attention to detail on every line of code, every unit test, and every commit message. Comfortable with rapid development cycles and tight schedules.
• Experience with Linux, GitHub, Jira is a plus. Good experience with benchmarking, optimization, and CI / CD pipeline.
• Experience with web paradigms such as REST, Responsive Web Design, Test-driven Development (TDD), Dependency Injection, unit testing frameworks such JUnit, etc.
• Bachelor’s degree or higher in Computer Science with relevant skills in mobile application development and web.