Senior ETL Developer

Job descriptionRequired:

• Hands-on experience with writing and optimizing complex SQL queries involving multiple joins, subqueries, and aggregations.
• Proficiency in performance tuning SQL queries for efficiency and scalability.
• Worked on at least one development project from an ETL Perspective, demonstrating expertise in extracting, transforming, and loading data.
• File Processing using ETL tools, showcasing ability to handle various file formats and processing requirements.
• Experience in Shell/Python Scripting, particularly for automating ETL processes and data manipulation tasks.
• Hands-On Experience writing Business Logic SQL or PL/SQL, ensuring data integrity and adherence to business rules.
• ETL Testing and Troubleshooting, including identifying and resolving data quality issues and ETL process failures.
• Good to have experience in Building a Cloud ETL Pipeline, leveraging cloud services for scalable and reliable data processing.
• Hands-on experience in Code Versioning Tools like Git, SVN, ensuring code integrity and collaboration.

Required Skills and Abilities:

• Mandatory Skills - Hands-on and deep experience working in ETL Development, demonstrating proficiency in all stages of the ETL process.
• Mandatory Skills - Strong in SQL Query and Shell Scripting, with a focus on writing efficient, maintainable code.
• Better Communication skill to understand business requirements from SME, facilitating clear communication between technical and non-technical stakeholders.
• Basic knowledge of data modeling, enabling understanding of database structures and relationships.
• Good Understanding of E2E Data Pipeline and Code Optimization, ensuring efficient data flow and processing.

Additional Content for SQL and Complex SQL Coding and Experience:

• Extensive experience in crafting SQL queries for data analysis, reporting, and decision-making purposes.
• Hands-on experience in optimizing SQL queries for large datasets, including index optimization and query plan analysis.
• Demonstrated ability to work with complex data structures and hierarchies within SQL queries, ensuring accurate and efficient data retrieval.
• Experience in designing and implementing database schemas to support ETL processes, including table partitioning and indexing strategies.
• Experience in troubleshooting and resolving performance issues related to SQL queries and database operations.
• Proven track record of delivering high-quality SQL code within tight deadlines and under changing requirements.

Note: Minimum 5-7 years experience.