ETL Developer

Department: Software

Project Location(s): Bengaluru, Karnataka,India

Education: Bachelor of Engineering

Designing, developing, and maintaining ETL processes and workflows.
Extracting data from various sources, transforming it to fit into the target schema, and loading it into the data warehouse or data lake.
Collaborating with data architects, data analysts, and other stakeholders to understand data requirements and design appropriate ETL solutions.
Writing complex SQL queries for data extraction and transformation.
Developing and implementing data validation and quality assurance processes.
Monitoring ETL jobs and troubleshooting issues to ensure data accuracy and integrity.
Optimizing ETL processes for performance and scalability.
Documenting ETL processes, data mappings, and data lineage.
Keeping up-to-date with new ETL technologies and best practices.
Providing technical support and guidance to other team members.

roficiency in SQL for data extraction, transformation, and loading.
Experience with ETL tools such as Informatica, Talend, or SSIS.
Knowledge of data warehousing concepts and methodologies.
Familiarity with databases such as MySQL, Oracle, or SQL Server.
Strong understanding of data modeling and data integration techniques.
Experience with scripting languages such as Python, Perl, or Shell scripting.
Knowledge of big data technologies such as Hadoop, Spark, or Hive (depending on the organization’s requirements).
Familiarity with cloud platforms such as AWS, Azure, or Google Cloud Platform.
Excellent problem-solving and analytical skills.
Strong communication and teamwork skills.