This job has expired, please see additional jobs below
ETL Developer
BMI
Nashville, TN, United States
Job Details - this job has expired, please see similar jobs below
POSITION SUMMARY:Designs, develops, and executes formal Extract, Transform, and Load (ETL) processes. Recommends, implements, develops and utilizes innovative tools and processes to efficiently, accurately, and securely acquire, integrate, and provision large sets of data from and to thousands of sources and customers around the world.
FUNCTIONS OF THE JOB
Essential Functions:which may be representative but not all inclusive of those commonly associated with this position.
• Responsible for the efficient, accurate, and secure acquisition, integration, provision, and exchange of the enterprise data
• Works with external vendors and internal business and technology staff to accurately gather and interpret requirements, specifications, and database models to determine appropriate ETL development solutions
• Develops ETL technical specifications and recommends, designs, develops, tests, implements, and supports innovative and optimal data solutions
• Works with the Data Services and Business Intelligence team to design, implement, and support end-to-end data solutions across multiple platforms, environments, domains, and locations
• Integrates ETL development with existing codebase to maximize object reuse
• Creates, executes, and documents unit test plans for ETL and data integration processes and programs
• Documents ETL processes, programs and solutions as per established standards
• Performs tasks required to conform to the company’s configuration management and software release processes
• Monitors and administers ETL jobs to verify execution and measure performance
• Works with internal team, vendors, consultants, and external partners to quickly identify and resolve data integration and ETL job issues
• Assesses and documents the structure, quality, and compliance of source data and coordinate with business and technology teams to identify and resolve issues
POSITION QUALIFICATION REQUIREMENTS
Education:Bachelor’s Degree in Computer Science or Mathematics. Equivalent work experience as an ETL developer in an enterprise business environment may be considered.
Experience:
• Minimum three years experience designing, developing, testing, and implementing ETL solutions using enterprise ETL tools (experience with IBM DataStage/QualityStage is preferred)
• Minimum two years experience developing and implementing data integration and DW solutions in an Oracle 11g/12g database environment (experience with Netezza preferred; experience with DB2 is a plus; experience with Oracle EBS is a plus; experience with Salesforce is a plus)
• Minimum one years experience working with high volume data exchange and transaction processing systems, preferably in a custom software development environment
Skills and Abilities:which may be representative but not all inclusive of those commonly associated with this position.
• Understanding of Oracle RDBMS
• SQL and PL/SQL development skills in a multi-tier, SOA environment are required
• Proficient in flat file formats, XML within PL/SQL, and file format conversion
• Proficient in web services development
• Understanding of SDLC and Agile Methodologies
• Understanding of model driven development
• Understanding of ETL best practices
• Hands-on experience with design and development best practices
• Proficient in working with technical and business teams to extract and document data integration/exchange requirements
• Ability to express complex technical concepts effectively, both verbally and in writing
• Ability to handle multiple projects and deadlines with minimal supervision
Machines, Tools, Equipment and Work Aids: which may be representative but not all inclusive of those commonly associated with this position.
• Personal computer and associated software
• Normal office equipment
• Enterprise servers
License(s)/Certifications Required: None