Sr. SSIS ETL/Informatica Developer Salesforce

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.