ETL Applications Developer Job Description
ETL Applications Developer Duties & Responsibilities
To write an effective ETL applications developer job description, begin by listing detailed duties, responsibilities and expectations. We have included ETL applications developer job description templates that you can modify and use.
Sample responsibilities for this position include:
ETL Applications Developer Qualifications
Qualifications for a job description may include education, certification, and experience.
Education for ETL Applications Developer
Typically a job would require a certain level of education.
Employers hiring for the ETL applications 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, Engineering, Technical, Software Engineering, Business, Information Technology, Education, English, Writing, Design
Skills for ETL Applications Developer
Desired skills for ETL applications developer include:
Desired experience for ETL applications developer includes:
ETL Applications Developer Examples
ETL Applications Developer Job Description
- Utilize Big Data tools and technologies to meet our customer’s expanded needs for meaningful information
- May serve project team roles, such as project lead, business systems analyst, or technical lead, for small to medium efforts
- Develop and maintain Extract, Transform, and Load functions from Epic and other operational data sources into their respective target environments
- Performance monitoring to ensure timely and quality delivery of data into AWS data storage environment such as S3
- Serve as a data management subject matter expert focused on modeling and designing data integrations, transformations, and migrations from various sources
- Validate that data standards are implemented across several interfaces with other applications
- Design data integration and management software to automated imports, exports or transfers of data to other systems using approved USCB ETL tools (e.g., Pentaho Data Integration 7.x)
- Work with data owners to document data mappings and transformations to support effective downstream analytics and alerts
- Make recommendations and advise on data refresh, optimization of data, data storage, and data integration among two or more systems
- Collaborate with team to manage risk as it pertains to data, software, lifecycle management, software development methodologies, and data modeling
- Working knowledge or willingness to learn capital makets products
- 7 years of professional experience as an ETL developer in an Enterprise Data Warehousing environment/Operational Data Store environment
- Experience using and understanding Data Modeling tools
- Knowledge of UNIX shell script,schedular tool Control-m preferred,SharePoint,Version Control tool
- A self-starter with ability to work under minimal supervision
- Strong interpersonal and communication skills to interact with different levels and types of users
ETL Applications Developer Job Description
- Attend various meetings as subject matter expert for ETL
- Take ownership of work and partner with team members to deliver innovative solutions that meet needs
- Interact with Users and SMEs to understand, document functional integration requirements and turn them into technical specification documents
- Participate in evaluating, designing, testing and implementing integration and middleware solutions
- Perform integration, system, and functionality testing
- Build reconciliation and exception processes to keep data accurate and keep checks and balances with source data
- Identify risks during design and executions phases, and develop mitigation plans
- Define and maintain documentation around new and existing integrations
- Must be able to estimate work and provide delivery timelines
- Participate in the maintenance and support required to address defects
- Monitor milestones and critical dates to identify potential slippages and mitigate risk appropriately
- Bachelor’s Degree (or higher) in an Information Technology related field
- Service Management Tools experience (like HPSM, BSM, HP Perf Mgr, ALM, Clarity)
- Be able to multi-task while remaining professional and courteous
- Bachelors or higher in a related scientific or technical discipline
- Bachelor's degree or 4 additional years of IT experience beyond the minimum required may be substituted in lieu of a degree
ETL Applications Developer Job Description
- Perform ongoing monitoring, optimization, and refinement
- Involved in all aspects of data warehousing development and operations
- Write both ad-hoc and proprietary C and Python production ETL code
- Perform analysis of raw data sets and comparisons of similar data sets, providing results
- Focus on maintaining and increasing the quality of the company’s data assets
- Clarity Administration Certification
- 2+ years of software development experience demonstrating depth of technical and functional understanding within Data Management
- Comprehensive knowledge of data warehouse concepts, practices, and procedures (EMP Suites
- Comprehensive knowledge of logical and physical modeling and development techniques using CASE tools and DBMS support in a multi-tiered Client/Server environment
- Comprehensive knowledge of data integration, data quality, multi dimensional design and ETL tools and processes
- Good knowledge of project management and SDLC processes and methodology
- Should be able to work in team environment and also independently deliver by taking control and ownership of work
ETL Applications Developer Job Description
- Good understanding of Data lineage in BI / DW environment
- Experience in Transportation / Airline industry Strongly preferred
- Basic knowledge of application development
- Working knowledge in general purpose programming languages, plus an interest in learning other coding languages and skills as needed
- 5+ years working in IT with experience in Financials, Sales and Marketing Data Warehouse projects
- 3+ years hands-on experience in Informatica
- Caboodle Administration Certification
- In total 5+ years of experience with ETL development experience using Abinitio, Unix Shell Scripting, SQL, Oracle, Teradata
- Ability lead and manage a small team of Abinitio Developers both on / offshore
- Strong technical skills in Ab Initio, UNIX Shell Scripting, SQL(Oracle and Teradata) and other scheduling tools
- Extensively worked on Oracle and Teradata as databases using Ab Initio as ETL tool for large scale data integration
- Good understanding on the Ab Initio Admin concepts and all EME features
ETL Applications Developer Job Description
- Experience with Alteryx and Tableau is a plus
- Experience with B2C and eCommerce business models, data and systems a plus
- Experience with Oracle EBS a plus
- CRM application experience a plus
- Bachelor's degree in a related technical area or equivalent hands-on experience
- Strong experience in Financials, Order and inventory management concepts
- 3+ years ETL experience using Oracle EBS modules as Data Source
- Solid understanding of requirements for Data Quality, Metadata, Data Lineage, Operational Data Management and Operational Data Stores
- Strong Experience in Financial, Sales and Marketing Data Warehouse environment is highly desirable
- A self-starting team player with willingness to learn new tools and framework
- Excellent communication skills, both written and verbal with technical and non-technical audiences
- 2+ years of experience with Oracle Database (10g/11g)