Data Warehouse Developer / Analyst
- Kiya.ai
- 2 - 5 years
- Bengaluru
- 6 days ago
- Email to a friend
- Report this job
Job Description
Position Purpose
ODIN is a Data Warehouse application and it is changing its overall architecture and migrating to new efficient data model, Also few of the technical upgrade are due in this year.
We are looking for the mid experience team member in the team, who can learn the BAU quickly and come up with fresh ideas in the team and contribute in designing and development of the statistical models.
The team is in charge of the maintenance and the development of new features on 3 reporting applications as well as a Data Warehouse. These applications are designed to provide KPI and reports for back-office and valuation and risk control teams. Direct Responsibilitieso Understand the need of Business/Operations teams and propose indicators to meet the expectations.
o o Work on DWH environment
o o Propose, when relevant, the architecture & flow of new applications that would help them integrate with existing ones and with the whole data architecture being developed
o o Develop, when relevant, different components of this architecture/flow of the applications.
o o Automation of recurring actions and implementation of tools to facilitate the support and evolution of applications
o o Contribution to the evolution of the application architecture to improve the quality of service provided to users (Operations, Business)Contributing Responsibilities
o Support and maintenance in operational condition of various applications focused on the collection and analysis of technical and functional data
The technical environment consists of OS such as Windows, Linux Red Hat / Ubuntu, various technologies (Kafka, MQ, API, ELK) and a DevOps part using Ansible, Kubernetes, Git, Jenkins and all of the Atlassian tools.
Creation of processes to onboard new projects (Infrastructure and Business)
Study and advice on the technological choice for evolutions and new projects
Implementation and monitoring of action plans to avoid the recurrence of problems
Technical and functional data analysis (Data Intelligence, Machine Learning, )
Technical & Behavioral Competencies
Mandatory Technical expertise required:
- Oracle Database SQL Development (+++)
- Advanced PL/SQL which includes Partitions, performance tuning, local & global indexing, Dynamic SQL, Exception Handling and Bulk data handling, etc.
- ETL concepts
- Shell scriptingNice to have Technical skills:
- Data Warehousing
- Oracle APEX
- Python
- Statistical/Machine Learning Modelling.Behavioral Skills
- Curiosity and analysis skills and willingness to learn.
- Good Communication skills.
- Quality-focused with a good eye for detail.
- Capacity to work in a high-pressure environment.
- Must be able to work closely with distributed team, users and business analysts.
- Willing to share knowledge and skills with other developers within the team.
- Whilst able to work independently, should be a true team player.
- Creativity and Problem solving attitude.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Data warehouse DeveloperEmployement Type: Full timeContact Details:
Company: Kiya.aiLocation(s): Bengaluru
Keyskills: Data Warehousing Advanced PL/SQL Shell scripting Data Warehouse Oracle ETL APEX SQL Machine Learning Modelling
Similar positions
Kiya.ai
About Us\n\nWe are AMS. AMS is a global total workforce solutions firm founded in 1996. We enable organizations to thrive in an age of constant change by building, reshaping, and optimizing workforces. We do this through talent acquisition and contingent workforce management, internal mobility and s...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in