Vacancy caducado!
General Job Description: Designs, develops, programs, installs, implements, conducts research for, and maintains internal data processing computer systems and utilities, and/or for customers on a contract basis. Designs, models, documents, and guides the logical and conceptual relationship of data and database changes for complex applications. Establishes system parameters and formats; ensures hardware/software compatibility; and coordinates and/or modifies user requirements in terms of existing and projected computer capacity and capabilities. May make programming changes as required to adapt or enhance existing or new programs and/or utilities. Develops general and detailed documentation describing system specifications and operating instructions; and revises existing systems and procedures to correct deficiencies and maintain more effective data handling, conversion, input/output requirements, and storage. Specific Job Description:
- Gathers information from existing systems, analyzes program and time requirements. Provides technical advice on complex programming. Writes and prepares detailed specifications for programs at all levels of complexity.
- Designs systems and programs to meet complex business needs including enhancements to existing programs. Ensures programs meet standards and technical specifications. Performs technical analysis and component delivery. Supports project personnel in resolving complex program problems.
- Conducts quality assurance activities such as peer/code reviews.
- Works with all technical areas to resolve issues and validate programming requirements. Enhances processes where applicable.
- Ability to derive the pseudo code on metric calculations that can be used by the SDLC teams for Design, Development, and testing. Perform Gap and Impact analysis on any type of source changes and/or requirement updates.
- Ability to write complex SQL queries to perform analysis on complex and large sets of data in various file formats.
- Provides technical advice on complex data warehouse scenarios. Experience in Informatica is must to understand the data flow from source to Data warehouse by reading the existing complex ETL mappings. Experience with MicroStrategy BI tool is advantage.
- Leads data analysis, database design, develop Logical and Physical Data Models, including Relational and Dimensional Models, prepare Mapping documents with all the transformation logics, BI Objects, Data Quality Rule creation/ enforcement, etc.
- Write DDL script to create/update database structures supporting Oracle and Redshift either manually or through erwin, ability to tune database performance.
- Analyzes multi-data mart system integration opportunities and challenges. Proposes and communicates recommended solutions. Recommends testing methodologies for the proposed design.
- Works individually and with peers to perform metadata management across erwin, Oracle, Redshift, Informatica and MicroStrategy.
- Develops, documents, and maintains data architecture-related standards and documentation.
- Responsible for supporting planning activities and supporting the on-schedule delivery of milestone and deliverables.
- Must possess effective organizational, interpersonal, oral and written skills, strong analytical and problem-solving capabilities and close attention to detail. Must be a team player able to multi-task in a dynamic environment and have an extensive working knowledge of the SDLC and the associated processes and documentation.
Vacancy caducado!