ETL DataStage Consultant

Posted 14 Hours Ago
Oakland, CA
Senior level
Artificial Intelligence • Cloud • Machine Learning • Analytics • Consulting
The Role
The ETL DataStage Consultant will lead the migration of file transfer interfaces to a managed file transfer process, requiring design and implementation of Extract Transform Load (ETL) applications and data loading processes. Responsibilities include working with complex decision support systems, SQL coding, and ensuring data quality and documentation of ETL code accuracy.
Summary Generated by Built In

Company Description

Saxon Global is one of the fastest growing Inc. 500 Companies in the U.S., providing enhanced IT consulting and engineering solution services for past 16 years. Saxon Global specializes in Business Intelligence, Mobility, Big Data & Cloud and provides IT tools and services to help organizations across industry verticals such as Financial Services, Retail, Telecom, Healthcare, Banking and Media Entertainment for their continued growth.

Job Description

Title: ETL DataStage Consultant.

Location: Oakland, CA

Duration: 6+ Months Contract

Interview: Phone and Skype(Need local)

TOP 2 REQUIREMENTS:

DataStage

PGP

POSITION SUMMARY:

Client is charged with the migration of File transfer interfaces from VSFTP to a managed file transfer (MFT) process - Go-Anywhere. The position requires considerable administrative and technical coordination in a highly complex technical and organizational environment and results in systems designed to meet the migration effort.

Under direction of the Data Services ETL Manager and other members of the Data Services team, the incumbent is responsible for implementing changes required to onboard with the new managed file transfer process, designing and implementing robust Extract Transform and Load applications and processes to load data and supporting metadata into the decision support systems.

PROPOSED JOB REQUIREMENTS:

  • Minimum five years’ experience in data related work with at least 2 years’ experience on UNIX / Shell scripting and as a senior ETL analyst / developer for large, complex decision support systems.
  • Experience working with encryption protocols like PGP Encryption, SSH keys.
  • Hands on experience with IBM DataStage, including extensive experience with parallel job design and development and strong SQL coding skills, is required.
  • Working experience with revision control systems, Linux platform, Shell scripting, and DB2 database is required.
  • Strong familiarity with multi-dimensional Star schema and general DBMS concepts is required.
  • Extensive experience in extract transform and load, data profiling, data quality, metadata management and data intake for large complex data systems.
  • Ability to analyze, verify, and document the accuracy of the developed ETL code through self-directed testing.
  • Bachelors Degree in Information Systems or a related field or an equivalent combination of education and experience.
  • Strong interpersonal skills; ability to work on cross-functional teams.
  • Strong verbal and written communication skills with an ability to express complex technical concepts in business terms and complex business concepts in technical terms.
  • Self motivated and independent
  • Able to work with a minimum of supervision and able to work well with stakeholders and project staff.
  • Ability to prioritize and multi task across numerous work streams.
  • Ability to plan and organize technical work and deliverables.
  • Ability to lead teams to consensus decisions on complex business and technical data challenges.
  • Ability to follow guidelines and adhere to the established software development standards and conventions.
  • Deep knowledge of best practices through relevant experience across data-related disciplines and technologies particularly for enterprise wide data architectures and data warehousing/BI.
  • Experience with IBM data warehouse environment

Qualifications

  • Minimum five years’ experience in data related work with at least 2 years’ experience on UNIX / Shell scripting and as a senior ETL analyst / developer for large, complex decision support systems.
  • Experience working with encryption protocols like PGP Encryption, SSH keys.
  • Hands on experience with IBM DataStage, including extensive experience with parallel job design and development and strong SQL coding skills, is required.
  • Working experience with revision control systems, Linux platform, Shell scripting, and DB2 database is required.
  • Strong familiarity with multi-dimensional Star schema and general DBMS concepts is required.
  • Extensive experience in extract transform and load, data profiling, data quality, metadata management and data intake for large complex data systems.
  • Ability to analyze, verify, and document the accuracy of the developed ETL code through self-directed testing.
  • Bachelors Degree in Information Systems or a related field or an equivalent combination of education and experience.
  • Strong interpersonal skills; ability to work on cross-functional teams.
  • Strong verbal and written communication skills with an ability to express complex technical concepts in business terms and complex business concepts in technical terms.
  • Self motivated and independent
  • Able to work with a minimum of supervision and able to work well with stakeholders and project staff.
  • Ability to prioritize and multi task across numerous work streams.
  • Ability to plan and organize technical work and deliverables.
  • Ability to lead teams to consensus decisions on complex business and technical data challenges.
  • Ability to follow guidelines and adhere to the established software development standards and conventions.
  • Deep knowledge of best practices through relevant experience across data-related disciplines and technologies particularly for enterprise wide data architectures and data warehousing/BI.
  • Experience with IBM data warehouse environment

Additional Information

All your information will be kept confidential according to EEO guidelines.

Top Skills

ETL
SQL
The Company
HQ: Irving, TX
361 Employees
On-site Workplace
Year Founded: 2000

What We Do

Saxon Global is a leading Digital Transformation Service provider. Saxon Global helps customers achieve operational excellence using cloud and Digital technologies. Our team of consultants, dedicated certified engineers, and decades of traditional IT experience combine to enable our customer’s success across every stage of the digital transformation journey. Companies in industries across healthcare, financial service, Retail, Telecom, Media, and SaaS rely on our pool of consultants to help them scale securely, automate, modernize their IT and gain efficiencies in private and public clouds.

Similar Jobs

PwC Logo PwC

Data & Analytics- Senior Manager

Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Hybrid
San Francisco, CA, USA
364000 Employees
130K-256K Annually

PwC Logo PwC

Managed Services - Informatica Data Engineer - Senior Associate

Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Hybrid
Sacramento, CA, USA
364000 Employees
58K-161K Annually

Munchkin, Inc. Logo Munchkin, Inc.

Front Desk Receptionist

3D Printing • Consumer Web • eCommerce • Enterprise Web • Kids + Family
Los Angeles, CA, USA
325 Employees

Outsight Logo Outsight

Spontaneous Application

Information Technology • Software
Hybrid
San Francisco, CA, USA
92 Employees

Similar Companies Hiring

Jobba Trade Technologies, Inc. Thumbnail
Software • Professional Services • Productivity • Information Technology • Cloud
Chicago, IL
45 Employees
InCommodities Thumbnail
Renewable Energy • Machine Learning • Information Technology • Energy • Automation • Analytics
Austin, TX
234 Employees
RunPod Thumbnail
Software • Infrastructure as a Service (IaaS) • Cloud • Artificial Intelligence
Charlotte, North Carolina
53 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account