Match score not available

Data ETL Engineer

Remote:

Full Remote

Experience:

Senior (5-10 years)

Work from:

India

Offer summary

Qualifications:

5+ years experience in ELT/ETL design, Mastery in Business Intelligence concepts, Strong SQL and relational database skills, BS/MS in computer science or related field.

Key responsabilities:

Develop and test ELT/ETL solutions
Integrate data into target applications or databases

IDT Corporation Large http://www.idt.net

1001 - 5000 Employees

See more IDT Corporation offers

Job description

This is a full-time work from home opportunity for a star BI data engineer from India.

IDT (www.idt.net) is a US communications and financial services company founded in 1990 and headquartered in New Jersey, US. Today it is an industry leader in prepaid communication and payment services and one of the world’s largest international voice carriers. We are listed on the NYSE, employ over 1500 people across 20+ countries, and have revenues in excess of $1.5 billion.

We are looking for a Mid-level Business Intelligence Engineer to join our global team. If you are highly intelligent, motivated, ambitious, ready to learn and make a direct impact, this is your opportunity! The individual in this role will perform data analysis, ELT/ETL design and support functions to deliver on strategic initiatives to meet organizational goals across many lines of business.

* The interview process will be conducted in English.

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.

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.

Pluses

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