Ab Initio ETL

2T Consulting

Wilmington, DE

Posted On: Oct 22, 2024

Posted On: Oct 22, 2024

Job Overview

Job Type

Contract - W2, Contract - Independent

Experience

8 - 20 Years

Salary

Depends on Experience

Work Arrangement

On-Site

Travel Requirement

0%

Required Skills

  • Ab Initio
  • ETL
  • SQL
  • JSON
Job Description
Responsibilities
  • Design and develop ETL processes using Ab Initio, including mapping specifications, high-level design (HLD), and low-level design (LLD).
  • Perform coding, unit testing, and debugging of ETL jobs to ensure data integrity and performance.
  • Write and optimize SQL queries and PL/SQL scripts for data extraction, transformation, and loading.
  • Develop and maintain Unix shell scripts for automation of ETL workflows.
  • Implement data parsing techniques using JSON and XML for data ingestion and transformation.
  • Collaborate with cross-functional teams to gather requirements and translate business needs into technical specifications.
  • Provide technical support and guidance to team members and stakeholders.
  • Monitor and troubleshoot ETL processes to resolve any issues promptly.
  • Stay updated with emerging technologies in the ETL and data processing space.

 

Qualifications
  • 8+ years of hands-on experience in Ab Initio ETL development.
  • Strong proficiency in SQL, with extensive experience in Oracle and Teradata databases.
  • Familiarity with Hadoop and Hive is a plus.
  • Knowledge of BFS domain is an advantage.
  • Proficient in Unix shell scripting and developing efficient scripts for automation.
  • In-depth experience with JSON and XML data formats, including parsing and transformation techniques.
  • Strong analytical and problem-solving skills with a keen attention to detail.
  • Excellent communication skills, with the ability to engage effectively with both technical and business teams.

Job ID: 2C240434


Posted By

Shayne

Sr. Recruiter


Related Jobs
  • Contract - W2
  • Contract - Independent

  • Company
  • COMPANY

    2T Consulting

  • Company
  • experience

    8 - 20 Years

  • Travel Requirements
  • Work Arrangement

    On-Site

  • Wallet
  • SALARY

    Depends on Experience

  • Skills
  • SKILLS

    • Ab Initio
    • ETL
    • SQL
    • JSON

Posted On: Oct 22, 2024