Data Warehouse / Business Inteligent (2-7 Years)

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

Keyskills : Data Warehouse PL/SQL SQL


Job Summary

5 Openings
IT-software services
IT/ Software/ Services
Graduation

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

Email
neniprivateA15@gmail.com
Social Links
Links
Address

See other Courses

Share job on :