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.