About us
ALGOTEQUE is an IT consultancy firm that helps startups, mid-sized and large corporations to create and deliver innovative technologies. Our team has a successful track record in designing, developing, implementing, and integrating software solutions (AI, ML, BI, Web, Automation) for Telecom, Energy, Bank, Insurance, Pharma, Automotive, Industry, e-commerce. We deliver our services both in fixed-price and time-and-materials models, helping our customers achieve their business and IT strategies.
Job Description
We are looking for a Data Engineer to design, build, and maintain scalable ETL processes and data solutions using Python, AWS, TypeScript, and SQL/PLSQL. This role will work closely with data analysts, architects, and business stakeholders to ensure high-quality, reliable data pipelines and APIs.
Responsibilities
- Design, develop, and maintain ETL pipelines using Python to extract, transform, and load data from multiple source systems into target data stores.
- Implement and optimize data workflows on AWS (e.g., Lambda, Glue, S3, Step Functions, or similar services) to ensure scalability, reliability, and cost efficiency.
- Develop and maintain RESTful endpoints in TypeScript (e.g., using Node.js frameworks) to support data access, integration, and analytics use cases.
- Write and optimize complex SQL queries and PLSQL functions for data transformation, validation, and reporting.
- Implement testing strategies (unit, integration, regression) for ETL jobs, APIs, and data transformations to ensure data accuracy and system reliability.
- Monitor, troubleshoot, and improve data pipelines and services, including performance tuning, error handling, and root-cause analysis.
- Collaborate with data analysts and business stakeholders to understand data requirements and translate them into technical solutions and data models.
- Ensure data quality, governance, and documentation by maintaining clear technical documentation for ETL jobs, APIs, schemas, and data flows.
- Apply data analytics concepts to validate data, support reporting needs, and help derive insights from datasets.
- Follow best practices for security, coding standards, and DevOps in the cloud environment, including version control, CI/CD, and environment management.
Required qualifications
- Strong hands-on experience with Python for ETL and data processing
- Practical experience with AWS services relevant to data engineering
- Solid experience in TypeScript and building RESTful endpoints
- Strong SQL skills and experience with PLSQL (functions, procedures, performance tuning)
- Experience in testing (unit/integration tests) for code and data pipelines
- Exposure to data analytics and working with large datasets
- Familiarity with version control (e.g., Git) and CI/CD practices
- Good communication skills and ability to work in cross-functional teams
