Sign In
 [New User? Sign Up]
Mobile Version

Data Warehouse Developer

Chennai, TN
Job Code:
  • Miscellaneous
Applying for this job will take you to an external site
  • Shortlist
  • Email Friend
  • Print

Job Details

The role of the Data Warehouse Developer requires a background in data warehousing for reporting and dashboards, strong SQL skills (DB2/SQL Server), ETL knowledge, debugging capabilities, strong team oriented work ethic, and an understanding of business objectives. This role provides access to essential data for multiple reporting and functional applications. This includes Business Objects, JD Edwards and our proprietary applications BV Fusion and Pulse. The analyst will create, maintain and grow products and services that help us achieve our critical strategic initiatives.Job DescriptionEssential Functions1. Development* Develop new tables and universes for the data warehouse used by Business Objects, Pulse, and BV Fusion.* Create stored procedures to effectively return datasets for multiple platforms.* Demonstrate a systemic thought process through all phases of software development.* Participate in open discussions during the analysis and design phases of development.2.Create and Maintain* Optimize current databases, indexes, and stored procedures.* Create and maintain ETL processes using Data Integrator.* Create and maintain technical documentation when developing solutions.* Maintain and enhance existing software using the SDLC process.3. Analysis* Perform technical analysis and design for a given business requirement. This will include setting expectations for what will be needed to complete the project.* Create ad-hoc queries to assist the business and the technology group.* Analyze, debug and make changes to software when assigned.4. Relationships* Build a good rapport and maintain positive relationships with other team members, business analysts, outside customer contacts, and users.5. Accountabilities* Create efficient and scalable code.* Understanding business objectives.* Create well documented code.* Follow and contribute to software development best practices.* Participate in and conduct code reviews.6. Supervisory Responsibility Direct and Indirect* Must maintain confidentiality as this position has access to data used to operate the business.* Must possess the ability to take ownership over a task, demonstrating good organizational and time management skills.* Works independently, but meets with manager weekly to review projects.7. Level of Analytical Thinking and Problem Solving Required* Must understand the abilities and limitations of various software platforms used within Best Vendors. This would include limitations with the database, language, device or end user capabilities.* Must be able to suggest solutions or alternatives when faced with complex business requirements or bug fixes.8. Level of Judgment and Decision Making Required* Works on a combination of assigned and self-initiated projects, which could include ways to improve current solutions or processes.* Makes recommendations and takes action on improving system operations, performance and data integrity.* Understands usability and the end user experience, so to design a solution that will maximize the user experience.9. Major Challenge(s)* Must be able to decipher incomplete or vague design specifications and determine how to create a solution that will meet or exceed the expected results.Education, Training and Experience1. Education and ExperienceRequired* Bachelor s degree or combination of job experience and related course work (3-5 years business data experience).Preferred* Language specific or System certifications are a plus.2. Knowledge, Skills, and AbilitiesRequired* Enterprise reporting universe development.* Enterprise report writing.* Strong SQL background.* ETL development.* Word, Excel, and Outlook.Preferred* JD Edwards experience or similar ERP system.* Business Objects experience.ContactsInternal* Works with management, analysts, and users to gather requirements and discuss solutions.* Will be required to attend design and planning meetings.External* Maintain positive relationship with other sectors and users.Supervision* This position has no supervisory responsibilities.Initiative* Ability to take vague business requests and translate them to functional enhancements/products.* Identify bugs and take control in resolution.
Degree: MCA/ PGDCA

Additional Degree: BE/ B.Tech (Engineering) | BCA (Computer Application)

Experience: 3-5


Application Programming | Data Warehousing | Software Engineer | System Security
Applying for this job will take you to an external site


© Copyright 2015 Al Nisr Publishing LLC - powered by Gulf News