Current opportunities >> Position Details >>

Position Details

Job order - J0117-1951 - Permanent Full Time
Title Senior Data Warehousing Specialist
Category Database Administration
City Albany, Georgia, United States

Job Description Senior 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).



At CGI, we’re a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 65,000 professionals located in 40 countries. Founded in 1976, CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources, expertise, stability and dedicated professionals needed to achieve results for our clients - and for our members. Come grow with us. Learn more at www.cgi.com.

This is a great opportunity to join a winning team. CGI offers a competitive compensation package with opportunities for growth and professional development. Benefits for full-time, permanent members start on the first day of employment and include a paid time-off program and profit participation and stock purchase plans.

We wish to thank all applicants for their interest and effort in applying for this position, however, only candidates selected for interviews will be contacted.

No unsolicited agency referrals please.

All CGI offers of employment in the U.S. are contingent upon the ability to successfully complete a background investigation. Background investigation components can vary depending upon specific assignment, or upon any US government security clearance if required. 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 519547

Click here to apply