Essential Experience, Skills and Qualifications
— Expertise in SQL , ETL concepts and processes
— Expertise in Big Data Platform and have worked in Transformation projects on Big Data
— Good Scripting knowledge in Python or have programming experience in Java
— Understanding of creating Data Load Jobs in HDFS and have created workflows to run Data Load Jobs
— Good understanding of Unix command and scripting
— Expert knowledge on porters, constructors, inspectors, data matchers, process launchers, UI Workflows and Elements and Console Groups.
— Expertise in writing of SQL Queries, Stored Procedures, functions, views, analytical functions.
— Experience in entity relationship modelling, Performance Optimization of Queries, Ability to debug, analyse and optimize SQL queries
— Middleware technology like MQ, database interface
— Experience in PowerShell,Shell scripting
— Experience in scheduling tools like Control M
— Experience in Build Management tools like team city and some experience in continuous integration.
— Nice to have functional Knowledge of Funds, Trade Lifecycle, Custody, Settlement, Workflow system
— Demonstrable ability to gather requirements, analyse, question and produce technical documentation
— Knowledge of the SDLC and different development models
Ideal candidate profile