ETL Developer Job Description
As an ETL Developer, you will be responsible for extracting, transforming, and loading data from various sources into our data warehouse. You will work closely with cross-functional teams to understand data requirements, develop ETL strategies, and ensure the integrity and quality of data.
Responsibilities
- Design, develop, and test ETL processes to extract data from multiple sources and load it into the data warehouse
- Collaborate with business analysts and data engineers to understand data requirements and translate them into ETL workflows
- Perform data profiling and analysis to identify data quality issues and implement data cleansing and transformation rules
- Optimize ETL processes for performance and scalability
- Troubleshoot and resolve issues related to data integration, data transformation, and data loading
- Proactively monitor the data pipeline and ensure data integrity and quality
- Document ETL specifications, workflows, and dependencies
- Stay up to date with emerging ETL tools and technologies
Qualifications
- Bachelor's degree in Computer Science, Information Systems, or a related field
- Proven experience as an ETL Developer or in a similar role
- Strong SQL skills and proficiency in SQL programming
- Experience with ETL tools such as Informatica, Talend, or AWS Glue
- Familiarity with data warehousing concepts and methodologies
- Knowledge of scripting languages like Python or Shell scripting
- Ability to work effectively in a team environment and collaborate with cross-functional teams
- Analytical mindset and problem-solving skills
Skills
- ETL tools (Informatica, Talend, AWS Glue)
- SQL programming
- Data warehousing
- Scripting languages (Python, Shell scripting)
- Analytical mindset