Sr. ETL Developer
Category
All Locations
Job Location
Posted Date
Tracking Code
Position Type
JOB SUMMARY:
Experience what being part of the Globe Life family feels like. Be inspired by your leaders, encouraged, and cheered on by your teammates to excel and be supported in your career while working with us. We offer a competitive salary with a great benefits package, including 401(K) match, medical, dental, and vision health plans, short – term and long-term disability, paid time off, tuition reimbursement and other career development opportunities.
The Sr. ETL Developer is 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.
PRIMARY DUTIES & REPONSIBILITIES:
Required Skills
KNOWLEDGE, SKILLS, & ABILITIES:
Required Skills
- 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
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/SME Work
- 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
Applicable to all employees of Globe Life & Accident and its subsidiaries:
- Reliable and predictable attendance of your assigned shift
- Ability to work full time and/or part time based on the position specifications.
Required Experience
EDUCATION & WORK EXPERIENCE REQUIRED:
Education
- Bachelor's degree in Computer Science or Business Administration
Required Competencies and Experience
- 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
Hybrid Working Conditions
- Onsite or Hybrid (WFH/Remote - Monday and Friday) & (In Office - Tuesday thru Thursday)
- Must be able to collaborate as required with teammates using tools such as Webex, Zoom and others
This position is located at 3700 S. Stonebridge Dr., McKinney, TX. View the Google Map in full screen.