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

  • .Net developer with Angular and C Experience

    Adifice Technologies Kansas City, KS

    Job Description: 7 years of experience in web-based applications using Microsoft technology ...

    View Job
  • Software Engineer (Java)

    Prime Robotics Denver, CO

    Job Description: You will work on some of the server or client applications that interact with ...

    View Job
  • Senior Java/Scala Developer

    Logisoft Technologies Inc Cary, NC

    Responsibilities: Analyze user requirements and design appropriate Big Data solutions that ...

    View Job
  • Java Developer

    UCA services Albany, NY

    Job Description: 7 years of experience as a Java Developer More than Three(3) Years ...

    View Job
  • Java Developer

    SkillStorm Washington, DC

    Job Description: The Senior Java Developer is responsible for Java EE application development ...

    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.