ETL Developer Job Description
ETL Developer Duties & Responsibilities
To write an effective ETL developer job description, begin by listing detailed duties, responsibilities and expectations. We have included ETL developer job description templates that you can modify and use.
Sample responsibilities for this position include:
ETL Developer Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for ETL Developer
List any licenses or certifications required by the position: SQL, MCSA, ITIL, HANA, SAP, ETL, SAS, V3, DOM, AJAX
Education for ETL Developer
Typically a job would require a certain level of education.
Employers hiring for the ETL developer job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Computer Science, Education, Engineering, Information Systems, Technical, Information Technology, Business, Computer Engineering, Science, Technology
Skills for ETL Developer
Desired skills for ETL developer include:
Desired experience for ETL developer includes:
ETL Developer Examples
ETL Developer Job Description
- Work closely with the Report Analysts, Data Warehouse Administrator, SQL Server DBA, Business System Analysts and Project Managers
- Teradata, Aster, Oracle, Netezza, Vertica and Hadoop experience highly desired
- Expert background in data analysis and profiling (UNIX Scripting, SQL, SAS, Perl, Pig & Python)
- Manages incidents and resolves problems with thorough analysis, troubleshooting and validation techniques
- Translates business and customer needs into logical system solutions
- Review proposed mappings with relevant personnel, Business Analyst, Data Stewards, Business System and Data Analyst
- Perform detailed source-system analysis, source-to-target data analysis, and transformation analysis
- Design and build data mappings from multiple source systems to data warehouse, maintaining source data integrity
- Participate in the full development cycle for ETL, end to end from design, implementation, documentation, and maintenance
- Validate and test ETL build mappings to meet requirements
- 6+ years of ETL Development experience with strong ETL and SQL programming skills (required)
- Support other ETL developers
- Excellent analytical, problem solving and trouble shooting skills in order to develop and support systems to meet user requirements
- Knowledge of emerging areas such as Big Data and NoSQL technologies
- Minimum two years experience developing and implementing data integration and DW solutions in an Oracle 11g/12g database environment (experience with Netezza preferred
- Strong experience with the development on Oracle platform
ETL Developer Job Description
- Codes, tests and delivers application enhancements and project build deliverables
- Work with business requirements to identify and understand source data systems
- Map source system data to data warehouse tables
- Provide support and maintenance on ETL processes and documentation
- Ensure that spend is captured and allocated correctly
- Maintain Marketing Attribution rules approved by Marketing Leadership
- Maintain Visit tracking data and track sales and campaign data per visit
- Identify key data across multiple business systems in support of business needs in Operations, Marketing and Finance
- Develop, Operationalize and Support ETL processes in support of critical, revenue generating business systems
- Evaluate company's technology landscape for efficiency and efficacy, and establish recommendation to improve
- Experience with Job automation software such as Autosys, Control-M...etc
- Very Strong experience in SQL (structured query language)
- Good knowledge of the UNIX environment
- Knowledge of a scripting language such as Python, Groovy, Bash….etc
- Knowledge of development methodologies (SDLC, Agile or other)
- Experience in environments like Unix, Linux, Windows IIS, Data Warehouse (DHW)
ETL Developer Job Description
- Manage Logility integration with AS/400, Dynamics, SAP, and others
- Thorough understanding of the system setup and capabilities, allowing for intelligent system improvements
- Write functional specs for interfaces into Logility and help translate into technical specification
- Work hands-on with integration processes for the Data Warehouse
- Working together with the Project Management team, upper level management, and the rest of the IT development team in order to see the project through to delivery
- Assisting with ETL Processes
- Documenting IT Controls
- Assist ETL team to solve complex mappings and perform ETL development in some cases
- Work extensively with complex mappings using Power Center transformations
- Have strong Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer
- Working knowledge and experience with data extraction from SAP ERP, Hadoop, SAAS services, structured and unstructured data sets, and integration with SAP BW
- Performance tuning of integration flows, destination repositories and server load
- Write and maintain ETL mapping specifications
- Delivering projects with a high-level of data quality and integrity
- Meet deadlines and possess a proven record of successful project execution and delivery
- Demonstrate knowledge of SDLC processes and procedures adjusted for a Rapid Application Development methodology (agile)
ETL Developer Job Description
- Ability and passion to deliver ETL development projects quickly and efficiently using the Agile development methodology
- Evaluate and recommend database development tool
- Analyze CMS data and integrate data into the Optum Labs DB
- The job involves problem solving and debugging skills, with strong ability to quickly learn and understand business processes and problems in order to effectively develop technical solutions to their requirements
- Troubleshooting issues within ETL, UNIX, and Database environments
- Work with the Analyst team to iron out requirements and specification
- Responsible for providing database analysis/design, management and day to day administration of the reporting databases
- Managing the database artifacts and providing subject matter expertise on best practices for creation, deployment and ongoing management of databases in a reporting/BI environment
- Performing routine database administration activities including setup login credentials for users and administer general security measures on database, to resolve and troubleshoot database access/other database issues, handle the backing up process of the database and its inspection
- This may involve working with Philips internal business process owners, business SME's
- Expert knowledge of DB2, SQL Stored Procedures, Triggers, and data querying optimization
- Review technical deliverables throughout the development phase to ensure quality adherence and identify gaps or redesign requirements as needed
- Comply with well-defined enterprise technology delivery practices and standards and project management disciplines, business technology architecture, and risk and production capacity - including development of project documentation of system requirements, estimates of scope and cost
- Works autonomously and leads on a diverse range of activities and is relied upon to coach / educate and monitor the work of Others
- Strong technical background in data modeling, database design and optimization, specifically DB2 and Sybase
- Experienced with Job scheduling platforms preferably Autosys
ETL Developer Job Description
- Act as a Technical Resource to the development staff in all data ETL needs
- Design and Develop innovative solutions for demanding business situations
- Planning, development, delivery and maintenance of various analytical and reporting data requirements of manufacturing and engineering community within the organization
- Experience with UNIX OS distributions (Centos/SUSE/Redhat) and shell scripting (bash, ksh), Perl, Python
- In depth knowledge & experience of data warehouse development and maintenance using BI and ETL tools including Wherescape Red, Teradata, SQL Server, SSIS, SSRS, T-Inform development
- Analyze business data requirements to produce relevant ETL architecture deliverables (source analysis, source to target maps, ETL flows)
- At least 4 years of experience in ETL development
- At least 4 years of experience in data warehousing, ODS, Data Mart and Cubes
- At least 1 year of experience with Talend
- 1 + year of experience with D3.js, Tableau, JasperSoft, or Business Objects
- 2 + years of experience in Change Data Capture using Tungsten and SQL Server CDC
- 1 + year of ETL experience