Market Job Description
Branch / ATM Technology team part of Wells Fargo Enterprise Information technology is looking for experienced ETL ( Ab Initio ) developers to help us build and enhance our line of business data capabilities and create a competitive advantage.
Below given is an overview of the position requirements and the qualifications.
Design, develop, review and test ETL processes consistent with application architecture and security guidelines using Ab Initio / DataStage ETL tool to support Business Analytics
Analyze business requirements as they relate to the ETL or EDQ processes
Schedule, compile, and run Ab Initio jobs efficiently; Create reusable objects and job templates with understanding of clustering architecture and parallel jobs
Provide technical assistance to team and evaluate code for quality and performance
Monitor current design, architecture, daily loads; analyze performance and recommend changes as needed
Deliver data analysis reports that clearly articulate data accuracy and completeness results.
Mentor junior developers on best practices and standards, manage their tasks / assignments and work closely with business and other technical teams
Proven experience with Ab Initio including admin and development (all components and stages)
Most recent experience in leading a team of DataStage developers
Proven ability to develop, debug, maintain, optimize, support, and test all ETL designs and code
Deep understanding of ETL methodologies, Business Intelligence and Data Warehousing principles, approaches, technologies, and architectures including the concepts, designs and usage of data warehouses and data marts
Expert level knowledge in Data Warehouse development, perform root cause analysis, monitor jobs for performance issues and troubleshoot
Demonstrated experience in ETL design and options to improve load and extract performance
Experience creating data warehouse documentation including, but not limited to requirements, technical specifications, and source to target mappings
Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amount of information with attention to detail and accuracy
Prior experience in Linux scripting; Understand and aid in database performance tuning efforts, utilize Oracle analytic functions
Experience in Data modelling and design, Scheduling Tools, BI Reporting and Visualization tools
Experience in Talend is an advantage