
Data Engineer
Artech · San Antonio, TX · Onsite
Strong hiring record · median 13 days open
- First seen
- 20 November 2026
- Reposted
- Once since September 2026
All reasons
In its favour
- Posted today
- Still listed on the employer's own board
- Publishes a salary range
Job Title : Senior Data Engineer – Data Warehouse
Location
San Antonio, TX – 100% Onsite from Day 1
Duration
6 Months
Salary Range
$35.00 - $38.00/Hour on W2 (Without Benefits).
Applicants must be willing to work on W2.
Job Summary
We are seeking an experienced Senior Data Engineer to support the migration from the legacy Shaw Commercial Loan Maintenance System to FIS Commercial Lending Suite (CLS).
The role will focus on data warehouse data integration, conversion support, ETL development, data validation, and downstream system enablement.
The ideal candidate has strong experience in enterprise data warehousing, large-scale system conversions, complex ETL processing, and financial services data.
Key Responsibilities
- Develop and support Informatica workflows and mappings.
- Create high-performance SQL transformations and data processing logic.
- Implement incremental load and Change Data Capture (CDC) solutions.
- Optimize large-volume batch data loads.
- Integrate data with different source systems.
- Support enterprise data synchronization processes.
- Develop data reconciliation processes.
- Resolve data quality issues and transformation discrepancies.
- Support conversion testing and production cutover validation.
- Execute batch runs for integration testing.
- Coordinate with offshore engineers.
Required Qualifications
- 3+ years of Data Engineering experience.
- Experience supporting enterprise migration or modernization programs.
- Basic knowledge and experience in AI and prompt engineering using GitHub Copilot.
Technical Skills
ETL
- Informatica PowerCenter
- Informatica IICS (preferred)
- Informatica CDI (Cloud Data Integration)
- IDMC
Databases
- Teradata
SQL Expertise
- Complex SQL Development
- Performance Tuning
- Stored Procedures
- Macros
- Views
Data Warehousing
- Dimensional Modeling
- Data Integration Design
- Data Lineage
- Metadata Management
Nice to Have
- FIS Commercial Lending Suite (CLS) domain knowledge.
- Python programming.
- Automation using AI.
Experience Requirements
- 6–8 years of experience (as specified for Informatica CDI).
- 7+ years of experience in Informatica CDI (Cloud Data Integration).
Skills
- ETL
- Informatica
- SQL
- Prompt Engineering
- GitHub Copilot
- Python
More jobs at Artech
All 475Similar roles
- Lead Data ArchitectExpert In Recruitment Solutions · West Los Angeles, CAtoday
- Security Architect V (Senior Cloud Data Architect)Mindlance · Washington, DCtoday
- Data & Integration EngineerCompass Health Center · Chicago, Illinois, United Statestoday
- Senior Data Engineer - HybridGenesis10 · Eagan, MN · USD 79–89/hrtoday
- Senior Forward Deployed Data ScientistFin · NYC · USD 206,000–229,000/yrtoday