Senior SQL / ETL Developer with Informatica

KForce   •  

Aliso Viejo, CA

Industry: Business Services

  •  

5 - 7 years

Posted 268 days ago

This job is no longer available.

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