ETL Developer
- Compensation
- Not disclosed
- Location
- Remote US, United States
- Work setup
- Hybrid
- Seniority
- Senior
- Employment
- Not specified
- Experience
- 10+ years
- Category
- Data engineering
- Posted
Skills
Must have
- Bachelor's degree in Computer Science, Information Systems, or a related field.
- Proven experience as an ETL Developer, with a minimum of 10 years in a senior role.
- Strong proficiency in ETL tools such as Informatica, Talend, Apache Nifi
- In-depth knowledge of SQL and database technologies (SQL Server, Oracle, PostgreSQL, etc.).
- Proficiency in programming languages such as Python, Java, or Scala.
- Experience with data modeling, data warehousing concepts, and data integration best practices.
- Strong problem-solving skills and the ability to work in a fast-paced, collaborative environment.
- Excellent communication and interpersonal skills.
- Knowledge of data quality and data governance principles.
- Familiarity with cloud-based ETL solutions (e.g., AWS Glue, Azure Data Factory) is a plus.
- Relevant certifications (e.g., Microsoft Certified: Azure Data Engineer, Informatica Certification) are advantageous.
- Ability to work with large volumes of data efficiently and optimize ETL processes for performance.
Full description
Senior ETL DeveloperAbout the Role
We are seeking an experienced Senior ETL (Extract, Transform, Load) Developer to join our dynamic team. The ideal candidate should have a strong background in data integration, ETL processes, and data warehousing. As a Senior ETL Developer, you will be responsible for designing, developing, and maintaining ETL solutions that facilitate data extraction, transformation, and loading of information from various source systems into our data warehouse. Your expertise will be crucial in ensuring data accuracy, performance, and reliability to support data-driven decision-making within the organization.
Responsibilities
- Collaborate with cross-functional teams, including data analysts, data engineers, and business stakeholders to understand data requirements and design efficient ETL processes.
- Develop, optimize, and maintain ETL workflows using industry-standard ETL tools and technologies.
- Create and maintain comprehensive ETL documentation, including data mappings, transformation rules, and data lineage.
- Monitor ETL processes for performance and data quality, and proactively address issues or bottlenecks.
- TMSIS Troubleshoot and resolve ETL-related problems, ensuring minimal disruption to business operations.
- Perform data profiling and quality checks to ensure data accuracy and consistency.
- Design and implement data validation and data reconciliation processes to identify and correct data anomalies.
- Stay up-to-date with ETL best practices and emerging technologies, and provide recommendations for process improvements.
- Mentor and provide guidance to junior ETL developers on best practices and ETL development techniques.
- Work with stakeholders to define and implement data security and access controls within the ETL process.
- TMSIS knowledge would be a plus
Requirement
- Bachelor's degree in Computer Science, Information Systems, or a related field.
- Proven experience as an ETL Developer, with a minimum of 10 years in a senior role.
- Strong proficiency in ETL tools such as Informatica, Talend, Apache Nifi
- In-depth knowledge of SQL and database technologies (SQL Server, Oracle, PostgreSQL, etc.).
- Proficiency in programming languages such as Python, Java, or Scala.
- Experience with data modeling, data warehousing concepts, and data integration best practices.
- Strong problem-solving skills and the ability to work in a fast-paced, collaborative environment.