Data Engineer II

Data Engineer IIRootshell 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 TermThe 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)