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 *408-457-9399 ext 2050*
*Need Visa copy, without that no submission. Please don’t send me resumes if you can’t provide Visa copy.* *Role**::* *SSIS /SQL Server Developer Location::* *Bridgewater, NJ Duration:: 8+ months* *Job Description::* *Job Title* *SSIS /SQL Server Developer* *Relevant Experience* *(in Yrs)* 5 to 7 *Technical/Functional Skills* · 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. *Experience Required* May require a bachelor's degree. Requires 5 - 7years of experience in the field or in a related area. *Roles & Responsibilities* · Familiar with a variety of the field's concepts, practices, and procedures · Relies on experience and judgment to plan and accomplish goals · Performs a variety of complicated tasks · May lead and direct the work of others · Experience working within a matrix project team · A wide degree of creativity and latitude is expected. *Generic Managerial Skills* *Soft Skills Requirements:* · Excellent communication, interpersonal and professional client interaction skills · Excellent team player, quick learner , detail oriented and responsible · Strong analytical, management, organizational and problem solving skills · Ability to adapt quickly to fast pace and changing environment along with new technological innovations · Able to communicate and get along well with other coworkers *Education* *Start* *date* (dd-mmm-yy) 9/7 *Duration of assignment *(in Months) 8 to 12 months *Work Location* Bridgewater, NJ *Thanks & Regards,* Vaishali Tyagi Sr. Technical Recruiter *IDC TECHNOLOGIES INC* | *1851 McCarthy Boulevard, Suite 116, Milpitas, CA , USA, 95035* *Phone No.: **408-457-9399 ext-2050 **I** Email: * *[email protected]* <[email protected]>* I * *Gtalk: **[email protected]* <[email protected]> *Web: **www.idctechnologies.com* <http://www.idctechnologies.com/> "Under Bill s. 1618 Title III passed by the 105th U.S. Congress this mail cannot be considered spam as long as we include a way to be removed from our mailing list. Simply send us an e-mail with REMOVE in the subject and we will gladly REMOVE you from our mailing list." *Error! Filename not specified.* -- You received this message because you are subscribed to the Google Groups "oraapps" 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/oraapps. For more options, visit https://groups.google.com/d/optout.
