2 Posgresql Jobs

Americana Restaurants International PLC is a pioneering force in the MENA region and Kazakhstan's Out-of-Home Dining industry, and 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 60 years. Our expansive network of 2,600+ restaurants spans 12 countries throughout the Middle East, North Africa, and Kazakhstan from Kazakhstan in the east to Morocco in the west powered by a team of over 40,000+ talented individuals committed to delivering exceptional food, superior service, and memorable experiences. In line with our vision for innovation and operational excellence, we have established our Center of Excellence in Mohali, India. This facility plays a pivotal role in product development, IT, Digital, AI, and Analytics, as well as in implementing global IT best practices. Serving as a strategic hub, it is integral to strengthening our technology backbone and driving digital transformation across our worldwide operations. Your Impact In this role, you will lead and inspire a high-performing technical support team, ensuring every customer interaction is handled efficiently, professionally, and with care. Your Role Will Include: We are looking for a skilled Data Engineer to join our growing team. As a Data Engineer, you will be responsible for designing, developing, and maintaining scalable data pipelines and infrastructure to support the extraction, transformation, and loading of data into our data warehouse and other data repositories. You will collaborate closely with data scientists, analysts, and other stakeholders to understand data requirements and deliver solutions that enable data-driven decision-making. Responsibilities: Data Pipeline Development: - Design, build, and maintain scalable and robust data pipelines for ingesting, transforming, and storing large volumes of data from various sources. - Implement ETL (Extract, Transform, Load) processes to ensure data quality and reliability. - Optimize data pipelines for performance, reliability, and cost-effectiveness. Data Modeling and Architecture: - Design and implement data models and schemas to support business requirements. - Work closely with data architects to ensure alignment with overall data architecture and standards. - Implement and maintain data warehouse solutions and data lakes. Data Integration and API Development: - Integrate data from multiple sources and third-party APIs. - Develop and maintain RESTful APIs for data access and integration. Data Quality and Governance: - Implement data quality checks and monitoring processes to ensure data accuracy, completeness, and consistency. - Define and enforce data governance policies and best practices. Performance Tuning and Optimization: - Monitor and optimize data storage and query performance. - Identify and resolve performance bottlenecks in data pipelines and databases. Collaboration and Documentation: - Collaborate with cross-functional teams including data scientists, analysts, and software engineers to understand data requirements and deliver solutions. - Document data pipelines, data flows, and data models. - Provide technical guidance and support to junior team members. What You Bring - Bachelors degree in computer science, Engineering, or a related field, or equivalent work experience. - Proven experience as a Data Engineer or similar role, with a strong understanding of data management and integration techniques. - Hands-on experience with big data technologies and frameworks such as Hadoop, Spark, Confluent, Kafka, Data Lake, PosgreSQL, Data Factory etc. - Proficiency in programming languages such as Python, Scala, or Java for data manipulation and transformation. - Experience with cloud platforms and services (e.g., Confluent, Azure, Google Cloud). - Solid understanding of relational databases, SQL, and NoSQL databases. - Familiarity with data warehousing concepts and technologies (e.g., Redshift, Snowflake, Big Query). - Strong analytical and problem-solving skills. - Excellent communication and collaboration skills. - Ability to work effectively in a fast-paced environment and manage multiple priorities. Preferred Qualifications: - Masters degree in data science, Computer Science, or a related field. - 5+ years of experience in software development, with a focus on full stack web development using Java technologies. - Experience with containerization and orchestration tools such as Docker and Kubernetes. - Knowledge of machine learning and data analytics techniques. - Experience with data streaming technologies (e.g., Apache Kafka, Kinesis). - Familiarity with DevOps practices and tools.,

Role & responsibilities Develop backend services and APIs using Python (Django/Flask) Handle GIS data processing and location-based data handling Design scalable and secure backend architecture Work with spatial and relational databases (PostGIS, PostgreSQL, MySQL) Implement ORMs like Django ORM or SQLAlchemy Perform data validation, serialization, and caching (Redis) Optimize performance, handle asynchronous programming, and ensure clean code Collaborate across teams and contribute to documentation and debugging Preferred candidate profile Python Programming: Strong hands-on experience with core Python Django / Flask Development: Backend development using any of the mentioned framework RESTful API Development: Building and integrating APIs for web services PostGIS / PostgreSQL / MySQL: Working with spatial and relational databases ORM (Django ORM / SQLAlchemy): Managing database interactions efficiently GIS Data Processing: Handling and processing geospatial datasets Data Validation & Serialization: Ensuring data quality and format consistency Backend Architecture Design: Designing scalable and maintainable services Debugging & Documentation: Identifying issues and maintaining clear technical documentation Good-to-Have Skills:- Location-Based Data Handling: Managing and querying spatial/location data Redis / Caching: Enhancing performance through caching mechanisms Asynchronous Programming: Managing concurrent backend tasks efficiently Performance Optimization: Improving system response and load handling Domain Knowledge GIS / Survey Applications: Familiarity with mapping or location-based services Collaboration & Profiling: Working in teams and using tools for code analysis