ETL Developer

About the role

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.

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.
• A 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.
• Experience 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

• Experience with cloud data warehouses including Snowflake, Azure Synapse Analytics, Amazon Redshift, or Google BigQuery.
• Knowledge of Apache Spark, Databricks, PySpark, or distributed data processing frameworks.
• Experience implementing enterprise Master Data Management (MDM) and Data Quality solutions.
• Familiarity with streaming technologies including Apache Kafka, Azure Event Hub, or Amazon Kinesis.
• Experience developing metadata-driven ETL frameworks and reusable integration components.
• Knowledge of Data Vault 2.0 architecture and modern data lakehouse concepts.
• Familiarity with DevOps practices for data engineering and automated ETL deployments.
• Experience with BI platforms including Power BI, Tableau, or Qlik for downstream reporting integration.
• Understanding of data governance frameworks, lineage, cataloging, and regulatory compliance.
• Cloud certifications in Azure, AWS, Snowflake, or Informatica are highly desirable.

Benefits

Not specified

Pay

$115,000–$175,000 Annually

Schedule

100% Remote (U.S.)

Qualifications

U.S. Citizens, Green Card Holders, EAD Holders, and H-1B transfer candidates are encouraged to apply. We are unable to sponsor new H-1B visa petitions for this position.