Billennium is a Polish IT Company that has been developing innovative services and products for over 20 years and provides the best outsourcing specialists.We implement IT projects and services in Poland and other European Union countries. We currently hire over 1600 Specialists in the field of the latest business support solutions and have offices in Poland, Malaysia, India, Germany, Switzerland, Netherlands and Canada.Join a constantly growing team that works on projects for clients in many industries, including a global leader in the pharmaceuticals industry.You will work in an international, innovative, and engaging environment. You will be part of a highly motivated, dynamic, and fun-loving team that is never afraid of taking on new challenges.Responsibilities:
Primary responsibilities include end-to-end ETL development assignments for multiple integrations/projects.
Responsible for supporting stakeholders by designing, developing, and documenting ETL processes, technical architecture, and data pipelines.
Responsible for unit testing, system testing and user acceptance testing and debugging new highly complex software solutions or enhancement to existing software in a maintenance capacity.
Work with business users to translate requirements into system flows, data flows, data mappings etc., and develop solutions to complex business problems.
Work with technical staff to understand challenges and resolve them.
Design and code complex applications using routine and/or other advanced technologies.
Engineer, optimize, fine-tune, and maintain efficient, secure, and reliable data pipelines to clean, ingestion and consolidate data from various sources into the analytics systems.
Create or enhance administrative, operational, and technical policies and procedures as well as adopting best practice guidelines, standards and procedures.
Provide development status and process updates to management or leadership.
Recognized as a technical expert by internal and external peers by demonstrating broad knowledge of technical solutions.
May design and create prototype applications, assist, or lead in development of a particular software technical solution.
Job Requirements:
Mandarin speaking is a MUST.
At least 10 years of working experience in ETL development.
MUST HAVE Data Extraction, Transformation and Loading (ETL) using Talend (good to have experience in other similar tools such as Informatica 9.x/10.x Power Center, DataStage, SSIS or related technologies).
Advanced understanding of relational databases (Oracle, MySQL, SQL Server, Teradata).
Expertise in theoretical and practical knowledge of data warehousing and data modelling.
Highly skilled in SQL technologies (writing, reviewing, and tuning).
NICE TO HAVE experiences in AWS or similar cloud computing technologies (Microsoft Azure, Google Cloud Platform).
Expertise in Data Analysis, Data Profiling and SQL Tuning.
Excellent problem-solving skills, logical process thinking and end-to-end system concepts.
Broad experience in OLAP/OLTP concepts and terminology.
UNIX Scripting.
Hybrid working arrangement (3 days per month)
Work-life balance
Health insurance coverage (including spouse and children)
Integration activity
Opportunities for promotion (reviewed every year)
Optical coverage reimbursement
Additional 2 days of annual leave upon completion every 1 year in Billennium.#J-18808-Ljbffr