Get your dream job within 2 days (HURRY UP)ENROLL NOW
+

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

Work Authorization : H1 Visa

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

  • Big Data Architect- OPT H1B

    Cloudious LLC Minneapolis, MN

    Job Description : Build high-efficiency, secure, real-time, ...

    View Job
  • Devops Engineer (Junior Position) - OPT/CPT/H1B

    CloudLogic San Francisco, CA

    Job Description:   Required Skills: Software Development experience with DevOps ...

    View Job
  • Junior DevOps Engineer

    Blue Stone Staffing Detroit, MI

    Responsibilities: Define, design, build, test, deploy, and support software products ...

    View Job
  • Data Analyst

    Great Logics inc Plano, TX

    Job Description & Duties: Analyze today's service enrollment and renewal rates from ...

    View Job
  • Scrum Master

    Great Logics inc Plano, TX

    Job Description: Must be CSM/PSM Certified Good to have Telematics Domain Knowledge Manage...

    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.