Description:
Job Description
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 a Data Engineer, you will be responsible for the development and support for internally created or supported ETL or and Database program, including: Business requirement gathering, Designing the data model, developing the solution, and testing roubleshooting the solution. Your job score will also include:
- Responsible for the understanding and documenting the business requirements,
- Deep understanding of ETL methodologies, Business Intelligence and Data Warehousing principles, approaches, technologies, and architectures including the concepts, designs and usage of data warehouses and data marts
- Works closely with business and technical teams to understand, document, design, develop, code, and test ETL processes
- Demonstrated experience in ETL design and options to improve load and extract performance
- Translate source to target mapping documents into ETL processes
- Design, Develop, Test, Optimize and Deploy ETL code and stored procedures to perform all ETL related functions
- Experience with Agile methodologies
- Design the data model for the BI system and other applications
- Responsible for designing/implementing/managing ETL processes using Azure Data Factory\SSIS
- Responsible to administrate and maintain the SQL server Databases and Microsoft Enterprise Data warehouse.
- Developing Spark Job in Scala or Java.
- Write, implement, and maintain appropriate ETL processes
- Troubleshooting any bug\issue in the system and identifying the appropriate fix.
- Responsible for the Integrity, Maintenance and changes to the databases.
- Maximizing applications performance by monitoring performance, troubleshooting database.
- Lead, train and support the work of other staff engaged in similar functions.
- Monitoring and maintain the following all the databases and al the ETL components
As an ideal candidate, you will need to have:
- Educated to degree level in Computer Science, Microsoft Certified Querying Microsoft SQL Server or equivalent
- Minimum 4 years’ experience of ETL development using Azure Data Factory\SSIS including data modeling using Kimball.
- 3+ years’ experience of Developing SQL queries, Stored Procedures, Views and at least 2 years’ experience in Database administration
- Demonstrable, strong analysis skills and good communication skills
- Programming skills utilizing Scala, Java, T-SQL, JSON
- Ability to create and debug complex stored procedures, SQL statements, views, triggers, and functions for MS SQL Server.
- Demonstrable, strong expertise in data modeling and strong Database administration skill for MS SQL Server, Oracle, and MS EDW
- Understanding of utilizing Visual Studio and Team Foundation Server\GitHub.
- Experience with MS Azure Cloud and data modeling tools such as Erwin