Sr Oracle Pl/sql Programmer - Data Warehouse Development

Soft tech Career Info system Pvt. Ltd
  • Bangalore
  • 10-20 lakh
  • 3-8 years
  • Views
  • 08 Nov 2016

  • Business Analytics

  • IT/ Technology - Software/ Services
Job Description

Position Summary:

The Sr. developer's job is to design, execute and direct data engineering solutions including data extraction, and data manipulation. The role will involve translating business objectives into data and analytics solutions using appropriate data engineering, analytics, visualization and dashboard applications. The Sr. developer will support the Business Insights Group in extending and innovating our big data and analytic capabilities. They will assist the Business Insights Group and business units with data validations, data extractions, and analysis of large and complex datasets.

The position will connect key users to data both within the department and across the organization, and will entail significant daily interactions of all levels of personnel, including VPs, Managers, Developers, Project Managers, and external consultants.

Responsibilities & Duties :

- Develop and/or implement tools for data acquisition, extraction, transformation, management, and manipulation of large and complex data sets

- Explore, model, mine and experiment with data to answer critical business issues

- Support and train business units in use of data and visualization tools to generate and communicate insights and to expand the use of data science analytics/Big Data

- Work with the Analytics Group and business unit analysts to define data requirements and plan data acquisition

- Work with business units to extract large or complex data sets from EIT (Enterprise Information Technology) sources (structured and unstructured)

- Facilitating data merging and transformation in preparation for analysis by planning the process and either executing directly or training business units to implement directly

- Keep abreast of new and current data science/big data techniques

- Communicate with and educate both senior and junior colleagues to further embed data science and analytics across the organization

- Communicate effectively with analytics/data experts, business leaders, executives inside and outside of Cablevision to assess opportunities and develop data driven solutions

- Assist the Director and EIT group (Enterprise Information Technology) in designing and implementing the data architecture, analytics, environment, and best practices for analyzing large or complex data sets.

Qualifications :

- Bachelor's degree or higher in a quantitative discipline such as Statistics, Mathematics, Engineering, Computer Science, Econometrics or information sciences such as business analytics or informatics

- 5+ years experience in data warehousing development, large scale data acquisition, transformation, and cleaning, both structured and unstructured data

- SQL expertise and data modeling experience including competencies in database architectures such as relative, star and snowflake schemas. Demonstrated experience with data warehousing technologies (e.g. Oracle, Netezza, Teradata, MS SQL Server, Vertica, MySQL)

- Experience with Business Intelligence tools (e.g. MicroStrategy, Tableau, Qlikview, Tibco Spotfire)

- Excellent oral and written communication skills a must

- Ability to collaborate with people at all levels

- Understanding of OLAP business intelligence applications

- Strong analytical, problem solving and communication skills, including mapping of business need or issue to development of application requirements or procedural initiatives

- Strong understanding of reporting and database environments, processes, ad associated applications

- Well-developed knowledge of operational systems, processes and budgeting/forecasting concepts and activities

- Proven ability to ensure effective forms of documentation essential for support of overall technical and user needs.

Job Posted By

O.P. Chawla