Responsible for developing, deploying, monitoring and maintaining ETL Jobs, convert existing SQL scripts into ETL platform and data mining and text analytics
What you'll beResponsible for?
? Design and construction of various enterprise procedure constructs using PentahoDI
? Provide accurate work estimates and manager efforts across multiple lines of work
? Research and prototype innovative solutions using Big Data technologies like Elasticsearch, Hadoop, MongoDB, etc.
? Design and develop exception handling and data cleansing/standardization procedures
? Requirement gathering from various stakeholders related to ETL automation
? Designing and creating the data extraction, transformation, and load of data functions
? Data modelling of complex large data sets
? Manage new Demand, Solution Scope and Design of ETL request
? Perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications
What you'd have ?
? 5-7 years of experience in design and development of large-scale enterprise ETL solutions
? Experience in open source ETL tool primarily PentahoDI (minimum 2 year) essential
? Knowledge and Skills
? Experience in full lifecycle software development and production support for DWH systems
? Experience in data analysis, modelling (logical and physical data models) and design specific to a DWH/BI environment (normalized and multi-dimensional modelling)
? Exposure in development of ETL packages and job using SPOON
? Exposure in scheduling Pentaho ETL Jobs in crontab (i.e. Kitchen)
? Exposure in Hadoop, Hive and PIG
? Experience in SQL scripting for relational databases such as MySQL, PostgreSQL, etc
? Experience in data loading tools like Flume, Sqoop
? Knowledge of workflow/schedulers like Oozie
? Knowledge of migrating existing dataflows into Big Data platforms
? Experience in any opensource BI will be an added advantage
Why join us?
We thought you'd never ask! We offer all the usual stuff: competitive salary, flexible working hours, challenging product culture But the real perks are:
? Challenging and fun work environment solving meaningful real life business problems - you'll never have a boring day at the office.
? World class team who love solving tough problems and have a bias for action. Tanla is an equal opportunity employer.
We welcome and encourage diversity in the workplace regardless of race, gender, religion, age, sexual orientation, gender identity, disability, or veteran status.