Design, build and maintain complex ELT jobs that deliver business valueTranslate high-level business requirements into technical specsIngest data from disparate sources into the data lake and data warehouseCleanse and enrich data and apply adequate data quality controlsProvide insight and direction to guide the future development of organizations data platformDevelop re-usable tools to help streamline the delivery of new projectsCollaborate closely with other developers and provide mentorshipEvaluate and recommend tools, technologies, processes and reference architecturesWork in an Agile development environment, attending daily stand-up meetings and delivering incremental improvementsBasic Qualifications
- years of experience with data analytics and warehousing in Investment & Finance Domain
- SQL : Deep knowledge of SQL and query optimization
- ELT : Good understanding of ELT methodologies and tools
- Troubleshooting : Experience with troubleshooting and root cause analysis to determine and remediate potential issues
- Communication : Excellent communication, problem solving and organizational and analytical skills
- Able to work independently and to provide leadership to small teams of developers
- years of coding and scripting (Python, Java, Scala) and design experience.
- years of experience with Spark framework.
- Experience with Vertica or any Columnar Databases.
- Strong data integrity, analytical and multitasking skills. Role & responsibilities
Skills Required
Data Analytics, Java, Scala, Vertica, Sql, Python, ELT