*Send resumes to **[email protected]* <[email protected]>* or reach me at 631-759-8044 Ext: 329*
*Job Title:** Sr. SQL ETL Developer* *Location:** San Diego - CA* *Duration:** 12+ Months* *Description:* The Sr. SQL ETL Developer is needed to program SQL Server 2012 to create SSIS packages to load raw data from GreenPlum to a SQL Server Database. The candidate will create stored procedures to cleanse and transform data into an existing relational data model. *Primary Responsibilities:* · Responsible for data modeling and design, ETL development and processing, performance tuning, and administration for a Business Intelligence environment. · Responsible for end to end design, coding, testing, review and implementation of data interfaces into an existing data warehouse. · Additional responsibilities include troubleshooting, maintenance, and optimization or enhancement of existing processes and code management. *Required Qualifications:* *PROGRAMMING* • SQL Server 2008/2012 • Stored Procedures / T-SQL / P-SQL • ETL / Bulk Load / Data Transformation • SSIS / SQL Server Integration Services /Integration Services • VLDB / Very Large Database • SQL CLR • Data Modeling and Design • Database Administration • Performance Optimization / Performance Tuning / SQL Profiler • Indexes / Keys / Foreign Keys / Unique Keys / Clustered Keys • Relational Database • Data Warehousing / Date Warehouse Design • 3rd Normal Form / Third Normal Form / 3NF • Star Schema / Snowflake Schema • Type II Dimension / Type 2 Dimension / SCD / Slowly Changing Dimensions • OLTP / OLAP / Cubes • Oracle 9i / Oracle 10g / Oracle • SSMS / SQL Server Management Studio *TESTING* • Prepares test plans, documents test cases, reviews results of tests, and identifies further testing required. • Exhibits an expert knowledge of testing techniques and the scope needed in a test plan. *IMPLEMENTATION* • Assists in technical implementation. *Desired Qualifications:* • Bank or similar financial experience a plus. *PROGRAMMING* • Familiar with the technical aspects of data warehousing, Business Intelligence, and CRM systems. • TOAD • pgAdmin III • GreenPlum • SAN / NAS / Network Attached Storage / Storage Area Netwo -- Thanks & Regards, *Sampath* Damcosoft Inc. Phone: 631-759-8044 Ext: 329 Email: *[email protected] <[email protected]>* GTalk: [email protected] Website: www.damcosoft.com -- You received this message because you are subscribed to the Google Groups "American Vendor--IT Consulting" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sap-vendor. For more options, visit https://groups.google.com/d/optout.
