ETL Architect

2 days ago


Pittsburgh, United States EvonSys Full time

Job Title: ETL Architect

Location: Pittsburgh

Employment Type: Full-Time

Job Summary

We are seeking an experienced ETL Architect to design, implement, and manage ETL solutions that ensure seamless data integration across enterprise systems. The ideal candidate will have a strong technical background, a deep understanding of data management principles, and expertise in transforming complex business requirements into scalable ETL frameworks.


Key Responsibilities

  1. Architecture Design:
  • Develop and document scalable ETL architectures for data integration and transformation processes.
  • Design data flow processes that align with enterprise data strategy and business needs.
  1. ETL Development:
  • Build, test, and optimize ETL processes using tools such as Informatica, Talend, Apache NiFi, Microsoft SSIS, or equivalent.
  • Implement robust error handling, logging, and performance monitoring mechanisms.
  1. Data Integration:
  • Collaborate with data analysts, data scientists, and business stakeholders to understand data requirements.
  • Integrate data from various sources, including on-premises databases, cloud platforms, and third-party APIs.
  1. Performance Optimization:
  • Monitor and enhance ETL performance to meet SLAs and handle large datasets efficiently.
  • Troubleshoot bottlenecks and resolve issues in data workflows.
  1. Governance and Standards:
  • Ensure compliance with data governance policies, security standards, and regulatory requirements.
  • Establish best practices and documentation for ETL processes.
  1. Team Collaboration:
  • Provide technical guidance to ETL developers and other team members.
  • Act as a subject matter expert in ETL architecture and data integration technologies.


Qualifications and Skills

Required:

  • Bachelor's or Master’s degree in Computer Science, Information Technology, or a related field.
  • Proven experience as an ETL Architect or similar role.
  • Expertise Informatica 10.5, ,UNIX, Mainframe Scheduling, DB View creation, Stored Procedures & DB Tuning.
  • Strong knowledge of SQL, database systems (e.g., Oracle, SQL Server, PostgreSQL), and data modeling.
  • Proficiency in programming or scripting languages (e.g., Python, Java, Shell scripting).
  • Experience with cloud platforms (AWS, Azure, GCP) and associated data services (e.g., AWS Glue, Azure Data Factory).
  • Familiarity with Big Data frameworks (e.g., Hadoop, Spark) is a plus.
  • Solid understanding of data warehousing, data lakes, and real-time data processing.


Preferred:

  • Certification in ETL tools or cloud data services.
  • Experience with Agile/Scrum methodologies.
  • Strong problem-solving and analytical skills.


Key Competencies

  • Strong communication and interpersonal skills.
  • Ability to handle multiple priorities in a fast-paced environment.
  • Detail-oriented with a focus on data accuracy and quality.
  • Team leadership and mentoring capabilities.


Benefits

  • Competitive salary and performance-based incentives
  • Comprehensive health and wellness benefits
  • Opportunities for career development and growth
  • Access to the latest technologies and resources for continued professional development



  • Pittsburgh, United States Mastech Digital Full time

    Your future duties and responsibilities• Lead the design, development, and implementation of ETL processes using Informatica PowerCenter and related technologies.• Collaborate with business stakeholders, data architects, and analysts to understand data requirements and translate them into effective ETL solutions.• Manage a team of ETL developers,...

  • ETL Lead

    2 months ago


    Pittsburgh, United States Mastech Digital Full time

    Role: ETL Informatica Lead Location: Pittsburgh, PA (Hybrid) Job type: Full time/ Permanent role Responsibilities: Lead the design, development, and implementation of ETL processes using Informatica PowerCenter and related technologies. Collaborate with business stakeholders, data architects, and analysts to understand data requirements and translate them...

  • ETL Lead

    1 month ago


    pittsburgh, United States Mastech Digital Full time

    Role: ETL Informatica Lead Location: Pittsburgh, PA (Hybrid) Job type: Full time/ Permanent role Responsibilities: Lead the design, development, and implementation of ETL processes using Informatica PowerCenter and related technologies. Collaborate with business stakeholders, data architects, and analysts to understand data requirements and translate them...

  • ETL Lead

    1 month ago


    Pittsburgh, United States Mastech Digital Full time

    Role: ETL Informatica Lead Location: Pittsburgh, PA (Hybrid) Job type: Full time/ Permanent role Responsibilities: Lead the design, development, and implementation of ETL processes using Informatica PowerCenter and related technologies. Collaborate with business stakeholders, data architects, and analysts to understand data requirements and translate them...


  • pittsburgh, United States Mastech Digital Full time

    Your future duties and responsibilities• Lead the design, development, and implementation of ETL processes using Informatica PowerCenter and related technologies.• Collaborate with business stakeholders, data architects, and analysts to understand data requirements and translate them into effective ETL solutions.• Manage a team of ETL developers,...

  • Data Architect

    2 days ago


    Pittsburgh, United States Virtusa Full time

    Position : Data ArchitectLocation : Lake Mary, FL/Pittsburgh, PAJob Description:Highly skilled Architect & Data Engineer with 8.6 years of hands-on experience in the development and optimization of data architectures, ETL processes, and data warehousing solutionsHands on experience on a Trade Surveillance project with a large UK bankRe-engineered &...

  • Solutions Architect

    4 months ago


    Pittsburgh, United States Saxon Global Full time

    Our client is looking for a Solutions Architect who will be responsible for key deliverables in the financial crimes and compliance space. The ideal candidate will be responsible for implementing solutions, analyzing requirements for current and new software, migrating data from legacy systems, reporting/analytics, and business process optimization....

  • Solutions Architect

    4 weeks ago


    Pittsburgh, United States Saxon Global Full time

    Our client is looking for a Solutions Architect who will be responsible for key deliverables in the financial crimes and compliance space. The ideal candidate will be responsible for implementing solutions, analyzing requirements for current and new software, migrating data from legacy systems, reporting/analytics, and business process optimization....

  • Data Architect

    3 weeks ago


    Pittsburgh, Pennsylvania, United States Whitman Requardt and Associates Full time

    Job Title: Data ArchitectAt Whitman, Requardt & Associates, LLP: We are a team of professionals who are "People Focused and Project Driven". Our company has been in business for over 105 years and is known for its quality work and employees. We are currently seeking a talented Data Architect to join our growing team.Design and implement scalable data...


  • Pittsburgh, Pennsylvania, United States Saxon Global Full time

    About the Role:Saxon Global is seeking a seasoned Solutions Architect to lead our efforts in designing and implementing solutions for clients in the financial crimes and compliance space. This is an excellent opportunity for a talented professional to make a significant impact on our organization's growth and success.As a Solutions Architect, you will be...

  • Cloud Administrator

    2 months ago


    pittsburgh, United States Tata Consultancy Services Full time

    Experience Required6+ years of experience in SnowflakeExperience as a Snowflake Administrator or similar role, with hands-on expertise in managing Snowflake environmentsRoles & ResponsibilitiesArchitecting, developing, and deploying scalable enterprise data solutions.Architect scalable Snowflake data warehouse solutions.Develop complex SQL queries for...

  • Cloud Administrator

    2 months ago


    pittsburgh, United States Tata Consultancy Services Full time

    Experience Required6+ years of experience in SnowflakeExperience as a Snowflake Administrator or similar role, with hands-on expertise in managing Snowflake environmentsRoles & ResponsibilitiesArchitecting, developing, and deploying scalable enterprise data solutions.Architect scalable Snowflake data warehouse solutions.Develop complex SQL queries for...

  • Cloud Administrator

    2 months ago


    Pittsburgh, United States Tata Consultancy Services Full time

    Experience Required6+ years of experience in SnowflakeExperience as a Snowflake Administrator or similar role, with hands-on expertise in managing Snowflake environmentsRoles & ResponsibilitiesArchitecting, developing, and deploying scalable enterprise data solutions.Architect scalable Snowflake data warehouse solutions.Develop complex SQL queries for...


  • Pittsburgh, United States First National Bank of Pennsylvania Full time

    Primary Office Location:30 Isabella Street. Pittsburgh, Pennsylvania. 15212.Join our team. Make a difference - for us and for your future.FNB is looking for a Lead Developer to assist with data-drivenapplications. The Lead Developer will design ETL flows and mentor other developers on ETL Development. The lead will also assist with designing Data Marts and...

  • Snowflake Cloud Admin

    2 weeks ago


    Pittsburgh, United States VMC Soft Technologies, Inc Full time

    FULLTIME POSITIONTitle: Snowflake Cloud AdminLocation: Pittsburgh, PAExperience as a Snowflake Administrator or similar role, with hands-on expertise in managing Snowflake environments.Strong knowledge of Azure and AWS cloud services, including Azure Data Factory, AWS Glue, Azure/AWS Storage, and Azure/AWS Virtual Networks.Proficiency in SQL and experience...


  • Pittsburgh, Pennsylvania, United States Saxon Global Full time

    Job Description:Saxon Global is seeking a skilled Solutions Architect to join our team. As a key member of our organization, you will be responsible for implementing solutions that meet the needs of our clients in the financial crimes and compliance space.We are looking for an experienced professional with 7-10+ years of related experience in the financial...


  • Pittsburgh, Pennsylvania, United States Pittsburgh Regional Transit Full time

    Pittsburgh Regional Transit is currently seeking a skilled Database Administrator to oversee the development, implementation, and maintenance of its database systems.Key Responsibilities:Design and implement efficient database architectures to support the organization's data management needs.Develop and maintain database applications, ensuring data...

  • Snowflake Cloud Admin

    2 weeks ago


    Pittsburgh, United States PeopleLogic Full time

    We are seeking an experienced and outstanding for one of our esteemed Clients. Kindly have a look at the below JD and reach us with your updated & best time to connect.Role: Snowflake Cloud AdminLocation: Pittsburgh, PADuration: Full-timeJob DescriptionSkill: Snowflake Cloud AdminExperience as a Snowflake Administrator or similar role, with hands-on...

  • Snowflake Admin

    4 weeks ago


    Pittsburgh, United States SysMind Tech Full time

    Snowflake Admin 3+ years of experience in Snowflake, DBT, Airflow. Must have experience in Python and Data Modeling. Strong knowledge in implementing Snowpipes, building DATA pipeline (ELT). Strong in writing complex SnowSQL, Stored Procedures. Good understanding of UNIX/LINUX environment. Experience in building cloud native solutions, preferably on Azure...


  • Pittsburgh, Pennsylvania, United States TruSummit Solutions, LLC Full time

    Join TruSummit Solutions, LLC and embark on a rewarding career as a Salesforce Solutions Consultant. In this role, you will have the opportunity to work with a young, energetic, and fast-growing company that empowers and educates its clients on the value and capabilities of Enterprise Applications.Company OverviewTruSummit Solutions, LLC is a women-owned and...