*Hi, * *Hope you are doing great!!*
*Please find the requirement below , If you find yourself comfortable with the requirement please reply back with your updated resume and I will get back to you or I would really appreciate if you can give me a call back at my contact number 609-897-9670 *4012.* *Position : SSIS /SQL Server Developer* *Location: Bridgewater, NJ* *Duration: 12+ Months* *Required:- * *7 Years of relevant Experience.* *Strong experience in MS SQL Server 2000/2005/2008 with BI in SSIS* *Extensive knowledge of Relational Database Management Systems.* *Excellent backend skills in creating SQL Data Objects.* *Strong background and knowledge of T-SQL – DML, DDL, Transactions, Stored Procedures, Triggers and Functions to facilitate efficient data manipulation and data consistency.* *Proven ability in Performance Tuning, Query Optimization and running Database.* *Expert in understanding business-data relationships, modeling data and creating data mappings.* *Strong database design skills – Normalization, Keys, Indexes, Joins, and Partitions. * *Experience in extraction & migration of data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using import/export Wizard, DTS/SSIS, and BCP & Bulk Insert utilities. Optimized queries using SQL Profiler and Database engine tuning advisor.* *Extensive experience in creating ETL packages using SQL Server 2005/2008 Integration Services (SSIS) and scheduling packages, cleaning bad data, validating data using SSIS wizard.* *Knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services and experience working with Normalization and De-Normalization techniques for both OLTP and OLAP systems.* *Experience in using multiple transformations provided by SSIS such as script component, Lookup, Data Conversion, Conditional Split, Bulk Insert, Merge, Merge Join, Union All, and Slowly Changing Dimension.* *Experience in the whole cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.* *Experience in creating jobs, Alerts, SQL Mail Agent, Database Mails and Scheduled DTS and SSIS Packages.* *Familiar with Business Requirement Gathering creating BRDS, FRDs, Use Cases, Activity Diagrams and Test Cases. * Thanks & Regards Sheshan Y. Technical Recruiter Email: [email protected] Phone:609-897-9670 Extn 4012 Fax: 302-269-7171 Address: 38 Washington Road, Princeton Junction, NJ 08850 [image: Description: Description: Description: cid:[email protected]] -- You received this message because you are subscribed to the Google Groups "Open Source Erp & Crm" 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/open-source-erp-crm. For more options, visit https://groups.google.com/d/optout.
