Role: Software Engineer (Ab Initio)
Type: Hybrid
Location: Charlotte, NC
Role Summary
Hiring a strong Ab Initio professional with deep database expertise to design, build, optimize, and support enterprise ETL/data integration pipelines on Oracle/SQL platforms.
Key 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.
TOP SKILLS
• 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.
NICE TO HAVE
• Experience with cloud data platforms (AWS/Azure/Google Cloud Platform).
• 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).
EDUCATION
• Bachelor’s/Master’s in Computer Science, IT, or related field