Sr. Integration Engineer SSIS/ Informatica PowerCenter/ IDMC/ Python

Job Summary

Wells Fargo is seeking a Senior Software Engineer.

Responsibilities

• Lead moderately complex initiatives and deliverables within technical domain environments
• Contribute to large scale planning of strategies
• Design, code, test, debug, and document for projects and programs associated with technology domain, including upgrades and deployments
• Review moderately complex technical challenges that require an in-depth evaluation of technologies and procedures
• Resolve moderately complex issues and lead a team to meet existing client needs or potential new clients needs while leveraging solid understanding of the function, policies, procedures, or compliance requirements
• Collaborate and consult with peers, colleagues, and mid-level managers to resolve technical challenges and achieve goals
• Lead projects and act as an escalation point, provide guidance and direction to less experienced staff

Required Qualifications

• 4+ years of Software Engineering experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education

Desired Qualifications

• Design, develop, and maintain complex ETL/ELT pipelines using SSIS, Informatica PowerCenter, and Informatica IDMC/IICS.
• Lead modernization and migration initiatives from PowerCenter/SSIS to IDMC and Python-based data processing frameworks.
• Develop and optimize data integration solutions for SQL Server, Oracle, cloud data platforms, and enterprise data warehouses.
• Build Python-based utilities, frameworks, and automation solutions for data ingestion, validation, reconciliation, logging, monitoring, and orchestration.
• Perform complex data transformations, cleansing, enrichment, and data quality implementations using SQL, Python, and ETL tools.
• Develop and maintain data integration processes across heterogeneous sources, including relational databases, flat files, APIs, cloud storage, and SaaS platforms.
• Implement robust error handling, audit logging, restartability, and performance tuning capabilities within ETL workflows.
• Collaborate with business analysts, architects, data modelers, and stakeholders to translate business requirements into scalable technical solutions.
• Support production deployments, incident management, root cause analysis, and continuous performance improvements.
• Participate in code reviews, design reviews, and the establishment of ETL/data engineering best practices and standards.
• Work with enterprise scheduling and orchestration tools such as Control-M, Autosys, SQL Agent, Informatica Scheduler, or equivalent platforms.
• Create and maintain technical documentation, operational runbooks, and knowledge-sharing artifacts.

Skills

• SSIS Development and Administration
• Informatica PowerCenter
• Informatica IDMC / IICS (CDI, CAI, Mass Ingestion, Data Quality)
• Advanced SQL (SQL Server, Oracle)
• Python (Pandas, PySpark, Automation Frameworks)
• ETL/ELT pipelines
• Data ingestion, validation, reconciliation, logging, monitoring, and orchestration
• Control-M
• Autosys