ETL Specialist

Job Responsibilities:

Write PostgreSQL or other similar language scripts/statements to analyze and translate customer data into Jonas SQL database tables.

Interface directly with the customer to define mapping specifications based on data analysis.

Create, debug, and execute T-SQL scripts and stored procedures that match data mapping specifications.

Perform ETL (extract, transform, load) data imports, exports, and modifications.

Perform quality assurance and database validation on all test and live conversions.

Work on assigned tasks as a member of a project team as required.

Review data and database backups.

Ability to deal with ambiguity. Make decisions based on the information you have, even if that isnt the whole picture.

Ability to learn on the fly. Quickly and effectively integrates new information and skills to enhance personal performance or the performance of the organization. Learns from successes and failures, regards all experience as an opportunity to learn and improve.

Good problem-solving skills.

Process Management. Aligning processes with the organizations strategic goals, designing, and implementing process plans, establishing process measurement systems that align with organizational goals.

Ability to learn new technical skills, when required.

Ability to organize and plan how to divide your time between specific activities.

Qualifications:

Bachelors degree in Computer Science, Management Information Systems or equivalent.

Experience working with MS Access or other SQL-query-based database programs.

Strong Knowledge of Microsoft SQL Server 2016 and/or PostgreSQL.

Strong Transact-SQL & MS Data Transformation Services (DTS) knowledge.

Strong analytical skills and attention to detail.

Ability to work in a team/collaborative environment but to also work independently.

Solid communication and interpersonal skills are a must.

Skills Desired:

Experience with SQL Server Integration Services (SSIS)

Experience with SQL Server Reporting Services and Report Builder (SSRS)

Prior database conversion experience

Prior data implementation experience

Prior experience in the health and fitness industry

Key Competencies:

Technical Learning

Planning

Problem Solving

Dealing with Ambiguity

Integrity and Trust

Learning on the Fly

Exciting Benefits we offer:

Market-leading Salary

Medical Coverage – Self & Dependents

Parents Medical Coverage

Provident Fund

Employee Performance-based bonuses

Home Internet Subsidy

Conveyance Allowance

Profit Sharing Plan [Tenured Employees Only]

Life Benefit

Child Care Facility

Company Provided Lunch/Dinner

Professional Development Budget

Recreational area for in-house games

Sporadic On-shore training opportunities

Friendly work environment

Leave Encashment