Senior Datastage, Netezza Developer, Engineer

Job Description:

  • Design and develop complex DataStage jobs (Parallel and Sequence) to extract data from various sources (Flat Files, DB2, SQL Server, APIs) and load them into Netezza
  • Optimize DataStage jobs using partitioning, sorting, and buffer tuning
  • Perform SQL tuning specifically for Netezza (e.g., managing Distribution Keys, Clustered Base Tables, and minimizing data skew)
  • Utilize the Netezza Connector and Netezza Performance Server features within DataStage to implement high-speed data loading (nzload) and external table frameworks
  • Write advanced Netezza SQL, including stored procedures, complex joins, and analytical functions to handle data transformation directly within the warehouse (ELT approach)
  • Develop Unix/Linux shell scripts to automate job scheduling, file management, and error handling
  • Implement data validation and cleansing rules to ensure the integrity and accuracy of the data warehouse
  • Provide production support, troubleshoot job failures, and perform root cause analysis for performance bottlenecks

Requirements:

  • Bachelor’s degree in Computer Science, Information Technology, or a related field
  • 5-8 years of data engineer experience in ETL Development, with at least 2 years specifically focused on the DataStage-Netezza integration
  • Deep understanding of Netezza’s MPP architecture, S-Blades, and FPGA processing
  • Proven ability to debug complex data issues and optimize long-running ETL workflows
  • Advanced SQL (Netezza-specific SQL), Unix/Linux Shell Scripting
  • Knowledge of Star/Snowflake schemas, Dim & Fact tables, and SCD (Type 1/2)
  • Control-M or AutoSys (Scheduling), Git/SVN (Version Control), Aginity (Netezza Workbench)
  • Nice to have - some experience with Snowflake or Databricks will be preferred.

Benefits:

    Back to blog

    Common Interview Questions And Answers

    1. HOW DO YOU PLAN YOUR DAY?

    This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

    2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

    When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

    3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

    Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

    4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

    With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

    5. HOW DO YOU PROCESS INFORMATION?

    Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

    6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

    Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

    7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

    Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

    8. HOW TO PRIORITIZE WORK?

    The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

    9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

    Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

    10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

    This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...

    Other Jobs To Apply

    Loan Operations Specialist (WFH/REMOTE) - Hiring Now

    **Experienced Freelance Online Chat Operator – Entry-Level Customer Service Representative**

    Claims Provider Service Advocate - Remote in TN 2380577 | Brentwood, Tennessee | Remote

    reputed company Customer Support Jobs – Remote – College Level 2024 – Job ID- 485 Job ID- 2668

    UPS Remote Jobs (Data Entry| Full Time) Work From Home Jobs – Indeed Jobs US

    Overnight Warehouse Associate at Amazon(Part-Time,Greenfield)

    Home-Based Airline Chat Support Executive

    Entry Level - Data Entry Clerks (Student Work From Home)

    Work From Home Customer Service Rep

    Southwest reputed company $27Hr - reputed company

    Video Tutorial Planner at The Woobles: 100% Remote (US)

    Apple Jobs From Home, Apple Work From Home Apply For The Best Job ( 3D Graphics )

    Warehouse Team Member - Night Shift

    Utilization Management RN-PRN – Remote

    Sales Director, Costa Coffee Cambridge

    Travel and Tourism Assistant (Virtual)

    Waiter (Waitress)

    Hospice: After-Hours RN Overnight (Full-Time) + \$3000 Sign-On Bonus

    Social Media & Marketing Coordinator - Remote Entry Level

    Service Advocate - Remote

    Chat Support Specialist

    Student Franchise Owner | Dorm To Door Student Storage | Handshake

    Bilingual Client Experience Specialist (English/Spanish)

    Electronics/Computer Technician

    Part Time Evening Work From Home Data Entry Job

    Entry-Level Power Apps Developer

    Product Tester (Work From Home) – Keep Free Products + Weekly Pay

    Customer Service Representative Part Time

    Virtual Assistant for Real Estate transaction management and client feedback reporting (Remote)

    American Airlines Reservation Agent (Remote)

    American express remote jobs virtual customer care - VacancyGlobal

    Social Media Manager

    Data Entry Clerk Work From Home - Part-Time Focus Group Participants (Up To $750/Week)

    [Hiring] Survey Field Technician @AEI Consultants

    Remote Customer Service Representative 50k-60k/Year - Work From Home

    Administrative Assistant - Data Entry (Remote)

    Remote Entry-Level Customer Support – No Experience Required

    amazon flex $15+/ Hour (Sign on Bonus)!

    Delivery Driver (Seasonal) Full-Time Part-Time

    Talent Acquisition – Non-Technical Hiring (Remote)

    Financial Analyst – Sustainability & Carbon Pricing (USA)

    Hiring Now - Work from Home - No Experience

    DC Warehouse

    Warehouse Specialist with 75% Travel

    Clinical Appeals RN - Remote (M-F working alternating Saturdays)

    Pharmacy Technician - Fully Remote | Up to $70/hr

    Customer Care Specialist – Remote, No‑Degree Required – Earn $25‑$35/hr While Building a Career in a Supportive, Growth‑Focused Team at careerzynith

    Customer Service Representative Agent Work From Home - Part Time Focus Group Panelists

    Virtual Customer Care Chat Professional: Earn $25-$30 per Hour Remotely