ETL Developer

You have a strong experience in data modelling, database design, and optimization techniques. Your main responsibilities will include developing, designing, tuning, and maintaining ETL routines to perform ETL processes. You should have hands-on experience with ETL tools like Pentaho, Informatica, Talend, etc. Additionally, knowledge of databases such as Vertica, Teradata, Oracle, and SQL will be beneficial for this role. Key Responsibilities: - Design and develop MySQL stored procedures, functions, views, and triggers to be used during the ETL process. - Develop ETL technical specifications, designs, tests, and implements optimal data solutions. - Document ETL data mappings, dictionaries, processes, programs, and solutions following established standards for data governance. - Integrate ETL development with existing projects to maximize object reuse. - Create, execute, and document unit test plans for ETL and data integration processes. - Collaborate with the data analysis team to assess and troubleshoot potential data quality issues at key intake points. - Perform problem assessment, resolution, and documentation in existing ETL packages, mapping, and workflows in production. - Tune the performance of the ETL process and SQL queries, and recommend and implement ETL and query tuning techniques. - Develop and create transformation queries, views, and stored procedures for ETL processes. Qualifications Required: - Experience in data modelling, database design, and optimization techniques. - Hands-on experience with ETL tools like Pentaho, Informatica, Talend, etc. - Knowledge of databases such as Vertica, Teradata, Oracle, and SQL. - Proficiency in developing MySQL stored procedures, functions, views, and triggers. - Strong analytical and problems solving skills. - Excellent communication and teamwork abilities. (Note: Additional details of the company were not provided in the job description) You have a strong experience in data modelling, database design, and optimization techniques. Your main responsibilities will include developing, designing, tuning, and maintaining ETL routines to perform ETL processes. You should have hands-on experience with ETL tools like Pentaho, Informatica, Talend, etc. Additionally, knowledge of databases such as Vertica, Teradata, Oracle, and SQL will be beneficial for this role. Key Responsibilities: - Design and develop MySQL stored procedures, functions, views, and triggers to be used during the ETL process. - Develop ETL technical specifications, designs, tests, and implements optimal data solutions. - Document ETL data mappings, dictionaries, processes, programs, and solutions following established standards for data governance. - Integrate ETL development with existing projects to maximize object reuse. - Create, execute, and document unit test plans for ETL and data integration processes. - Collaborate with the data analysis team to assess and troubleshoot potential data quality issues at key intake points. - Perform problem assessment, resolution, and documentation in existing ETL packages, mapping, and workflows in production. - Tune the performance of the ETL process and SQL queries, and recommend and implement ETL and query tuning techniques. - Develop and create transformation queries, views, and stored procedures for ETL processes. Qualifications Required: - Experience in data modelling, database design, and optimization techniques. - Hands-on experience with ETL tools like Pentaho, Informatica, Talend, etc. - Knowledge of databases such as Vertica, Teradata, Oracle, and SQL. - Proficiency in developing MySQL stored procedures, functions, views, and triggers. - Strong analytical and problems solving skills. - Excellent communication and teamwork abilities. (Note: Additional details of the company were not provided in the job description)