Data Engineer

  • Mohali
  • Americana Restaurants
Americana Restaurants International PLC

is a pioneering force in the MENA region and Kazakhstan's out-of-home dining industry. It ranks among the world's leading operators of quick service restaurants (QSR) and casual dining establishments. With an extensive portfolio of iconic global brands and a dominant regional presence, we have consistently driven growth and innovation for over half a century. Our expansive network of 2,500 restaurants spans 12 markets throughout the Middle East, North Africa, and Kazakhstan, from Kazakhstan in the east to Morocco in the west.

Some of the world’s most prominent brands in fast food and casual dining; including

KFC, Pizza Hut, Hardee’s, Krispy Kreme,Wimpy, Costa Coffee, and TGI Friday’s; to name a few. Leveraging unparalleled local knowledge and capabilities, we are key players in our core markets with significant potential for further growth.

Our dedicated team of over 40,000 talented individuals

strives to create memorable moments through exceptional food, superior service, and outstanding experiences. https://www.americanarestaurants.com/

Positions: Data Engineer Location: Mohali Job Type: Full Time

Role Details The ideal candidate will be responsible for designing, developing, and maintaining ETL processes to support our data integration and warehousing needs. He needs to work closely with data architects, analysts, and business stakeholders to ensure data is accurately and efficiently integrated into our data warehouse.

Key Responsibilities

ETL Development: Design, develop, and maintain ETL workflows and mappings using tools like [ADF, SSIS, etc.].

Data Integration: Integrate data from various sources, including databases, flat files, APIs, and other data sources, into the data warehouse. Data Transformation: Implement data transformation logic to meet business requirements and ensure data quality and consistency. Performance Tuning: Optimize ETL processes for performance and scalability, including tuning SQL queries and ETL workflows. Data Quality: Ensure data quality by implementing data validation and error handling mechanisms. Documentation: Document ETL processes, data mappings, and transformation logic. Collaboration: Work closely with data architects, analysts, and business stakeholders to understand data requirements and deliver solutions. Maintenance and Support: Provide support and maintenance for existing ETL processes and address any issues or performance bottlenecks. These are desirable skills – Azure Infra / Azure Functions / Cosmo DB/ ADF/ DBT / Power BI / SQL Server ETL Services

Technical Skills Required:

Proficiency in ETL tools (e.g., Informatica, Talend, Microsoft SSIS). Strong SQL skills and experience with relational databases (e.g., SQL Server, Oracle). Experience with data warehousing concepts and methodologies. Knowledge of scripting languages (e.g., Python, Shell scripting) is a plus.

Preferred Qualifications Experience with cloud-based solutions (e.g., Azure Synapse Analytics, Azure Data Factory, Databricks, Lakehouse). Experience with data visualization tools_: Power BI