ETL Developer Job Description Template

As an ETL Developer, your duties will include managing the platforms, applications, and data associated with the job function, performing data migrations, performing and automating data enrichment tasks, and developing system integrations between marketing, finance, sales, and relationship management systems. It’s expected you will have an awareness of relational databases, data mining and transformation, integration patterns, systems administration, reporting, and risk management and application security. To create effective, best-in-class, scalable solutions, you will collaborate with and coach other ETL developers and data management team members. The ETL Developer will make tough decisions, put best practices into practice, and finish projects on schedule using their experience.

Typical Duties and Responsibilities

• Maintain Windows and Linux servers running integration platforms and help with compliance procedures
• Collaborate across disciplines with solutions architects, release/project managers, business analysts, and developers to ensure the proper strategy, design, and solution are created
• Create supporting documentation for system integration, administration, and compliance duties
• Identify and implement strategies to lower technical debt, enhance system integration, and boost database performance
• Assist with incident management and resolution for database and platform settings
• Recommend improvements to enhance workflow and productivity while clearly articulating and presenting best practices
• Stay up to date with novel and developing integration capabilities and patterns
• Advise colleagues who work on ETL and data management

Education

• Bachelor’s degree in computer science, electrical engineering, information technology or a related field

Required Skills and Experience

• 10+ years of IT experience, including managing and maintaining networks, databases, operating systems, etc.
• 5+ years of experience integrating systems using ETL tools (i.e., Talend, MuleSoft, Informatica, SSIS etc.)
• 2+ years of experience creating Salesforce API interfaces
• Knowledge of integration development for sales and CRM technologies
• Knowledge of design, development, and data linkages inside RDBMS and file data stores for MS SQL Server databases (CSV, XML, JSON, etc.)
• Knowledge of Salesforce SOQL, JSON, XML, SQL, and SOAP/REST-based online services
• Proven track record of collaborating across teams and groups to advance critical procedures and guarantee the dependability and stability of products
• Technical and process design abilities
• Thorough understanding of the development methods for batch and real-time system integration
• Proficiency with API Authentication and Authorization (OAuth, OpenID, Bearer, etc.)
• Experience using the API
• Knowledge of SDLC and Agile development techniques
• Practical experience with source control (GIT, SVN, etc.)
• Understanding of scripting to automate tedious jobs
• Strong analytical and problem-solving skills
• Ability to work autonomously with little oversight
• Results-driven and able to manage many conflicting priorities in a time-constrained setting
• Exceptional communication skills with internal and external parties at all levels

Preferred Qualifications

• Knowledge with RDBMS other than MS (i.e., Oracle, MySQL, PostgreSQL, etc.)
• Proven track record of creating system integrations with different cloud-based systems (i.e., Workday, SAP, ServiceNow, Clarity, etc.)
• Proven track record of constructing CI/CD pipelines to advance and test integration deployments
• Working knowledge of remote teams
• Experience in the financial institution sector or a closely connected industry