Exp: 5+ Years
Location: Bangalore
Key Responsibilities:
* Translate business requirements into queries against a set of relational tables and produce reporting based on the requirements.
* Design and build reporting layer from different data sources and act as a POC (Point of Contact) for user queries
* Database and ETL development, including stored procedures, queries, performance tuning, etc, using SQL and ETL tools such as Informatica or Python Pandas.
* Create efficient testing automation script (using Python etc.) as part of the ETL or reconciliation process.
* Create BOXI (Business Objects) universes for self-service queries or build Tableau Dashboards for user's metrics and KPIs.
The current global team members are all very skilled in domain modeling, database design, big data, Java, and messaging so this is an excellent opportunity to play a key role in the growing team.
Skills Required/Desired:
* Strong scripting knowledge such as Python and Shell
* Strong relational database skills especially with DB2/Sybase
* Create high quality and optimized stored procedures and queries
* Strong with scripting languages such as 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 the lifecycle of a trade and flows of data in an investment banking operation is a plus.
* Experienced in Agile development process
* Java Knowledge is a big plus but not essential
* Experience in delivery of metrics/reporting in an enterprise environment (e.g. demonstrated experience in BI tools such as Business Objects, Tableau, report design & delivery) is a plus
* Experience in ETL processes and tools such as Informatica is a plus. Real-time message processing experience is a big plus.
* Good team player; Integrity & ownership