Charlotte, North Carolina

About this role:

ETL Software Developer will be responsible for executing against the Compliance Risk Technology Strategic plan through development of the reporting platform. The success of the role will require focusing on development and working with other developers to effectively deliver software solutions that meet business requirements. The reporting database will house data from a variety of data sources transformation through SSIS/Informatica /Ab Initio and that will make it conducive to using business intelligence tools like Tableau, SSRS, Qlik, Cognos, etc, that will allow Compliance to pull together information that will aid them in their policy and decision making processes.

In this role, you will:

  • Act as senior developer working with other developers, BA and QA staff in programming, development, testing, and implementation process
  • Create thorough designs - taking care to assure that designs integrate well into existing architecture.
  • Analyze highly complex business requirements, designs and write technical specifications
  • Collaborate across teams, including global teams, to create high quality solution designs.
  • Design, develop, test, and deploy data integration initiative. As a senior Developer, perform Design & Code reviews and process optimization.
  • Provides design and development support for analytical systems and data integration applications
  • Contributes in analyzing complex requirements and translates to technical design and specifications
  • Design, development, test, and implement application ETL (Extract, Transform and Load) code
  • Utilize a thorough understanding of available technology, tools, and existing designs to source, map, extract and load large volumes of data.
  • Work on complex problems where analysis of data requires a solid grasp of compliance, regulatory and technology risk domains.

Required Qualifications, US:

  • 4+ years of Software Engineering experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education
  • 4 + years of experience writing relational database queries for stored procedures, query optimization and performance tuning
  • 4 + years of SQL experience - ETL Tools such as SSIS/Informatica/Ab Initio.
  • 4+ years of experience delivering ETL, data warehouse and data analytics capabilities on big-data architecture such as Hadoop
  • 4+ years of experience with scripting languages such as Bash, PowerShell, Python, Shell, VBScript, or JavaScript
  • 2 + years of experience working with large data sets
  • 2+ years of experience creating visual reports with one or combination of the following: SSRS, Tableau, or Power BI

Desired Qualifications:

  • SQL Server Integration Services (SSIS) experience
  • Knowledge and understanding of data modeling tools, such as Power Designer
  • Knowledge and understanding of data dimensional modeling
  • 4+ years of experience with source coding in one or a combination of the following: GitHub, SVN(Subversion), TFVC (Team Foundation Version Control) or TFSGit (Team Foundation Server)
  • Basic Microsoft Visio skills
  • Experience with Spark, Hive and Kafka
  • BS/BA degree or higher in information technology
  • An industry-standard technology certification
  • Ability to communicate effectively with a quantitative development team about models and integration strategies
  • Ability to dissect technical problems, analyze data, and recommend potential solutions


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, or status as a protected veteran.

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.

Charlotte, North Carolina

At Wells Fargo, we’ve been proudly supporting military veterans and their families for more than 170 years.

We value the leadership, discipline, and skills you’ve gained through your service to our country and recognize the contributions our veteran team members bring to the table. We’re committed to hiring and retaining military veterans, veterans with disabilities, National Guard, Reservists, and Military Spouses.

As a Wells Fargo employee, you’ll find a work culture that is team-oriented, collaborative, structured, and challenging. We support veterans transitioning from military service with a variety of job options, confidential resources, educational information, and career guidance. You may choose to join our Veteran’s Connection Employee Resource Group, a group of thousands who share an interest in veterans’ matters, and that promotes greater awareness and job development within the veteran community. To learn more about opportunities at our company, please visit Let’s talk about turning your military experience into a great civilian career.

Similar jobs