CGI Veterans Jobs

Job Information

CGI Technologies and Solutions, Inc. Data Warehouse Developer in Madison, Wisconsin

Data Warehouse Developer

  • Create your Profile | Sign in

  • Activate Career Alerts

Share this

Find similar career opportunities

Data Warehouse Developer

Category: Development/Engineering

City: Madison, Wisconsin, US United States

Position ID: J0221-3162

Employment Type: Full Time

Meet our professionals

CGI: A place to build an IT career

Position Description:

CGI is seeking a Data Warehouse Developer to join our team!

Your future duties and responsibilities:

You will be responsible for assisting in ETL design, development, testing, maintenance, metadata, and implementation of data warehouse initiatives. Understand user requirements, and implement solutions that ensure requirements can be achieved through high quality deliverables.

Develop ETL mapping specifications for loading information into the data warehouse and for ensuring reliability of information loaded. Seek continuous improvement in performance & tuning of data warehouse and ensure security of data.

Work with other IT technical teams and Business users to understand requirements, and recommend & implement solutions.

Closely supervised with some latitude for independent judgment. Typically requires up to three years of experience or equivalent education.

Required qualifications to be successful in this role:

Ideal candidate will have skills and experience in the following areas:

  • Moderate experience in data warehousing process design, development, performance & tuning using the Informatica data warehousing tool suite

  • Developing skills in the architecture of data warehouse and data integration strategies and solutions

  • Knowledge in data warehouse best practice standards

  • Knowledge in relational data base technologies; e.g. Oracle, DB2, SQL Server

  • Moderate skills working with relational and dimensional data models

  • Moderate skills working with slowly changing dimensions

  • Strong data management and data analysis using SQL

  • Strong verbal and written communication skills, including facilitation of meetings with customers and technical staff

  • Knowledge and skills in the project development life cycle process (i.e., planning, analysis, design, coding, testing, implementation, support)

  • Demonstrated knowledge and skills in requirements gathering

  • Effective interpersonal relations skills, ability to effectively collaborate with others and work as part of a team

  • Skills in navigating a large organization in order to accomplish results

  • Ability to initiate and follow through on complex projects of both short and long term duration

  • Excellent organizational and time management skills.

  • Excellent analytical and problem solving skills

  • Ability to work independently, assume responsibility for job development and training, researching and resolving questions and problems, requesting supervisor input and keeping supervisor informed

  • Proficiency with MS Office suite, MS Visio, and MS Outlook.

Seeking 3 years of experience in the following:

*Ability to develop and implement quality assurance processes and procedures including test/use cases

*Ability to navigate and query a relational database (Oracle) to both develop

*Data Warehouse - Experience in data warehouse design and development

*Data Warehouse - Experience in requirements gathering for data warehouse

*Data Warehouse - Performance tuning


  • Develop design specifications

*Business Objects or other BI tools

*Develop Test Plans, Test Cases, and Test Procedure

*Identify defects

Seeking 2 years of experience in the following:

Knowledge of Kimball data warehouse and business intelligence lifecycle


Seeking 2 years of experience in the following:

*Demonstrated experience in the design and utilization of performance measure and reports


*Dashboarding/Business Objects Xcelsius

Seeking 3 years of experience in the following:

*Data analysis

*In-Depth Knowledge of System Development Life Cycle Deliverables for each Phase of Development

Est. Salary Range (Colorado Only): $66K-$85K*

*Disclaimer: In accordance with Colorado’s Equal Pay for Equal Work Act, effective January 1, 2021, a good faith hourly or base salary range must be posted for all positions where the work may be performed in the state of Colorado. Therefore, this good faith salary range will only apply where this described position will be performed in the state, and should not be considered the compensation range in other locations or for other positions.

At CGI we call our professionals “members” to reinforce that all who join our team are, as owners, empowered to participate in the challenges and rewards that come from building a world-class company. CGI’s benefits include:

• Competitive base salaries

• Eligibility to participate in an attractive Share Purchase Plan (SPP) in which the company matches dollar-for-dollar contributions made by eligible employees, up to a maximum, for their job category

• 401(k) Plan and Profit Participation for eligible members

• Generous holidays, vacation, and sick leave plans

• Comprehensive insurance plans that include, among other benefits, medical, dental, vision, life, disability, out-of-county emergency coverage in all countries of employment;

• Back-up child care, Pet insurance, a Member Assistance Program, a 529 college savings program, a personal financial management tool, lifestyle management programs and more


  • Business Objects

  • Data Analysis

  • Data Warehousing

  • DB2

What you can expect from us:

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 .

No unsolicited agency referrals please.

CGI is an equal opportunity employer.

Qualified applicants will receive consideration for employment without regard to their race, ethnicity, ancestry, color, sex, religion, creed, age, national origin, citizenship status, disability, pregnancy, medical condition, military and veteran status, marital status, sexual orientation or perceived sexual orientation, gender, gender identity and gender expression, familial status, political affiliation, genetic information, or any other legally protected status or characteristics.

CGI provides reasonable accommodations to qualified individuals with disabilities. If you need an accommodation to apply for a job in the U.S., please email the CGI U.S. Employment Compliance mailbox at . You will need to reference the requisition number of the position in which you are interested. Your message will be routed to the appropriate recruiter who will assist you. Please note, this email address is only to be used for those individuals who need an accommodation to apply for a job. Emails for any other reason or those that do not include a requisition number will not be returned .

We make it easy to translate military experience and skills! Click here to be directed to our site that is dedicated to veterans and transitioning service members.

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 dependent upon specific assignment and/or level of US government security clearance held. CGI will consider for employment qualified applicants with arrests and conviction records in accordance with all local regulations and ordinances.

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.