Data Engineer II

Data Engineer II

Rootshell Enterprise Technologies Inc. is a recognized provider of professional IT Consulting services in the US. We are actively seeking Data Engineer II for one of our client.

Role: Data Engineer II Location: Santa Clara, CA Duration: Long Term

The project has two modules:

• Data processing module developed in Python and SQL.
• Rest API module developed in Java.

Responsibilities:

• Writing reusable, testable, and efficient code - SQL and Python.
• Design and implementation of low-latency, high-availability, and performant applications.
• Developing ETL processing in python as needed.
• Work with cross-functional teams to complete migration effort.
• Performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.

Skills:

• 5+ years of experience working in the enterprise setting SQL and Python applications in multiple projects.
• Intermediate to advance working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
• Hands-on experience with Flask or other Python frameworks.
• Experience writing python applications that interact with ORM (Object Relational Mapper) libraries.
• Able to integrate multiple data sources and databases.
• Good understanding of the threading limitations of Python and multi-process architecture.
• Strong unit test and debugging skills.
• Strong knowledge in XML and JSON parsing in python.
• Knowledge in Kafka, EMS queues.
• Proficient understanding of code versioning, unit testing tools (e.g. Git)