Job Details

Email to Friend Save Back

Senior BI/ETL Developer

FRISCO-75034, TX, US
03/23/2020

-

Required Skills

Unix Shell scripts, Tableau

Company

Infinity Consulting Solutions, Inc

Experience

5 to 7 Year(s)

Job Description

SENIOR BI DEVELOPER

Frisco, TX

6+ month contract

The Senior BI/ETL Developer will support our Client's NextGen product by developing reporting, migrating data, ETL/data mapping and ensuring readiness for the pilot.

ICS is hiring a Senior BI/ETL Developer for a growing Client in Frisco! This is a 6+ month contract position with the potential to extend or convert.

What You'll Do:

Design, develop, test, implement, and maintain PL/SQL code for ETL, reports and other needs.

Build out reporting for the NextGen product

Work closely with different teams for manual processes as well as resolving issues.

Troubleshoot data and work flow issues within the data warehouse, as well as transactional databases

Work closely with team members, DBAs, and business analysts to implement a sound solution, while
adhering to agile methodology and lean integration techniques

Automate and monitor jobs, rectifying issues within a timely manner ensuring SLAs are met

Logical and physical database design following best practices and standards

Monitor and resolve issues with Golden Gate

Work efficiently to resolve production support issues, escalating issues as needed.

Maintain proficiency in a variety of computer programming languages, such as SQL, PL/SQL, Unix shell
scripting, in order to successfully complete the tasks of the role.

Update and maintain Entity Relational Diagrams as required.

Provide documentation of new processes, as well as update and maintain existing documentation as
needed.

Skills/Experience You'll Need:

Bachelor's degree in Information Technology or related field from an accredited college or university is preferred

5+ years Data Warehousing/ETL experience

6+ years of Development experience

Experience with AWS

Experience with two or more of the following tools:

Siphon

Pentaho

Domo

PowerBI

Tableau

Hands-on experience with the following:

Gathering business requirements

Documenting the reporting and analysis specifications

Designing technical architecture

Installing and configuring all components of an ETL tool

Creating complex mappings, sessions, and workflows

Strong experience writing SQL, PL/SQL, and Unix Shell scripts.

Experience with Oracle Developer Tools such as Enterprise Manager and SQL Developer preferred