ETL Lead Job Description
ETL lead
provides architectural direction and thought leadership on Oracle EBS Reporting & Business Intelligence technologies, specifically Oracle Business Intelligence and BI Publisher.
ETL Lead Duties & Responsibilities
To write an effective ETL lead job description, begin by listing detailed duties, responsibilities and expectations. We have included ETL lead job description templates that you can modify and use.
Sample responsibilities for this position include:
Developing ETL (Batch) / SQL transformation using Microsoft SQL Server tools, Informatica software and Mulesoft
Distribute and manage ETL/SQL development work across the team’s ETL / SQL internal developers and contractors
Create Teradata, Informatica and UNIX code artifacts
Developing transactional SQL Queries for web and mobile applications
Create technical documents for ETL and SQL developments using Visio, Powerpoint and other MS Office package
Participate in Scrum Sprints as the ETL/SQL Development Lead
Translating technical requirements into ETL/ SQL application code
Set / Implement ETL / SQL development standards (Coding Standards, Code Reviews, Test-Drive Development) for the G360 Program and other Development initiatives
Coach staff in technical matters and delivering on other job-related responsibilities
Ability to work with IT and/or business personnel on adjustments required to their processes (bundles of queries) including potentially to the application or tool which triggers the process(es)
ETL Lead Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for ETL Lead
List any licenses or certifications required by the position: ETL, AWS, ITIL, PMP, BI
Education for ETL Lead
Typically a job would require a certain level of education.
Employers hiring for the ETL lead job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Education, Computer Science, Engineering, Business, Information Technology, Technical, Information Systems, Computer, Mathematics, Management
Skills for ETL Lead
Desired skills for ETL lead include:
Data warehousing
SQL
DAC
Oracle Business Intelligence Enterprise Edition analytical application
Reporting and related tools
Supporting Informatica applications
Teradata
Later version of database
PL/SQL on Oracle 11
Reporting tools: Power BI
Desired experience for ETL lead includes:
Experienced Tech Lead managing a small team of developers on project delivery.Not looking for line management but must be delivery focused
Strong Java/C# server side development (Python preferable)
Strong BI and reporting experience on any platform
Strong user interaction and problem analysisskills
Highly desirable is Market Risk and Value-at-Risk experience
Highly desirable is experience with Agile/Scrum, Scrum Master and unit testingand automation - Desirable is experience with QA and releasemanagement.
ETL Lead Examples
1
ETL Lead Job Description
Job Description Example
Our innovative and growing company is hiring for an ETL lead. 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 lead
- Extensive client interface
- Perform address profiling using QualityStage and obtain address coordinates using Geolocator
- You will be working closely with the Business Analyst and Data Modeler to review business requirements, understand business processes, data entities, data producers, consumers, and the data dependencies between various departments
- Balances various & conflicting support priorities
- Applies data analysis, data modelling, and quality assurance techniques, based upon a detailed understanding of business processes, to establish, modify or maintain data structures and associated components (entity descriptions, relationship descriptions, attribute definitions)
- Designs, codes, tests, corrects and documents complex programs or processes and scripts from agreed specifications, and subsequent iterations, using agreed standards and tools, to achieve a well-engineered result
- Design and construct large ETL mappings, packages workflows
- Gather requirements , work on high level design, implement (code) and deliver efficient and scalable DW solutions in high data growth environment
- Oversee team activities related to coding, unit testing, system testing, resolve defect originating during system test and deploy the fixes for the defects when needed
- Investigate production data issues and provide workaround/fixes for the issues per SLA
Qualifications for ETL lead
- It plays a leadership role with developers
- Ensure the quality of deliverables development (code review, unit testing, installation instructions, regardless of performance)
- Bachelor of Computer
- Ability strong leadership, coaching, interpersonal and communication, both spoken and written
- Sense of innovation, initiative, creativity, organization, autonomy, adaptability to various technologies
- Ability marked for research and evaluation
2
ETL Lead Job Description
Job Description Example
Our company is searching for experienced candidates for the position of ETL lead. 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 lead
- Understand business logic and implement measures to ensure data accuracy and accessibility
- Deliver on time and with high level quality as per SLA through project life cycle
- Lead business intelligence application solutions delivery across multiple programs/projects in the portfolio
- Review and analyze business requirements and provide technical feasibility and estimates with regards to data access, extracts and transformations
- Making modifications to existing applications and modules in accordance with written specifications
- Work closely with the QA / Testing team to help identify/implement defect reduction initiatives
- Work closely with the Architecture team to make sure architecture standards and principles are followed during development
- Take part in code reviews, and reviewing the work of colleagues
- Will need to engage with Project Managers, Business Analysts and Application DBA to implement ETL Solutions
- Must be able to multi-task between various tasks and projects
Qualifications for ETL lead
- Fluency development environment for Oracle or MSSQL
- Mastery of the structured query language
- Very good knowledge of the UNIX environment
- Drive the build and testing teams co-ordinating the day-to-day project activities for the team
- Have expertise in ETL tools (preferably Informatica)
- Strong UNIX and Windows experience
3
ETL Lead Job Description
Job Description Example
Our company is looking for an ETL lead. 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 lead
- This ETL developer role is geared more towards an ETL developer with python or Perl development skills
- Must be available for Off Hours support
- Must have the ability to support all phases of SDLC- requirements gathering, development, testing, production implementation and post production
- Performing Proof of Concepts on new platforms
- Work closely with Management and Data Scientist teams to achieve company business objectives
- Work with the team to establish and reinforce disciplined software development, processes, standards, and error recovery procedures are deployed
- Maintain and support existing ETL and Data Quality jobs in production environment
- Acts as first point of contact for any job failure, review problem(s), identify issue(s) and works to resolve them
- Monitors the loads and systems and communicates with other teams regarding problems to ensure the system is functioning
- Works with Offshore team to maintain and monitor the systems 24*7
Qualifications for ETL lead
- Strong data modeling, data architecture and data warehouse skills
- Experience in XML schema usage
- Strong analytical and problem solving skills, and the ability to adapt to a fast pace environment
- Effective issue resolution and structured problem solving methodology
- Must have experience with at least one major ETL toolset
- At least 3 years full life cycle software development experience
4
ETL Lead Job Description
Job Description Example
Our growing company is searching for experienced candidates for the position of ETL lead. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for ETL lead
- Helps in maintaining Informatica in multiple environments
- Develop, create and document technical specifications and designs from which the appropriate data models, schemas and data warehouse will be implemented
- Must manage customer expectations and ensure prompt and complete customer service
- Work with Business Analysts, Application Developers, Solution Architects and Data Architects in analyzing business requirements, specifications and technical design documents to define the optimal ETL solution and identify responsibilities for delivering
- Provide support and guidance regarding ETL database development, best practices and development standards
- Research and facilitate resolution of support or production related ETL database development issues
- Create and maintain documentation as it relates to ETL database development standards, templates and processes
- Understand the data structure and meaning in both the source and the target BI systems
- Identify, assess and create source/target mappings
- Create physical model
Qualifications for ETL lead
- Must understand software development methodologies including waterfall and agile
- Knowledge of UNIX as an operating system and scripting specifically LINUX and its variants
- Ability to read, analyze, and interpret user manuals, technical procedures, or business communications
- Experience with the usage of ETL tools, Reporting or BI tools (Pentaho Kettle is a plus)
- Stakeholder management and team lead experience
- Familiarity with Software Requirements and Software Development Documentation
5
ETL Lead Job Description
Job Description Example
Our growing company is searching for experienced candidates for the position of ETL lead. 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 lead
- Define business rules for state detection
- Design and specify source data detection and extraction processes
- Design and develop transformation code/logic/programs for environment
- Design and develop data transport and population processes for environment
- Unit test source data detection and extraction processes for environment
- Develop ETL technical architecture
- Develop access/analysis tool technical architecture
- Interface with DBA and infrastructure teams
- Works directly with the business users to provide support includng the design and development of customer training materials, and conducting customer training sessions
- Participates in 24x7 rotational technical support to solve business problems and documents resolution
Qualifications for ETL lead
- Ability to adapt to changes in a fast-paced environment, highly motivated and creative
- Ability to work with large bodies of complex code
- Ability to handle projects with minimal supervision work in a team environment
- Experience with Java and scripting languages a plus
- Work with functional and technical teams to answer question for both internal and external deployments
- Act as an internal consultant to the organization driving application optimization and performance