Software Engineer - Hyderabad / Secunderabad @ Wells Fargo

About Role
this is senior SSIS ETL developer role, which will involve Design, develop, implement and maintain of ETL solution. This position also responsible for production support, analyzing, troubleshooting, and resolving Production job failures . Responsibilities

• Good understanding of various Data Domains and particularly in IT Data Domain, which includes knowledge on Enterprise CMDB, IT Asset Management Practices, ITIL process etc.
• Working with stakeholders to help refine requirements and develop to those requirements
• Design, develop, test, document, and deploy high quality integration solutions using SSIS based on industry best practices as well as business needs
• Communicate and collaborate with other technical resources and stakeholders regarding status, technical issues and creative solutions
• Interface with business analysts and technical staff and be responsible for delivering complete work products
• Primary production support for ETL jobs

• 7 Years of Total IT Experience
• Strong in SQL queries, stored procedures, functions and performance tuning.
• Experience in databases development using MS SQL Server, Teradata, Oracle
• Hands-on experience and implementation knowledge on ADIF / EXPAND / Reports. / Administrator
• Good knowledge on XML/HTML5
• Design and Develop SSIS ETL to handle complex business rules while balancing the fulfillment of stringent performance requirements
• Leading the ETL design of prototypes and determining final design to ensure client satisfaction with product.
• Data processing capabilities to automate data extraction, load and computations via SSIS PKG
• Data Validation processes to ensure data integrity, consistency, and quality..
• Define and implement SDLC, CI/CD and automated testing process for ETL and data processing work.
• Challenging Support Role in L2 & L3 involving Production Support, Root Cause Analysis, Automation, Solution Proposals along with BAU Support
• Production & Platform support involves being on standby for providing 24x7 support & Responsible to maintain high availability of the systems & applications
• Responsible for Change & Release Management & Be a gate keeper for making sure no releases issues by efficient review
• Support the most complex technical issues & initiatives (Upgrade/Tech Refresh)
• Good knowledge on PAC2000,Autosys,TFS
• Good to have IT asset management functional knowledge
• Effective verbal, written, and interpersonal communication skills