Specialty Software Engineer

Job Descriptions

In this contingent resource assignment, you may: Consult on or participate in moderately complex initiatives and deliverables within Specialty Software Engineering and contribute to large-scale planning related to Specialty Software Engineering deliverables. 
Review and analyze moderately complex Specialty Software Engineering challenges that require an in-depth evaluation of variable factors. 
Contribute to the resolution of moderately complex issues and consult with others to meet Specialty Software Engineering deliverables while leveraging solid understanding of the function, policies, procedures, and compliance requirements. 
Collaborate with client personnel in Specialty Software Engineering.

Required Qualifications

8+ years of Specialty Software Engineering experience, or equivalent demonstrated through one or a combination of the following: work or consulting experience, training, military experience, education. 
The Enterprise Functions Technology (EFT) group provides technology solutions and support for Risk, Audit, Finance, Marketing, Human Resources, Corporate Properties, and Stakeholder Relations business lines. In addition, EFT provides unique technology solutions and innovation for Wells Fargo Technology, Enterprise Shared Services, and Enterprise Data Management. This combined portfolio of applications and tools are continually engineered to meet the challenges of stability, security, scalability, and speed. 
Within EFT the Corporate Risk Technology group helps all Wells Fargo businesses identify and manage risk. We focus on three key risk areas: credit risk, operational risk and market risk. We help our management and Board of Directors identify and monitor risks that may affect multiple lines of business, and take appropriate action when business activities exceed the risk tolerance of the company. 
We are seeking a Senior Data Integration Developer to be part of a team that provides reporting data warehouse solutions for Risk and Compliance across all levels of the organization. This position will use their strong understanding of data management, how to design and build dimensional data models, and overall delivery of data integration solutions. This position will partner with Data Modelers, report developers, and Business Intelligence Analysts to design/develop/deploy information solutions in the enterprise risk domain.

Role

In this role, you will:

Work closely with Data Modelers to structure data requirements into a data warehouse model for reporting and analytics 
Design, develop and debug ETL integration code to meet defined source to target mappings 
Handle complex ETL requirements and design 
Work with Business Stakeholders to build database objects to meet desired output 
Build, maintain and govern the Hadoop data layer to ensure data consistency and single version of the truth 
Complete Unit Testing to ensure low probability of defects and that data matches with back-end systems 
Ensure solutions are highly usable, scalable, and maintainable 
Understand the impacts of data layer performance factors and collaborate with the Data Architect to implement mitigating physical modeling solutions 
Perform code and design reviews to ensure performance, maintainability, and standards 
Work with the Data Architect to define data security roles, groups and policies 
Enforce Hadoop design standards, reusable objects, tools, best practices, and related development methodologies for the organization 
Partnering with Business Stakeholders and developers to ensure deliverables meet business expectations 
Suggest solutions for development or process improvement 
Tuning of dataset design for optimal performance 
Develop, execute, and troubleshooting of complex report SQL 
Must be comfortable working on multiple, complex issues and projects.

Required Qualifications, US

7+ years of Software Engineering experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education 
5+ years of ETL (Extract, Transform, Load) Programming experience 
3+ years of experience designing and optimizing complex SQL queries involving table joins and correlated sub-queries on large scale data tables 
3+ years of experience writing SQL relational database queries, stored procedures, query optimization and performance tuning 
3+ years of experience with databases such as Oracle, DB2, SQL Server, or Teradata 
2+ years of Hadoop / Big Data development experience

Desired Qualifications

An industry-standard technology certification 
Strong verbal, written, and interpersonal communication skills 
A BS/BA degree or higher in science or technology 
Knowledge and understanding of software development life cycle (SDLC): all phases and types of testing 
Ability to work effectively in virtual environment where key team members and partners are in various time zones and locations 
MS SQL server experience 
Knowledge and understanding of Selenium software testing framework 
2+ years of experience with Talend ETL development. 
Knowledge and understanding of GitHub