Skip to content

ETL/ELT Developer - Pipeline

Woodbridge, NJ 07095

Employment Type: Contract Expertise: Software Development Job Number: 24105 Pay Range:

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.




 
Apply Online

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.

About Woodbridge, NJ

Ready to embark on a fulfilling career journey in Woodbridge, New Jersey? This vibrant area nestled in Middlesex County is brimming with job opportunities and endless possibilities for professional growth. From the picturesque landscapes of Merrill Park to the bustling atmosphere of Woodbridge Center Mall, there's something for everyone in this thriving community. Take a stroll through the artsy Downtown Woodbridge and catch a show at the historic State Theatre. Indulge in a delicious slice of Woodbridge's famous pizza or explore the diverse culinary scene that lines Main Street. Join our team and discover why Woodbridge is not just a place to work, but a place to thrive. Explore our job listings today and kickstart your career in this charming and bustling region!