guys, can you help me determine which would be more fit to this duties and responsibilities. this is for one company only but having dual or more roles:
NOC: 217X (Computer related NOC)
Position/Title: Systems Analyst
Role1:
• Supports one or more systems. Work on data-driven projects that involve business intelligence, data warehousing and data integration
• Identifies areas for improvement / enhancement on existing data warehouse (DWH) system and on new ones being developed; support renewal, stability and upgrade projects, including disaster recovery exercises
• Identifies, analyzes, rationalizes and transforms business requirements to produce conceptual and technical design specifications at the system and programming levels. This includes understanding core business and associated business rules, data collection requirements, business rules, project objectives and assists in the operational maintenance of reference data to further support and enabling ability to evaluate and helps to maintain quality data for the creation of reports
• Review project artifacts (such as design documents, database schemas, Data Definition Language (DDL) scripts and compare to minimum acceptable standards, conformance to industry best practices and alignment with the project's requirements and company standards
• Create and maintain system documentation (e.g. User Manual, Technical Systems Manual and Operations Manual) that impact the use of data warehouse systems
• Design, develop, code, test, implement, debug/fix programs and document system changes and new projects according to technical program specifications and company's standards
• Provide ongoing support of DWH applications in production including responding to service requests, performing problem analysis and resolution, issue escalation and reporting as necessary
• Perform regular DWH maintenance activities required to keep the applications working at expected levels. Provide on-call and after-hours support as required
• Defines and creates test plans; develops documents and maintains data quality targets and standards. Perform testing – Dev, System Integration Testing (SIT), User Acceptance Testing (UAT) and other testing as required to ensure that the application system processing reflects user requirements / technical designs
• Performs and oversees DWH and all related activities such as data sourcing, migration, design, implementation and quality control, installation of the application system, functional and technical training and tutorial for end users
• Customize, configure and install software products and patches as per vendor specifications
• Work closely and maintain effective communication with key business people, technology teams, and other project teams.
• Provides leadership and coordination on projects assigned to systems analysts. Provides updates and status reports to the project manager during the course of development and related support activities
• Provides work estimates in support of assigned work
• Performs other related duties as assigned.
Role2:
• Plan and interact with business users (non-technical) to identify and understand high-level and detailed requirements and provide functional and technical expertise through data warehouse (DWH) development and implementation using Informatica PowerCenter (ETL), Business Objects (BOBJ) (Report) and Oracle and MS SQL Server (database system) for new and existing company's DWH solutions
• Participate in the evaluation and direction of specific project deliverables and ensures that end-to-end business requirements are met and delivered; provide recommendations in areas that require a high level of technical competency including data models and architecture, data profiling, ETL design patterns, data warehouse implementation best practices and solutions, effort estimates, etc.
• Lead the development and implementation of Company's data warehouse; ensure standards and requirements are met, understand and assess the impact of technical changes (including DB changes, table dependencies, data integrity, capacity planning, etc.) within the environment
• Design, model and implement data warehousing activities including data sourcing, migration/promotion, design, implementation and quality control of codes and configures databases and provides support to end users. Responsible for verifying data integrity, quality and accuracy and implementing business rules throughout development lifecycle
• Manage, monitor and maintain data warehouse performance and resolve production issues and challenges as they occur. Provide technical and application support (corrective and preventive) for Data Warehouse reporting processes and functions
• Develop and support DWH architecture using star and snowflake schemas, dimensional models, define standards and direct the data warehouse capture and access effort.
• Design and develop dashboards, parameterized reports, and guided analysis using business intelligence software (BOBJ).
• Determine and implement security, data protection and information access requirements for the data warehouse including data masking and type of users' and group's access to the reports
• Design, develop and optimize processes to extract, transform and load (ETL) data by tuning complex mappings with multiple sources, and extensively used SCD Type 1 and Type 2 to update Slowly Changing Dimension tables, Changed Data Capture (CDC), fact and dimension using Star and Snowflake models, physical and logical designs and other ETL strategies, methods and best practices
• Design, create, implement and maintain database/ data warehouse / data mining objects such as tables (facts, dimensions, referential and metadata tables including Informatica and BOBJ repository tables), views, materialized views, synonyms, indexes, sequence, stored procedures and functions
• Manage development, test and production server environments; Provide technical assistance on implementing and managing data server upgrades; and building, migrating and maintaining Informatica and BOBJ metadata and repository
• Administer the repository by creating folders and logins for the group members and assigning necessary privileges.
• Ensure deployment adheres to deployment process in place – following change management standards and procedures as implemented by Company
• Work with relational databases such as Oracle 11g, SQL Server 2005 and integration (ETL) and reporting tool such as Informatica and Business Objects
