ETL Lead Job Description
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:
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:
Desired experience for ETL lead includes:
ETL Lead Examples
ETL Lead Job Description
- 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
- 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
ETL Lead Job Description
- 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
- 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
ETL Lead Job Description
- 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
- 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
ETL Lead Job Description
- 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
- 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
ETL Lead Job Description
- 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
- 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