Data warehouse engineer (ETL pipelines/ Informatica, Talend, SSIS, or similar)
Posted on May 22, 2025
Job Description
- Key Responsibilities:
- * Design, develop, and maintain scalable data warehouse solutions.
- * Create and optimize complex SQL queries for data extraction and analysis.
- * Develop and manage ETL pipelines using tools like Informatica, Talend, SSIS, or
- similar.
- * Work closely with BI developers and data analysts to ensure data accuracy and
- availability.
- * Implement data quality and data governance best practices.
- * Collaborate with business stakeholders to gather requirements and translate them
- into technical specifications.
- * Monitor and troubleshoot performance issues and optimize data processing
- workflows.
- * Ensure compliance with data security and privacy regulations.
- Required Skills:
- * Strong experience in data warehousing concepts and best practices.
- * Proficiency in SQL and experience with RDBMS such as Oracle, SQL Server, MySQL,
- or PostgreSQL.
- * Hands-on experience with ETL tools (e.g., Informatica, Talend, SSIS, DataStage).
- * Familiarity with data modeling tools (e.g., Erwin, SAP PowerDesigner).
- * Good understanding of dimensional modeling (Star Schema, Snowflake Schema).
- * Experience with cloud data platforms (AWS Redshift, Google BigQuery, Azure
- Synapse) is a plus.
- * Strong analytical and problem-solving skills
Required Skills
rdbms such as oracle
sql server
mysql
or postgresql.