ETL Developer

This is a fully remote position, open to applicants in United States.

📋 Description

• Collaborate with data analysts, data engineers, and business stakeholders to gather data requirements.

• Design, develop, optimize, and maintain ETL processes and workflows.

• Extract, transform, and load data from source systems into the data warehouse.

• Create and maintain ETL documentation, which includes data mappings, transformation rules, and data lineage.

• Monitor ETL performance and ensure data quality.

• Troubleshoot and resolve issues related to ETL processes.

• Conduct data profiling and perform quality checks.

• Design and implement data validation and reconciliation procedures.

• Identify and rectify data anomalies.

• Stay updated on ETL best practices and emerging technologies.

• Suggest process enhancements.

• Mentor junior ETL developers.

• Define and implement data security measures and access controls within ETL processes.

⛳️ Requirements

• Bachelor's degree in Computer Science, Information Systems, or a related discipline.

• At least 10 years of experience in a senior ETL Developer position.

• Strong expertise in Informatica, Talend, or Apache NiFi.

• Extensive knowledge of SQL and database technologies, including SQL Server, Oracle, and PostgreSQL.

• Proficient in Python, Java, or Scala.

• Experience with data modeling, data warehousing concepts, and best practices in data integration.

• Understanding of data quality and governance principles.

• Familiarity with AWS Glue or Azure Data Factory is advantageous.

• Capability to work efficiently with large datasets and optimize ETL processes for performance.

• Knowledge of TMSIS would be beneficial.

• Relevant certifications such as Microsoft Certified: Azure Data Engineer or Informatica Certification are a plus.

• Strong problem-solving abilities.

• Excellent communication and interpersonal skills.

• Ability to thrive in a fast-paced, collaborative environment.

🏝️ Benefits

• Remote work from home.

• Opportunities for career growth.

• Possibilities to advance your career.

• Award-winning work environment.

• Comprehensive health insurance coverage.

• Optional dental and vision programs.

• Life and disability insurance.

• Retirement savings plan.

• Paid holidays.

• Paid time off (PTO) or vacation and/or sick leave.

• Potential for bonuses or incentives based on business needs.