Senior SQL Developer - SSIS

Key Skills

Oracle, SQL, Azure, SQL Server, Machine learning techniques, Writing, Cybersecurity, ETL frameworks, Effective communication skills, Data Warehousing

Job Description

Identity and Access Management's (IAM) vision is to provide Wells Fargo world leading cyber security risk management. Through a framework that addresses policy, process, operations, people, and technology, Information & Cyber Security (ICS) protects Wells Fargo’s infrastructure, corporate data, and customer assets, and ensures alignment with applicable regulations and laws. ICS is part of Wells Fargo's Technology organization and is led by the Chief Cybersecurity Officer.

About the Role:

We are looking for a Senior Software Engineer to assist with our data driven, machine learning automation efforts for the Identity and access management processes. This person will perform Data Engineering activities including but not limited to the capture of key data and the development and automation of said data for automated intelligence for business processes. Prefer a candidate that has extensive knowledge in data lakes, data warehousing, data modeling and data integration for automating of analytics integration within business processes. Should have knowledge with various Identity and access data elements and various IAM functions. 

This position will support the IAM Organization in data process and engineering within the Cybersecurity (ICS) and IAM organizations for information needs.

Work Shift:

• 30PM to 10.30PM (There is possibility of change in future to India regular work timings)

Responsibilities:

• Designs, documents, tests, maintains, and provides issue resolution recommendations for moderately complex security.
• Provides security consulting on medium projects for internal clients to ensure conformity with corporate Cybersecurity policy, and standards.
• Possesses subject matter expertise in industry leading security solutions and best practices used to implement one or more components of Cybersecurity such as availability, integrity, confidentiality, risk management, access management, and business continuity. May interface with senior management.
• Deliver data process consistency across Wells Fargo EIT supporting Access Management initiatives.
• Works with a variety of complex applications and/or application initiatives.
• Utilizes an understanding of data and data design to provide solutions enabling the business.
• Build & maintain the Data Engineering and design for the automation of IAM data capture and machine-driven analytics
• Perform regression activity for the Product development deliverables and provide necessary evidence to signoff for Production deployment of Agile Releases.
• Perform & Validate New development/Enhancement/Defect Fixes related to Data processing of multiple IAM Subject Areas.
• Build and maintain strong relationships within a variety of teams throughout the organization.

Assist with building sustainment reports to monitor EAM compliance with policies.

Successful candidate will work closely with the various stakeholders within IAM, Cybersecurity Management, Risk, and with business lines and technology leadership across the enterprise in the execution of the WF strategies/objectives. Accordingly, critical success factors will include the ability to effectively engage in a matrixed organization, develop partnerships with many business and functional areas, and have a strong operational and delivery focus. Accordingly, critical success factors will include the ability to effectively engage in a matrixed organization, develop partnerships with many business and functional areas, and have a strong operational and delivery focus

Essential Qualifications:

• Bachelors or Master’s degree in technology / Engineering
• Overall 9+ years of information technology applications and systems experience
• 9+ years of hands-on development experience in Microsoft T-SQL and ETL SSIS.
• 7+ years of experience with Data warehouse and/or data mart design.
• 7+ years of experience with scheduling tools such as NDM, Autosys, SSIS, etc.
• 7+ years of experience working with a variety of data sources including SQL, MS SQL Server, Oracle, and various Data Marts.
• Expert analytical skills with a keen ability to see how to translate needs of the teams into tangible deliverables.
• High level understanding of various development data technologies and development environments.
• Desired Qualifications:
• Excellent communication skills and ability to articulate complex material to a diverse audience.
• Strong customer relationship management skills.
• Excellent verbal, written, and interpersonal communication skills.
• Processing Cloud Certification, preferably Azure.
• Experience with one or more IAM technologies (Access provisioning, identity data management, access review/certification, Authentication and Authorization).
• Ability to transform conceptual design to technical implementation.
• Ability to identify challenges, anticipate obstacles, influence and resolve issues.
• Excellent documentation and communication skills (written and spoken) including Senior Management.

Posting End Date:

24 Mar 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.