Data Engineer

1.Translate business requirement into queries against a set of relational tables and produce reporting based on the requirements.
2.Design and build scalable and performant databases.
3.Database and ETL development, including stored procedures, queries, performance tuning, archiving, etc.; using python, SQL and ETL tools.
4.Build efficient automation scripts (using Python etc.).The current global team members are all very skilled in domain modeling, database design (both relational and noSQL), big data, kafka, and messaging so this is an excellent opportunity to play a key role in the growing team.

Technical Skills Requirement:
– Strong relational database skills especially with DB2/Postgres/Greenplum.
– Knowledge of Spark, Snowflake, and Databricks is desirable.
– Create high quality and optimized stored procedures and queries.
– Experience with Power Designer or some similar modeling tool.
– Python and Unix / K-Shell.
– Strong knowledge base of relational database performance and tuning such as: proper use of indices, database statistics/reorgs, de-normalization concepts.
– Familiar with lifecycle of a trade and flows of data in an investment banking operation.
– Experienced in Agile development process.
– Effective communication skills