Job Title: Ab-initio Developer/Data Engineer
Location: Charlotte, NC (5 Days Onsite)
Duration: 24 Months (Possible to convert to Full Time)
`
NOTE: THIS IS ON W2 Job Overview: - Data Engineering aligned with Home lending line of business
- Designing Blueprints
- Data modeling and analysis exp required
- Data transformation and distribution
- Interact with complex system
- Should have sourced data from large complex systems
- ETL/ETL experience for few years
- Financial Services exp preferred or can consider large Enterprise Clients
- Strong Python programming experience
Key Skills: Abinitio, Python, PL/SQL, Teradata, BigQuery(preferred), CI/CD, Orchestration, Airflow, Unix Shell Scripting exp
- Join the Home Lending Data and Insights team as a Software Engineer 3 - Contingent, where candidates will build, run, and modernize enterprise data pipelines in a hybrid landscape-spanning on?prem platforms (Python, Oracle, Teradata and Ab Initio) and a modern Google Cloud stack (BigQuery, Dataplex).
- Candidates will focus on dependable batch and near real-time processing, operational excellence, and the transition from legacy scheduling and ETL patterns to cloud-native orchestration with Google Cloud Composer, backed by strong data quality standards using Informatica Data Quality.
In this role, candidates will: - Build and maintain scalable batch and near real-time data pipelines using AB Initio, Python, PySpark, PL / SQL and SQL to ingest, transform, and publish curated datasets across on-prem and Google Cloud platforms.
- Develop and optimize BigQuery transformations and data models, including partitioning, clustering, query optimization, and cost/performance tuning.
- Support modernization/migration from Teradata and Ab Initio workflows to Google Cloud Platform/BigQuery, including logic re-platforming, reconciliation, parallel runs, and controlled cutovers.
- Implement orchestration and scheduling for pipelines using legacy Autosys while driving migration toward Google Cloud Composer (Airflow), including dependency management, retries, SLAs, and backfills.
- Apply data governance and discovery practices using Dataplex: metadata management, dataset organization, classification support, and ensuring data is consumption-ready.
- Build and operationalize data quality controls using Informatica Data Quality: profiling, rule implementation, thresholds, exception handling, and embedding quality gates into pipelines.
- Ensure operational excellence: monitoring, alerting, runbooks, incident triage/root cause analysis, and continuous improvements to reliability and performance.
- Implement secure data engineering practices: least-privilege access, PII handling/masking where required, retention controls, and audit-friendly documentation.
- Partner with product, analytics, and engineering stakeholders to translate requirements into clear data contracts, curated datasets, and maintainable documentation (data dictionaries, reconciliation notes, operational runbooks).
Must-have: - Use AI-assisted coding tools (e.g., GitHub Copilot, Devin, or similar) to accelerate development while maintaining strong code review discipline, testing, and secure coding standards.
- Closely partner with Product Owners, Architects and Engineers on definition, design, development, integration, testing and support of reliable and reusable Data pipelines.
- Analyze highly complex business requirements; generate technical specifications to design ETL processes.
- Act as an expert technical resource for analysis and provides critical direction to less experienced staff. Work with team members to provide insight into solving complex problems with middleware while leveraging enterprise and industry best practices (including scalability, availability, maintainability, and flexibility).
Required Qualifications: - 4 plus years of Data Engineering experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education
- 4 plus years PL/SQL and SQL skills with proven experience in Oracle, Teradata, Python and/or BigQuery: complex query development, tuning, and debugging.
- 4 plus years Ab Initio skills with proven experience to build complex graphs, Psets, performance tuning.
- 3 plus years programming skills in Python; hands-on PySpark for distributed data processing.
- 3 plus years of ETL/ETL design, data warehousing concepts, and data modeling best practices.
Desired Qualifications: - Production operations experience: monitoring, SLAs, incident response, root cause analysis, and performance optimization.
- Experience working in hybrid environments (on-prem + cloud) and supporting data migration/modernization initiatives.
- Experience with scheduling/orchestration in Autosys and Airflow-based orchestration (Cloud Composer direction).
- Experience with Git-based workflows, code reviews, and automated testing practices for data pipelines.
- Experience with Harness, Jenkins and uDeploy based CICD environments.
- Practical experience using AI-assisted coding tools in daily development to improve productivity without compromising quality or security.
- Ab Initio development/maintenance experience and/or hands-on migration of Ab Initio graphs to modern Spark/SQL patterns.
- Experience with Dataplex and broader data governance concepts (metadata, classification, stewardship, lineage practices).
- Experience with Informatica Data Quality implementation patterns (profiling, rules, scorecards/metrics, exception workflows).
- Experience designing near real-time patterns (micro-batch/event-driven concepts) and handling late-arriving/out-of-order data.
- Familiarity with Google Cloud Platform operational practices for data workloads (service accounts/IAM basics, job monitoring, quota/cost controls).
About PTR Global: PTR Global is a leading provider of information technology and workforce solutions. PTR Global has become one of the largest providers in its industry, with over 5000 professionals providing services across the U.S. and Canada. For more information visit ;br>
At PTR Global, we understand the importance of your privacy and security. We NEVER ASK job applicants to:
- Pay any fee to be considered for, submitted to, or selected for any opportunity.
- Purchase any product, service, or gift cards from us or for us as part of an application, interview, or selection process.
- Provide sensitive financial information such as credit card numbers or banking information. Successfully placed or hired candidates would only be asked for banking details after accepting an offer from us during our official onboarding processes as part of payroll setup.
Pay Range: $55 - $60/hr on W2
The specific compensation for this position will be determined by several factors, including the scope, complexity, and location of the role, as well as the cost of labor in the market; the skills, education, training, credentials, and experience of the candidate; and other conditions of employment. Our full-time consultants have access to benefits, including medical, dental, vision, and 401K contributions, as well as PTO, sick leave, and other benefits mandated by applicable state or localities where you reside or work.
If you receive a suspicious message, email, or phone call claiming to be from PTR Global do not respond or click on any links. Instead, contact us directly at +1 . To report any concerns, please email us at
During the hiring process, we may use artificial intelligence (AI) tools to assist in evaluating information related to your application. These tools may help analyze job-related qualifications or assist recruiters in reviewing applications and interview responses. AI-generated information is one factor considered in our hiring process. Final employment decisions are made by qualified hiring personnel and are not based solely on AI-generated recommendations.
#LI-SS4
Never miss an opportunity! Create an alert based on the job you applied for.