Job Description :
POSITION: SSIS Developer
LOCATION: San Francisco, CA
DURATION: Long Term
Job Description :
ll the highlighted statements relates to a lead position, I was hoping we would get someone who is hands on SSIS developer. Updated this section below
Acts as a senior SSIS developer with strong knowledge on SSIS/ SQL/ C# to develop complex ETL packages for DataMart, analyzing highly complex business requirements, designs and writes technical specifications to design or redesign complex computer platforms and applications.
Acts as an expert technical resource for modeling, simulation and analysis efforts. Prepares test data, unit test case, execute unit test case and document unit test result. Prepares detailed FSD documentation. Support overall systems testing and the migration of platforms and applications to production.
Develops new documentation, departmental technical procedures and user gui
The Enterprise Legal Technology group within Enterprise Risk Management Technology is responsible for designing, developing and supporting the needs of Wells Fargo Law Department and Wells Fargo Legal Entity Office.
The applications managed by this team are used by Attorneys, Paralegals, Compliance Managers, Fees Consultants, and Legal Entity Office staff to manage various functions within the lines of business.
The Legal Technology team is looking for an experienced SSIS developer and applications systems engineer to build and support a new ETL process to populate a Datamart reporting database.
The successful candidate
Develops and implements extract, transform, and load systems
Understands reporting technologies
Evaluates systems specifications for data and reporting and develops efficient data models and solutions
Performs database development including ETL and Stored Procedures
Demonstrates ability in supporting enterprise database platforms across all SDLC phases and across multiple environments
Works independently being a team player
Good communication skills to work with various groups
Expert in writing complex SQL queries
SQL Server/TSQL- 5+ years
SSIS- 5+ year
C# to use in SSIS – 5+ years
Experience with BI tools, Business Objects preferred
SSRS- 3+ year