ETL Developer is responsible for Design and Development of ETL Jobs which follow standards, best practices and are maintainable, modular and reusable.
ETL Developer will analyze and review complex object and data models and the metadata repository in order to structure the processes and data for better management and efficient access.
Working on multiple projects, and delegating work to Junior Analysts to deliver projects on time.
Training and mentoring Junior Analysts and building their proficiency in the ETL process.
Preparing mapping document to extract, transform, and load data ensuring compatibility with all tables and requirement specifications.
Experience in ETL system design and development with Talend / Pentaho PDI is essential.
Create quality rules in Talend.
Tune Talend / Pentaho jobs for performance optimization.
Write relational(sql) and multidimensional(mdx) database queries.
Functional Knowledge of Talend Adminstration Center/ Pentaho data integrator, Job Servers & Load balancing setup, and all its administrative functions.
Develop, maintain, and enhance unit test suites to verify the accuracy of ETL processes, dimensional data, OLAP cubes and various forms of BI content including reports, dashboards, and analytical models.
Exposure in Map Reduce components of Talend / Pentaho PDI.
Creating and deploying Talend / Pentaho custom components is an add-on advantage.
Nice to have java knowledge
BE, B.Tech / MS Degree in Computer Science, Engineering or a related subject.
Having an experience of 2 - 3+ years.
Comprehensive understanding and working knowledge in Data Warehouse loading, tuning, and maintenance.
Proficiency with Talend or Pentaho Data Integration / Kettle.
Working knowledge of relational database theory and dimensional database models.
Ability to work independently.
Company Name: Helical IT Solutions
Location: Hyderabad, India
Share your resumes or the one's who are interested at email@example.com