A new Job, ID: 161784 <http://www.ejobsville.com/display-job/161784> was added at eJobsVille.com - For the Best Tech Jobs in Town<http://www.ejobsville.com>
Title: ETL/BI Data Warehouse Developer (EAD, GC, Citizens or TN Visa only) posted on 2014-05-02 08:15:29 Job Description:*Job Title: ETL/BI Data Warehouse Developer (EAD, GC, Citizens or TN Visa only)* *Location: Carrollton, TX* *Duration: 4-6 month + (Possibly Convert CTH)* *Job Description:* 1. Building a new data warehouse in SQL 2012 2. New product, hasn’t been launched; high-visibility with new product development team 3. This type of product is not in the industry currently 4. Highly technical manager who the existing team really respects 5. Has huge amounts of data and own a majority of the customers in their vertical *Top Skills:* · Strong ETL design and build using SSIS · T-SQL · Must be able to explain Kimball methodology · SQL 2012 Kimball/Inmon, SSIS, Cognos (nice, but not required) *Project Details:* · UDS Central Reporting team - new product, not launched yet · Strong SSIS, ETL, T-SQL · Be able to explain Kimball methodology in an interview · Building data warehouse in SQL 2012 (do not have to have 2012 experience, just heavy 2008 R2) · Building macro reporting tool that will compare/contract a portfolio of properties for executives (tool like this doesn’t exist in the market currently). Includes benchmarking capability and shows how the properties are doing. · Cognos experience would be nice but not required · Not using out of the box Cognos reports- they have a Cognos UX SME who is creating a beautiful layer over the reporting system that makes everything really unique. · Avoid folks with heavy consulting/contracting background. They need someone who’s not going to come in and try to shake things up. Be a team player, transition into the existing processes and team well. · Team highly respects Tom, the manager, he’s very technical *Description:* *ETL DEVELOPER* You will support the implementation and integration of data warehouses, data marts, and cubes. You will also perform data warehouse design and construction; perform extensive testing, as well as ETL and repository creation. This position will coordinate with other team members and managers to translate business needs into technical solutions. This position will troubleshoot issues in cubes, ETL packages and databases to identify and solve problems with data accuracy and performance. *PRIMARY RESPONSIBILITIES* - Develop, deploy, maintain, support, and debug SSIS packages. - Evaluate and monitor databases to resolve performance issues. - Interpret business processes to develop data entity structures, star schemas, measures, and cubes. - Develop, test and maintain MS SQL Server databases in the BI Product environment. - Develop application/inter-application test plans; assist in the development of data requirement test scenarios and verify test results. - Develop, deploy, maintain, support, and debug Cognos framework, reports and dashboards. - Investigate and resolve problems of data accuracy and availability. - Participate in design and code reviews. - Participate in internal testing to identify problems early, perform error and stress scenarios. - Will work with Business Analysts to aid in the design of the system. - Identify architectural issues and propose alternative solutions. - Install upgrades and patches to existing databases. - Develop and maintain data warehouse environment documentation. *REQUIRED KNOWLEDGE/SKILLS/ABILITIES* - Bachelor’s degree in computer related field preferred, or equivalent experience - Minimum 5 years’ experience in Microsoft SQL Server database administration; database monitoring and performance tuning, stored procedures, triggers, cursors, and views - Minimum of 2 years’ experience using Microsoft SQL Server 2005 - Experience developing ETL processes loading Data Warehouses/Data Marts required - Experience using SSIS packages required - Experience with Cognos 8 framework, connection, CAFÉ, reports, or dashboards - Experience utilizing Kimball method of Data Warehousing a plus - Excellent understanding of RDBM (Relationship Database Management) - Knowledge of best practices and software development process (full SDLC) - Experience supporting a multi-database environment - Ability to work independently with little or no supervision - Outstanding analytical and problem solving skills - Strong written and verbal communication skills - Ability to effectively prioritize and escalate issues - Demonstrated ability to troubleshoot software/database issues independently - Ability to work extended hours when needed Job Requirements: *EAD, GC, Citizens or TN Visa only etl, sql or ssis 2012, TSQL, datawarehouse, Kimball/Inmon* *Click here to view full job description and apply <http://www.ejobsville.com/display-job/161784> (Registration not mandatory to apply for this job)* ------------------------------ Best regards, eJobsVille.com - For The Best Tech Jobs In Town . -- You received this message because you are subscribed to the Google Groups "Oracle-Projects" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracle-projects+unsubscr...@googlegroups.com. To post to this group, send email to oracle-projects@googlegroups.com. Visit this group at http://groups.google.com/group/oracle-projects. For more options, visit https://groups.google.com/d/optout.
