EPAM is on the lookout for a talented Python ETL Engineer to join the team. In this role, you'll be the wizard behind the curtain, designing and implementing ETL processes that weave data magic. Extracting, transforming and loading data from various sources into our data warehouse will be your domain. Your expertise will be pivotal in understanding business requirements, crafting data models, and ensuring the accuracy and quality of our data.
Got a passion for Python? Love the thrill of creating ETL pipelines that run like clockwork? Perfect! Your solid Python development background, advanced programming knowledge and expertise with Airflow or Luigi will drive our data-driven success. And let's not forget your experience in data modeling, database design, and SQL - a true game-changer.
Want more jobs like this?
Get Software Engineering jobs in Zhezqazghan, Kazakhstan delivered to your inbox every week.
So, if you're passionate about ETL development and crave the excitement of cutting-edge technologies, we can't wait to welcome you aboard!
#Senior-Python-ETL-Engineer-8
What You'll Do
- Design and implement ETL processes
- Understand business requirements and translate them into technical specifications
- Develop custom ETL scripts using Python
- Maintain ETL pipelines using frameworks such as Airflow or Luigi
- Ensure data accuracy and quality by implementing ETL best practices such as data cleansing, data validation, and error handling
- Work with data warehouses such as Redshift, Snowflake, or BigQuery to store and manage large data sets
- Run SQL and relational databases such as PostgreSQL, SQL Server, and Oracle to design and optimize database schemas and queries
- Operate cloud technologies such as AWS, Azure, or Google Cloud Platform, including cloud-based ETL services such as AWS Glue or Azure Data Factory
- Collaborate with cross-functional teams to ensure the successful delivery of projects
- Stay up-to-date with industry trends and best practices in ETL development
- Bachelor's degree in Computer Science, Information Technology or a related field
- 3+ years of experience in Python development
- Advanced Python programming language knowledge with an understanding of internal mechanics (interpreter, memory management, concurrency, etc.)
- Ability to develop scalable, maintainable and reliable ETL code
- Proficiency with ETL frameworks such as Airflow or Luigi
- Familiarity with data extraction from diverse sources such as databases, APIs, and flat files and transforming them to meet business requirements
- Strong understanding of data modeling and database design, including experience with dimensional modeling and star schemas
- Knowledge of SQL and relational databases such as PostgreSQL, SQL Server, and Oracle, including experience with database optimization techniques
- Showcase of working with cloud technologies such as AWS, Azure or Google Cloud Platform English - B1+, both verbal and written
- Competency in maintaining CI/CD pipelines for ETL applications
- Expertise in web applications for data ingestion using Flask or FastAPI
- Knowledge of Agile development methodologies (SCRUM/Kanban)
- Availability of Cloud certification (AWS, GCP, Azure)
- Familiarity with Docker and Docker Compose
- Flexibility to use big data technologies such as Hadoop, Spark
- We connect like-minded people:
- Delivering innovative solutions to industry leaders, making a global impact
- Enjoyable working environment, whether it is the vibrant office or the comfort of your home
- Opportunity to work abroad for up to two months per year
- Relocation opportunities within our offices in 50+ countries
- Corporate and social events
- We invest in your growth:
- Leadership development, career advising, soft skills and well-being programs
- Certifications, including GCP, Azure and AWS
- Unlimited access to LinkedIn Learning, Get Abstract, O'Reilly, Cloud Guru
- Free English classes with certified teachers
- Discounts in local language schools, including online courses for the Kazakh language
- We cover it all:
- Participation in the Employee Stock Purchase Plan
- Monetary bonuses for engaging in the referral program
- Comprehensive medical care package
- Six trust days per year (sick leave without a medical certificate)
- Coverage of psychology sessions of your choice
- Discounts for fitness clubs and sports programs
- Benefits package (hotels, tech stores, food delivery)
- EPAM Kazakhstan is a team of technologists and innovators united by a passion for technology. Today, we operate across all cities with offices in Astana, Almaty, and Karaganda and work with the world's leading companies from different industries. In 2023, EPAM Kazakhstan received the Export Excellence Award at the esteemed Digital Bridge Awards, showcasing our commitment to excellence and innovation