Senior SSIS ETL Developer (Apps Systems Engineer 5)

Wells Fargo   •  

Concord, NC

Industry: Financial Services


8 - 10 years

Posted 333 days ago


Job Description

We have an excellent opportunity for a senior SSIS ETL Developer to provide ETL design and development guidance and consultation, utilizing a thorough understanding of applicable technology, patterns and tools. Analyzes highly complex business requirements, designs and writes technical specifications to design or redesign complex computer platforms and applications. Provides coding direction to less experienced staff or develops highly complex original code. Acts as an expert technical resource for modeling, simulation and analysis efforts. Verifies program logic by overseeing the preparation of test data, testing and debugging of programs. Oversees overall systems testing and the migration of platforms and applications to production. Develops new documentation, departmental technical procedures and user guides. Leads projects, allocates and manages resources and manages the work of less experienced staff. Assures quality, security and compliance requirements are met for supported area and oversees creation of or updates to and testing of the business continuation plan.

Specific responsibilities include but not limited to:

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 initiatives

May act as a lead Developer

Perform Design & Code reviews and process optimization

Create Code Check Lists, DBA Check lists, Installation game plans, and other required process documentation for production deployments

Migrate the code through various environments and verify the migration

Effectively communicate to broad and diverse audience with differing needs

Analyze production issues and defects to determine root cause and resolution

Provide required support throughout the project development life cycle and post deployment activities

Provide training, guidance, and mentorship to less experienced team members

Participate in developer on-call rotation as needed





Required Qualifications

  • 7+ years of application development and implementation experience
  • 7+ years of SQL Server Integration Services (SSIS) experience
  • 4+ years of Autosys experience
  • 5+ years of MS SQL server experience
  • 4+ years of data modeling experience

Desired Qualifications

  • Good verbal, written, and interpersonal communication skills

Other Desired Qualifications

  • Must have experience with design/development of enterprise level multi-tier systems for a high volume transactional and analytical databases
  • Hands on experience as a SQL Server DB Developer with strong RDBMS architectural fundamentals - SQL Server
  • Proven ETL development and production experience  in Data warehouse or Data Mart or Master Data Management environments
  • Ability to interact effectively with a variety of contacts including technical and business team members
  • Ability to work effectively in a virtual team environment
  • Strong and effective interpersonal communication (written and oral), organizational, and customer service skills
  • Strong verbal and written communications skills
  • Proven success in problem analysis and resolution
  • Strong attention to detail and accuracy
  • BS/BA relevant business/technology degree

Job Expectations

  • Ability to travel up to 10% of the time
  • Ability to work nights, weekends, and/or holidays as needed or scheduled