What are the responsibilities and job description for the ETL Production Support position at Mindsprint?
Job Title: ETL Production Support Analyst
Location: Woburn, MA
Job Summary:
We are seeking an experienced ETL Production Support Analyst to join our team in Woburn, MA. The ideal candidate will have 4-6 years of experience in ETL processes and data production support. You will be responsible for monitoring, troubleshooting, and maintaining our ETL systems to ensure data integrity and availability for business operations.
Key Responsibilities:
- Monitor daily ETL jobs and workflows to ensure successful execution and data processing.
- Troubleshoot and resolve production issues related to ETL processes, databases, and data quality.
- Analyze, identify, and document root causes of ETL job failures, and implement preventive measures.
- Collaborate with data engineers and developers to optimize ETL processes and improve performance.
- Provide timely support and communication to stakeholders regarding ETL job status and incidents.
- Conduct regular audits of data to ensure accuracy, completeness, and adherence to data governance standards.
- Maintain and update documentation related to ETL workflows, operational procedures, and best practices.
- Participate in the deployment and implementation of new data integration solutions.
- Assist in user training and support for data-related queries and tools.
Qualifications:
- Bachelor’s degree in computer science, Information Technology, or a related field.
- 4-6 years of experience in ETL production support, data integration, or data management.
- Proficient in ETL tools (e.g., Informatica, Talend, SSIS) and SQL.
- Strong understanding of relational databases and data warehousing concepts.
- Experience with data quality and data governance practices.
- Excellent troubleshooting and problem-solving skills.
- Strong communication skills and the ability to work collaboratively in a team environment.
- Familiarity with scripting languages (e.g., Python, Shell) is a plus.
Preferred Skills:
- Knowledge of cloud based ETL solutions (e.g., AWS Glue, Azure Data Factory).
- Experience with data visualization tools (e.g., Tableau, Power BI).
- Understanding of Agile methodologies and project management frameworks.
