As a Data Warehouse Developer, you will be working as part of the Data Analytics Center team and will be responsible for the data warehouse development over Oracle and SQL Server Databases, also eventually will start developing in Azure Databricks.
Design and Develop database tables, views, queries and stored procedures as part of Data Analytics solutions to cover business needs based on data warehouse standard methodologies.
Apply modifications suggested in the executions plan to improve performance in existing objects like indexes, hints or even table partitioning if vital.
Work with development methodologies in order to achieve requirements on time.
Participate in collecting requirements with other members, providing mentorship on databases topics.
Promote developments among DEV, UAT and PROD environments.
Write technical specification documents for new processes.
Optimal execution of integration processes.
Tackle issues in existing integration processes reported through the IT service desk or related to data problems.
Deliver administrative, technical and functional documentation, in relation to developments or modifications made on integration processes.
Run unit tests, together with the client and the IT quality area (QA), in order to validate the correct functioning of the application
Bachelor's Degree or higher education in Computer Science, Software Engineering, Information Systems or a related field.
Advance knowledge in performance and development in Oracle databases
Medium experience in SQL Server databases.
Good understanding of data warehouse architecture
Advance experience in PL / SQL programming
Advance experience crafting tables, views (joins, filtering), aggregation, stored procedures, loops also implementing indexing, hints, partition.