Job Description :
Position: SSIS Developer
Location: Torrance, CA
Duration: 6+ Months

Job Description :
End to end design and implementation of ETL using 2008 Microsoft SSIS and other data-warehousing technologies
Manage data transfer and integration between SQL server and other external systems
Build scripts to query data from multiple SQL servers and manage data integration for easy user access
Ability to interpret business logic and develop appropriate data-flows and data dependencies
Understand and design system integration as required for extracting data for reporting purposes
Ability to work with and communicate with a team of Developers/Analysts and non-technical Business Stakeholders

Daily Tasks Performed:

Write efficient T-SQL
ETL using Bulk Insert, SSIS
Performance Tuning and Optimization using native monitoring and troubleshooting tools
Perform other duties as assigned


Mastery of Microsoft 2008 SIS
2008 SQL Server Database and SSIS development
Stored procedures, views, triggers, and functions
Principles of Data Mining
Exposure to SSAS 2008, SharePoint, and other BI tools, a plus
Knowledge of Data Warehouse Design Principles
Excellent verbal and written communication skills
Microsoft BI Certification


Experience in 2008 SQL Server Database Development
Experience in Automotive Finance industry
Create, manage and optimize database in SQL Server 2008 & 2012
At least 3-4 project implementations in MS SSIS 2008

Thanks with Regards.
Randhir Prasad
ll Technical Resourcer ll
ll IT-SCIENT LLC | Fremont,CA ll
ll Phone: 510-516-78[ONE][FIVE] ll
ll Email: randhir[DOT]itscient[AT] ll