Abinitio Developer
- Kezan Inc
- 4 - 6 years
- Noida, Gurugram
- 29 days ago
- Email to a friend
- Report this job
Job Description
Job Title: Ab Initio Developer
Location:Gurugram
Experience: 4-5 years
Employment Type: Full Time
Job Summary:
We are seeking an experienced Ab Initio Developer to design, develop, and maintain high-volume, enterprise-grade ETL solutions for our data warehouse environment. The ideal candidate will have strong technical expertise in Ab Initio components, SQL, UNIX scripting, and the ability to work collaboratively with both business and technical teams to deliver robust data integration solutions.
Key Responsibilities:
- Analyze, design, implement, and maintain large-scale, multi-terabyte data warehouse ETL applications that operate 24/7 with high performance and reliability.
- Develop logical and physical data models to support data warehousing and business intelligence initiatives.
- Lead and participate in complex ETL development projects using Ab Initio, ensuring quality and efficiency.
- Translate business requirements into system and data flows, mappings, and transformation logic.
- Create detailed design documentation, including high-level (HLD) and low-level design (LLD) specifications.
- Conduct design reviews, capture feedback, and facilitate additional sessions as required.
- Develop, test, and deploy ETL workflows using Ab Initio components such as Rollup, Scan, Join, Partition, Gather, Merge, Interleave, Lookup, etc.
- Perform SQL database programming and optimize SQL queries for performance.
- Develop and maintain UNIX shell scripts to automate ETL workflows and system processes.
- Collaborate with Release Management, Configuration Management, Quality Assurance, Architecture, Database Support, and other development teams.
- Ensure adherence to source control standards using EME or similar tools.
- Provide ongoing support and maintenance of ETL processes and troubleshoot issues as needed.
Required Skills & Qualifications:
- Hands-on development experience with Ab Initio components (Rollup, Scan, Join, Partition by key, Round Robin, Gather, Merge, Interleave, Lookup, etc.)
- Strong background in designing and delivering complex, large-volume data warehouse applications
- Experience with source-code control tools such as EME
- Proficient in SQL database programming, including query optimization and performance tuning
- Good working knowledge of UNIX scripting and Oracle SQL/PL-SQL
- Strong technical expertise in preparing detailed design documents (HLD, LLD) and unit testing
- Ability to understand and communicate effectively with both business and technical stakeholders
- Strong problem-solving skills and attention to detail
- Ability to work independently as well as part of a team
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: ETL DeveloperEmployement Type: Full timeContact Details:
Company: kezanincLocation(s): Noida, Gurugram
Keyskills: Abinitio Graphs Ab Initio ETL Unit Testing Rollup Oracle SQL LLD Initio Data Mapping Partitioning Low Level Design Unix Scripting Data Flow Lookup Interleave Data Loader Gather SQL Graph Merge PLSQL Scan Round Robin High Level Design Data Warehousing
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in