Add office photos
All Filters
2 Institute of Design and Technology Jobs
Data ETL Engineer
5-6 years
Pune, Bangalore / Bengaluru
1 vacancy
Data ETL Engineer
Institute of Design and Technology
posted 24d ago
Job Role Insights
Fixed timing
Key skills for the job
Job Description
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
- Experience with scripting languages like Python, Shell, JavaScript.
- Education: BS/MS in computer science, Information Systems or a related technical field or equivalent industry expertise.
Employment Type: Full Time, Permanent
Read full job description What people at Institute of Design and Technology are saying
What Institute of Design and Technology employees are saying about work life
based on 5 employees
Strict timing
Monday to Saturday
No travel
Day Shift
Institute of Design and Technology Benefits
View more benefits
Compare Institute of Design and Technology with
TCS
Compare
Accenture
Compare
Wipro
Compare
Cognizant
Compare
Capgemini
Compare
HDFC Bank
Compare
ICICI Bank
Compare
Infosys
Compare
HCLTech
Compare
Tech Mahindra
Compare
Genpact
Compare
Teleperformance
Compare
Concentrix Corporation
Compare
Axis Bank
Compare
Amazon
Compare
Jio
Compare
Reliance Retail
Compare
IBM
Compare
iEnergizer
Compare
LTIMindtree
Compare
Similar Jobs for you
Share an Interview