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
- Robust 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.