Alteryx Knime Developer - Bengaluru, India - CORTEX Consultants

Description

Responsibilities :

• Design, develop, and maintain data pipelines using Alteryx and KNIME to automate data extraction, transformation, and loading (ETL) processes.
• Utilize advanced KNIME development techniques to build robust and scalable data workflows.
• Write clean and efficient code, ensuring data integrity and performance optimization within both platforms.
• Perform complex data cleaning and manipulation tasks, including data profiling, validation, and transformation.
• Apply knowledge of SQL programming concepts (procedures, analytical functions) to interact with relational databases and retrieve data effectively.
• Leverage understanding of data warehouse concepts (dimensional modeling, change data capture, slowly changing dimensions) to design efficient data models within the ETL pipelines.
• Develop and implement shell/PowerShell scripts to automate repetitive tasks within the data integration process.
• Participate in the development and implementation of quality assurance (QA) practices and testing procedures to ensure the accuracy and reliability of data pipelines.
• Collaborate with analysts, data scientists, and other IT professionals to understand data requirements and deliver solutions that meet their needs.
• Stay up-to-date on the latest advancements in Alteryx and KNIME functionalities and best practices.

Qualifications :

• Minimum of 4-6 years of experience in data integration using Alteryx and/or KNIME.
• Proven experience with advanced KNIME development techniques.
• Proficiency in SQL programming concepts, including procedures and analytical functions.
• Working knowledge of predictive, prescriptive, and time series analysis in Alteryx (a plus).
• Good understanding of data warehouse concepts and data modeling principles.
• Experience with shell/PowerShell scripting for automating data processing tasks.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration skills.
• Ability to work independently and manage multiple projects simultaneously.