Informatica and SQL Server Developer - CRM Systems

  • location: Burbank, CA
  • type: Temp to Perm

job description

Informatica and SQL Server Developer - CRM Systems

Randstad Technologies is currently seeking a talented Informatica and SQL Server Developer to join a well-known client of ours within a location in the greater Los Angeles area.

  • Contract to Hire
  • Bachelor's degree REQUIRED
  • 5+ years of experience REQUIRED
Informatica and SQL Server Developer - CRM Systems

Description

The Informatica and SQL Server Developer will work closely with SalesForce program staff, technical team members, project managers, business users, and our client's staff to deliver customer management projects ranging in size from minor enhancements to major multi-year initiatives. The developer will play a key role in developing, supporting and administering the SalesForce cloud based SQL Server instance and all ETL capabilities.

Duties/Typical Activities

The Informatica and SQL Server Developer ? CRM Systems will perform a variety of project-related activities, including:

  • Serving as a knowledge resource for SalesConnect ETL capabilities and best practices.
  • Understanding general business drivers and context for development projects.
  • Defining the Salesforce.com Data required to support functional and non-functional requirements and business processes.
  • Configuring working prototypes and performing business process reviews to validate and refine prototypes.
  • Preparing formal project documentation, including specifications, requirements summaries, logical system design documents, state diagrams, and test scripts.
  • Monitor all existing ETL jobs on a day-to-day basis and report failures
  • Support ad hoc data load, data migration, data cleansing and data transformation
  • Collaborate with our partners for software upgrades, code deployments and administration
  • Maintain and update documentation of ETL jobs
  • Strong analytical skills and detail oriented
  • Comfortable working in an Agile environment using Scrum framework
  • Passion for code quality and code reviews
  • Will work under the guidance of Lead Database Developer and/or architect
  • Pride of ownership
  • Passion for self-development
Required Experience and Qualifications

  • Degree in Computer Science, Software Engineering, Operations, Industrial Engineering, or related field.
  • 5 or more years of progressive experience as a Informatica developer in a medium to large organization
  • Effective personal communication and client-facing skills with technical and management staff.
  • Experience working with ERP and/or CRM application in a large organization
Must have skills

  • Expert in developing ETL jobs using Informatica power center
  • Expert in SQL Server and T-SQL
  • Experience using SSIS
  • Experience developing ER diagrams
  • Expert in RDMS best practices
  • Experience is using database links (DB Link)
Nice to have skills

  • Experience with Salesforce.com, Salesforce.com data loader would be a plus
  • Experience/knowledge of Salesforce.com connector for Power Center would be a plus

get jobs in your inbox.

sign up
{{returnMsg}}