Saxon AI Logo

Saxon AI

ETL DataStage Consultant

Reposted 3 Months Ago
In-Office
Oakland, CA, USA
Senior level
In-Office
Oakland, CA, USA
Senior level
The ETL DataStage Consultant will lead the migration of file transfer interfaces and develop ETL applications while managing complex data systems and ensuring data quality.
The summary above was generated by AI
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.

Similar Jobs

5 Minutes Ago
Remote or Hybrid
USA
85K-100K Annually
Mid level
85K-100K Annually
Mid level
Cloud • Fintech • Information Technology • Machine Learning • Software • App development • Generative AI
Manages channel partner relationships to drive revenue, identify sales opportunities, execute joint selling initiatives, develop go-to-market strategies, forecast revenue, support partner education, resolve contract and deal-booking issues, and collaborate with sales and marketing teams. The role requires SaaS channel sales experience, consultative selling skills, CRM proficiency, accurate pipeline management, and travel up to 40% of the time.
Top Skills: Blackline SolutionsCrm SoftwareSaaSSales Reporting Tools
5 Minutes Ago
Easy Apply
Remote or Hybrid
United States
Easy Apply
234K-349K Annually
Expert/Leader
234K-349K Annually
Expert/Leader
eCommerce • Healthtech • Kids + Family • Retail • Social Media
Own the strategy, architecture, development, deployment, monitoring, and continuous improvement of production personalization and recommendation systems. Build custom embeddings, ranking models, and shared representations across feeds, search, and recommendations. Lead ambiguous problems from concept to measurable customer impact, establish AI evaluation standards, partner with product and data teams, make cross-team technical decisions, and coach senior engineers.
Top Skills: AirflowAWSAws SagemakerBedrock AgentcoreClaude CodeCoderabbitDatadogDbtDeep LearningDevinGithub ActionsHexIncident.IoIterableKotlinKubernetesLangchainLaunchdarklyLinearMatrix FactorizationMaximMlflowMySQLPackwerkPandasPythonPyTorchRuby on RailsRankingReactRetrievalScikit-LearnShopifySidekiqSigmaSnowflakeSwiftTerraformTypescriptWardenWarpstreamWeaviateXgboost
6 Minutes Ago
Remote or Hybrid
US
85K-100K Annually
Junior
85K-100K Annually
Junior
HR Tech • Information Technology • Professional Services • Sales • Software
Manage approximately 200 existing SMB accounts, driving upsells, cross-sells, renewals, and expansion revenue. Own the full commercial sales cycle from opportunity identification through negotiation and contract execution. Build consultative customer relationships, uncover whitespace, forecast pipeline, and use structured sales methodologies. Partner with Customer Success Managers and Sales Engineers while maintaining accurate CRM records and staying current on products, customer trends, and sales tools.
Top Skills: Gong EngageLinkedin Sales NavigatorSalesforce

What you need to know about the San Francisco Tech Scene

San Francisco and the surrounding Bay Area attracts more startup funding than any other region in the world. Home to Stanford University and UC Berkeley, leading VC firms and several of the world’s most valuable companies, the Bay Area is the place to go for anyone looking to make it big in the tech industry. That said, San Francisco has a lot to offer beyond technology thanks to a thriving art and music scene, excellent food and a short drive to several of the country’s most beautiful recreational areas.

Key Facts About San Francisco Tech

  • Number of Tech Workers: 365,500; 13.9% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Google, Apple, Salesforce, Meta
  • Key Industries: Artificial intelligence, cloud computing, fintech, consumer technology, software
  • Funding Landscape: $50.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Sequoia Capital, Andreessen Horowitz, Bessemer Venture Partners, Greylock Partners, Khosla Ventures, Kleiner Perkins
  • Research Centers and Universities: Stanford University; University of California, Berkeley; University of San Francisco; Santa Clara University; Ames Research Center; Center for AI Safety; California Institute for Regenerative Medicine

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account