ETL Developer

1 week ago


Seattle, United States Petadata Full time
Job DescriptionJob Description

POSITION: ETL Developer (Must have a Matillion tool)

LOCATION: Seattle, WA (Onsite)

Experience: 10+ years

Work type: Fulltime (W2 / C2C)

PETADATA is currently looking to hire for the ETL / Spark Developer role for one of their clients.

Roles & Responsibilities:

  • Should have experience with both streaming and batch workflows will be essential in ensuring the efficient flow and processing of data to support our clients.

  • Collaborate with cross-functional teams to understand data requirements and design robust data architecture solutions.

  • Design, develop, and implement scalable data processing solutions using Apache Spark

  • Ability to organize and to keep the projects well-arranged and structured.

  • Ensure data quality, integrity, and consistency throughout the ETL pipeline.

  • Integrate data from different systems and sources to provide a unified view for analytical purposes.

  • Collaborate with data analysts to implement solutions that meet their data integration needs.

  • Design and implement streaming workflows using PySpark Streaming or other relevant technologies.

  • Develop batch processing workflows for large-scale data processing and analysis.

  • Analyze the business requirement to determine the volume of data extracted from different sources, data models, to ensure the quality of the data involved.

  • Should be able to figure out the best storage medium required for the data warehouse needed.

  • Identify the data storage needs to determine the amount of data to deal with the company's requirements.

  • Must ensure the data quality that everything is in place at the transformation stage to eliminate errors and fix unstructured and unorganized data extracted.

  • Responsible for ensuring that the data is loaded into the warehouse system and meets the business needs and standards.

  • Should be responsible for data flow validation, creating and building a secured database warehouse that meets a given company's needs and standards.

  • Must be responsible for determining the storage needs of a business and the volume of data involved.

Required skills:

  • Should have 10+ years of experience in implementing ETL processes to extract, transform, and load data from various sources to ensure data quality, integrity, and consistency throughout the ETL pipeline.

  • Must be expertise in Python, PySpark, ETL processes, CI/CD (Jenkins or GitHub).

  • Must have a Matillion tool.

  • Experienced in Python and PySpark to develop efficient data processing and analysis scripts.

  • Optimize code for performance and scalability, keeping up-to-date with the latest industry best practices.

  • Must load data and be proficient in valuable technical skills such as SQL, JAVA, XML, and DOM, among others.

  • Extensive knowledge and experience with Spark and its technologies.

  • Hands-on Experience with Apache Spark framework, including the Spark SQL module for querying databases.

  • Good knowledge on data analysis, design, and programming skills such as JavaScript, SQL and XML, and DOM.

  • Familiar with various coding languages used in web development, including HTML, CSS, JavaScript, Python, Java, Scala, or R proficiency.

  • Should have experience in writing clean code that's free of bugs and reproducible by other developers.

  • Experience in managing SQL databases and organizing big data.

  • Hands-on experience with ETL such as MS SQL, SSIS (Server Integration Services), Python / Perl, Oracle, SQL Server/ MySQL.

  • Solid understanding of Data warehousing schemes, Dimensional modeling, and implementing data storage solutions to support efficient data retrieval and analysis.

  • Must be an expert in debugging ETL processes, optimizing data flows, and ensuring that the data pipeline is robust and error-free.

  • Good knowledge of Verbal and communication skills.

Educational Qualification:

Bachelor's/ Master's degree in Computer Science, Engineering, or a related field.

We offer a professional work environment and are given every opportunity to grow in the Information technology world.

Note:

Candidates required to attend Phone/Video Call / In person interviews and after Selection of candidate (He/She) should go through all background checks on Education and Experience.

Please email your resume to:jhansib@petadata.co

After carefully reviewing your experience and skills one of our HR team members will contact you on the next steps.



  • Seattle, United States Futran Tech Solutions Pvt. Ltd. Full time

    Title: Sr ETL Developer with Pentaho Location: Onsite Day One - Washington, DC (2 days a week, hybrid model), Also open for initial remote for 3 months. Long Term Contract /Full Time Senior - Data integration (ETL) Developer(Pentaho) Job Description • Contribute substantially to the business analysis, design, development, testing, and deployment of...

  • Senior ETL Developer

    3 weeks ago


    Seattle, Washington, United States VDart Full time

    About the RoleWe are looking for a highly skilled Senior ETL Developer to design and develop complex data pipelines using ADO, Snowflake, DBT, Boomi, and Python in Seattle WA. This is an onsite contract opportunity with a duration of 6+ months.The estimated salary for this role is $125,000 - $190,000 per year, depending on experience.Key...


  • Seattle, United States Photon Full time

    Greetings Everyone Who are we? For the past 20 years, we have powered many Digital Experiences for the Fortune 500. Since 1999, we have grown from a few people to more than 4000 team members across the globe that are engaged in various Digital Modernization. For a brief 1 minute video about us, you can check this link. What will you do? Job Title: Senior...

  • ETL Developer

    7 days ago


    Seattle, United States Widenet Consulting Full time

    Whether you are a candidate looking for a new opportunity or an organization looking for talent, when you work with WideNet Consulting, you can be confident that you will receive an unequaled experience. As a leading technology consulting and recruitment firm, WideNet has built an outstanding reputation of consistently bringing together professionals, who...


  • Seattle, Washington, United States Futran Tech Solutions Pvt. Ltd. Full time

    Pentaho ETL Developer ExpertWe are looking for an experienced Pentaho ETL Developer Expert to lead our data integration efforts. As a key member of our team, you will be responsible for designing, developing, testing, and deploying an enterprise data warehouse (EDW) using Pentaho Data Integration.About the Company:Futran Tech Solutions Pvt. Ltd. is a leading...


  • Seattle, United States Saxon Global Full time

    Job Title - ETL/Informatica Developer Location - Seattle, WA (Remote) Job Type - Contract Specific Skills: Proficient in writing complex SQL queries, Stored procedures, Functions (T-SQL, PL/SQL) and Query optimization/tuning techniques Must have experience with Informatica (Informatica Data Quality as well as Power Center) and Alteryx Experience with SQL...


  • Seattle, Washington, United States Cynet Systems Full time

    OverviewCynet Systems is a cutting-edge company that specializes in providing top-notch data engineering services. Our team is dedicated to delivering exceptional results to our clients, and we're looking for talented professionals like you to join us.About the RoleWe're seeking a skilled Data Engineer who can perform complex data analysis, troubleshoot ETL...

  • Senior ETL Specialist

    3 weeks ago


    Seattle, Washington, United States widenet Full time

    Are you a skilled professional looking to take your career to the next level? WideNet Consulting is seeking a seasoned Senior ETL Specialist to join our team. In this role, you will be responsible for designing and implementing efficient ETL processes.About the Role:Design and develop ETL processes using Databricks, IDMC, and ODI.Collaborate with...

  • ETL Quality Engineer

    4 weeks ago


    Seattle, United States Moorecroft Systems Full time

    ETL Quality EngineerHybrid – Seattle area12+ month ContractRole Overview:Test and validate ETL logic and data pipelines to ensure seamless functionality.Take ownership of the quality of production releases, employing a data-driven approach to maintain high standards.Develop, deliver, and continually enhance quality processes to provide operational data...

  • ETL Quality Engineer

    2 weeks ago


    Seattle, United States Moorecroft Systems Full time

    ETL Quality EngineerHybrid – Seattle area12+ month ContractRole Overview:Test and validate ETL logic and data pipelines to ensure seamless functionality.Take ownership of the quality of production releases, employing a data-driven approach to maintain high standards.Develop, deliver, and continually enhance quality processes to provide operational data...

  • ETL Quality Engineer

    24 hours ago


    Seattle, United States Moorecroft Systems Full time

    ETL Quality EngineerHybrid – Seattle area12+ month ContractRole Overview:Test and validate ETL logic and data pipelines to ensure seamless functionality.Take ownership of the quality of production releases, employing a data-driven approach to maintain high standards.Develop, deliver, and continually enhance quality processes to provide operational data...


  • Seattle, Washington, United States Tata Consultancy Services Full time

    Job Description:Tata Consultancy Services is seeking a seasoned Oracle Business Intelligence Consultant to join our team. As a key member of our data analytics team, you will be responsible for leading large-scale, complex projects focused on the WFM Data Services platform.Your Key Responsibilities:Design and implement high-quality automation and monitoring...

  • Senior ETL Specialist

    3 weeks ago


    Seattle, Washington, United States Amazon Full time

    Imagine being part of a team that's revolutionizing the way people shop on Amazon! As a Data Engineer, you'll play a critical role in building the future of shopping by leveraging big data and machine learning to create personalized recommendations for our customers.This role offers a unique opportunity to work with cutting-edge technologies, design and...


  • seattle, United States Moorecroft Systems Full time

    ETL Quality EngineerHybrid – Seattle area12+ month ContractRole Overview:Test and validate ETL logic and data pipelines to ensure seamless functionality.Take ownership of the quality of production releases, employing a data-driven approach to maintain high standards.Develop, deliver, and continually enhance quality processes to provide operational data...


  • seattle, United States Moorecroft Systems Full time

    ETL Quality EngineerHybrid – Seattle area12+ month ContractRole Overview:Test and validate ETL logic and data pipelines to ensure seamless functionality.Take ownership of the quality of production releases, employing a data-driven approach to maintain high standards.Develop, deliver, and continually enhance quality processes to provide operational data...

  • ETL Quality Engineer

    1 month ago


    Seattle, United States aKube, Inc. Full time

    Job Description City: Seattle, WA /Santa Monica, CA Onsite/ Hybrid/ Remote:Hybrid, 2 days a week Duration: 12 months Rate Range: $92.5/hr on W2 depending on experience (no C2C or 1099 or sub-contract) Work Authorization: GC, USC, All valid EADs except H1b Job Qualifications: . 3 - 5 years' experience in Quality validating ETL pipelines and Data Warehouses ....

  • Snowflake Developer

    1 month ago


    Seattle, United States Diverse Lynx Full time

    At least 5 years of software development experience, and minimum 2 years of experience on Snowflake development in AWS Snowflake data engineers will be responsible for supporting data intelligence solutions around Snowflake Data Warehouse. A solid experience and understanding of architecting, designing and operationalization of large scale data and analytics...


  • Seattle, Washington, United States widenet Full time

    WideNet Consulting is looking to hire an experienced Data Warehouse Developer to join our team. This role will be part of the Data Services team as part of an integration project, where you will work on designing and developing a strong data warehouse.Key Responsibilities:Play a lead role in the areas of ETL design, data modeling, and ETL...


  • Seattle, United States TechnoGen Full time

    Job Title - Snowflake And AWS Developer Location - Seattle,WA (Hybrid) Type - Long Term Contract Note: PP no. is mandatory for Submission. Mandatory Skill Snowflake SQL , Advance SQL Terraform Job Description: At least 10+ years of software development experience, and minimum 2 years of experience on Snowflake development in AWS Snowflake data engineers...


  • Seattle, United States CloudBC Labs Full time

    Oracle BI Apps Developer(BI Apps upgrade project) Location-Seattle, WA Job Type-Long Term ContractMinimum Required Skills: OAC (Oracle Analytics Cloud): Experience in building and managing dashboards, reports, and data visualizations. OBIEE (Oracle Business Intelligence Enterprise Edition): Proficiency in designing RPD models, creating complex dashboards,...