ETL Developer

2 weeks ago

Phoenix, United States Western Alliance Bank Full time
Job Title:
ETL Developer

Location:
Block 23

What you'll do:
Western Alliance Bank is seeking passionate, results-driven SQL/ETL developer to deliver innovative, industry leading solutions. We want a creative, highly-motivated developer who can take initiative, have good sense of urgency and is comfortable working in a fast paced, agile environment.

What we are looking for:

Responsibilities

Key responsibilities shall include but not be limited to:
  • Responsible for the design, development and deployment of data extracts, transformations or loads, supporting the ingestion and transformation of data as needed using Azure Data Factory and SSIS packages.
  • Provide database administration support for on-perm and cloud databases
  • Work with different teams to understand complex business logic and design ETL process.
  • Design and develop data warehouse ETL processes in SSIS & SQL stored procedures
  • Analyze business user requirement, Asses different source data of banking applications and design data flow to implement ETL process using Microsoft SSIS tool.
  • Develop reports using SSRS & SQL stored procedures
  • Analyze and provide suggestions to tune database stored procedures to ensure optimal performance
  • Troubleshoot and fine tune database configurations, ETL processes and SQL code for optimal performance.
  • Set and Maintain database standards
  • Recommend and Implement emerging database solutions.
  • Contribute to continuous improvements of the existing applications
  • Conduct code reviews
  • Develop SQL server stored procedure to implement business logic.
  • Follow Banks processes and procedures for each development cycle.
  • Maintain Documentation patterns for all the applications.
  • Adhere to all data security and integrity policies
  • Actively participate in all aspects of the software engineering process.
  • Efficiently work in Agile environment
Job Requirements
  • Must have 7+ years of solid Experience in SQL development.
  • Must have 7+ years hands on experience in ETL design and development using any Microsoft SQL server ETL tools or Informatica
  • Must have 5+ years in database administration
  • 4+ years' experience in Azure data factory
  • Good understanding of data cleansing, normalization, standardization, enrichment, fuzzy match techniques and data governance concepts
  • Excellent troubleshooting and problem-solving skills
  • Outstanding SQL and data analysis skills
  • Experience in analyzing and building reports/dashboards using BI reporting tools such a Tableau
  • Experience in BI development, database development and SQL Database.
  • Good understanding with development life cycle, data architect and related methodologies


Benefits you'll love:
We offer all the important things you'd want - like competitive salaries, an ownership stake in the company, medical and dental insurance, time off, a great 401k matching program, tuition assistance program, an employee volunteer program, and a wellness program. In addition, you'll have the opportunity to bolster your business knowledge, learning the ins and outs of how successful companies operate and manage their finances, giving you invaluable hands-on experience to help grow your career

About the company:

Western Alliance Bank is a wholly owned subsidiary of Western Alliance Bancorporation. Alliance Bank of Arizona, Alliance Association Bank, Bank of Nevada, Bridge Bank, First Independent Bank, and Torrey Pines Bank are divisions of Western Alliance Bank; Member FDIC. AmeriHome Mortgage is a Western Alliance Bank company.

Western Alliance Bancorporation is committed to equal employment and will consider all qualified applicants without regard to race, sex, color, religion, age, nation origin, marital status, disability, protected veteran status, sexual orientation, gender identity or genetic information. Western Alliance Bancorporation is committed to working with and providing reasonable accommodations for individuals with disabilities. If you are an individual with a disability and require a reasonable accommodation to complete any part of the application process and/or need an alternative method of applying, please email HR[redacted] or call [redacted]. When contacting us, please provide your contact information and state the nature of your accessibility issue. We will only respond to inquiries concerning requests that involve a reasonable accommodation in the application process.

© Western Alliance Bancorporation

  • ETL Developer

    10 hours ago

    Phoenix, United States Omni Inclusive Full time

    Job Description: Design, develop, and maintain ETL processes using Informatica and Fivetran Create and optimize complex mappings, workflows, and sessions for data extraction, transformation, and loading Responsible for production support of big data platform and on-call Expertise in performance tuning of real-time, near-real-time or batch data integration...

  • ETL Informatica Developer

    3 days ago

    Phoenix, Arizona, United States Iconic Infosys, Inc Full time

    Job DescriptionAt Iconic Infosys, Inc, we are seeking a highly skilled ETL Informatica Developer to join our team. As a key member of our data integration team, you will be responsible for designing, developing, and maintaining complex ETL processes using Informatica and Fivetran.Data Extraction and Transformation: Design and develop ETL processes to...

  • Senior ETL Developer

    3 hours ago

    Phoenix, Arizona, United States ApTask Full time

    About the JobWe are seeking a highly skilled Senior ETL Developer to join our team at ApTask. As a Senior ETL Developer, you will be responsible for designing and implementing complex ETL interfaces using various ETL tools, including SAP BODS. Your expertise in ETL tools and experience in working with complex data sources and targets will be invaluable in...

  • ETL Developer I

    2 weeks ago

    Phoenix, United States Republic Services, Inc. Full time

    The ETL Developer/ Engineer I develops, configures, codes, tests, and debugs complex new software, enhancements to existing proprietary software or purchased software packages. In conjunction with functional users and IT Business Systems personnel, t Developer, Technical Support, Business Systems, IT, Database, Software

  • ETL Developer

    10 hours ago

    Phoenix, United States Diverse Lynx Full time

    JD: Informatica ETL data pipelines Snowflake, SQL Maintain current data integrations & build new ones General knowledge of Linux, Azure, Data Governance Knowledge of APIs & Python is a plus too Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination....

  • Data Developer | ETL

    1 week ago

    Phoenix, Arizona, United States Focused HR Solutions Full time

    About Focused HR Solutions Focused HR Solutions is a leading provider of innovative human resources solutions, dedicated to helping organizations optimize their workforce and achieve strategic goals. We are committed to fostering a collaborative and inclusive work environment where talent thrives. Data Developer | ETL & Reporting Specialist We are seeking a...

  • SAP BODS with Any ETL Tool Developer

    3 months ago

    Phoenix, United States ApTask Full time

    About Client: The Client is a leading global IT services and consulting company, providing a wide range of services to clients in various industries, including banking, financial services, retail, manufacturing, healthcare, and more. It is one of the largest employers in the IT industry and has a vast and diverse workforce. The company places a strong...

  • SAP BODS with Any ETL Tool Developer

    3 months ago

    Phoenix, United States ApTask Full time

    About Client: The Client is a leading global IT services and consulting company, providing a wide range of services to clients in various industries, including banking, financial services, retail, manufacturing, healthcare, and more. It is one of the largest employers in the IT industry and has a vast and diverse workforce. The company places a strong...

  • Lead ETL Developer

    9 hours ago

    Phoenix, United States ApTask Full time

    About Client: The Client is a leading global IT services and consulting company, providing a wide range of services to clients in various industries, including banking, financial services, retail, manufacturing, healthcare, and more. It is one of the largest employers in the IT industry and has a vast and diverse workforce. The company places a strong...

  • Data Integration Specialist

    5 days ago

    Phoenix, United States Noblesoft Technologies Full time

    Job DescriptionJob DescriptionData Integration Specialist (ETL/Informatica & Fivetran)Phoenix, AZ ( Onsite from day 1 )6 Months contract to hire role.Job Description:Design, develop, and maintain ETL processes using Informatica and FivetranCreate and optimize complex mappings, workflows, and sessions for data extraction, transformation, and...

  • ETL Lead

    9 hours ago

    Phoenix, United States ApTask Full time

    About Client: The Client is a leading global IT services and consulting company, providing a wide range of services to clients in various industries, including banking, financial services, retail, manufacturing, healthcare, and more. It is one of the largest employers in the IT industry and has a vast and diverse workforce. The company places a strong...

  • SAP BODS Developer

    1 week ago

    Phoenix, Arizona, United States ApTask Full time

    About ApTask:ApTask is a leading global workforce solutions and talent acquisition services provider, dedicated to shaping the future of work. With a focus on excellence and innovation, the company offers staffing, recruitment solutions, IT consulting, and project management services to a diverse range of industries.Job Summary:We are seeking an experienced...

  • Senior Oracle/Informatica Developer

    2 hours ago

    Phoenix, Arizona, United States Syntricate Technologies Full time

    Job SummaryWe are seeking a highly skilled Senior Oracle/Informatica Developer to join our team at Syntricate Technologies. As a key member of our data warehousing team, you will be responsible for designing and implementing data warehouse subject areas, developing high-performing ETL routines, and creating efficient PL/SQL code.Key ResponsibilitiesData...

  • Big Data Developer

    3 weeks ago

    Phoenix, United States CoreAi Consulting Full time

    Company DescriptionCoreAi Consulting in Phoenix, AZ, specializes in generative AI services designed to drive business advancements. Their GenAI solutions, powered by models like GPT and Llama, automate workflows for increased productivity and efficiency.Role DescriptionThis is a full-time on-site role for a Big Data Developer at CoreAi Consulting. The Big...

  • Big Data Developer

    3 weeks ago

    Phoenix, United States CoreAi Consulting Full time

    Company DescriptionCoreAi Consulting in Phoenix, AZ, specializes in generative AI services designed to drive business advancements. Their GenAI solutions, powered by models like GPT and Llama, automate workflows for increased productivity and efficiency.Role DescriptionThis is a full-time on-site role for a Big Data Developer at CoreAi Consulting. The Big...

  • Data Developer

    1 day ago

    Phoenix, Arizona, United States Focused HR Solutions Full time

    About the RoleFocused HR Solutions is seeking a skilled Data Developer to join our team. As a Data Developer, you will play a critical role in creating solutions using SSIS, SSRS, and T-SQL to support various business processes and reporting requirements.Key ResponsibilitiesDevelop ETL Solutions: Design, develop, and implement ETL solutions using SQL Server...

  • Microsoft SQL Developer

    2 weeks ago

    Phoenix, United States Saxon Global Full time

    Position: SQL developer Location: Tempe AZ (hybrid) Duration: Long term Job description - SQL - ETL - Power BI -integration and data modeling -joining/mapping two different data sets understanding (item and site) how to source the data

  • Data Developer 8-11

    2 weeks ago

    Phoenix, United States Focused HR Solutions Remote Work Freelance Full time $58 - $56

    The selected resource will be required to go onsite for the first day. Anyone submitted must be willing to go onsite. The position will primarily be worked remotely after that until the agency returns to working in the office. At that time the expectation is that they will work 100% in the office.  Our direct client has an opening for a Data Developer rec...

  • Big data developer

    4 weeks ago

    Phoenix, United States Centraprise Full time

    Big data developerPhoenix, AZ (Onsite Face to Face - Interview)Long Term ContractJob Description:We are seeking a skilled Big Data Developer with hands-on experience in Apache Spark and SQL. You will design and develop scalable data applications, optimize data pipelines, and work closely with teams to deliver data-driven solutions.Key...

  • SAP BODS with Informatica Power center experience

    3 weeks ago

    Phoenix, United States Smart IT Frame LLC Full time

    Role: SAP BODS with Informatica Power center experience Location: Phoenix, AZ (Day 1 Onsite)Duration: Long Term Job Description:Responsibilities:Design, develop, and implement complex ETL processes using SAP BODS and Informatica PowerCenter.Collaborate with business users and data analysts to understand data requirements and translate them into technical...