Globe Life Inc. Mckinney , TX 75071
Posted 2 months ago
Job Description:
Sr. ETL Developer
Primary Duties & Responsibilities
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:
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
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 Knowledge & Experience
EDUCATION & WORK EXPERIENCE REQUIRED:
Education
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
Monday and Friday) & (In Office
Tuesday thru Thursday)
Location: 3700 S. Stonebridge Dr., McKinney, Texas
Globe Life Inc.