ETL Developer Job Description
ETL developer
provides technical support for business critical applications (Principal technologies / applications used include Informatica, OBIEE, Oracle PL/SQL, Control-M and UNIX.
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:
Produces the required analysis and application design, either individually or by actively participating in development process
Responsibilities will include technical analysis, design, development and performance enhancements
Designing and implementing data processing for large volume concurrent runs, building efficient data processing for batch UI triggered events for near-time performance
Perform ETL Development for Outbound File Feeds, file loads and various controls
Responsible for loading data into Data Warehouse and Data Marts
Manage and participate ‘hands-on’ in the implementation by analyzing user requirements, providing technical specifications and designs, developing detailed work-plans, scheduling technical resources, monitoring progress against plan and developing/maintaining programs according to standards
Validate and transform data extracted from structured and unstructured data inputs, databases, and other repositories, using scripts and other automated capabilities, logs, and queries, as required
Collaborate with BI developers, DBA, researchers, and IT in enhancing existing projects or data structures, and resolving project and programming issues
Act as a subject matter expert for the ETL architecture for the EDW
Work with Agile team members to document and execute test plans for data loading and data validation scripts
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:
SQL
Informatica
ETL dependent technologies in the below scope:
Financial Services and IT industries
Oracle
PL/SQL
Mapping Designer & Mapplet Designer
Transformation Developer
Warehouse Designer
Application
Desired experience for ETL developer includes:
8+ years of hands-on experience developing software with Ab-Initio (GDE v1.15) ETL tool and at least 2 years as a technical lead
Minimum 3+ years of data integration development experience within an enterprise environment
Experience with relational databases, industry data models, data warehousing
Experience in handling Mainframe data, flat files and XML
Experience with Netezza, Cognos, SAS EBI is an asset
Knowledge of financial services or payment card industry is an asset
ETL Developer Examples
1
ETL Developer Job Description
Job Description Example
Our company is growing rapidly and is looking to fill the role of ETL developer. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for ETL developer
- 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
Qualifications for ETL developer
- 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
2
ETL Developer Job Description
Job Description Example
Our growing company is searching for experienced candidates for the position of ETL developer. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for ETL developer
- 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
Qualifications for ETL developer
- 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)
3
ETL Developer Job Description
Job Description Example
Our growing company is looking for an ETL developer. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for ETL developer
- 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
Qualifications for ETL developer
- 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)
4
ETL Developer Job Description
Job Description Example
Our company is hiring for an ETL developer. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for ETL developer
- 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
Qualifications for ETL developer
- 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
5
ETL Developer Job Description
Job Description Example
Our company is looking to fill the role of ETL developer. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for ETL developer
- 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)
Qualifications for ETL developer
- 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