Sr. ETL Developer

Sr. ETL Developer (Hybrid)

Primary Duties & Responsibilities

At Globe Life, we are committed to empowering our employees with the support and opportunities they need to succeed at every stage of their career. Our thriving and dynamic community offers ample room for professional development, increased earning potential, and a secure work environment.

We take pride in fostering a caring and innovative culture that enables us to collectively grow and overcome challenges in a connected, collaborative, and mutually respectful environment that calls us to help Make Tomorrow Better.

Role Overview:

Could you be our next Sr. ETL Developer? Globe Life is looking for a Sr. ETL Developer to join the team

In this role, you will be responsible for analysis, design, development, maintenance, and support for various data applications. The person in this role must understand business requirements and translate them into detailed technical documents that will serve as the blueprint for ETL Developers and other knowledge workers.  The Sr. ETL Developer is likely to be tasked with the creation of key software components and is likely to work directly with various groups within the company to architect and build proof of concept modules that can later be incorporated into solutions or built out as needed to perform various business processes.  The Sr. ETL Developer will perform code reviews and provide guidance to team members. 

This is a hybrid position located in McKinney, TX (WFH Monday & Friday, In Office Tuesday-Thursday).

What You Will Do:

Application Development

• Perform key tasks within the SDLC including gathering requirements, creating technical design documents, developing code, leading code reviews, performing testing and implementation support.
• Create and refine technical documents that will guide the developers as they build code.
• Design, prototype, develop, and document ETL components.
• Perform code reviews, document issues and communicate action items.
• Assist with project planning and scheduling.
• Work with technical leads, other Sr. ETL Developers, system architects, subject matter experts, product owners, project managers, developers, technical support groups and test teams to deliver value to the business.
• Build ETL components 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.

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

• Involves users in the development/maintenance of applications (e.g., requirements, testing).
• Understands how users use their applications.
• Anticipates users’ future needs when architecting solutions.

What You Can Bring:

• Bachelor's degree in Computer Science or Business Administration.
• 5+ years of experience with SQL and ETL.
• Create technical documentation.
• Perform code reviews and provide feedback.
• Motivated, organized self-starter who can meet commitments.
• Ability to mentor others.
• 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.
• Possess a very good understanding of Life Insurance industry.
• 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.
• Highly organized and able to efficiently coordinate multiple tasks.
• Self-starter and able to deliver on your assignments on-time.
• Excellent communication skills.
• Ability to create detailed technical design specifications that when the software is developed it will meet the business requirements.
• Willingness to guide and mentor others.
• Strong ETL Development experience using ETL tools including Informatica PowerCenter and Informatica IICS.
• Strong Hands-on Experience with complex SQL and relational databases like SQL Server, MySQL, and Postgres.
• Excellent skills in writing, maintaining, testing, and debugging code in T-SQL.
• Hands-on experience including design and implementation across broad range services on Amazon Web Services (AWS).
• Experience with migrating RDBMS (SQL Server/Oracle) from On-prem to AWS (Aurora/Redshift).
• Solid understanding of various Data Management and Data Pipeline tools available in AWS.
• Working knowledge with primary AWS Services like S3, Lambda, Batch, Glue, Athena, EC2, EBS, CloudWatch, CloudTrail, ECS, ECR, EMR, IAM, SNS etc.mm.
• Good understanding of implementing data warehouse in Cloud.
• 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.

Applicable To All Employees of Globe Life Family of Companies:

• Reliable and predictable attendance of your assigned shift.
• Ability to work full time and/or part time based on the position specifications.

How Globe Life Will Support You:

Looking to continue your career in an environment that values your contribution and invests in your growth? We've curated a benefits package that helps to ensure that you don’t just work, but thrive at Globe Life:

• Competitive compensation designed to reflect your expertise and contribution.
• Comprehensive health, dental, and vision insurance plans because we believe that taking care of your well-being is fundamental to your performance.
• Robust life insurance benefits and retirement plans, including company-matched 401k and pension plan.
• Wellness club reimbursements and gym discounts to help you stay on top of your health.
• Paid holidays and time off to support a healthy work-life balance.
• Parental leave to help our employees welcome their new additions.
• Development training programs to enhance your skills and career progression and unlock your full potential.

Opportunity awaits Invest in your professional legacy, realize your path, and see the direct impact you can make in a workplace that celebrates and harnesses your unique talents and perspectives to their fullest potential. At Globe Life, your voice matters.

#DICE #AWS #Informatica #SQL #ETL