ETL Developer

Full-time

Encore Technologies

ETL Developer Erlanger, KY

Encore Technologies is seeking an ETL Developer. The ideal candidate will possess strong SSIS experience together with a high-level/basic level experience with SQL development and coding.

Responsibilities:
Build ETL processes that map data from source systems to target systems utilizing SSIS in an automated manner
Perform extraction, transformation, and the load of data functions within IT
Work with outside vendors to develop data transfer strategy both internally and externally for new and existing systems
Develop a secure model for data transfer design along with database administration that will keep all data secure
Determine and report the impact of database changes and ETL processes on the application systems
Keeps data secure by managing access, privileges, and information migration
Responsible for translating database design and diagnosing database performance issues
Ensure integrity of all physical database objects and established database procedures
Develop, maintain and improve database stored procedures
Implement and maintain backup/recovery, restart/refresh, and disaster recovery procedures

Qualifications:
Thorough understanding of Business Intelligence and Data Warehousing principles, approaches, technologies, and architectures including the concepts, designs, and usage of data warehouses, data marts, and operational data stores
Good understanding of RDBMS principles
Hands-on experience in building database objects (Oracle, SQL Server)
Understand the relationships between business activities and application systems

Tagged as: ETL Developer