| Data Warehouse Analyst - Local to Florida Only at Florida, New York, USA |
| Email: [email protected] |
| From: Megha, Infologitech [email protected] Reply to: [email protected] Hi Greetings from InfoLogitech, Inc. Here is our open requirement which can be filled immediately. Kindly respond to this requirement with your resume, contact and current location info to speed up the interview process. Job Position : Data Warehouse Analyst Job Location : Tallahassee, FL Job Duration : 4 Years Job Description: Contractor staff assigned to this agreement must possess the following minimum qualifications and experience: Six years of experience with Structured Query Language (PL/SQL) to query Oracle databases. Six years of experience with Oracle relational databases, On-Line Transaction Processing (OLTP) and Decision Support System (DSS), serving in high performance, service-oriented, multi-tiered environments. Six years of experience with Source Code Control System (SCCS) for the management of internal code changes to Oracle Forms and Reports, Oracle objects, and scripts. Microsoft Structured Query Language (MS SQL) Related Experience: Six years of experience with MS SQL products inclusive of MS SQL 2008. Six years of experience as an MS SQL administrator inclusive of data design and modeling, monitoring, and performance tuning. Six years of experience with Structured Query Language (SQL) programming inclusive of stored procedures, functions, triggers, DTS packages, scheduled jobs, and linked servers. Six years of experience with SQL relational databases, OLTP and DSS, serving in high performance, service-oriented, multi-tiered environments. Six years of experience with configuration management (SourceSafe administration) for SQL database objects. Six years of experience with database design tools including ERWin and ERStudio. Reports Development Experience: Six years of experience with independently analyzing and interpreting table structures and relationships to develop complex queries and reports. Six years of experience with database navigational and analysis tools, and the ability to recommend the appropriate tool for the appropriate data infrastructure complexity; Six years of experience with developing queries and reporting against complex relational databases with preference given to experience with Crystal Reports and ASP to deliver such queries and reports. Six years of experience with data integrity evaluation, taking corrective action on identified data problems, and assisting with implementing data quality checks during data intake; Six or more years developing queries and reports against the Versa Regulation and Versa Online Commercial Off-the-Shelf (COTS) products. CONTRACTOR RESPONSIBILITIES: SERVICE TASKS: Contractor will perform the following tasks in the time and manner specified: As directed by the Department, develop ad-hoc queries on database schema daily. As directed by the Department, provide reporting and data integrity requirements of the licensure data warehouse to the Departments Office of Information Technology (OIT) daily. As directed by the Department, modify MS SQL T-SQL language daily. As directed by the Department, modify MS SQL Database Storage structures tables daily. As directed by the Department, modify MS SQL tables view indexes daily. As directed by the Department, develop ad-hoc queries on MS SQL Databases daily. As directed by the Department, work directly with the Departments OIT to manage production promotion for Crystal BO reports daily. As directed by the Department, provide analytical services for system incidents and enhancements daily. As directed by the Department, process defect tickets to correct system errors within two business days. As directed by the Department, process release tickets to manage user requirements within the specific ticket request timeframe. The response due date of tickets assigned will range from one hour to more than one week. As directed by the Department, provide analytical services on systems to implement user-defined report requirements monthly. As directed by the Department, provide analytical services on systems to identify data integrity issues daily. As directed by the Department, facilitate collection of report requirements with the business program staff daily. As directed by the Department, deliver code to perform reporting functions as defined in user requirements daily. As directed by the Department, document report requirements, business processes, and system processes daily. As directed by the Department, perform testing on system changes to meet user-defined requirements daily. As directed by the Department, facilitate user acceptance testing (UAT) with the business program staff daily. As directed by the Department, facilitate meetings with technical and program staff (scheduling meetings, document decisions, identify issues and action items) daily. As directed by the Department, produce work estimates to implement user-defined requirements and system changes daily. As directed by the Department, produce status reports on the implementation of user-defined requirements monthly. As directed by the Department, produce detailed accounting of hours worked by tasks monthly. As directed by the Department, provide analytical services on Departments OIT processes to identify operational efficiencies daily. As directed by the Department, provide analytical research to satisfy queries requested by the Legislature and Departments management daily. As directed by the Department, follow the Departments OIT processes and coordinate with other Department IT staff to ensure compliance with Department standards daily. Coordinate efforts with the Departments Program Manager to achieve cost savings under this agreement, where feasible and practicable, as directed by the Department. Those efforts include, but are not limited to, identifying common system errors in systems that can be resolved in a manner that achieves cost savings in the State of Florida. Thanks & Regards, Megha US IT Recruiter | InfoLogitech, Inc. 3 Independence Way, Suite 117, Princeton, NJ - 08540. Direct 609-212-0605 Email: [email protected] | www.infologitech.com Infologitech Technology Company Keywords: active directory information technology microsoft procedural language Florida New Jersey Data Warehouse Analyst - Local to Florida Only [email protected] |
| [email protected] View all |
| Mon Apr 29 20:19:00 UTC 2024 |