Data Warehouse / Business Inteligent (2-7 Years)

Posted on 05-Jan-2017 (Job Expired) by : ITBMS India Pvt. Ltd.
Not Disclosed

Keyskills : Data Warehouse PL/SQL SQL

Job Summary

5 Openings
IT-software services
IT/ Software/ Services

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 & Responsibilities

    -- 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.

Company Profile

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.

Recruiter Details

Social Links

See other Courses

Share job on :
Urgent Openings for SAS Base and Teradata (4-7 Years)
Enfluence It Services pvt. Ltd
Not Disclosed
Keyskills : SAS SQL Teradata

Java Developer: 1 - 3 Years (1-3 Years)
Fidelis Corporate Solutions Private ltd
Not Disclosed
Keyskills : CoreJava OOPS PL/SQL SQL