Sr. ETL Developer (Skype or Teams interviews)

Please note that this position is with our direct client

We are looking for a Sr. ETL Developer (Min 7-10 yrs exp) (Skype or Teams interviews)

POSITION DESCRIPTION

DIRECT CLIENT Position

Number of positions: 1

Length: 6 Months +

Location: Columbus, OH, 43215

Work Address: 246 North High, Columbus, OH 43215

Immediate interviews Skype or Teams interviews ONLY

Requirement Description:

Client is looking for an experienced Sr. ETL Developer to join the team. She or he will be involved in designing, testing and implementing ETL scripts within the Oracle and SQL database environment to maximize the efficiency of data migration process while maintaining excellent data quality standards, and will participate in other data management initiatives.

A well-qualified candidate will have experience with various coding languages and systems and will have extensive knowledge of data warehouse architecture. Individual must have the ability to effectively communicate with internal and external stakeholders, and will actively support the Client's data strategy and goals

This position will function as a skilled Sr. ETL Developer that include:

Utilize the software development lifecycle to implement technology solutions that create and enhance applications.

Extensive knowledge of database and coding languages including Oracle databases, SQL database, PL/SQL packages, Microsoft .NET, Web API and REST, JSON, jQuery, and SQL.

Strong hands-on experience of data modelling techniques including dimensional modelling

Define and capture metadata and rules associated with ETL processes.

Attend information gathering sessions and provides data analysis and data mapping.

Work with various customers, prospects and stakeholders, understands and translates business use cases and/or requirements into data models, data integration routines and analytics reports.

Identifies data sources, develop and maintain data architectures, constructs data catalog and data decomposition diagrams, provide data flow diagrams and documents the process.

Facilitate the development of data integration efforts with the development team in addition to hands on design and development of large complex ETL jobs.

Develop, manage and maintain data models, including physical and logical models of the data warehouse, data marts, development and staging areas and source systems as necessary to meet new and changing business requirements.

Design, implement and maintain database objects (tables, views, indexes, etc.) and database security.

Establish methods and procedures for tracking data quality, completeness, redundancy and improvement; and processes for governing the identification, collection and use of corporate metadata to assure metadata is accurate and valid in the business intelligence environments.

Apply best practices in the design of ETL processes to support information loads, validations and reporting.

Mandatory experience:

4-year college degree or equivalent technical study

10+ years of Application Development in Microsoft .NET,

7+ years of Oracle Database

7+ years of SQL Database

7+ years of SQL script

7+ years of ETL process

7+ years of API designs in RESTful, XML, XSLT, JSON, jQuery.

5+ Years of UI/UX experience

5+ years of PL/SQL Experience

Excellent analytical skills, attention to detail, and problem-solving skills.

Ability to demonstrate working knowledge of ETL Tool including SSIS, Tableau Pre, Talend, Segment.

Proven ability to handle multiple tasks and projects simultaneously.

Familiar with the Agile Methodology.

Working experience in Database & application performance tuning.

Must possess excellent written and oral communication skills.

Strong experience in creating good solutions w/o mature, detailed, codified business requirements.

Working experience in delivering expected results in unstructured environments.

Works productively and effectively independently without significant management oversight.