ETL Developer

Data Conversion Project ETL DeveloperPerforms highly advanced (senior-level) ETL development work as part of a team on the Data Conversion Project at ERS. ERS has embarked on a multi-year project to convert data from their legacy PeopleSoft system to a cloud solution. The ETL development work will be extracting data from an Oracle database and transforming/loading it to an in-house SQL Server database. Extensive T-SQL skills will be key to the process.Essential Functions:Performs advanced ETL development work on data primarily residing in SQL ServerTranslates rules provided by PeopleSoft developers (Oracle based) into efficient T-SQL scripts to load data into the target database on SQL ServerTroubleshoots, supports and maintains the ETL processes developed by the teamDesigns, deploys, and manages standardized, centralized data sourcesHelps to establish best practices for development, testing, migration and error handling of the ETL activitiesPerforms other duties as assignedOther Duties and Responsibilities:May interact with outside vendorsEssential Work Behaviors:Impeccable written and oral communicationCommunicates respectfully and works harmoniously with all co-workers, customers, and vendors.Provides exceptional customer service.Is flexible; able to work under pressure and; able to adapt to change; and able to work on multiple problems and tasks.Takes initiative to prevent and solve problems.Qualification Requirements:Education/Special Requirements:Bachelor’s degree in computer science, engineering, or related business field.Experience and Training:Three (3) years of hands on experience in T-SQL and SSIS/SSMS developmentThree (3) years of hands on experience in ETL developmentThree (3) years of hands on experience moving and manipulating large data setsPreferred Qualifications:Experience in health/life insurance, accounting and financials, or investment data related activitiesExperience with data tools (i.e. Visual Studio, SSIS, MSSQL )Experience with Azure and agile iterationsExperience with ERP applications (i.e. PeopleSoft, etc.)Knowledge, Skills and Abilities:Uses all knowledge, skills, and abilities to apply critical thinking to all aspects of the job. Critical thinking is a process of forming reasoned opinions through observation, information collection, interpretation, analysis, inference, evaluation, and other skills necessary to successfully meet performance standards of the job.Experience with PeopleSoft HRMS or Finance packages preferredExperience with ERD Modeling & MaintenanceKnowledge of RDBMS architecture and troubleshooting is desirable.Knowledge of data mining methodsTerm of Service: 6 months – 990 hoursWork Hours and Location: M-F 8:00 – 5:00 PM, 200 E. 18th St, Austin, Texas 78701ERS is working 2 days at the office and 3 days from home.