Bangalore
6 days ago
Developer III - Software Engineering

We are looking for an experienced ETL Developer with strong DBA skills to manage and maintain our data architecture, optimize data flows, and ensure database performance. This role will focus on developing and maintaining ETL (Extract, Transform, Load) processes, as well as database administration, optimization, and data integrity to support analytical needs and operational systems. Key Responsibilities: ETL Development: Design, develop, and maintain efficient ETL pipelines to support data ingestion, transformation, and loading processes. Collaborate with business and technical teams to understand requirements and develop ETL solutions. Implement data cleansing, standardization, and transformation rules to ensure high data quality and consistency. Automate data workflows to optimize ETL processes and reduce manual intervention. Troubleshoot and resolve ETL issues, ensuring timely data availability. Database Administration: Oversee and maintain database systems (e.g., Oracle, MySQL, SQL Server, PostgreSQL, etc.) to ensure reliability, security, and optimal performance. Monitor and optimize database performance, manage indexing, and execute database tuning tasks. Implement and maintain data backup and recovery strategies, ensuring data integrity and compliance. Perform database security checks, access control, and user account management to secure sensitive data. Perform database migrations, upgrades, and patches as needed. Data Management & Collaboration: Work closely with data analysts, data scientists, and business stakeholders to support reporting and analytical requirements. Conduct performance tuning of ETL processes and data integration to improve response time for analytics. Develop and maintain documentation for ETL processes, data schemas, and database administration procedures. Assist in designing and implementing data architecture and governance standards across projects. Experience: Minimum 3+ years of experience in ETL development and database administration. Technical Skills: Proficiency in ETL tools (e.g., Informatica, Talend, Apache Nifi, SSIS). Strong SQL skills, including experience with stored procedures, functions, triggers, and complex queries. Familiarity with at least one major RDBMS (Oracle, SQL Server, PostgreSQL, MySQL). Hands-on experience with database optimization and tuning, including indexing, partitioning, and query optimization. Experience with data warehousing concepts and data modeling. Familiarity with data lake and cloud-based databases (e.g., AWS Redshift, Google BigQuery, Azure SQL Database) is a plus. Soft Skills: Strong analytical and problem-solving skills. Excellent communication and collaboration abilities to work with cross-functional teams. Attention to detail and commitment to data quality and security.

Confirm your E-mail: Send Email