Data Etl Engineer

Summary

Join IDT, a leading US communications and financial services company, as a Mid-level Business Intelligence Engineer! This full-time, work-from-home position based in India offers the opportunity to contribute directly to strategic initiatives. You will develop, document, and test ELT/ETL solutions using industry-standard tools like Snowflake and Looker. Collaboration with QA and a focus on process improvement are key aspects of this role. The ideal candidate possesses extensive experience in data analysis, ELT/ETL design, and database technologies. This is a chance to make a significant impact in a dynamic and growing organization.

Requirements

• 5+ years experience in ELT/ETL design, development and populating data warehouses from heterogeneous OLTP or API sources
• Excellent English communication skills
• Mastery in Business Intelligence and Data warehousing concepts and methodologies
• Extensive experience in data analysis and root cause analysis and proven problem solving and analytical thinking capabilities
• Extensive expertise on Databases, data acquisition, ELT/ETL strategies and tools and technologies using Pentaho/Kettle Data Integration/ Ab Initio ETL tool
• Should have experience designing complex ELT/ETL’s extracting data from RDBMS, JSON, API and Flat file sources
• Strong SQL programming skills, relational database skills with expertise in cloud RDBMS systems like Snowflake, Oracle DB, MySql, Redshift, etc
• Should be able to analyze poorly performing queries ELT/ETL mappings and provide suggestions to tune them
• Understanding of software engineering principles and skills working on Unix/Linux/Windows Operating systems, Agile
• Exposure to Standard support ticket management tools like JIRA / Git
• Interest in business and the understanding of how strong BI systems drive corporate profitability
• Education: BS/MS in computer science, Information Systems or a related technical field or equivalent industry expertise

Responsibilities

• Develop, document, and test ELT/ETL solutions using industry standard tools (Snowflake, Denodo Data Virtualization, Looker)
• Recommend process improvements to increase efficiency and reliability in ELT/ETL development
• Extract data from multiple sources, integrate disparate data into a common data model, and integrate data into a target database, application, or file using efficient ELT/ ETL processes
• Collaborate with Quality Assurance resources to debug ELT/ETL development and ensure the timely delivery of products
• Should be willing to explore and learn new technologies and concepts to provide the right kind of solution
• Target and result oriented with strong end user focus
• Effective oral and written communication skills with BI team and user community

Preferred Qualifications

• Experience with cloud data warehousing (Snowflake)
• Experience with the Ab Initio ETL tool is desirable
• Experience with AWS cloud is also a plus
• Experience with reporting/visualization tools a plus (e.g., Looker) and job scheduler software
• Experience in Telecom, eCommerce, International Mobile Top-up
• Experience with scripting languages like Python, Shell, JavaScript

Benefits

Full-time, work-from-home position