ETL Data Stage developer

Reposted 8 Days Ago
Be an Early Applicant
Ewing Township, NJ, USA
In-Office
Senior level
Information Technology • Professional Services • Software • Consulting
The Role
Design and build IBM DataStage ETL jobs to extract, transform, and load data into 3NF and star schemas. Implement Slowly Changing Dimensions and Change Data Capture, write strong Oracle SQL, use QualityStage and parallel processing, create source-to-target mappings, write/execute test cases, and use Unix shell scripting. Collaborate with stakeholders and maintain data warehouse ETL processes.
Summary Generated by Built In
Company Description

We specialize in Staffing, Consulting, Software Development, and Training along with IT services to small to medium size companies. AG's primary objective is to help companies maximize their IT resources and meet the ever-changing IT needs and challenges.

In addition, AG offers enterprise resource planning and enterprise application integration, supply-chain management, e-commerce solutions, and B2B public exchanges and B2B process integration solutions. Our company provides application analysis, design, development and programming, software engineering, systems development, testing, integration, and implementation, and management consulting services to various clients – including governmental agencies and private companies – throughout the United States and India.

We provide these services in multiple computing environments and use technologies such as client/server architecture, object-oriented programming languages and tools, distributed database management systems, state-of-the-art networking, and communications infrastructures. Our honest and realistic approach to recruiting dictates that AG does not entice or lure engineers from their employers. We represent only high caliber technical professionals who have committed to making a change required by career.

Job Description

Experienced in creating Data Stage jobs to Extract, Transform and Load data from diverse source systems to both Normalized (3NF) structures and Star Schemas in a Data Warehouse environment.

Very strong ORACLE SLQ is mandatory as is experience with history data using Slowly Changing Dimensions.

Minimum of 5-7 years experience

SKILLS                                                 REQUIRED EXPERIENCE 

Data Stage 8.5                                                   5 years  

Parallel Processing                                           2 years  

Quality Stage                                                      2 years  

Slowly Changing Dimensions                         5 years  

Unix Shell Scripts                                               2 years  

ORACLE SQL                                                     5 years  

Change Data Capture                                       5 years  

Source to Target Mapping                                2 years  

Creating and executing Test Cases               2 years  

Additional Information

  1. Good comm skills are a big priority
  2. Duration: 6 months
  3. In person interview required

  4. Interviews to begin next week

Skills Required

  • Minimum 5-7 years ETL/Data Stage experience
  • DataStage 8.5 (IBM DataStage)
  • Slowly Changing Dimensions (SCD) implementation
  • Oracle SQL - strong
  • Change Data Capture (CDC)
  • QualityStage
  • Parallel processing experience
  • Unix shell scripting
  • Source-to-target mapping
  • Creating and executing test cases
  • Experience building ETL for normalized (3NF) and star schema data warehouses
  • Good communication skills
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
125 Employees

What We Do

Atria Group LLC, also operating as Atria IT, is a specialized IT staffing and consulting firm headquartered in Plano, Texas. The company provides comprehensive workforce solutions, including staffing, consulting, software development, and training services, specializing in enterprise solutions for small to medium-sized businesses. Their primary objective is to assist these enterprises in maximizing their IT resources to meet evolving technological challenges.

Similar Jobs

Cox Enterprises Logo Cox Enterprises

Technical Customer Care Specialist I (Vin Solutions)

Artificial Intelligence • Automotive • Greentech • Information Technology • Machine Learning • Software • Cybersecurity
Remote or Hybrid
United States
50000 Employees
17-25 Hourly

Eve Logo Eve

Vice President Of Sales

Legal Tech • Software • Generative AI
Easy Apply
Remote or Hybrid
United States
180 Employees

Zeta Global Logo Zeta Global

Global Compensation Analyst

AdTech • Artificial Intelligence • Marketing Tech • Software • Analytics
Easy Apply
Remote or Hybrid
United States
2429 Employees
120K-130K Annually

Zeta Global Logo Zeta Global

Lead Software Engineer

AdTech • Artificial Intelligence • Marketing Tech • Software • Analytics
Easy Apply
Remote or Hybrid
United States
2429 Employees
150K-200K Annually

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account