skip to navigation | skip to content
Site SelectorReal Estate ProfessionalsContact


1 (800) 810-7771
337-234-3009 (Fax)

[email protected]
211 E. Devalcourt St.
Lafayette, LA 70506
map center

LEDA Virtual Job Fair


Employers interested in posting their job openings on the LEDA Virtual job fair (at no cost) can send job description, qualifications, and application method to LEDA's Director of Workforce Development by email.

In addition to posting your vacancies on LEDA's website, positions are also distributed to a network of workforce centers and educational institutions as appropriate.

Position: Senior ETL Developer (Informatica) (CGI)

Over 10 years IT experience in Design ETL solutions and data conversion strategy and solutions for multiple disparate systems using Oracle and Informatica
Create end-to-end solution for ETL transformational jobs that involve writing Informatica workflows and mappings, and creating database Packages, procedures and functions
Develop, maintain, and enhance Informatica Mappings, Work-flows, and processes
Support proper functioning and performance tuning of Informatica platform
Develop stored procedures and triggers using DB2 database to support ETL jobs
Work effectively with the DBA teams to ensure that all approved development and deployment procedures are followed.
Provide production support from development teams for existing systems, troubleshoot data and/or system issues
Identify root causes and resolve data related issues
Review and optimize query performance
Writing Test Strategies, Test Plans, Test Cases, and Test Closure document.
Expert in Create Data mapping documents to support ETL process
Extensive experience with database development tools (Oracle, Toad), ETL and integration technologies
Converting functional specifications into ETL technical specifications and source to target mappings
Proven hands-on experience in using Informatica components such as Designer, Workflow Manager, Workflow Monitor, Repository Manager, etc
Hands on experience with database Performance tuning like Oracle, MSSQL Server, MySQL, and strong database languages like SQL, PL/SQL, TSQL, Unix Shell, Python and Perl Scripting
Good Experience in tuning of Informatica mappings and Database scripts and procedures.
Experience in implementation of BI projects in a large scale enterprise data warehouse environment

Implement and maintain the database design- Create database objects (tables, indexes, etc.)

Write database PLSQL Packages, procedures, functions and triggers
Assist team members (Developers/QA/DEVOPS) with database activities
Tune database queries
Monitor application related jobs and data replication activity.
Your future duties and responsibilities:
Primary Skill:
Secondary Skills:


Minimum experience, Bachelors Degree in relevant studies.

  • Expert (5 Years hands on experience) in Informatica v9.1 or higher

  • Expert (7 Years hands on experience) in Oracle database development (SQL,PLSQL, Oracle tools)

  • Minimum 3 years Quality Assurance experience

  • Minimum 3 years of Python development

Application Requirements:
Apply online at

Apply Online

Job Posted:
Application Deadline:

Resume Prep & Job Search Assistance

Click below to find more information on visiting the local Business & Career Solutions Center at 706 E. Vermilion Street, Lafayette, LA where staff can assist you with resume preparation assistance, job search assistance, and referrals to training and employment opportunities.


  Job Posting Websites

Click Here to view a listing of upcoming job fairs.