Data Warehouse ETL Developer

Analytics EngineerAnalytics EngineerFull TimeRemoteTeam 10,001+Since 2017H1B SponsorCompany SiteLinkedIn

Location

New Jersey

Posted

5 days ago

Salary

$80.1K - $104K / year

Bachelor Degree5 yrs expEnglishETLInformaticaOracleSQL

Job Description

• Design, develop, and deploy ETL mappings, workflows, and sessions using Informatica PowerCenter. • Extract data from heterogeneous source systems (e.g., Oracle, SQL Server, flat files, SAP) and load into target data warehouse environments. • Collaborate with business analysts and data architects to understand data requirements and translate them into efficient ETL solutions. • Optimize ETL processes for performance, scalability, and maintainability. • Conduct data validation, reconciliation, and troubleshooting to ensure data quality and integrity. • Maintain ETL documentation, including data flow diagrams, technical specifications, and process design documents. • Participate in code reviews, unit testing, and UAT support. • Monitor ETL jobs and workflows, identify bottlenecks, and implement improvements. • Provide production support and resolve data-related issues in a timely manner.

Job Requirements

  • Bachelor’s degree in Computer Science, Information Technology, or a related field.
  • 5+ years of experience in ETL development using Informatica PowerCenter.
  • Strong understanding of data warehousing concepts, dimensional modeling, and star/snowflake schemas.
  • Experience with SQL, PL/SQL, and performance tuning of database queries.
  • Knowledge of data quality, data governance, and best practices in ETL development.
  • Strong analytical, problem-solving, and communication skills.
  • Experience with version control systems and ETL deployment processes.

Benefits

  • Health & Welfare Benefits: Comprehensive plans tailored to your needs, effective from day one.
  • Retirement Savings: Robust programs to help you secure your financial future.
  • Employee Discounts: Access to a wide range of discounts on merchandise, services, travel, and more.
  • Career Growth Opportunities: Paths for advancement within a global organization.
  • Paid Training: Learn while you earn with award-winning learning platforms.
  • Paid Time Off: Competitive PTO packages to help you recharge.
  • Great Work Environment: Join an award-winning culture that values diversity and inclusion.

Related Categories

Related Job Pages

More Analytics Engineer Jobs

Analytics Consulting Manager

Komodo Health

In our mission to reduce the burden of disease, our Healthcare Map™ answers healthcare's most complicated questions.

Analytics Engineer6 days ago
Full TimeRemoteTeam 501-1,000Since 2014H1B Sponsor

This role exists on the Marmot Enabled Analytics (MEA) team to ensure the delivery of high-quality analytics products and services to our clients. The Analytics Consulting Manager plays a crucial role in driving client satisfaction, business growth, and innovation within the comp...

SQLPythonRProject ManagementHealthcare AnalyticsData AnalysisClient Relationship Management
United States

Senior Data & Analytics Consultant

MetLife

We're honored to be No. 10 on Great Place to Work's World's Best Workplaces and recognized in the Fortune 100 Best Companies to Work For® list in 2025. At MetLife, we're leading the global transformation of an industry we’ve defined for over 157 years. At MetLife, every innovation and line of code is a lifeline for our customers and their families—from victims of natural disasters to people living with disabilities and beyond. With operations in more than 40 markets and leading positions across the globe, MetLife fosters an inclusive culture where our people are energized and inspired to deliver for our customers and communities. Join our remarkable journey—one in which you help write the next century of innovation in financial services—because with MetLife, making the world a better place is All Together Possible.

Analytics Engineer6 days ago
Full TimeRemoteTeam 43,000Since 1868

The Senior Data & Analytics Consultant will lead data structuring, reporting, and analysis for the pet business, ensuring accurate reporting to meet business objectives.

ExcelPower BISQLVBA
United States
$76.5K - $125K / year

AV Safety Engineering Analytics AI/ML Engineer (GPSSC)

General Motors

Join us on our journey toward a world with zero crashes, zero emissions, and zero congestion.

Analytics Engineer6 days ago
Full TimeRemoteTeam 10,001+Since 1908H1B Sponsor

Lead AI/ML efforts for vehicle safety analytics, develop cloud-based solutions, mentor team members, and engage with stakeholders to ensure effective safety monitoring and performance evaluation.

AWSCI/CDDockerGitGoogle Cloud PlatformJavaJenkinsJIRAKubernetesLangchainAzureMlflowNumpyPandasPlotlyPower BIPysparkPythonPyTorchRScikit-LearnSQLTableauTensorFlow
District of Columbia
Analytics Engineer6 days ago
Full TimeRemoteTeam 1,372Since 2022

The Senior ETL Developer will be central to designing, developing, and maintaining data pipelines for analytics and reporting, involving extracting data from diverse sources, transforming it, and loading it into target systems within a SAFe Agile framework. Responsibilities include architecting Data Lake solutions in AWS, writing complex SQL, and ensuring data quality and integrity across all pipeline stages.

United States