Remote ETL Developer for Cloud & Data Modernization

Bright Vision Technologies

Round Rock (TX)

On-site

USD 115,000 - 175,000

Full time

4 days ago

Be an early applicant

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

Bright Vision Technologies is seeking an experienced ETL Developer to design, develop, and optimize enterprise-scale data integration solutions that support BI, analytics, regulatory reporting, and cloud modernization initiatives.

You will collaborate with data architects, data engineers, business analysts, cloud engineers, and BI developers to build scalable data integration frameworks, automate workflows, and ensure high-quality, trusted data across the organization.

Qualifications

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 CDC, 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.

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 reporting and analytics.
Implement SCD, 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.