ETL Development: Build and optimize ETL workflows using Knime for data extraction, transformation, and loading from various sources (databases, APIs, flat files, cloud services).
Data Transformation & Cleansing: Use Knime nodes (e.g., Joiner, GroupBy, Pivoting) for data cleaning, preprocessing, and transformation to ensure high data quality.
Data Integration: Integrate data from relational, NoSQL databases, and cloud platforms (AWS, Azure, Google Cloud).
Data Visualization: Create interactive dashboards and reports using Power BI to visualize key business insights.
Automation & Optimization: Automate workflows using Knime Server, and optimize ETL processes for performance and scalability.
Collaboration:
Work with cross-functional teams to understand business needs and deliver actionable data insights.
Required Skills:
Solid experience with Knime for building ETL pipelines, data integration, and transformation.
Proficiency in Power BI or Tableau for designing data visualizations and dashboards.
Advanced SQL skills for querying and transforming data.
Experience with Knime Server for workflow automation.
Familiarity with cloud platforms like AWS, Azure, or Google Cloud for data storage and processing.
Knowledge of Python or R for advanced data processing within Knime.