|
Informatica Developer I
Republic National Distributing Company (RNDC) - Atlanta, GA
Job Brief
As Informatica Developer I, the ideal candidate will become part of a team responsible for the complete lifecycle and the management of ETL processes and database systems at RNDC.
Job Code:
27956
Route Information:
Not Applicable
Sales Division:
Not Applicable
Sales Channel:
Not Applicable
Specific Scope:
Not Applicable
Shift:
Day
Pay Type:
Salary
Employment Type:
Full time
City:
Atlanta
Relocation Benefits:
No Relocation Assistance Provided
As Informatica Developer I, the ideal candidate will become part of a team responsible for the complete lifecycle and the management of ETL processes and database systems at RNDC. Collaborating with business, development and testing teams, this role will facilitate accurate data reporting within company standards and maintain 24/7 system availability. Investigate and analyze issues, as well as research opportunities for improvement of processes. Provide expert system and technical advice and guidance to other developers. Enable the use of data quality and accuracy as a strategic enabler. Provide sage advice and design to incorporate additional data points into an ever evolving reporting system to further business visibility.
Essential Duties and Responsibilities include the following. Other duties may be assigned:
Leads the tuning of ETL processes
Leads the tuning of databases
Responsible for timely project deliveries
Leads in writing and reviewing software functional specifications and design reviews
Provides guidance to more junior staff
Provides input to continuously improve ETL process discipline and resulting output quality
Participates in writing and reviewing software functional specifications and design reviews
Collaborates with development teams, business units to identify, define, develop and implement new data source feeds
Monitors usage of the Data Warehouse to identify potential capacity overloads and bottlenecks
Assists with tuning of ETL processes and database performance
Design and develop any/all necessary ETL processes
Responsible for loading and validating data into the data warehouse
Provides support for technical issues and ensuring system availability
Remains current on Data Warehousing technologies, testing industry trends and best practices
Ownership of projects and responsible for deliverables
On-call duties
Additional responsibilities may be assigned
Competencies: To perform the job successfully, an individual should demonstrate the competencies of the RNDC Individual Contributor - Administrative Leadership Competency Model.
Qualifications: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Required skills and abilities:
Ability to translate business requirements into technical solutions
Self-starter with "can-do" attitude, a must in a fast-paced business and technical environment
Professional oral and written communication skills, communicate regularly and effectively with other team members.
Strong interpersonal and relationship building skills, conducive to team development, work under own initiative. Ability to prioritize tasks and work concurrently on multiple tasks.
Project management experiences a plus.
Ability to work well independently and in a team environment
Education and/or Experience:
Bachelor’s degree preferred; six years programming experience and/or training. Broad understanding of general business and management practices is preferred.
6 years of experience in software development utilizing Informatica in combination with Oracle databases in a distribution system environment is preferred.
Complete understanding of all phases of the software development life cycle.
Expert Knowledge of application design principles, systems development and analysis.
Expert UNIX/LINUX and Oracle 12c experience
Complete understanding of relational database design and architecture
Solid understanding of Business Intelligence (BI) architecture and reporting mechanism using tools like Microstrategy
Language Skills: Ability to read and interpret documents (such as safety rules, operating and maintenance instructions, and procedure manuals), write routine reports and correspondence, and to speak effectively before groups of customers or employees of organization. Spanish bilingual abilities preferred.
Mathematical Skills and Reasoning Ability: Ability to apply advanced mathematical concepts such as exponents, logarithms, quadratic equations, & permutations. Ability to apply mathematical operations to such tasks as frequency distribution, determination of test reliability & validity, analysis of variance, correlation techniques, sampling theory, and factor analysis. Ability to define problems, collect data, establish facts, & draw valid conclusions. Ability to interpret an extensive variety of technical instructions in mathematical or diagram form & dal with several abstract & concrete variables.
Computer Skills: Relevant knowledge of application design principles, system development and analysis. Expert knowledge and experience with Informatica Powercenter and its application in a production environment. Advanced knowledge and understanding of Business Intelligence architecture and reporting mechanisms. Expert experience with UNIX/LINUX platforms and Oracle 12c relational databases.
Physical Demands: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this Job, the employee is regularly required to sit; use hands to finger, handle, or feel; reach with hands and arms and talk or hear. The employee is occasionally required to stand and walk. The employee must occasionally lift and /or move up to 10 pounds. Specific vision abilities required by this job include close vision, and color vision.
Work Environment: The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The noise level in the work environment is usually quiet.
| 
(281) 265-2473
