Welcome to the job board! Below you will find various available positions. If you click on the title, or on read more, it will take you to a page with a full description of the job posting. To search for a specific job press Ctrl+F to open up a search bar in your browser. It will only search the current page you are on, so it is important to remember to refresh your search when you go to a new page of openings.

Senior ETL Developer (Informatica)

CGI/Lafayette, LA
Job Title: Senior ETL Developer (Informatica)
Full Time
Job Description:
  • 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:
  • Informatica
  • Secondary Skills:
  • SQL/PLSQL
  • ETL
  • Scripting
Qualifications:
  • 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
Contact:
Apply online at https://goo.gl/hVaEFX
Date Posted: 11/13/2017