Computer Science jobs in United States

ETL Developer Job Description

The purpose of the ETL Developer is to develop extraction, translation, and loading jobs which will populate the Data Warehouse.

Develop and enhance the back-end of the data warehouse to satisfy specified and agreed user requirements in conformance with standards, time, and cost parameters agreed for each project/request.

1. Accountabilities: Design, code, debug, and correct programs to ensure business requirements are met.
2. Analyze the effect of new functions on the existing system, prepare test cases according to the System Development Lifecycle methodology, and conduct thorough in-house testing per operational procedures.
3. Implement practical solutions that utilize specialist and departmental systems and processes.
4. Provide input and recommendations to improve efficiency, compliance, and quality objectives related to the area of specialization.
5. Identify problems and develop solutions to present to leaders or stakeholders.
6. Ensure operational support is provided to enhance performance.
7. Cost containment: Support the identification, development, and implementation of cost-effective processes to increase efficiency and reduce costs.
8. Review cost/benefit and ROI within the area of specialization.
9. Drive customer-centricity: Support improved delivery by understanding client and stakeholder needs, satisfaction, and service delivery.
10. Knowledge management: Share and maintain knowledge within the organization, provide training as needed.
11. Maintain expertise level: Engage with professional bodies and meet CPD requirements annually.
12. Network key relationships: Engage with internal and external resources and partners.
13. Specialist support to projects: Provide expertise, ensure best practices, and represent the department on committees.
14. Specific deliverables: Design, develop, and implement ETL pipelines, debug programs, perform performance tuning, support BI solutions, analyze new functions, and ensure operational support.

• Credibility: Lead with integrity and build trust.
• Entrepreneurship: Improve customer experiences.
• Influence: Engage with customers and colleagues.
• Collaboration: Build networks and share knowledge.
• Ownership: Make decisions aligned with organizational and customer interests.
• Knowledge: Understand SDLC methodology and relevant legislation.
• Skills: Task management, data modeling, communication, business writing, system design, attention to detail, problem-solving, customer focus, numerical ability.

• 5-10 years' experience in programming, database design, and system analysis.
• 5-10 years' experience in Data Warehousing.
• Knowledge of ETL tools (DataStage 8.2+).
• Basic UNIX scripting skills.
• Diploma/Degree in IT, Computer Science, or related field (3-4 years).

Package & Remuneration: Competitive.