Position: ETL Developer
Company: Luxoft
Experience required: 2y
Category: Other
English level: upper
Published: 2020-03-01T00:00:00+02:00

Positional duties include the creation of new Talend scripts, the transition of PL/SQL ETLs to new Talend scripts, or the modification of existing scripts. The candidate will be involved in developing Talend Mappings and writing complex Oracle PL/SQL programs for the Data Warehouse. Other tasks include analyzing transaction errors, troubleshooting issues in the software, developing bug-fixes, and providing performance tuning efforts.
Responsibilities:
• Setup the Talend environment in the DEV, TST, and PRD landscapes
• Setup a development environment to develop and version maps, etc.
• Create a common framework for error and exception handling, status reporting, and restart
• Develop scheduling streams to schedule the maps, verify dependencies, and report job status
• Configure Talend per MDM project requirements
• Develop Talend services
• Integrate Talend MDM
• Develop ETL between systems, as required (e.g. Develop the maps for moving data from SAP R3 to the corresponding tables in Oracle)
• Implement data conversions, including mappings between systems
• Create a common framework for error and exception handling, status reporting, and restart
Mandatory Skills:
Education: Bachelor's degree in Computer Science, Management Information, or Electrical Engineering
• Role Specific Experience: 2+ years of strong implementation experience with Talend MDM, and Talend ETL
• Experience with PL SQL, and SAP BAPI, and ABAP
• Experience with Talend on Oracle systems
• Experience with the establishment of operational framework for Talend based tasks
• Extensive experience in development, maintenance, and enhancement of Talend Mappings, Work-flows, and processes
• Project experience with developing complex SQL query and dimensional data model
• Experience with developing and deploying Talend in Unix and Oracle 11g database environment
• Experience with MS SQL Server
• Experience with creating complex Talend ETL mappings and workflows
• Experience coding complex SQL queries
Nice-to-Have Skills:
• Experience with the Talend ETL tool
• Firm understanding of relational database theory