Senior SQL / ETL Developer with Informatica

Confidential Company  •  Aliso Viejo, CA

5 - 7 years experience  •  Business Services

Salary depends on experience
Posted on 02/23/18
Confidential Company
Aliso Viejo, CA
5 - 7 years experience
Business Services
Salary depends on experience
Posted on 02/23/18

Description

Kforce has a financial services client that employs approximately 2,700 employees that is seeking a Senior SQL / ETL Developer in Aliso Viejo, California (CA). Job Overview: The SQL / ETL Developer position will be responsible for the design, development, delivery and support of SQL / ETL solutions within the organization. The applicant must have a strong working knowledge of SQL Server 2012+ databases and Infomatica PowerCenter for ETL. This includes developing complex queries, performance tuning, optimization and developing complex stored procedures. The candidate must have strong written and verbal communication skills and the ability to explain logic behind their analysis / ideas in a clear and concise manner. This team will participate in a Salesforce transformation and implementation, moving to an AWS Cloud environment and data consolidation across the enterprise. Benefits:

  • Medical / Dental coverage
  • Two retirement plans
  • 401k retirement plan with company match
  • Company-paid Retirement Benefit Account
  • Company contributes 4% up to taxable wage base and 8% over to IRScompensation maximum
  • Vacation / holiday pay
  • Medical and dependent care flexible spending accounts and more

Requirements

  • Five plus years of Information Technology industry experience
  • Three plus years of current, hands on development experience implementing ETL solutions using Informatica PowerCenter
  • Three plus years of current, hands on database development Skills (particularly implementing SQL Server 2012+ technologies)
  • Extensive programming experience in T-SQL, tuning and optimization
  • Extensive experience determining, developing, testing, and implementing system requirements and specifications
  • Exceptional skills in development of complex stored procedures and advanced SQL techniques to optimize system performance and generate multiple types of outputs: XML, Pivoted results, Data Sets
  • A skilled technician able to operate in a blend of Agile and Waterfall efforts with a sense of urgency, commitment and customer service
  • Understand normalized and star-schema (dimensional) physical models and logical modeling concepts
  • Ability to communicate with a wide range of audiences including management, development, and operational units
  • Ability to develop technical documentation and executive summaries describing technical design and architectural concepts

JobID: 1699939-WQG

Not the right job?
Join Ladders to find it.
With a free Ladders account, you can find the best jobs for you and be found by over 20,0000 recruiters.