Lead Ab Initio Developer

Lead Ab Initio Developer#26-05440 CHARLOTTE, NC All On-site Job Description

Job Descriptions:

In this contingent resource assignment, you may: Consult on complex initiatives with broad impact and large-scale planning for Software Engineering. Review and analyze complex multi-faceted, larger scale or longer-term Software Engineering challenges that require in-depth evaluation of multiple factors including intangibles or unprecedented factors. Contribute to the resolution of complex and multi-faceted situations requiring solid understanding of the function, policies, procedures, and compliance requirements that meet deliverables. Strategically collaborate and consult with client personnel.

Required Qualifications:

5+ years of Software Engineering experience, or equivalent demonstrated through one or a combination of the following: work or consulting experience, training, military experience, education. 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/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.

SOFT SKILLS

• Strong analytical/problem-solving ability.
• Clear communication and stakeholder management.
• Ability to work in agile delivery teams.

INTERVIEW

• 1-2 ROUND

INTERVIEW

• 30 min
• 1 hour
• Video interview

EEO:

"Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of

• Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.

"