CGI Technologies and Solutions Jobs

Job Information

CGI Technologies and Solutions, Inc. ETL Developer in Lafayette, Louisiana

ETL Developer

  • Log in

Share this

Find similar career opportunities

ETL Developer

Category: Development/Engineering

City: Lafayette, Louisiana, United States

Position ID: J1019-0603

Employment Type: Full Time

Position Description:

Become a member of CGI as we collaborate with our Life Sciences/Healthcare clients to transform the way they work today and enable their path forward. CGI’s capabilities and our client engagements will offer you an exciting path for growth. We strongly encourage and facilitate our members’ development through various avenues including leading engagements, developing new service offerings, designing solutions, and preparing proposals. Our practice’s focus on the New England region allows our consultants to work predominately with local clients, while CGI’s national and international operations offers opportunities for travel if desired. We are seeking candidates with Business Analyst experience in Life Sciences Quality & Manufacturing and GMP fields, as well as strong consulting, analysis, problem solving and communication skills. If you are looking to make your career journey extraordinary while delivering innovative client projects, come and be a part of CGI’s continued success.

Your future duties and responsibilities:

The ETL Developer is responsible for interpreting business requirements through the use of artifacts such as Technical Requirements Document (TRD), logical and physical data models and source to target mappings (STM). Leverage these artifacts to design and functional code to achieve business objectives.

Required qualifications to be successful in this role:

3-5 years’ experience with Oracle 10g/11g; Informatica Power Center 8, 9, 10 and/or PowerExchange (CDC)

SQL/SQL*Plus including the ability to reverse engineer existing code

Skilled in creating detailed Technical Requirements and Design documents

Experienced in OLTP and/or DW/BI development

Familiar with Unix operating environments and Unix Scripting

Familiar with schedule programming software, e.g. Tidal

MS Windows, Microsoft Office including MS Word and MS Excel

Good communication skills, able to communicate effectively with others

Ability to work independently with limited to moderate supervision

Able to prioritize, multitask, meet deadlines, and coordinate schedules with others

Ability to produce documentation, follow process, and possess good organizational skills

Good knowledge of software development standards and best practices such as Waterfall and Agile

Quick learner, able to diagnose technical challenges through reading code and supporting technical documentation

Ability to interpret Data Models


  • Application Development

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, 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 at 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 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.