Role Overview: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). This role focuses on data warehouse data integration, conversion support, ETL development, data validation, and downstream system enablement, requiring 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 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.
- Batch run for Integration testing.
- Coordination with Offshore Engineers.
Required Skills:- Experience supporting enterprise migration or modernization programs.
- Basic knowledge and experience in AI and prompt engineering using GitHub/copilot.
- ETL: Informatica PowerCenter.
- Databases: Teradata.
- SQL Expertise: Complex SQL Development, Performance Tuning, Stored Procedures, Macros, Views.
- Data Warehousing: Dimensional Modeling, Data Integration Design, Data Lineage, Metadata Management.
Qualifications:- 3+ years of Data Engineering experience.
Preferred Skills:- Informatica IICS.
- FIS Commercial Lending Suite (CLS) domain knowledge.
- Python programming.
- Automation using AI.
- IDMC.