The Sr. ETL Developer is responsible for analysis, design, development, maintenance and support for various data applications and processes. The processes created by the ETL developer become critical components of key systems within Globe Life because they enable systems to integrate allowing the business to operate.
APPLICATION DEVELOPMENT
- Work with technical leads, architects, subject matter experts, developers, technical support groups and test teams to deliver value to the business
- Build and deliver ETL components as specified in the design requirement that meet the functional requirements of the business, within established budget, while meeting time and quality standards
- Perform unit testing of ETL components and document test results
- Support all testing activities including Development Integration Testing, System Testing, User Acceptance Testing, End-to-End Testing and Performance Testing
- Document processes within operational runbooks
- Participate in code reviews and documentation reviews for ETL components
- Support and verify code implementations
- Create schema and data modification scripts as required
- Perform troubleshooting support on ETL components
- Collaborate with members of the team
- Experience with shell scripting within Linux and Windows environments preferred
PRODUCTION SUPPORT
- Supports the operations of existing applications
- When on call, provides timely response and resolution of emergency production questions, issues and defects
- Adheres to a production support process
APPLICATION MAINTENANCE
- Works on periodic maintenance releases of applications, including enhancements and defects
- Looks for ways to enhance design of application for better maintainability and software reuse
- Looks for ways to incrementally improve the architecture of legacy systems
BUSINESS ALIGNMENT
- Involved in the development and maintenance of applications and processes
- Understands how users use their applications
- Anticipates users’ future needs when architecting solutions
Required Skills
- Strong ETL Development experience using Informatica PowerCenter
- Knowledge of IICS is a plus
- Current hands on experience with complex SQL code and relational database management systems like SQL Server 2019, MySQL and Postgres
- Excellent skills in writing, maintaining, testing and debugging code in T-SQL
- Able to develop and deliver quality code while meeting deadlines
- Excellent data analysis abilities
- Possess great attention to detail while also being flexible to adapt to a dynamic environment and changing priorities
MANAGING WORK
- Manages workload to deliver quality deliverables that meet requirements and timelines
- Communicates status of assignments to Manager
- Notifies Manager of issues that impact productivity or ability to meet expectations
- Assists Manager in tracking progress, prioritizing work, developing time estimates and work plans and assisting less experienced team members
- Resolves issues or escalates to Manager, if necessary
- Checks work in to central repositories
MANAGING EMPLOYEES
- Reports to the Application Development Manager and/or Project Manager
- No direct reports
- Coaches less experienced teammates
- Creates documentation to aid in others' learning
- If applicable, provides project supervision and ensures quality and timeliness of others' deliverables
Required Experience
EDUCATION
Bachelor's degree in Computer Science or Business Administration
REQUIRED COMPETENCIES AND EXPERIENCE
- Develop, maintain, and support company’s ETL processes and documentation
- Demonstrate clear, concise, accurate, and timely communication to management, peers, and customers; in written and oral form
- Follows established standards regarding coding and naming practice
- Knowledge and understanding of the Life Insurance industry is an asset
- Follow established team, program and product policies and procedures
- Demonstrated high level of attention to detail, professional attitude and ability to consistently produce a quality product