Sr. ETL Developer (14227)

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 DevelopmentWork with technical leads, architects, subject matter experts, developers, technical support groups and test teams to deliver value to the businessBuild 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 standardsPerform unit testing of ETL components and document test resultsSupport all testing activities including Development Integration Testing, System Testing, User Acceptance Testing, End-to-End Testing and Performance TestingDocument processes within operational runbooksParticipate in code reviews and documentation reviews for ETL componentsSupport and verify code implementationsCreate schema and data modification scripts as requiredPerform troubleshooting support on ETL componentsCollaborate with members of the teamExperience with shell scripting within Linux and Windows environments preferredProduction SupportSupports the operations of existing applicationsWhen on call, provides timely response and resolution of emergency production questions, issues and defectsAdheres to a production support processApplication MaintenanceWorks on periodic maintenance releases of applications, including enhancements and defectsLooks for ways to enhance design of application for better maintainability and software reuseLooks for ways to incrementally improve the architecture of legacy systemsBusiness AlignmentInvolved in the development and maintenance of applications and processesUnderstands how users use their applicationsAnticipates users'' future needs when architecting solutionsRequired Skills:Strong ETL Development experience using Informatica PowerCenterKnowledge of IICS is a plusCurrent hands on experience with complex SQL code and relational database management systems like SQL Server 2019, MySQL and PostgresExcellent skills in writing, maintaining, testing and debugging code in T-SQLAble to develop and deliver quality code while meeting deadlinesExcellent data analysis abilitiesPossess great attention to detail while also being flexible to adapt to a dynamic environment and changing prioritiesManaging WorkManages workload to deliver quality deliverables that meet requirements and timelinesCommunicates status of assignments to ManagerNotifies Manager of issues that impact productivity or ability to meet expectationsAssists Manager in tracking progress, prioritizing work, developing time estimates and work plans and assisting less experienced team membersResolves issues or escalates to Manager, if necessaryChecks work in to central repositoriesManaging EmployeesReports to the Application Development Manager and/or Project ManagerNo direct reportsCoaches less experienced teammatesCreates documentation to aid in others'' learningIf applicable, provides project supervision and ensures quality and timeliness of others'' deliverablesRequired Experience:EducationBachelor''s degree in Computer Science or Business AdministrationRequired Competencies and ExperienceDevelop, maintain, and support company''s ETL processes and documentationDemonstrate clear, concise, accurate, and timely communication to management, peers, and customers; in written and oral formFollows established standards regarding coding and naming practiceKnowledge and understanding of the Life Insurance industry is an assetFollow established team, program and product policies and proceduresDemonstrated high level of attention to detail, professional attitude and ability to consistently produce a quality product

Created: 2021-11-29