Know ATS Score
CV/Résumé Score
  • Expertini Resume Scoring: Our Semantic Matching Algorithm evaluates your CV/Résumé before you apply for this job role: ETL/ELT Developer Pipeline.
United States Jobs Expertini

Urgent! ETL/ELT Developer - Pipeline Job Opening In Woodbridge Township – Now Hiring Overture Partners

ETL/ELT Developer Pipeline



Job description

ETL/ELT Developer
Key Responsibilities


  • Design, develop, test, and implement ETL/ELT solutions using FiveTran, DBT, and Snowflake to support regulatory reporting and historical data integrations.
  • Develop and maintain code for data mappings and transformations in both on-premise (DB2, AIX) and cloud-based (AWS, Snowflake) environments.
  • Collaborate with business analysts to review requirements, assist in system specifications, and create technical specifications for data integrations.
  • Build and optimize data pipelines using FiveTran for data ingestion and DBT for transformation, ensuring compliance with Informatica development standards.
  • Perform in-depth unit testing, participate in system and user acceptance testing, and support production implementation with comprehensive documentation.
  • Work with DBAs to implement database changes and optimize Snowflake schemas, tables, and queries for performance.
  • Analyze and resolve data integration issues, propose solutions, and enhance existing processes for efficiency.
  • Provide accurate effort and duration estimates for development tasks and participate in code reviews to ensure quality and compliance.

Required Skills and Qualifications
ETL/ELT Development (50%)

  • 3-7 years of experience in ETL/ELT design and development, with proficiency in FiveTran for data ingestion and DBT for data transformation.
  • Strong expertise in Snowflake for schema creation, table setup, query optimization, and performance tuning.
  • Experience with Informatica Power Center and Informatica Cloud for data mappings and transformations.
  • Familiarity with data warehousing principles and API-based data integrations.

Database and Scripting (50%)

  • Proficient in database development using DB2, SQL Server, and Snowflake, with strong SQL skills for writing and optimizing complex queries.
  • Experience with Python scripting for automation, data processing, and workflow orchestration.
  • Knowledge of software development life cycle (SDLC) methodologies and version control tools (e.g., Git, Jira).
  • Understanding of data modeling principles to support efficient database design.

Additional Considerations

  • Knowledge of the Property & Casualty (P&C) insurance industry is a plus.
  • Experience with stored procedures, Unix/Perl scripting, or balancing and control mechanisms is advantageous.
  • Familiarity with AWS components (e.g., S3, Glue, RDS) and cloud migration strategies is highly valued.
  • Ability to develop metrics and visualizations for data insights is a plus.
  • Candidates must be local to Central New Jersey to facilitate collaboration and occasional on-site work.

Why Join Us?

This role offers an opportunity to join a dynamic Data Services team responsible for critical regulatory and reporting integrations.

You’ll work with modern tools like FiveTran, DBT, and Snowflake, contribute to the modernization of our data infrastructure, and collaborate with a forward-thinking team dedicated to delivering high-quality data solutions that drive business success.

What is a Pipeline Job?

These roles represent future opportunities we've uncovered through our client discussions.

We have stripped away the rigid “Must Haves,” “Mandatories,” and “Required” criteria to find the right fit for their needs.

By applying for these future roles, we will complete our human-centered process to see if you are a fit while adding your profile to our database to be considered for additional openings.

When you apply, rest assured a human will thoroughly review your resume and respond to you personally.

We take pride in finding the right match for each job, valuing your unique talents and potential over just what's on your resume.









 


Required Skill Profession

Computer Occupations



Your Complete Job Search Toolkit

✨ Smart • Intelligent • Private • Secure

Start Using Our Tools

Join thousands of professionals who've advanced their careers with our platform

Rate or Report This Job
If you feel this job is inaccurate or spam kindly report to us using below form.
Please Note: This is NOT a job application form.


    Unlock Your ETL ELT Potential: Insight & Career Growth Guide


  • Real-time ETL ELT Jobs Trends in Woodbridge Township, United States (Graphical Representation)

    Explore profound insights with Expertini's real-time, in-depth analysis, showcased through the graph below. This graph displays the job market trends for ETL ELT in Woodbridge Township, United States using a bar chart to represent the number of jobs available and a trend line to illustrate the trend over time. Specifically, the graph shows 297 jobs in United States and 1 jobs in Woodbridge Township. This comprehensive analysis highlights market share and opportunities for professionals in ETL ELT roles. These dynamic trends provide a better understanding of the job market landscape in these regions.

  • Are You Looking for ETL/ELT Developer Pipeline Job?

    Great news! is currently hiring and seeking a ETL/ELT Developer Pipeline to join their team. Feel free to download the job details.

    Wait no longer! Are you also interested in exploring similar jobs? Search now: .

  • The Work Culture

    An organization's rules and standards set how people should be treated in the office and how different situations should be handled. The work culture at Overture Partners adheres to the cultural norms as outlined by Expertini.

    The fundamental ethical values are:
    • 1. Independence
    • 2. Loyalty
    • 3. Impartiality
    • 4. Integrity
    • 5. Accountability
    • 6. Respect for human rights
    • 7. Obeying United States laws and regulations
  • What Is the Average Salary Range for ETL/ELT Developer Pipeline Positions?

    The average salary range for a varies, but the pay scale is rated "Standard" in Woodbridge Township. Salary levels may vary depending on your industry, experience, and skills. It's essential to research and negotiate effectively. We advise reading the full job specification before proceeding with the application to understand the salary package.

  • What Are the Key Qualifications for ETL/ELT Developer Pipeline?

    Key qualifications for ETL/ELT Developer Pipeline typically include Computer Occupations and a list of qualifications and expertise as mentioned in the job specification. Be sure to check the specific job listing for detailed requirements and qualifications.

  • How Can I Improve My Chances of Getting Hired for ETL/ELT Developer Pipeline?

    To improve your chances of getting hired for ETL/ELT Developer Pipeline, consider enhancing your skills. Check your CV/Résumé Score with our free Tool. We have an in-built Resume Scoring tool that gives you the matching score for each job based on your CV/Résumé once it is uploaded. This can help you align your CV/Résumé according to the job requirements and enhance your skills if needed.

  • Interview Tips for ETL/ELT Developer Pipeline Job Success
    Overture Partners interview tips for ETL/ELT Developer   Pipeline

    Here are some tips to help you prepare for and ace your job interview:

    Before the Interview:
    • Research: Learn about the Overture Partners's mission, values, products, and the specific job requirements and get further information about
    • Other Openings
    • Practice: Prepare answers to common interview questions and rehearse using the STAR method (Situation, Task, Action, Result) to showcase your skills and experiences.
    • Dress Professionally: Choose attire appropriate for the company culture.
    • Prepare Questions: Show your interest by having thoughtful questions for the interviewer.
    • Plan Your Commute: Allow ample time to arrive on time and avoid feeling rushed.
    During the Interview:
    • Be Punctual: Arrive on time to demonstrate professionalism and respect.
    • Make a Great First Impression: Greet the interviewer with a handshake, smile, and eye contact.
    • Confidence and Enthusiasm: Project a positive attitude and show your genuine interest in the opportunity.
    • Answer Thoughtfully: Listen carefully, take a moment to formulate clear and concise responses. Highlight relevant skills and experiences using the STAR method.
    • Ask Prepared Questions: Demonstrate curiosity and engagement with the role and company.
    • Follow Up: Send a thank-you email to the interviewer within 24 hours.
    Additional Tips:
    • Be Yourself: Let your personality shine through while maintaining professionalism.
    • Be Honest: Don't exaggerate your skills or experience.
    • Be Positive: Focus on your strengths and accomplishments.
    • Body Language: Maintain good posture, avoid fidgeting, and make eye contact.
    • Turn Off Phone: Avoid distractions during the interview.
    Final Thought:

    To prepare for your ETL/ELT Developer Pipeline interview at Overture Partners, research the company, understand the job requirements, and practice common interview questions.

    Highlight your leadership skills, achievements, and strategic thinking abilities. Be prepared to discuss your experience with HR, including your approach to meeting targets as a team player. Additionally, review the Overture Partners's products or services and be prepared to discuss how you can contribute to their success.

    By following these tips, you can increase your chances of making a positive impression and landing the job!

  • How to Set Up Job Alerts for ETL/ELT Developer Pipeline Positions

    Setting up job alerts for ETL/ELT Developer Pipeline is easy with United States Jobs Expertini. Simply visit our job alerts page here, enter your preferred job title and location, and choose how often you want to receive notifications. You'll get the latest job openings sent directly to your email for FREE!