ETL Engineer Job Description
ETL engineer
provides our partners assistance with Database Design, Database modeling, Database porting, database administration, data warehousing and Application development.
ETL Engineer Duties & Responsibilities
To write an effective ETL engineer job description, begin by listing detailed duties, responsibilities and expectations. We have included ETL engineer job description templates that you can modify and use.
Sample responsibilities for this position include:
Write and code logical and physical database descriptions and specify identifiers of database to management system
Design and development of software using C#, SQL, ASP.Net, and related technologies
Direct object oriented code and database development
Designs and Develops ETL processes to populate Enterprise Data Warehouse and data marts using Informatica, Pentaho, Oracle PL/SQL, & Unix shell scripts
Troubleshoots and resolves database, application, software configuration and ETL related performance issues
Will perform hands-on development for enhancements on the ETL/Reporting tools such as Informatica 9, Business Objects, QlikView, SQL/PLSQL/Teradata/Unix Scripting/Appworx
Review project requests to estimate time and cost required to accomplish project
Understand requirements and identify errors and omissions in specification
Improves operations by conducting systems analysis
Updates job knowledge by studying state-of-the-art development tools, programming techniques, and computing equipment
ETL Engineer Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for ETL Engineer
List any licenses or certifications required by the position: AWS, ETL, PMI, ITIL, SQL, SP, ISTQB, EPIC
Education for ETL Engineer
Typically a job would require a certain level of education.
Employers hiring for the ETL engineer 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, Engineering, Technical, Education, Information Technology, Business, Information Systems, Computer Engineering, Management, Science
Skills for ETL Engineer
Desired skills for ETL engineer include:
Database
Email
Key data warehousing and database processes
Presentation software
Specialized business applications
Spreadsheet
Word processing
SQL and database concepts
SQL
Database concepts
Desired experience for ETL engineer includes:
BS in Computer Science or related field, or professional experience in delivering code for data management applications
Experience designing, developing, and implementing ETL (Ab Initio, Java)
Experience designing, developing, and implementing enterprise data warehouse solutions (Teradata, DB2)
Proficiency with scripting languages (Shell, Python, Perl)
Experience with UNIX/Linux, including basic commands and system administration/configuration
Robust portfolio of shipped code on GitHub and/or open source contributions of which you are proud to share
ETL Engineer Examples
1
ETL Engineer Job Description
Job Description Example
Our growing company is hiring for an ETL engineer. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for ETL engineer
- Work independently in developing and maintaining RHI business reporting and analytics applications
- Creates technical designs, develops, unit tests, and documents application enhancements and fixes using RH approved technologies
- Work independently to analyze and provide solution for simple to moderate sized system or data related issues
- Designs, implements and maintains report batches using Oracle Reporting tools and Hyperion toolsets
- Prepares code migration document and works with release team in migrating the code to QA & other environments
- Excellent knowledge of distributed systems and SOA (Service Oriented Architecture)
- Prior experience deploying and/or maintaining a SOA application
- Experience with Data models, ETL/ELT and other backend services
- Good knowledge of BI tools
- Ability to absorb, master and leverage emerging technologies
Qualifications for ETL engineer
- Bachelor’s Degree in Computer Science, Computer Engineering, or military experience
- At least 1 year of professional work experience coding in data management, data movement, or data warehousing
- 5+ years experience designing, developing, and implementing ETL (Ab Initio)
- 5+ years experience in at least one scripting language (Shell, Python, Perl)
- Lead & own the process of preparation of design deliverables with due consideration for applicable Codes & Standards
- Take ownership of deliverable produced & their quality
2
ETL Engineer Job Description
Job Description Example
Our innovative and growing company is searching for experienced candidates for the position of ETL engineer. 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 engineer
- Ability to work extended hours when needed to deliver results
- Assists in analyzing and solving complex system problems
- Provides weekly status to the production supervisor/manager
- Implements Extract Transform Load (ETL) solutions using BI best practices and methodologies
- Update remedy tickets with information such as work log status, ticket status
- Requirements gathering, development and deployment of new ETL processes into and out of the solution platform
- Work directly with reporting team to ensure ongoing operational and new work complies with requirements and ETL best practice and standards
- Develop and manage project schedules/project work plans, lead design and development reviews
- Expert in data movement techniques and best practices to handle large volume of data
- The Business Intelligence developer will be responsible for design, development, testing, maintenance, and support of the enterprise data warehouse using Oracle Business Intelligence tools and underlying technologies
Qualifications for ETL engineer
- Ensure appropriate checking & review of all documents / drawings before release at any Revision status
- Efficient Analytic, Problem - Solving Skills
- Efficient Decision- Making Skills
- Experience in building UI applications using latest technologies such as HTML5
- Working knowledge of ETL solutions such as Informatica
- 2+ years’ Software Engineering experience with BS in Engineering in related field
3
ETL Engineer Job Description
Job Description Example
Our innovative and growing company is looking to fill the role of ETL engineer. 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 engineer
- Manage relation between data sources and database server, design its interface
- Perform source system data analysis and profiling
- Prepare low-level ETL design documents
- Design and develop ETL mappings for EDW using Informatica
- Tune Informatica ETLs for optimal performance and adherence to business SLAs
- Perform peer code reviews, and assist with IT and business validations to ensure high quality results
- Design and development ETL mappings within data integration tools Informatica
- Analyzes BI end-user requirements and evaluates the feasibility of these requirements from a technical perspective
- Participates in the design, implementation, execution and debug of manual test cases using a variety of testing techniques
- Analyze, design, develop, unit test and resolve defects of multi-source ETL solutions that deliver the dashboards and reports that make data actionable
Qualifications for ETL engineer
- 2+ years’ experience in Business Intelligence area
- At least 2 years experience with MicroStrategy reporting software
- Knowledge of data modeling concepts, data warehouse and data aggregation processes and strategies
- Some experience developing utilizing Big Data Hadoop Ecosystem components (Sqoop, Hive, Pig, Flume)
- Design, Develop and ETL, Big Data Hadoop, Design and coding across platforms
- Must have the ability to reason logically and creatively, and use a variety of analytical and research techniques to solve complex problems
4
ETL Engineer Job Description
Job Description Example
Our innovative and growing company is looking to fill the role of ETL engineer. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for ETL engineer
- Drive the collection of new data and the refinement of existing data sources to continually improve data quality
- Perform source system analysis to identify potential data quality issues, develop required ETL mappings to stage and integrate data to specifications while providing complete documentation, test plans, and results
- Monitor the ETL processes by building alerts necessary to maintain data integrity, and respond and troubleshoot issues when they arise
- Performance tune existing solutions solutions in which you will be creating
- Review and analyze business requirements and translate these into data integration designs
- Work with various IT and business teams to perform source and target data analysis
- Create technical documentation of Source and Target mappings
- Provide technical leadership to ensure development of data integration maps, workflows, and load processes remain in alignment with proven designs through development reviews
- Troubleshoot, optimize and tune ETL mappings
- Collaborate with system owners and other stakeholders to resolve source data issues and refine transformation rules
Qualifications for ETL engineer
- Must be a certified Project Management Professional by the Project Management Institute
- The physical office is within fifteen (15) miles of the client headquarters to support the client’s end-users
- This position is designated under client’s Conflict of Interest Code and will be required to complete and submit to FPPC Form 700, Statement of Economic Interest on an annual basis
- One year of production operations experience in healthcare environment
- At least 6+ years of BI experience with strong expertise in dimensional modeling, ETL Architecture and enterprise data warehouse
- 6+ years of experience in Informatica platform and ETL design and architecture
5
ETL Engineer Job Description
Job Description Example
Our innovative and growing company is hiring for an ETL engineer. 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 engineer
- Manage exploratory data analysis to support database and dashboard development, advanced analytics efforts
- Evaluate existing ETL mappings and processes and collaborate with the architecture team to identify opportunities for automation and efficiency gains
- Mentor junior team members and contractors
- Maintain updated ticketing for events, incidents, requests, changes, problems
- Responsible for writing and executing test plans and cases, designing and developing automated/ manual test scripts, analyzing, debugging, and reporting code bugs for ETL jobs and data sync jobs
- Creating and executing testing automation jobs for ETL
- Create test cases based on business requirements, user stories, data mapping/transformation rules and interface design
- Validate data across platforms and databases
- Reviews and reports clear test results and defects to stake holders
- Design, architect, develop, and maintain SSIS packages and SSIS batch jobs involving complex source data which will be used to drive clinical and patient care decision making requiring the highest degree of quality and accuracy
Qualifications for ETL engineer
- Strong experience in playing Techno-functional role
- Strong experience in performance tuning of SQL Queries and ETL Jobs
- Experience with ticketing tool ServiceNow and versioning tool Perforce a Plus
- Deep understanding of replication technologies Golden gate
- Strong experience with logical / physical data modeling, Dimensional modeling
- Proficient with one of the following relational databases, Oracle/Netezza/UDB