Alternate Locations: Greensboro, NC (North Carolina); Work from Home (Excluding Colorado)
Relocation assistance is not available for this opportunity.
Level: P4
Requisition 65413
About the Company
Lincoln Financial Group, a Fortune 250 company with over 10,000 employees, provides advice and solutions that help empower Americans to take charge of their financial lives with confidence. Our core business areas Life Insurance, Annuities, Retirement Plan Services and Group Protection focus on supporting, preserving and enhancing over 17 million customers lifestyles and retirement outcomes.
Headquartered in Radnor, Pennsylvania, Lincoln Financial Group is the marketing name for Lincoln National Corporation (NYSE: LNC) and its affiliates. The company had $238 billion in assets under management as of December 31, 2018.
Ranked one of the Best Large Employers in America by Forbes magazine, Lincoln Financial Group makes a serious investment in our employees futures through a broad range of wealth accumulation and protection plans, health and wellness programs, and career development resources designed to help each individual reach their personal and professional goals.
The Role
This exciting opportunity within Lincolns LTD and LOB team for a Senior ETL Developer to help build solutions for Lincolns LTD solutions. As a Senior ETL Developer in this organization, you will assist Analytical Teams with the design and implementation of Data solutions and systems, including integration with Operational Datastpres and Data Warehouses, both on-Premise and in the Cloud. This candidate must be able to develop, enhance, and support Informatica workflows and processes using Informatica Power Center for the extraction and transformation of data in both UNIX/Oracle and Windows/MS SQL Server database environments. The candidate must have Sr. Level experience participating in and leading teams within a Data Management Organization by suggesting new and innovative ways of gaining data processing efficiencies and participating in architectural and modeling discussions.
LI-AE2
Responsibilities
* Participates in analysis, design, and ETL development as part of Agile / Scrum Develop Team
* Understands data mapping and data modeling methodologies including normal form, star, and snowflake to reduce data redundancy and improve data integrity.
* Performs technical tasks including estimating, analysis, technical requirements, design, construction and unit & integration testing following SDLC.
* Maintains knowledge on current and emerging developments/trends for assigned area(s) of responsibility, assesses the impact, and collaborates with Scrum Team and Leadership to incorporate new trends and developments in current and future solutions
* Participates and enhances organizational initiatives by positively influencing and supporting change management and/or departmental/enterprise initiatives within assigned area(s) of responsibility
* Identifies and directs the implementation of process improvements that significantly improve quality across the team, department and/or business unit for his/her assigned area(s) of responsibility
* Provides expertise to team members and applicable internal/external stakeholders on complex assignments/projects for his/her assigned area(s) of responsibility
* Provides direction on complex assignments, projects, and/or initiatives to build and enhance the capability of his/her assigned area(s) of responsibility
Experience
* 5-7+ Years experience in application development that directly aligns with the specific responsibilities for this position (Required)
* 5+ years of experience in design and development of operational data stores, data warehouses and data marts (Required)
* 5+ years of experience in hands-on development with Python or an equivalent Object-oriented programming language (Java, DotNet, etc.) (Required)
* Experience with developing data interchange interfaces for real time, event-driven, and batch mode operations (Preferred)
* Experience with Oracle, Redshift, and Aurora for design, build, and performance tuning in Data Warehouse environments (Preferred)
* Sr Level knowledge of relational database systems / Data integrity concepts and data standardization (Required)
* Strong fundamentals in data modeling Conceptual, Logical, and Physical designs including NoSQL, relational, snowflake, and star schemas (Required)
* Big Data NoSQL, Hive, HBase, Pig, Cassandra, MongoDB, Redshift, Cloud integrations (Plus)
* Experience in developing ETL mappings using Informatica PowerCenter or Informatica BDM (Plus)
Education
* 4 Year/Bachelor's degree or equivalent work experience (4 years of experience in lieu of Bachelors)_Minimum Required in Computer Science, Computer Information Systems, Information Systems, Information Technology or Computer Engineering or equivalent work experience
This position may be subject to Lincolns Political Contribution Policy. An offer of employment may be contingent upon disclosing to Lincoln the details of certain political contributions. Lincoln may decline to extend an offer or terminate employment for this role if it determines political contributions made could have an adverse impact on Lincolns current or future business interests, misrepresentations were made, or for failure to fully disclose applicable political contributions and or fundraising activities.
Any unsolicited resumes/candidate profiles submitted through our web site or to personal e-mail accounts of employees of Lincoln Financial Group are considered property of Lincoln Financial Group and are not subject to payment of agency fees.
Lincoln Financial Group (LFG) is an Equal Opportunity employer and, as such, is committed in policy and practice to recruit, hire, compensate, train and promote, in all job classifications, without regard to race, color, religion, sex (including pregnancy), age, national origin, disability, sexual orientation, gender identity and expression, veterans status, or genetic information. Applicants are evaluated on the basis of job qualifications. If you are a person with a disability that impedes your ability to express your interest for a position through our online application process, or require TTY/TDD assistance, contact us by calling 260-455-2558.
[[customString5]]
Nearest Major Market: Greensboro
Job Segment: Database, Oracle, Information Systems, ERP, Computer Science, Technology
Radnor Twp, PA
Lincoln National Corporation, through its subsidiaries, operates multiple insurance and retirement businesses in the United States. It operates through four segments: Annuities, Retirement Plan Services, Life Insurance, and Group Protection. The Annuities segment offers variable, fixed, and indexed variable annuities. The Retirement Plan Services segment provides employers with retirement plan products and services primarily in the defined contribution retirement plan marketplace. This segment offers individual and group variable annuities, group fixed annuities, and mutual fund-based programs; and a range of plan services, including plan recordkeeping, compliance testing, participant education, and trust and custodial services.
The Life Insurance segment provides life insurance products, including term insurance, such as single and survivorship versions of universal life insurance; variable universal life insurance; and indexed universal life insurance products; and a critical illness rider. The Group Protection segment offers group non-medical insurance products comprising short and long-term disability, statutory disability and paid family medical leave administration and absence management services, term life, dental, vision and accident, and critical illness benefits and services to the employer marketplace through various forms of employee-paid and employer-paid plans.
The company distributes its products through consultants, brokers, planners, agents, financial advisors, third-party administrators, and other intermediaries. Lincoln National Corporation was founded in 1905 and is headquartered in Radnor, Pennsylvania.