*Senior Data warehouse * Location : King of Prussia, PA,NJ,NY,VA Duration : 6-12 Months
******For Immediate feedback please forward your resume to [email protected] *********** REQUIREMENTS: 6-9+ years of IT development experience in developing full lifecycle implementations, support, and upgrades. 6+ years of Data Warehouse experience. 3+ years of experience with ETL tool, preferably Sagent, DataStage or Informatica 6+ years of relational database experience (SQL, tuning, optimizer, relational concepts) Oracle specific and PL/SQL skills is preferred Strong MS Windows OS knowledge 2+ years UNIX experience Excellent written and verbal communicate skills with both technical and non-technical staff Ability to form durable, flexible work relationships The candidates will be working on portfolio and production support tasks (PS Tickets) as required. Portfolio work will include the full SDLC Requirements, design, development, testing, and deployment Perform hands-on design, development and testing within the ETL tool environment using a mixture of GUI driven tools and hands-on SQL Provide ETL design, development and testing estimations based business requirements and research into data that is currently sourced. Interface with the BI Team to support the design of reports and dashboards meeting business requirements downstream. As part of a rotating team schedule, provide on-call, off-hour support for ETL and Data Warehouse systems that are under strict SLAs for 24/7 availability Educate client management and business users on business value and capabilities of data warehousing Provide advice and guidance on data warehousing approaches and solutions, and use of data warehousing methodology Assist in identifying and prioritizing business information needs, and defining business benefit of data warehousing Assist in evaluating and selecting data warehousing tools for business intelligence, data population, data management, metadata management, and warehouse administration Responsible for supporting the architecture and design of the data warehouse, data marts and BI reports which will support various data initiatives Identify data warehousing issues and assist in their resolution Review project work products, including project work plans, business activity and information models, test plans, content storage design, and application component design Performs table and interface design, development of logical and physical data model/database, ETL processes, BI reporting/OLAP cubes/OLAP reporting, and population and tuning of databases/ETL processes/BI reports/queries while meeting business/user requirements Facilitates requirements definition and contributes to documentation of project and system documentation Provide infrastructure support for the BI/ETL environment Research and analyze various data source systems, applications and perform data research/analysis Provide project, system and other technical documentation as required Bachelor's degree in Computer Science, Information Technology or related field Strong SQL Skills Knowledge of ETL tool inner workings, appropriate design techniques to support restartability, and high volume data load techniques Knowledge of a BI/reporting tool functions and report execution/performance concepts Ability to work on multiple small projects simultaneously, multi-tasking and balancing work based on priority Thanks and Regards. . Neev Roy , Sr. Technical Recruiter, CAT Technology Inc. Committed to Human Excellence Through IT 377 Route 17 South Hasbrouck Heights, New Jersey Voice: 201 257 5081 x 283 Fax: 201 727 9296 Email 2 : [email protected] Visit us at www.catamerica.com -- You received this message because you are subscribed to the Google Groups "CorptoCorp" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/corptocorp?hl=en.
