Senior Data Integration Software Engineer

About this role: Wells Fargo is seeking a Senior Software Engineer in Technology as part of the Wealth Investment Management Technology (WIMT) engineering and transformation office. Learn more about the career areas and lines of business at wellsfargojobs.com. The WIM Client Relationship Management (WIM Salesforce CEM) data integration focuses on creating the CRM database and integrating data from multiple sources to be used mostly by Salesforce platform hosted in Salesforce cloud. It encompasses components of the Financial Advisors need to interact with their clients. The major functions Salesforce will serve are Practice Management, Clients and Prospects, and Book Analyzer. Various users within WIM will use the platform and represent Front Office (Sales), Middle Office (Service), and Back Office (Operations). In this role, you will: 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 Reacting and resolving production support issues on multiple ETL processes/cycles/environments as needed. Provide on-call support duties for Informatica Production Support, including off hours and weekends. Keep the Production Support team management informed of any issues or concerns. 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 3 years of demonstrated experience with the Informatica suite of products. 3 year of SQL development experience in Oracle 11g or Higher database environments. 3 years of Data Modeling experience using data modeling tools. 3 years of experience in Cloud Technologies 3 years of experience in Salesforce CRM data Integration development using Informatica suite of products. 2 years of experience in Tableau dashboard development or reporting tools like OBIEE. Desired Qualifications: 3 years of experience in development, maintenance, and enhancement of Informatica Mappings, Workflows, and processes. 3 years of Experience in Oracle Performance Tuning. 3 years of Unix Shell scripting. Experience in data warehouse and data mart environments. Several years of experience building and implementing scalable, reliable, and high-performance ETL architectures Ability to architect an ETL solution and data conversion strategy. Proficiency with RDBMS systems, SQL, Oracle PL/SQL, UNIX Shell scripting, and database optimizations Familiarity with database analysis, design, and programming, with an understanding of related technologies (i.e. Java, XML, web services, XSLT, SOAP, WSDL, etc.) Proficiency with job scheduling tools such as Autosys, Unix CRON, TIDAL, Control-M etc. Financial Services Experience Job Expectations: Ideal candidate will be an individual who takes ownership of a process, accountable for its day-to-day activities, able to work independently or as part of a team, and seeks to work on a diverse range of programming languages and technologies. Flexibility to work in a 24/7 environment. Position will require onsite presence at one of the available locations listed below. Or Ability to work on-site at posted location Posting End Date: 19 May 2024 *Job posting may come down early due to volume of applicants. We Value Diversity At Wells Fargo, we believe in diversity, equity and inclusion in the workplace; accordingly, we welcome applications for employment from all qualified candidates, regardless of race, color, gender, national origin, religion, age, sexual orientation, gender identity, gender expression, genetic information, individuals with disabilities, pregnancy, marital status, status as a protected veteran or any other status protected by applicable law. Employees support our focus on building strong customer relationships balanced with a strong risk mitigating and compliance-driven culture which firmly establishes those disciplines as critical to the success of our customers and company. They are accountable for execution of all applicable risk programs (Credit, Market, Financial Crimes, Operational, Regulatory Compliance), which includes effectively following and adhering to applicable Wells Fargo policies and procedures, appropriately fulfilling risk and compliance obligations, timely and effective escalation and remediation of issues, and making sound risk decisions. There is emphasis on proactive monitoring, governance, risk identification and escalation, as well as making sound risk decisions commensurate with the business unit’s risk appetite and all risk and compliance program requirements. Candidates applying to job openings posted in US: All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other legally protected characteristic. Candidates applying to job openings posted in Canada: Applications for employment are encouraged from all qualified candidates, including women, persons with disabilities, aboriginal peoples and visible minorities. Accommodation for applicants with disabilities is available upon request in connection with the recruitment process. Applicants with Disabilities To request a medical accommodation during the application or interview process, visit Disability Inclusion at Wells Fargo. Drug and Alcohol Policy Wells Fargo maintains a drug free workplace. Please see our Drug and Alcohol Policy to learn more. Wells Fargo & Company (NYSE: WFC) is a leading financial services company that has approximately $1.9 trillion in assets. We provide a diversified set of banking, investment and mortgage products and services, as well as consumer and commercial finance, through our four reportable operating segments: Consumer Banking and Lending, Commercial Banking, Corporate and Investment Banking, and Wealth & Investment Management. Wells Fargo ranked No. 47 on Fortune’s 2023 rankings of America’s largest corporations. In the communities we serve, the company focuses its social impact on building a sustainable, inclusive future for all by supporting housing affordability, small business growth, financial health, and a low-carbon economy News, insights, and perspectives from Wells Fargo are also available at Wells Fargo Stories. Additional information may be found at www.wellsfargo.com LinkedIn: https://www.linkedin.com/company/wellsfargo For questions on how to search and apply, visit our frequently asked questions.