Location: CA
Education: Bachelor’s degree in Computer Science, Computer Applications, or a related Engineering discipline, or equivalent.
Job Responsibilities
- Collaborate with product development teams and senior designers to develop architectural requirement to ensure client satisfaction with product.
- Work on identifying and resolving various major production fixes and provide innovative solutions to meet the needs of the business.
- Integrating data to support both operations Operational Data Store ODS and analytics Data warehouse.
- Working with UNIX shell Scripts to create the parameter files dynamically and scheduling jobs using Autosys.
- Write complex SQL for purposes of push down, complex joins, analyzing data or evaluating how information needs might be translated into back end database structures.
- Participate in discussions with Business and User teams to analyze and develop requirements.
- Design data input and data collection processes for the enterprise Data warehouse.
- Enhance and maintain relational databases to support new application features and maintain data repository with data definitions, relationships, linkages and sources.
- Define source to target data mapping and rules so as to develop, document and revise system design
- Develop create and/or modify computer applications software and/or utility programs and Data warehouse modeling and design, Conceptual and Logical data modeling.
- Ability to build and articulate sound integration design patterns with governance responsibility across
- Design, develop, testing to ensure the quality of integrations across the enterprise cost.
- Review mapping, naming convention, table names, mapping variables etc and checking they are valid mappings with check in comment.