Job Summary

Informatica/ETL Developer Job in Knoxville, TN

  • Location:
    Knoxville , Tennessee
  • Category:
    Information Systems
  • Contract Type:
    Direct Hire
  • Job reference:

Exceptional job opportunity with a local well-known company for a highly experienced hands-on Informatica/ETL Developer is available in Knoxville, TN! This is a permanent position with excellent benefits. The successful candidate will join an established dynamic team of outstanding developers. Fun and casual work environment.
The ideal candidate will be responsible for the Enterprise Data Warehouse (EDW) ETL development, deployment and monitoring and will work with the team designing the ETL process and exception handling. Proficiency with designing, developing and deploying ETL mappings and workflows, providing technical guidance to other resources and have experience in a variety of software development concepts and practices is must desired.
• Maintains maps and transformation rules of source-to-target ETL processes
• Develops and tests extraction, transformation, cleansing, and load processes
• Adapts ETL processes to accommodate changes in source or target systems
• Modifies existing ETL processes to match new business requirements, improve efficiency, or bring them in line with standards and patterns.
• Maintains and enhances existing data extraction, cleansing, transformation, and loading processes to improve efficiency
• Analyzes ETL processes to identify sources of reported data problems, and provides solutions to those problems
• Mentors/coaches others in ETL by sharing knowledge and lessons learned from relevant past experiences
• Defines and oversees ETL deployment instructions including failure recovery procedures, and monitoring for successful data load of each ETL deployment
• Works within the context of an Agile Scrum team
Skills and Job Knowledge:
• Proficient in analyzing business/data requirements, writing metadata definitions, and writing data mapping specifications
• Proficient in data analysis, defect identifications and resolutions
• Understanding of conceptual, logical, and physical data modeling
• Understand full lifecycle development and agile methodologies
• Ability to understand data in-flight and at-rest and describe processing steps in a visual manner
• Expertise with Informatica’s Product Suite, particularly PowerCenter and PowerExchange, including ability to design and develop complex Informatica mappings, sessions, workflows and identify areas of optimization
• Working knowledge of Oracle database 11g or later, especially SQL constructs, functions, capabilities, and tuning queries
• Familiarity with emerging technologies and software development best practices, particularly related to Enterprise Data Warehousing, Operational Data Stores, Data Lakes, etc;
• Bachelor’s degree from a four-year college preferred, or the equivalent of at least seven years experience and/or training in the technical Business Intelligence field, or equivalent combination of education and experience
• Excellence in oral/written communications, interpersonal relations, team cooperation and demonstrated ability to communicate with both technical and business stakeholders
• Significant experience with Informatica’s PowerCenter and PowerExchange; Informatica Professional Certification is preferred;
• Informatica development experience required with Oracle database technologies 11g and later preferred

Apply Below


Note: Required fields marked with an asterisk (*).


Primary Number
[Ctrl (Cmd Mac) + Click] to select multiple industries
Upload your resume
Terms of Use


Upload your resume using

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability.

Equal employment opportunity information:
EEO is the Law (poster) | EEO is the Law (poster supplement) | Reaffirmation of Affirmative Action Policy Statement