Senior ETL Developer

Mckinney, TX

Job status
Full time
Job description
Globe Life's corporate office has an opportunity for an ETL Developer to join their IT department.

As an ETL Developer, you will be responsible for analysis, design, development, maintenance and support for various data applications. You will also be responsible for the development of key infrastructure and architectural components and processes for the application development teams.
Experience requirements
• Strong ETL Development experience using ETL tools, such as Informatica PowerCenter.
• Current and hands-on experience with complex SQL and relational databases like SQL Server 2008 and newer.
• Exposure to Data Modeling tools like Erwin, ER Studio.
Application Development:
• Work with technical leads, architects, subject matter experts, developers, technical support groups and test teams to deliver value to the business.
• Refine requirements to develop technical design documents to initiate development.
• Deliver ETL components as specified in the design, functional and non-functional requirements, within established budget, time and quality standards.
• Design, prototype, develop, test cases, and document ETL components.
• Perform unit testing of ETL components and document test results.
• Complete code reviews for ETL components and documentation of issues identified and action items.
• Support all testing, including Development Integration Testing, System Testing, User Acceptance Testing, End-to-End Testing and Performance Testing.
• Perform troubleshooting on ETL components.

Production Support:
• Support the operations of existing applications.
• Provide timely response and resolution of emergency production questions, issues, and defects when on call.
• Adhere to a production support process.

Application Maintenance:
• Work on periodic maintenance releases of applications, including enhancements and defects.
• Look for ways to enhance design of application for better maintainability and software reuse.
• Look for ways to incrementally improve the architecture of legacy systems.

Business Alignment:
• Involve users in the development/maintenance of applications (e.g., requirements, testing).
• Understand how users use their applications.
• Anticipate users’ future needs when architecting solutions.

Managing Employees:
• Report to the Application Development Manager and/or Project Manager. No direct reports.
• Coach less-experienced teammates.
• Create documentation to aid in others' learning.
• Provide project supervision and ensure quality and timeliness of others' deliverables.

Managing Work:
• Manage workload to deliver quality deliverables that meet requirements and timelines.
• Communicate status of assignments to Manager.
• Notify Manager of issues that impact productivity or ability to meet expectations.
• Assist Manager in tracking progress, prioritizing work, and developing time estimates and work plans.
• Resolve issues or escalate to Manager, if necessary.
• Check work in to central repositories.
• Excellent skills in writing, maintaining, testing and debugging code in T-SQL.
• Ability to create detailed technical design specifications.
• Excellent data analysis abilities.
• Great attention to detail while also being flexible to adapt to a dynamic environment and changing priorities.

Globe Life is an Equal Opportunity Employer.