Get job as soon as 2 days (HURRY UP) ENROLL NOW or Call   +1 (804)-454-3215
+

Sr. SSIS ETL/Informatica Developer Salesforce


Job ID : 24107

Location : San Ramon, California

Company Name : Technogen

Job Type : Contract

Industry : Information Technology

Salary : $55 - $65  per hour

No. of Positions : 2-4


Required Skills : Salesforce, SSIS, Data Warehouse

Benefits : No benefits are available


Job Description :

Role: Senior SSIS ETL/Informatica Developer Salesforce

Location: San Ramon, California

Duration: 12 Months

Visas: H1B,GC ALL,US citizen, L2 EAD, on C2C or W2

Roles & Responsibilities:

  • 7+ years' experience in developing and implementing enterprise-scale data warehouse systems including data integration (ETL) and Reporting Applications.
  • Strong grasp of data management concepts from learning business rules to data profiling, identifying discrepancies and resolving integration issues (validation and cleaning).
  • Must have 5+ years of experience in SQL Server Integration Services (SSIS) and TSQL Scripting
  • Design, develop, and support complex integration processes/ SSIS Processes (including interfaces) using SQL Server technologies
  • Demonstrated skills in building automated processes for error handling and resolving data discrepancies
  • Strong SQL Query Optimization and Performance Tuning skills
  • Excellent command of Database Concepts such as Data Modeling, Database Objects with expert level skills in writing complex queries, stored procedures and views using TSQL OR PLSQL
  • Solid skills in understanding source systems and their limitations and tracing back issues in reporting
  • Able to lead in performing code reviews, analyze execution plans, and refactor inefficient code
  • Excellent communication skills with the ability to work closely with Product Owners and Business Partners, translate key data issues into business terms and business rules into technical designs to map and load data from Source Systems to Downstream applications.
  • Able to effectively consult with the business to determine alignment of ETL with business requirements
  • Should be willing to do troubleshooting and quality assurance testing as necessary for SSIS packages and reports, verifying compliance with requirements, compatibility between systems etc.
  • Strong preference for candidate with understanding of Salesforce Data Model and experience loading and integrating data into Salesforce using Bulk and SOAP APIs or willingness to learn
  • Familiar with third party SSIS tools such as Task Factory
  • Willing and able to provide production support for SSIS package and Stored Procedure related issues.

Latest Jobs For You

  • Project Engineer

    Journey Group Sioux Falls, SD

    Essential Duties and Responsibilities: Assist the Project Manager with project procurement, ...

    View Job
  • Software/Database Developer

    CSL SOFTWARE SOLUTIONS Burlington, VT

    Ideal Experience/Skills: Knowledgeable in SQL, preferably Microsoft Transact-SQL Server 2012....

    View Job
  • Entry Level Computer Programmer

    Revature Chattanooga, TN

    Job Requirements: College degree (Associates or Bachelors) Must be authorized to work in the...

    View Job
  • Software Developer - Entry Level

    360 View Nashville, TN

    Job Description: Looking for talented graduates who are hungry to be challenged and grow their...

    View Job
  • Electrical Engineer – Entry and Mid-Level

    Elliott Bay Design Group Entry, WV

    Responsibilities & Duties: Work will primarily be in an office environment (5 days per ...

    View Job

Thanks For Your Feedback

We’re an equal opportunity provider.
All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.
OPTnation.com is not a Consulting Company/Training Company/H1B Sponsor.