ETL Application Developer Job Description
ETL application developer
provides subject matter expertise in data modelling and architecture design for Hadoop Big Data platform Designing and developing Sqoop workflows for migrating RDBMS data to Hadoop HDFS.
ETL Application Developer Duties & Responsibilities
To write an effective ETL application developer job description, begin by listing detailed duties, responsibilities and expectations. We have included ETL application developer job description templates that you can modify and use.
Sample responsibilities for this position include:
Develop and test extraction, transformation, and load (ETL) processes and adapt existing ETL processes to accommodate changes in source systems and new business user requirements
Manage ETL application
Develop mapping specifications, Source to target mappings and ETL development
Receives general direction
Code, test, modify, debug, document, and implement ETL graphs/mappings using Ab Initio, Informatica, Talend
Participate in code & design reviews and ensure that all solutions are aligned to pre-defined architectural specifications
You will work closely with the Support Analyst, Offshore Developers, and vendor support teams to deliver a solution that supports a broad array of business needs in a divisionally consistent model
You will coordinate with support and project team members to ensure that your deliverables are understood and solutioned well
You will prepare documents that outline your solution changes, create batch jobs, execute implementation tasks, and support testing
We support multiple services that require governance, process and procedures - you will help us to maintain and improve these
ETL Application Developer Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for ETL Application Developer
List any licenses or certifications required by the position: BODS, SAP, ICP, ETL
Education for ETL Application Developer
Typically a job would require a certain level of education.
Employers hiring for the ETL application 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, Information Systems, Business, Education, Technical, Science, Software Engineering, Arts, Technology
Skills for ETL Application Developer
Desired skills for ETL application developer include:
Version and revision control practices and procedures
What's technically feasible and what is desired by the end user
Application
Big data technologies like Hadoop/HDFS/Hive/Hbase/Impala & ETL tool integration experience with Hadoop file system desired
Data and infrastructure architecture disciplines
Dental
Loading
Multiple RDBMS
Relational database applications and data query protocols
Transformation
Desired experience for ETL application developer includes:
5 to 8 years of industry experience in information technology
Ability to work late evening / early morning hours as and when needed for production support interacting with offshore team members
5 years Hands-on experience with Teradata Utilities such as BTEQ, FastLoad, MultiLoad, FastExport, Tpump
Should be familiar with Oracle EBS & SFDC applications
Knowledge of end-to-end SDLC processes and Agile methodologies
Hands on experience in Control-M scheduling tool is a plus
ETL Application Developer Examples
1
ETL Application Developer Job Description
Job Description Example
Our company is searching for experienced candidates for the position of ETL application 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 application developer
- Develop the Application development plan, Analyse Business requirements, Design, Code and Test as per requirements
- Manage the development of Application for the SO2O Program
- As the project teams bring in new new technology – you get to learn it
- As we grow you will work closely with other teams in the organization learning what they are accountable for
- You will work with other developers and have a chance to contribute in different ways to the team
- Provide technical expertise and mentorship in SQL Server / SSIS
- Must be an independent, innovative, creative thinker with little to no supervision and prioritize all tasks
- Requires strong leadership, mentoring, organizational and communication skills
- Responsible for overall technical integrity of project, including deliverables such as design documentation, code, and test cases
- Oversee the assessment and estimation of business requests requiring backend and ETL development work
Qualifications for ETL application developer
- 5 to 7 years of Object Oriented Analysis & Design
- 3 to 5 years experience working on a Unix platform(Red Hat Linux preferred)
- 3 to 5 years of ETL tools and BI reporting experience
- 5 to 7 years development experience with Eclipse IDE
- 5 to 7 years of development experience with Tomcat/ Websphere
- 3 to 5 years of experience with Continuous Integration tool such as Jenkins/Hudson including Maven/Ant
2
ETL Application Developer Job Description
Job Description Example
Our company is hiring for an ETL application developer. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for ETL application developer
- Participate in application deployments in a production environment
- Understands and can apply best practices to application solutions
- Execute and test new application development and enhancements
- Plans and provides ETL solutions to achieve desired end-results on business problems working closely with Data Architects and BI Admin team
- Independently performs problem determination and resolution in the production environment and support production as needed both during and after normal business hours
- Performs code, design, and test plan reviews for peers and develops system implementation schedules
- Learn new tools / technologies / methodologies as appropriate for the department
- You will be a key part of the Informatica Data Supply Services delivery team
- You will be assigned Senior Developer tasks for complex Informatica Development projects
- You will play a part on the on-call rotation providing after hours support
Qualifications for ETL application developer
- Functional knowledge of Corporate Billing and Expense Management systems is a big plus
- Hands on experience with database like Oracle, MSSQL Server and database languages like SQL, PL/SQL and TSQL- Experience of data usage for SAP Data migrations using SAP BODS or Informatica
- 3 + years of development experience using Java, Spring framework, JSP and Javascript
- Experience preferably using Oracle
- Experience working on a Unix platform (Red Hat Linux preferred)
- 3 + years of ETL tools and Business Intelligence reporting experience
3
ETL Application Developer Job Description
Job Description Example
Our company is hiring for an ETL application developer. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for ETL application developer
- Interview business analysts in order to determine business requirements and understand source data systems
- Actively participate in and contribute to design sessions
- Make technical design and coding decisions independently within the scope of architectural guidance
- Assist with the creation of test cases, and participate in functional, load and performance testing
- Participate in the formulation of development procedures, standards and code maintenance and archiving
- Assist in development of project definitions, including proposals, estimates, planning, schedules and documentation
- Develop and maintain subject areas for Oracle Business Intelligence Suite
- Develop and maintain data deliveries and reporting solutions
- Create data mapping and workflow using Informatica Powercenter to extract, transform and load data into the NY APD target reporting environment
- Conform to Informatica workflow and mapping standards so development is consistent across all development resources (i.e., no hard coding, leverage of maplet, reuse concepts)
Qualifications for ETL application developer
- Development experience with Eclipse IDE
- Development experience with Tomcat/ Websphere
- Experience with Continuous Integration tool such as Jenkins/Hudson including Maven/Ant
- Experience with unit test automation frameworks such as Junit
- Experience with Jasper reporting framework
- Develop ETL processes using Informatica/Pentaho
4
ETL Application Developer Job Description
Job Description Example
Our growing company is searching for experienced candidates for the position of ETL application developer. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for ETL application developer
- Ability to translate complex business requirements to optimal technical solutions
- Maintain and enhance VBA/Excel solutions
- Contribute to prioritization and stewardship of customer projects, goals and expectations
- Coordinates with business unit representatives to define and evaluate ETL needs, perform requirement analysis of business requirements
- Develop new or modify existing Informatica mappings based on the business requirements following best practices
- Write/update technical documentation including data flows
- Write test plans and perform testing, Debug and resolve issues using Informatica PowerCenter, SQL and Informatica DVO
- Independently performs problem determination and resolution in the production environment and provides production support as needed both during and after normal business hours
- Work closely with other members in BI Analytics team, Data Warehouse team and BI Admin team
- Prepare routine project status reports to Senior Developer, Manager including assisting in developing estimates for project costing
Qualifications for ETL application developer
- Typical candidates will possess 2+ years of relevant experience and a BS in Computer Science or related fields, or equivalent experience
- 2+ years experience participating in multiple technical projects through a SDLC
- Retail Industry is preferred
- Teradata experience is preferred
- Netezza experience is preferred
- Enterprise CRM experience is a plus
5
ETL Application Developer Job Description
Job Description Example
Our innovative and growing company is looking for an ETL application 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 application developer
- Willingness to learn other Informatica tools/ other BI technologies/methodologies as appropriate for the department
- Provides inputs to Data architect as required and identify BI/ETL technology trends to explore opportunities for use within the organization
- Gain an extensive working knowledge of business data and user functions, and willingness to share knowledge
- Format and manipulate data, based on user requirements
- Troubleshoot & resolve report quality and/or performance issues
- Evaluate and recommend tools to enhance solutions
- Work independently collaboratively with a team
- Maintain multiple code versions
- Build and manage effective and efficient deployment processes
- Document business rules that are applied throughout solutions
Qualifications for ETL application developer
- BI performance management tool
- Knowledge of Cybermation is a plus
- Must possess ability to work independently and in a team environment
- Must possess good investigative and problem solving abilities
- Minimum 3 years of experience with ETL tools such as AB-Initio, Informatica, Talend
- ETL technologies such as Pentaho/Informatica/Ab Initio/NIFI, messaging and streaming technologies along with distributed computing skills is highly desirable