ETL Developer Job Description

ETL – Extract, Transform, Load, is a data integration process.

The three “T”s represent each phase of the ETL process.

Extract: In the extract phase, data is moved from one source system to another.

Transform: Transforming data means applying rules to it.

For example, you may want to create additional columns in a table or store this data differently.

Load: In the load phase, data is moved from the target system into the data warehouse or another system of record.

ETL – Extract, Transform, Load, is a data integration process.

Job Brief:

We’re looking for an experienced ETL Developer to join our team and help us continue to develop innovative solutions that meet our customers’ needs. As an ETL Developer, you will be responsible for designing, developing, and testing ETL processes to extract, transform, and load data from a variety of sources. In this role, you will work closely with other members of the development team, as well as business and IT stakeholders, to understand requirements and deliver high-quality ETL solutions.

ETL Developer Duties:

• Develop, write, and maintain ETL processes to load data from various systems into the data warehouse
• Help maintain and improve ETL processes, ensuring proper functioning
• Create technical specifications for ETL processes
• Develop, implement, and maintain data analysis tools
• Develop the SQL queries, reports, and stored procedures needed for the data warehouse
• Perform data validation and data quality assurance
• Maintain and update the data warehouse information, to include new or updated data, as well as edit, delete, and refresh
• Monitor system health and system performance
• Maintain and improve data quality, accuracy, and completeness
• Provide assistance and support to end users of the data warehouse
• Help streamline the ETL process
• Provide technical expertise and guidance to ETL developers, analysts, and developers
• Help with the development of ETL processes and reporting
• Provide technical guidance for ETL processes
• Provide analysis,

ETL Developer Responsibilities:

• Design, develop, test, and implement ETL processes, including data extraction, transformations, and loading of data
• Build and maintain efficient data pipeline and data warehouses
• Run performance diagnostic tests on data integration systems and code to meet business requirements
• Create data standards and identify data sources
• Work closely with architects and analysts to align ETL architecture with business requirements
• Provide leadership to data warehouses and data integration teams
• Provide leadership on best practices and standard data architectures
• Perform ad hoc business data analysis
• Execute and oversee different data migration methods
• Perform data validation
• Develop complex SQL queries with joins, views, subqueries, aggregates, and window functions
• Design and execute complex queries using Microsoft SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and SQL Server Data Tools (SSD

Requirements And Skills:

• Bachelor’s degree in engineering, computer science or a related field
• 2+ years’ proven experience developing ETL (Extract, Transform, and Load) solutions
• Experience with one or more of the following: ETL tools, cloud environments,
• Excel, SQL, Python

Company Name is an inclusive employer that is committed to diversity. We encourage applications from all races, religions, nationalities, genders, , , and ages.