ETL Developer

As an experienced data professional, you will be responsible for the following: - Develop, design, tune, and maintain ETL routines using tools such as Pentaho, Informatica, Talend, etc. - Design and develop MySQL stored procedures, functions, views, and triggers for ETL processes. - Create and document ETL technical specifications, data mappings, and dictionaries following data governance standards. - Integrate ETL development with existing projects to maximize object reuse. - Collaborate with the data analysis team to identify and troubleshoot data quality issues. - Perform problem assessment, resolution, and documentation for existing ETL packages, mappings, and workflows. - Optimize the performance of ETL processes and SQL queries through tuning techniques. - Develop transformation queries, views, and stored procedures to enhance ETL processes. Qualifications required for this role: - Experience in data modeling, database design, and optimization techniques. - Hands-on experience with ETL tools like Pentaho, Informatica, Talend, etc. - Knowledge of databases such as Vertica, Teradata, Oracle, SQL, etc.,