candidate_logo

Data Warehouse / Business Inteligent

  ITBMS India Pvt. Ltd.
   Data Warehouse, PL/SQL, SQL
Pune
Location
Location
Pune
Experience
2 - 7 years
Salary
Not Disclosed
Job Type
Full-Time
Vacancies
5 Openings
Functional Area
IT-software services
Qualification
Graduation
Share this job on:
Posted Date : 05-01-2017
(Job Expired)
candidate_logo
Apply without registration
Job Description

-- Conceptualize, design, and implement database migration, ETL migration, job scheduling implementations. Present viable solution architecture and options to remediate and optimize software.
-- Develop ETL/ ELTL code using SQL, PL/SQL, Java, AWS and Hadoop command-line, and UNIX scripting (No third-party proprietary ETL tool used).
-- Support existing production environments end to end (Data Sourcing, Data Stores, Applications, Clusters, BI). 
-- Support large scale MPP databases (Postgres, AWS Redshift, Greenplum) as a DBA.
-- Provide development and operational services on HortonWorks Hadoop (HDP 2.2). Should be proficient in writing and reviewing Pig, Hive, and MapReduce code.
-- Drive architectural best practices and guidelines on AWS (RDS, Redshift, EC2, S3, etc.)
-- Troubleshoot and fix production tickets based on priority and take tactical and strategic actions.


 

Roles Responsibilites

-- Perform database design, schema change management, and database administration tasks (backups/ restores). Perform proactive and reactive monitoring and performance tuning of operating systems, databases and application code. Review requirements and data models, and translate into ETL design processes that effectively populate data warehouse and data mart tables.
-- Automate repetitive tasks to improve productivity and efficiency Conceptualize, design, and implement innovative solutions using open source, Hadoop, and Cloud Computing technologies.
-- Communicate with the Business Analyst and Data Analyst to fully understand requirements, provide feedback, and request clarification, as needed Follow configuration and change management processes.
-- Maintain source code in GIT, Produce quality software products, utilizing best practice methodology and technology.
-- Lead Agile development as a Scrum Master.

ITBMS is a global IT services company, offering a wide array of solutions customized for a range of key verticals and horizontals. Our unique approach includes implementing solutions to integrate your processes, as well as deploying the best business practices needed to harness the power of information systems more effectively in a global organisation.

Contact Person
Mobile Number
Email
neniprivateA15@gmail.com
Designation
Social Links
Address
Subscribe, to get jobs into your inbox
See other related jobs
PHP, Wordpress Developer

Ikas Technologies Pvt Ltd

   HTML, Jquery, PHP, SQL, Wo...

   2 - 6 Years

     Chennai

Required Database Administr...

Byzan Systems Pvt. Ltd

   Data Warehouse, Database A...

   2 - 6 Years

     Mumbai

Data Warehousing Architect

Brainsearch Consulting Pvt Ltd

   Data Warehouse, ETL, OBIEE...

   9 - 14 years

     Gurgaon, Hyderabad

Enquiry

FeedBack Form