ETL Applications Developer Job Description
ETL applications developer
provides architectural oversight and implementation for application development design concepts, including version control, continuous integration, project build, and test automation.
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:
Create and manage PL/SQL packages, triggers, and stored procedures, views, SQL transactions
Hands on implementation of integration solutions including Snaplogic, SSIS, Informatica
ETL/ELT performance tuning and optimization in SQL database environment
Support Oracle 11.x and 12.x using PL/SQL, Stored Procedures, Functions and Packages
Identify process simplification opportunities for overall reporting environment
Help develop test cases and plans to complete Unit testing
Play a lead role to facilitate the full product life cycle of various data initiatives
Decompose high-level information into details and abstract up from low-level information to resolve solution vs
Develop, Deploy and maintain production java based applications
Support large, complex applications and business processes to achieve key business objectives
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:
Version and revision control practices and procedures
Optimal mapping techniques
SQL
Ab initio tools like ACE
Application development using Agile methodologies
BRE
Conduct>IT
Continuous flow
Data Warehouse concepts and designs
Informatica
Desired experience for ETL applications developer includes:
Solid experience with data modeling and database design for operational analytical systems
IBM DataStage development experience desired but not required
Query tuning and optimization
Familiarity with processing XML messages
Experience with job scheduling software (Autosys) desired but not required
Working knowledge or willingness to learn fundamentals of market, liquidity, and credit risk
ETL Applications Developer Examples
1
ETL Applications Developer Job Description
Job Description Example
Our company is growing rapidly and is looking for an ETL applications 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 applications developer
- 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
Qualifications for ETL applications developer
- 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
2
ETL Applications Developer Job Description
Job Description Example
Our innovative and growing company is hiring for an ETL applications 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 applications developer
- 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
Qualifications for ETL applications developer
- 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
3
ETL Applications Developer Job Description
Job Description Example
Our growing company is searching for experienced candidates for the position of ETL applications developer. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for ETL applications developer
- 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
Qualifications for ETL applications developer
- 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
4
ETL Applications Developer Job Description
Job Description Example
Our innovative and growing company is looking to fill the role of ETL applications 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 applications developer
- 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
Qualifications for ETL applications developer
- 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
5
ETL Applications Developer Job Description
Job Description Example
Our innovative and growing company is looking for an ETL applications 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 applications developer
- 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
Qualifications for ETL applications developer
- 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)