ETL Developer at Bright Vision Technologies | Austin, TX, US | Rezi

ETL Developer at Bright Vision Technologies

ETL Developer

Bright Vision Technologies · Austin, TX, US

1 weeks ago

ETL Developer

Bright Vision Technologies · Austin, TX, US

8 days ago
Resume preview

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now
Resume preview

Tailor your resume to this ETL Developer role.

Rezi rewrites your resume against Bright Vision Technologies's job description. Free.

Resume score gauge reading 58 out of 100

Don't guess if your resume is good enough.

See how it scores against the ETL Developer posting at Bright Vision Technologies — free, in seconds.

About the Role

We are seeking an experienced ETL Developer to design, develop, and optimize enterprise-scale data integration solutions supporting business intelligence, analytics, regulatory reporting, and cloud data modernization initiatives. This role focuses on building high-performance ETL pipelines that ingest, transform, validate, and deliver data from diverse operational systems into enterprise data warehouses and cloud-based analytics platforms.

Responsibilities

  • Design, develop, and maintain enterprise ETL/ELT pipelines for large-scale data integration projects.
  • Build scalable data ingestion workflows that extract data from relational databases, cloud applications, APIs, flat files, and enterprise systems.
  • Develop transformation logic for cleansing, standardizing, validating, and enriching large datasets.
  • Design and optimize batch and near real-time data processing pipelines supporting business-critical reporting and analytics.
  • Implement Slowly Changing Dimensions (SCD), Change Data Capture (CDC), incremental loading strategies, and data reconciliation processes.
  • Develop reusable ETL frameworks, metadata-driven workflows, and parameterized jobs to improve maintainability.
  • Perform source-to-target mapping, data profiling, and data quality analysis during project implementation.
  • Optimize ETL job performance by improving SQL queries, partitioning strategies, indexing, and parallel processing.
  • Monitor ETL workflows, troubleshoot production failures, and implement proactive alerting and recovery mechanisms.
  • Collaborate with cloud engineers to migrate legacy ETL workloads to Azure or AWS cloud platforms.
  • Participate in data architecture discussions, code reviews, deployment planning, and production support.
  • Ensure data security, governance, auditability, and regulatory compliance across enterprise data pipelines.

Requirements

  • Five or more years of professional experience developing enterprise ETL solutions.
  • Strong hands-on experience with ETL platforms such as Informatica PowerCenter, SSIS, Talend, IBM DataStage, or Pentaho.
  • Advanced SQL development skills with SQL Server, Oracle, PostgreSQL, Snowflake, or Teradata.
  • Strong understanding of relational databases, dimensional modeling, star schema, snowflake schema, and data warehousing principles.
  • Experience designing ETL workflows involving complex transformations, joins, aggregations, lookups, and data validation.
  • Hands-on experience implementing Change Data Capture (CDC), Slowly Changing Dimensions (SCD Type 1 & Type 2), and incremental loading techniques.
  • Experience working with cloud data platforms including Azure Data Factory (ADF), AWS Glue, or Google Cloud Data Fusion.
  • Experience integrating structured and semi-structured data formats including JSON, XML, CSV, Parquet, and Avro.
  • Familiarity with scripting languages such as Python, PowerShell, or Shell scripting for ETL automation.
  • Experience scheduling workflows using Control-M, Autosys, Apache Airflow, Azure Data Factory, or enterprise schedulers.
  • Experience with Git, Azure DevOps, Jenkins, or other CI/CD tools for ETL deployments.
  • Strong debugging, troubleshooting, and ETL performance tuning skills.
  • Experience working with Agile Scrum teams and enterprise SDLC processes.

Skills

  • ETL platforms (Informatica PowerCenter, SSIS, Talend, IBM DataStage, Pentaho)
  • SQL Server
  • Oracle
  • PostgreSQL
  • Snowflake
  • Teradata
  • Relational databases
  • Dimensional modeling
  • Star schema
  • Snowflake schema
  • Data warehousing
  • Change Data Capture (CDC)
  • Slowly Changing Dimensions (SCD Type 1 & Type 2)
  • Incremental loading
  • Azure Data Factory (ADF)
  • AWS Glue
  • Google Cloud Data Fusion
  • JSON
  • XML
  • CSV
  • Parquet
  • Avro
  • Python
  • PowerShell
  • Shell scripting
  • Control-M
  • Autosys
  • Apache Airflow
  • Git
  • Azure DevOps
  • Jenkins
  • CI/CD tools
  • Agile Scrum
  • SDLC processes
  • Snowflake
  • Azure Synapse Analytics
  • Amazon Redshift
  • Google BigQuery
  • Apache Spark
  • Databricks
  • PySpark
  • Apache Kafka
  • Azure Event Hub
  • Amazon Kinesis
  • DevOps
  • Power BI
  • Tableau
  • Qlik
  • Data governance
  • Data lineage
  • Data cataloging
  • Regulatory compliance

Location

  • 100% Remote (U.S.)

Work Type

  • Full-time
  • Direct W2

Experience Level

  • 5+ years

Salary/Compensations

  • $115,000–$175,000 Annually

About the Company

  • Bright Vision Technologies is a technology consulting and software development company delivering cloud, AI, data, and enterprise solutions across the United States.
  • This is a fantastic opportunity to join an established and well-respected organization offering tremendous career growth potential.

Equal Opportunity

  • Bright Vision Technologies is an Equal Opportunity Employer
  • Bright Vision Technologies (BV Teck) is committed to equal employment opportunity (EEO) for all employees and applicants without regard to race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, veteran status, or any other protected status as defined by applicable federal, state, or local laws. This commitment extends to all aspects of employment, including recruitment, hiring, training, compensation, promotion, transfer, leaves of absence, termination, layoffs, and recall.
  • BV Teck expressly prohibits any form of workplace harassment or discrimination. Any improper interference with employees' ability to perform their job duties may result in disciplinary action up to and including termination of employment.