Abinitio Developer

Nsw Consulting Vadoadara; Bengaluru; Hybrid; INR 1,500,000 - 2,100,000; Full time

Job summary

Nsw Consulting Vadoadara in Bengaluru is seeking an experienced Ab Initio & Teradata Developer to lead ETL development, data warehousing, and large-scale data transformation. The role focuses on high-performance data pipelines within BFSI/enterprise platforms.

The candidate will design Ab Initio workflows, optimize Teradata SQL, and ensure data quality and governance throughout the project lifecycle, collaborating with analysts and architects.

Qualifications

• 5+ years of experience in Ab Initio & Teradata development.
• Strong hands-on ETL, data warehousing and large-scale data transformation experience.
• Experience with BFSI/enterprise data platforms is preferred.

Responsibilities

• Design, develop, and maintain Ab Initio ETL workflows, graphs, and components.
• Build and optimize batch and real-time data pipelines.
• Develop and tune Teradata SQL for large-volume datasets.
• Implement data transformations, aggregations, and validations.
• Perform performance tuning for Ab Initio graphs and Teradata queries.
• Work on SCD (Type 1, 2, 3), fact and dimension load processes.
• Handle the end-to-end ETL lifecycle: requirements analysis, design, development, testing, deployment, and production support.
• Collaborate with business analysts, data architects, and downstream consumers.
• Ensure compliance with SDLC, data governance, and security standards.
• Create and maintain technical design documents and mapping specifications.

Skills

Ab Initio

Teradata

ETL Development

SQL

Data Warehousing

Data Governance

SDLC

Tools

Teradata

Job description

Location: Bengaluru
Experience: 5+ Years
Notice Period: Immediate to 15 Days

We are looking for an experienced Ab Initio & Teradata Developer with strong hands‑on expertise in ETL development, data warehousing, and large‑scale data transformation. The ideal candidate will work on complex data integration programs, primarily within BFSI / enterprise data platforms, ensuring high performance, scalability, and data quality.

Key Responsibilities

• Design, develop, and maintain Ab Initio ETL workflows, graphs, and components
• Build and optimize batch and real‑time data pipelines
• Develop and tune Teradata SQL for large‑volume datasets
• Implement data transformations, aggregations, and validations
• Perform performance tuning for Ab Initio graphs and Teradata queries
• Work on SCD (Type 1, 2, 3), fact and dimension load processes
• Handle the end‑to‑end ETL lifecycle: requirements analysis, design, development, testing, deployment, and production support
• Collaborate with business analysts, data architects, and downstream consumers
• Ensure compliance with SDLC, data governance, and security standards
• Create and maintain technical design documents and mapping specifications