Role Overview
The ETL Data Integration Engineer will play a critical role in designing and implementing data integration solutions that meet specific business requirements. This position requires strong technical skills and a deep understanding of ETL processes. The successful candidate will collaborate with various stakeholders to ensure that the data flows are efficient, reliable, and scalable. The ideal candidate will possess a keen eye for detail along with strong problem-solving skills.
Key Responsibilities:
- Develop and optimize ETL processes to ensure timely data ingestion and transformation.
- Collaborate with data architects to define data models and integrate various data sources.
- Perform data quality checks and validation to maintain high data integrity.
- Monitor and troubleshoot data pipelines to ensure smooth operation.
- Create and maintain documentation for data integration processes and architecture.
- Collaborate with cross-functional teams to gather requirements for new data projects.
- Evaluate and implement new technologies for improving ETL processes.
- Provide operational support during data migration activities.
Required Skills:
- Proficient in SQL and data modeling techniques.
- Strong understanding of ETL tools like Informatica, Talend, or SSIS.
- Experience with data warehousing solutions and methodologies.
- Familiarity with cloud-based data storage solutions, such as AWS or Azure.
- Ability to write efficient shell scripts or Python for automation.
- Knowledge of data quality practices and tools.
- Experience in data analysis and business intelligence principles.
- Familiarity with Agile methodologies.
Preferred Skills:
- Experience with big data technologies like Hadoop or Spark.
- Knowledge of data governance and compliance regulations.
- Familiarity with NoSQL databases.
- Experience with dashboard tools such as Tableau or Power BI.
