*SQL Developer* * *
*Atlanta, GA* * * *6 Months* * * *Need Local GA…* * * *Job Description* The SQL Developer should possess good technical/business communication skills to interact with both IT & business teams for understanding requirements.This include understanding and experience applying SDLC process. The Developer must have at least 6 yrs experience in the IT industry and at least 5 yrs experience hands on SQL development using in the MS SQL 2000/2005 environments. The developer must have at least 4 yrs experience using the MS SSIS development environment and should have experience with all SSIS transformers and their usage and implementation. The Developer must have good unit testing skills. The developer must be able to function in the capacity of an ETL Developer, SQL Developer, and QA Tester (analyzing source/target). *Responsibilities* - Perform source/target analysis of data structures & content - Create transformation requirements, data load & cleansing plans utilizing SSIS 2005. - Accessing data in a wide variety of formats, and get data to target format. - Query/research data and help identify missing/inconsistent data. - Design & develop a reusable database/framework, to support an ETL process - Build modules to apply business rules, transform the data and load into a data store. - Document the rational, process of extraction and business rules. - Automate the entire ETL process and send automated notifications to various parties - Should be able to work independently and also as a team member with a proactive sense *Skills* - Experience using and developing and administration in SQL Server 2005/2008. - 6 yrs of hands-on SQL programming, tuning and optimization experience. Stored Proc programming experience a must. - 4 yrs of hands-on data transformation coding using an ETL Tool or programming language - 4 yrs of hands-on MS SSIS design, development, including creation of workflows, job scheduling, maintenance and enhancement - Some .Net scripting a plus - Knowledge/experience with data warehousing concepts such as data modeling, data quality, data cleansing. - Knowledge/experience with both Relational Models, and Dimensional preferable *Software:*** *ETL Tools: * SSIS 2005/2008, SSAS *Databases:* SQL Server 2005/2008, *Languages:* Transact SQL, VB.NET, C#.NET, PLSQL *Data Modeling Tools:* ER Studio 7.1 and up *Operating Systems:* Windows NT / 98 / XP / 2000 / Server 2000 *Other Tools:* VSS, MS Visio -- Regards, kalyan venkatesh Sr.IT Recruiter Softpath Systems, Inc.|Maiden Lane, NY-10038 Voice: 212-405-1894 x 104 | FAX:(212)-405-1895 Email : [email protected],[email protected] URL : www.softpathsystems.com Disclaimer : We respect your Online Privacy. This is not an unsolicited mail. This mail cannot be considered Spam as long as we include Contact information and a method to be removed from our mailing list. If you are not interested in receiving our e-mails then please reply with a "remove" to [email protected] in the subject line and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e-mails to you. Sorry for the inconvenience caused.
