Apetan Consulting LLC is seeking a Software Engineer to design, build, optimize, and support enterprise ETL/data integration pipelines on Oracle/SQL platforms. The role requires strong Ab Initio expertise and involves developing ETL workflows, troubleshooting production issues, and collaborating with various teams to maintain technical documentation and support release activities.
Responsibilities:
- Design and develop ETL workflows using Ab Initio (GDE, Co>Operating System, EME)
- Build reusable components for extraction, transformation, and loading of large datasets
- Develop and tune complex SQL, PL/SQL, and database objects (views, procedures, indexes, partitions)
- Perform data mapping, data quality checks, reconciliation, and error handling
- Optimize graph performance (parallelism, memory, partitioning, sort/join strategy)
- Troubleshoot production issues, job failures, data mismatches, and performance bottlenecks
- Implement scheduling/dependencies with enterprise schedulers
- Work with source/target systems, business analysts, QA, and DevOps teams
- Maintain technical documentation and support release/deployment activities
- Follow security, governance, and SDLC standards
Requirements:
- 5+ years in Ab Initio development
- Hands-on with Ab Initio components (Reformat, Join, Rollup, Scan, Partition by Key, Sort, Lookup, Normalize/Denormalize)
- Strong expertise in Oracle/SQL (query tuning, execution plans, indexing, partitioning)
- Experience in PL/SQL development and performance tuning
- Strong understanding of data warehousing concepts (SCD, fact/dimension modeling, CDC, incremental loads)
- Unix/Linux shell scripting and automation
- Experience with version control and CI/CD practices
- Bachelor's/Master's in Computer Science, IT, or related field
- Experience with cloud data platforms (AWS/Azure/GCP)
- Knowledge of messaging and streaming (Kafka or similar)
- Exposure to Python for utility scripts/data validation
- Familiarity with monitoring tools and production support model
- Domain experience in BFSI/Healthcare/Retail (as applicable)