ETL Developer

As an ETL Developer, you will be responsible for designing and creating the data warehouse and all related extraction, transformation, and load of data functions in the company. You will provide oversight and planning of data models, database structural design, and development and work closely with the Data Architect.

Duties include working in cross-functional software development teams (business analysts, software engineers, testers), following agile software engineering and development practices. You will play a key role in contributing to the design, evaluation, selection, implementation, and support of databases solutions that deliver long-term value to Concentrix and our clients.

What is required in this role:

• Minimum 2+ years’ experience in Data Warehouse design and development for large-scale BI applications on Oracle Data Warehouse
• Minimum 2+ years’ experience with extract transform load (ETL) design and development
• Expert in Data Warehouse life cycle methodologies and BI best practices
• Expert tuning SQL queries
• Experience in developing Python code
• Full technical knowledge of all phases of a software development lifecycle and ability to analyze and solve complex problems in a dynamic environment
• Experience with Git version control software
• Good oral and written communication skills

Nice to have: Pentaho Data Integration, Kafka, Javascript, Spark and PySpark API, and Google Cloud Platform

What will be your responsibilities:

• Work with Business Analysts to correlate business requirements to domain entities and data elements
• Design, develop and maintain an information architecture and conceptual models for industry-specific domain area
• Lead/key contributor for development using ETL solutions like Pentaho PDI/Kafka.
• Work independently in determining impacts to code as per the requirements updates and fixes required for fixing defects
• Develop data and metadata policies and procedures for cross-functional software development teams to build, maintain and leverage the data model, ensuring integration with customer and industry data standards
• Work with Developers to design, implement and maintain scalable software solutions that use database structures designed and maintained by the Data Architect
• Review and evaluate database performance, risk, and financial analysis feasibility studies
• Provide complete assessments of the technical characteristics of proposals and alternatives considered to optimize database performance
• Review and assess technical proposals requesting changes or upgrades to the existing databases
• Perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications
• Perform root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on databases and provide support to all ETL applications
• Document all test procedures for systems and processes and coordinate with business analysts and users to resolve all requirement issues and maintain quality for the development work

What you will get from us:

• Remuneration based on technical skills
• Ability to work fully remotely at home.
• A strong work/life balance with a focus that we all have - and should have - lives outside of work.
• Challenging work with the opportunity to personally learn and grow
• Professional development opportunities with conferences & training.
• Multicultural work environment and career opportunities (EU and beyond)
• A bright, passionate, caring team that holds each other accountable and has each other’s backs.
• Private medical healthcare (Luxmed)
• MyBenefit program: shopping vouchers, free sports activities (e.g. Multisport card), and much more
• Group insurance (Uniqa)