Role Summary :
We are seeking a skilled and experienced ETL Data Engineer with 6-8 years of experience to design, build, and maintain robust data pipelines. The ideal candidate will have hands-on expertise with ETL tools and data platforms, a strong understanding of database systems, and proficiency in developing complex SQL queries. This role is essential for supporting our data warehousing and analytics initiatives.
Key Responsibilities :
- ETL Pipeline Development : Design, build, and maintain robust ETL pipelines using tools like Matillion and Informatica PowerCenter to support data warehousing and analytics.
- Data Transformation : Develop and optimize complex SQL queries for data transformation, cleansing, and reporting within platforms such as Snowflake and Oracle.
- Collaboration & Requirements : Collaborate with data analysts, architects, and business stakeholders to understand data requirements and deliver scalable solutions.
- Data Quality & Monitoring : Monitor data workflows, troubleshoot issues, and ensure high data quality and performance.
- Best Practices : Follow best practices in cloud data engineering, including version control, documentation, and CI / CD processes.
Skills : Required Skills :
Strong understanding of database systems.Proven ability to troubleshoot and ensure high data quality.Excellent collaboration and communication skills.Experience following cloud data engineering best practices.Technical Skills :
Proficiency in Informatica PowerCenter.Hands-on experience with Snowflake and Oracle database systems.Expertise in writing and optimizing complex SQL queries.Experience with Matillion for ETL pipeline development.Experience with Stored Procedures.Familiarity with version control systems and CI / CD processes.Education & Experience :
Education : A Bachelor's degree in Computer Science, Information Technology, or a related field is preferred.Experience : A minimum of 6-8 years of professional experience as a Data Engineer.(ref : hirist.tech)