1. DUTIES: Analyze and document the functional and technical requirements for existing and new product application. Responsible for the aggregation of data from multiple sources into an efficient Data Warehouse and designing reporting solutions for very large multidimensional databases. Document the technical design document before development process & make sure the SQL server Guidelines mentioned in the design will be followed during development process. Responsible for architecting cutting edge database technology solutions and support for evolving legacy platforms to modern software architectures. Optimize the code to improve performance optimization tools like Database Engine Tuning Advisor, SQL Profiler, and Index Tuning Wizard. Create the Task flows, Mappings and Mapping Tasks which will transform the data from Source to Destination. Develop SSIS packages by extracting the data from heterogeneous databases, perform transformations to meet the business requirements and finally load the data into Data Warehouse database.

Travel may be required to unanticipated client-site locations.

                EDUCATION:                 Master’s Degree or foreign equivalent in CS or Engg along with 12 months of work experience.

DAYS & HOURS:           9:00 am – 6:00 pm, Monday – Friday

SALARY:                                 $69,826.00 per Annum/Yearly

CONTACT:                            President,

                                                      3A Soft Inc.

                                                      15 Corporate Place South,

                                                      Suite 319, Piscataway, New Jersey, 08854

                                                      Tel # (732)476-6226