ETL Developer Programmer Analyst Level 3

Job Description

Position – ETL Developer Programmer Analyst Level 3

Location – Austin, TX – Hybrid

Duration – 1+ Year (Extendable)

Job Description:

General Description:

Performs 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.

Duties and Responsibilities

Essential Functions:

· Performs advanced ETL development work on data primarily residing in SQL Server

· Translates rules provided by PeopleSoft developers (Oracle based) into efficient T-SQL scripts to load data into the target database on SQL Server

· Troubleshoots, supports and maintains the ETL processes developed by the team

· Designs, deploys, and manages standardized, centralized data sources

· Helps to establish best practices for development, testing, migration and error handling of the ETL activities

· Performs other duties as assigned

Other Duties and Responsibilities:

· May interact with outside vendors

Essential Work Behaviors:

· Impeccable written and oral communication

· Communicates 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 development

· Three (3) years of hands on experience in ETL development

· Three (3) years of hands on experience moving and manipulating large data sets

Preferred Qualifications

· Experience in health/life insurance, accounting and financials, or investment data related activities

· Experience with data tools (i.e. Visual Studio, SSIS, MSSQL )

· Experience with Azure and agile iterations

· Experience 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 preferred

· Experience with ERD Modeling & Maintenance

· Knowledge of RDBMS architecture and troubleshooting is desirable.

· Knowledge of data mining methods

Please respond with your updated resume,visa, D/L and requested details below so that I will move forward in the process

Legal Full Name(FirstName, LastName)

DOB(MM/YYYY)

Last 4 SSN

skypeId

Phone(not google voice number)

Visa Status

Current Location

Willing To Relocate(Yes/No)

Onsite After Remote(post covid)(Yes/No)

Email Id

LinkedIn Url

Note: If you are not comfortable with the requirement, I’d appreciate your help. Please take a look and forward this job on to anyone you think would be interested in the position, or anyone else who could help me find a candidate.