Software Engineer / Remote

Role: Software Engineer Location : Remote Role SummaryHiring 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/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).EDUCATION Bachelor’s/Master’s in Computer Science, IT, or related field