Skip Navigation
Search LPL Jobs

Search LPL Jobs

View All Current Opportunities at LPL Financial

AVP ETL Lead

Job ID: R-008383 Date posted: 01/09/2020 Primary Location SC-Fort Mill Other Locations CA-San Diego

Essential Functions

  • Act as primary lead for Informatica projects
  • Create application designs and produce design specifications to be reviewed with other tech leads, architecture, and management team
  • Lead multiple simultaneous efforts with aggressive deadlines
  • Mentor offshore and sr. developers to develop proper system designs and find efficiencies in delivery
  • Create estimations for project work prior to kick-off and adjustments as requirements fluctuate
  • Assist analysts with data mapping specification to ensure completeness and accuracy
  • Keep senior leaders well informed during the project life cycle
  • Root Cause analysis for ETL job failures/Data issues raised by business

Qualifications

  • 8 to 12 years of ETL development experience
  • 8 years of experience with Informatica PowerCenter
  • 5 years of experience with Informatica Data Quality
  • 2 Years of experience with Informatica PowerExchange (change data capture)
  • Design, develop, test, implement, and troubleshoot ETL mappings and workflows in a large Data environment
  • Strong experience developing and maintaining Informatica mappings/workflows
  • Strong experience optimizing Informatica mappings, sessions and workflows
  • Experience writing complex SQL, PL/SQL and Performance Tuning is a plus
  • Strong database experience, data analysis and analytical skills
  • Experience creating ETL design documentation and maintaining overall design document and deliverables
  • Strong working experience of the SDLC processes
  • Strong written and oral communication skills
  • Computer-related degree or equivalent work experience
  • Strong analytical problem solving skills
  • Ability to work with limited guidance in a team environment
  • Full software life-cycle experience
  • Exemplary communication abilities
  • Experience in financial services a plus

About LPL Financial:

LPL Financial is a leader in the retail financial advice market and the nation’s largest independent broker/dealer*. We serve independent financial advisors and financial institutions, providing them with the technology, research, clearing and compliance services, and practice management programs they need to create and grow thriving practices. LPL enables them to provide objective guidance to millions of American families seeking wealth management, retirement planning, financial planning and asset management solutions. LPL and its affiliates have more than 3,700 employees with primary offices in Boston, Charlotte, and San Diego.

Our Culture:

If you join LPL, you will join a culture that believes in delivering a world-class client experience and looks to all employees to contribute to that goal by sharing their creativity, experience, and passion for continuous improvement. As a destination of choice, our top priorities are growth and development, social responsibility, and financial health for our employees. 

We offer competitive compensation and industry leading benefits, including a wellness facility with onsite fitness classes, healthy meal choices, and a walk-in clinic. We support employee financial health through a 401k match, ESPP, and employee discounts. Work/life balance is our foundation and is supported through paid holidays, and paid time off (including time to volunteer). We foster a diverse work environment through Employee Resource Groups and diverse strategic partnerships.  

Join the LPL team and help us make a difference by turning life’s aspirations into financial realities. Please login or create an account to apply to this position. Principals only. EOE

*As reported by Financial Planning magazine, June 1996-2017, based on total revenue.

Sign Up for LPL's Talent Community

If you’d like to receive recruiter outreach, news and information from LPL Financial, as well as details on current opportunities that match your preferences and interests, please sign up below.

Area(s) of InterestSelect a job category from the list of options. Search for a location and select one from the list of suggestions. Finally, click “Add” to create your job alert.

  • Information Technology, San Diego, California, United StatesRemove
  • Information Technology, Fort Mill, South Carolina, United StatesRemove