At Farah we thrive on seeing happy guests, colleagues and partners. We believe that each individual that we meet is important, and that we can make a positive difference to their lives.
Our purpose is to create happiness one smile at a time.
As ETL & Database Developer you are responsible for the developmentand support for internally created or supported ETL or and Database program,including : Business requirement gathering, Designing the data model, developingthe solution, and testing troubleshooting the solution.
Your jobscope will also include :
Responsiblefor the understanding and documenting the business requirements,
Deepunderstanding of ETL methodologies, Business Intelligence and Data Warehousingprinciples, approaches, technologies, and architectures including the concepts,designs and usage of data warehouses and data marts
Demonstratedexperience in ETL design and options to improve load and extract performance
Translatesource to target mapping documents into ETL processes
Design,Develop, Test, Optimize and Deploy ETL code and stored procedures to performall ETL related functions
Design thedata model for the BI system and other applications
Responsiblefor designing / implementing / managing ETL processes using Azure Data Factory SSIS
Responsible toadministrate and maintain the SQL server Databases and Microsoft EnterpriseData warehouse.
Experiencewith Agile methodologies and Developing Spark Job in Scala or Java.
Write,implement, and maintain appropriate ETL processes
Troubleshootingany bug issue in the system and identifying the appropriate fix.
Maximizingapplications performance by monitoring performance, troubleshooting database.
Lead, trainand support the work of other staff engaged in similar functions.
Monitoring andmaintain the following all the databases and al the ETL components
Asan ideal candidate, you will need to have :
Educated to degreelevel in Computer Science, Microsoft Certified Querying Microsoft SQL Server orequivalent
Minimum 4 years’experience of ETL development using AzureData Factory SSIS including data modeling using Kimball.
3+ years’ experience of Developing SQL queries, Stored Procedures, Views and at least 2years’experience in Database administration
Demonstrable, strong analysis skills and goodcommunication skills
Programming skills utilizing Scala, Java,T-SQL,JSON
Ability to create and debug complex storedprocedures, SQL statements, views, triggers, and functions for MS SQL Server.
Demonstrable, strong expertise in datamodeling and strong Database administration skill for MS SQL Server, Oracle,and MS EDW
Understanding of utilizing Visual Studio andTeam Foundation Server GitHub.
Experience with MS Azure Cloud and data modelingtools such as Erwin