Senior ETL Developer

5 days ago

Remote, Oregon, United States Amatriot Group, LLC Full time $110,000 - $155,000 per year

Clearance: U.S. Citizen ; 6c Public Trust

Location: 100% Remote

Job Type: Full-Time

Expected Salary Range*: $110,000 - $155,000

  • This represents the potential salary range for this position depending on education level, years of experience and/or certifications in addition to other position specific requirements which may impact salary

Position Overview:

Amatriot is currently seeking an ETL Developer to work remote and join our team supporting one of our Federal clients.

Essential Duties and Responsibilities:

  • Provide design and implementation expertise to a cross-functional software development team.
  • Design and develop software applications from business requirements in collaboration with other team members.
  • Support testing and remediate defects.
  • May mentor entry and mid-level developers.

Essential Duties and Responsibilities:

ETL Development:

  • Develop end-to-end ETL solutions using Actian DataConnect.
  • Participate in requirements gathering and design sessions.
  • Create applications for processing financial and other transactions using ETL, SQL, and Web Services.
  • Design self-cleanup ETL processes and enhance existing ETL processes for better performance.
  • Develop reusable transformations, SQL queries, stored procedures, and functions.
  • Conduct feasibility studies and proof of concepts.
  • Implement data validation, data management, and file management processes using various scripting languages.

Support and Upgrades:

  • Support environment and product/tool upgrades, including proof of concept and beta testing.
  • Re-engineer business processes for version control and change management.
  • Perform unit testing and validate ETLs during SQL Server upgrades.
  • Identify and address product gaps, engaging with vendor architects for solutions.

Production and Quality Assurance:

  • Monitor daily data transmission and ETL loading activities.
  • Troubleshoot and perform root cause analysis for production issues.
  • Conduct defect root cause analysis and participate in test case reviews.

Education and Experience Requirements:

  • Bachelor's degree in related field.

  • 5-7 years of related experience required. Equivalent combination of education and experience considered in lieu of degree.

  • Minimum 5 years experience ETL Tool required.

  • Minimum 5 years of SQL Server (T-SQL) experience, must experience writing very complex T-SQL procedures and queries.
  • Experience with reading and creating XML using an ETL tool.
  • Experience with creating Json functions.
  • Experience with invoking SOAP and REST calls using an ETL tool.
  • Experience with ETL tools to read and create various data files (Excel, Flat file, XML etc.).
  • Experience with Windows batch scripting.
  • Experience with Windows PowerShell scripting.

Preferred:

  • Experience with Actian Data Connect ETL.
  • Experience with Perl scripts.
  • Experience with C&R Software's Debt Manager application.

Additional Requirements as per contract/client:

  • Must be eligible to Obtain Government Clearance.
  • Must be a U.S. citizen.
  • Must currently reside in the U.S.
  • Must be able to pass a criminal background check.
  • Must not be delinquent or in default on any federal student loans.
  • Employment and continued employment are contingent upon obtaining and maintaining a favorable clearance.

  • ETL - Integration Developer

    5 days ago

    Remote, Oregon, United States Brown & Brown Insurance Full time $80,000 - $120,000

    Built on meritocracy, our unique company culture rewards self-starters and those who are committed to doing what is best for our customers.Brown & Brown is Seeking an ETL – Integration Developer to join our growing team.The ETL/Data Integration Engineer designs, develops, and maintains enterprise-grade data pipelines and integration solutions. This role...

  • ETL Developer

    5 days ago

    Remote, Oregon, United States ConServe Full time $70,000 - $90,000 per year

    OverviewWe are seeking a skilled ETL Developer to join our dynamic team. The ideal candidate will have a strong background in data integration and management, with expertise in various technologies and methodologies. As an ETL Developer, you will be responsible for designing, developing, and maintaining ETL processes that facilitate the movement and...

  • Senior ETL Software Engineer

    4 days ago

    Remote, Oregon, United States FIA Tech Full time

    FIA Tech is the leading technology provider to the exchange traded derivatives industry. Owned by a consortium of thirteen leading clearing firms and the Futures Industry Association (FIA), FIA Tech is committed to serving the industry and launching innovative solutions to improve market infrastructure across the listed and cleared derivatives industry. FIA...

  • Senior Software Developer

    5 days ago

    Remote, Oregon, United States Pfizer Full time $41 - $51 per year

    Senior Software DeveloperSummary:Pfizer is seeking a Senior Software Developer to develop and maintain an internal R package and to develop R-based ETL scripts for basic data engineering and QC of biomarker data.Responsibilities:Contribute and expand functionality to our internally developed R package. Coordinate with coworkers to ensure compatibility within...

  • Senior Python Developer

    5 days ago

    Remote, Oregon, United States Pen Software, Inc. Full time $120,000 - $150,000 per year

    PEN Software Inc. is hiring Python Developers / Technical Leads for one of our direct clients.Position: Python Developer / Technical Lead (Microservices / Data Engineering)Location: Remote – USA (USA Based Candidates)Employment Type: Contract – 6 months (extension possible)Open to: W2 (Hourly) / 1099 / C2COverview:We are looking for a hands-on Python...

  • Senior SFDC Developer with CPQ

    6 days ago

    Remote, Oregon, United States Digital Dhara LLC Full time $120,000 - $150,000 per year

    Job OverviewWe are seeking a highly skilled Senior Developer to join our dynamic team. The ideal candidate will possess extensive experience in software development and a strong understanding of various technologies, including service-oriented architecture and cloud security. This role requires a proactive individual who can contribute to system design,...

  • SQL Developer

    5 days ago

    Remote, Oregon, United States JPS Tech Solutions pvt ltd Full time $60,000 - $120,000 per year

    Role: SQL DeveloperIndustry: Property & Casualty (P&C) InsuranceLocation: RemoteDuration: Contract on W2Experience: 10+ YearsInterview Type: Virtual / In-PersonJob Description:We are seeking an experienced SQL Developer with a strong background in SQL Server 2014, SSIS, and SSRS to join our client team at CNA Insurance. The ideal candidate will have hands-on...

  • Snowflake Developer

    3 days ago

    Remote, Oregon, United States Supersourcing Full time $80,000 - $120,000 per year

    Responsibilities:Design, develop, and optimize Snowflake data warehouse solutions to meet business requirements.Collaborate with stakeholders to gather and understand data requirements, and translate them into technical specifications.Perform data modeling and schema design to ensure efficient and scalable data storage and retrieval.Develop and maintain ETL...

  • SQL Developer

    6 days ago

    Remote, Oregon, United States Piper Companies Full time $75,000 - $95,000 per year

    Piper Companies is seeking a SQL Developer to join a leading non-asset-based third-party logistics (3PL) provider located in Hickory, NC through 100% permanent remote work. The SQL Developer will support the parcel rating systems by configuring data, monitoring performance, deploying updates, and analyzing rating-related data in collaboration with DevOps and...

  • Power BI Developer

    5 days ago

    Remote, Oregon, United States ishare Inc Full time $120,000 - $140,000 per year

    Job Title: Power BI Developer / Data Analyst – P&C Insurance Location: Remote (US-based preferred) Type: Contract Duration: 6– Job Summary We are seeking a highly skilled Power BI Developer / Data Analyst with hands-on experience in data visualization, analytics, and reporting within the Property & Casualty (P&C) insurance domain. The ideal...