vmysmartpros

Compensation

Full Description

Job title: Business Intelligence Analyst Company: 3A Soft Inc. Job description: Business Intelligence Analyst Education Requirement: Master's Degree or foreign equivalent in CS or Engg along with 12 months of work experience. Please send your resume to Job Location: 3A Soft Inc., 15 Corporate Place South, Suite 319, Piscataway, New Jersey, 08854. Job 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 work-site locations. recblid my1js6gcvygqmxbmdmi4mwesuyjjbd Expected salary: Location: Piscataway, NJ Job date: Sat, 20 Aug 2022 05:20:29 GMT Apply for the job now!