| Position Details |
Job order - J0117-1950 - Permanent Full Time
|
| Title |
Data Warehousing Specialist |
| Category |
Database Administration |
| City |
Albany, Georgia, United States |
|
| Job Description |
Data Warehousing Specialist
Position Description
Join the CGI Federal team! CGI Federal is looking for a Data warehousing specialist to support USMC operations at our Albany, GA location. Alternately, this position may be staffed in Manassas, VA.
Your future duties and responsibilities
1) Test software systems or applications for software enhancements or new products.
2) Review designs, codes, test plans, or documentation to ensure quality.
3) Provide or coordinate troubleshooting support for data warehouses.
4) Prepare functional or technical documentation for data warehouses.
5) Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
6) Verify the structure, accuracy, or quality of warehouse data.
7) Select methods, techniques, or criteria for data warehousing evaluative procedures.
8) Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.
9) Map data between source systems, data warehouses, and data marts.
10) Implement business rules via stored procedures, middleware, or other technologies.
11) Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.
12) Develop or maintain standards, such as organization, structure, or nomenclature, for the design of data warehouse elements, such as data architectures, models, tools, and databases.
13) Design and implement warehouse database structures.
14) Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
15) Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
16) Create or implement metadata processes and frameworks.
17) Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
18) Design, implement, or operate comprehensive data warehouse systems to balance optimization of data access with batch loading and resource utilization factors, according to customer requirements.
19) Changing available storage to ensure maximum limits are not exceeded.
20) Planning and executing storage implementation plans to support production environments to include associated drawings.
Required qualifications to be successful in this role
Must be able to demonstrate accomplishments in the ability to maintain the system architecture to ensure sufficient capacity and availability; allocate file systems on client and application servers; reallocate storage space across physical file systems; Participate in the planning, implementation and monitoring of storage capacities to include or create all required documentation; knowledge of the Department of Defense Architecture Framework (DoDAF).
Also experience in the following programming languages but not limited to:
• AJAX; ASP; C programming; client-side JavaScript; Client-side VBScript; COBOL using oracle SQL*plus; C-shell; CSS; HTML (Versions 4.0 and Above); Java; Java Bean; Java Server Pages (JSP); JavaScript; Lexical Analyzer (LEX); NAWK; Oracle Forms/Reports (Versions 10g and Above); Oracle PL/SQL; PHP; SED; Unix Scripting including Korn Shell; Visual Basic and Visual Basic .NET.
Provides knowledge and expertise in industry standards including, but not limited to American National Standards Institute (ANSI) X12 protocol for electronic data interchange (EDI).
Build your career with us.
It is an extraordinary time to be in business. As digital transformation continues to accelerate, CGI is at the center of this change—supporting our clients’ digital journeys and offering our professionals exciting career opportunities.
At CGI, our success comes from the talent and commitment of our professionals. As one team, we share the challenges and rewards that come from growing our company, which reinforces our culture of ownership. All of our professionals benefit from the value we collectively create.
Be part of building one of the largest independent technology and business services firms in the world.
Learn more about CGI at www.cgi.com.
No unsolicited agency referrals please.
CGI is an equal opportunity employer.
Qualified applicants will receive consideration for employment without regard to their race, color, religion, sex, gender Identity, sexual orientation, national origin, age, disability, veteran status, pregnancy, or other status protected by law. CGI will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with CGI’s legal duty to furnish information.
|
|
| Skills |
|
|
| Reference |
519540 |
|
|
Click here to apply
|
|
|
|