Urgent need Sr.Data warehouse Engineer -King of Prussia,PA-locals preferred
Hi, This is Aparna – Sr. Technical Recruiter from SancroSoft USA Inc We have an urgent requirement as follows: Please respond with resumes in MS-Word Format with the following details to *apa...@sancrosoftusa.com* apa...@sancrosoftusa.com Full Name: Phone Number: Email Id: Visa Status: Willing to relocate : Availability: Rate / Hour : REQUIREMENT DETAILS :** *Sr.Data warehouse Engineer * Location: King of Prussia,PA Duration: 6+ months *Job Description:* Although the primary focus of this role is ETL design/development/support, the ideal candidate will bring a strong mix of full-lifecycle data-warehouse development skills that includes experience with reporting/BI concepts. The resource will function as part of a broader team that is responsible for not only supporting the ETL solution, but supporting the reporting tools and processes that run on a daily basis. Duties include, but are not limited to: - 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 Qualifications: - 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 - 6-9+ years of IT development experience in developing full lifecycle implementations, support, and upgrades. - 6+ years of Data Warehouse experience. - 1+ years of Talend ETL experience strongly desired - 1+ years of SVN experience - 1+ years of Java developer 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 - 2+ years UNIX experience - Excellent written and verbal communicate skills with both technical and non-technical staff - Ability to form durable, flexible work relationships - Portfolio work will include the full SDLC - Requirements, design, development, testing, and deployment Thanks Regards Aparna [image: cid:image001.jpg@01CABACF.F71E38B0] [image: cid:image002.jpg@01CABACF.F71E38B0] ** The power of focus SancroSoft USA INC** 4944 Sunrise Blvd, Suite B-4 || Fair Oaks, CA 95628 Phone : 916-671-5584|| Fax: 916-200-0305 E-Mail : *apa...@sancrosoftusa.com* tho...@sancrosoftusa.com || * www.sancrosoftusa.com* http://www.sancrosoftusa.com/* * The information contained in this email message is intended only for the personal and confidential use of the recipient(s) named above. The message may be privileged and confidential and protected
Urgent need Sr.Data warehouse Engineer -King of Prussia,PA-locals preferred
This is Aparna – Sr. Technical Recruiter from SancroSoft USA Inc We have an urgent requirement as follows: Please respond with resumes in MS-Word Format with the following details to *apa...@sancrosoftusa.com* apa...@sancrosoftusa.com Full Name: Phone Number: Email Id: Visa Status: Willing to relocate : Availability: Rate / Hour : REQUIREMENT DETAILS :** *Sr.Data warehouse Engineer * Location: King of Prussia,PA Duration: 6+ months *Job Description:* Although the primary focus of this role is ETL design/development/support, the ideal candidate will bring a strong mix of full-lifecycle data-warehouse development skills that includes experience with reporting/BI concepts. The resource will function as part of a broader team that is responsible for not only supporting the ETL solution, but supporting the reporting tools and processes that run on a daily basis. Duties include, but are not limited to: - 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 Qualifications: - 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 - 6-9+ years of IT development experience in developing full lifecycle implementations, support, and upgrades. - 6+ years of Data Warehouse experience. - 1+ years of Talend ETL experience strongly desired - 1+ years of SVN experience - 1+ years of Java developer 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 - 2+ years UNIX experience - Excellent written and verbal communicate skills with both technical and non-technical staff - Ability to form durable, flexible work relationships - Portfolio work will include the full SDLC - Requirements, design, development, testing, and deployment Thanks Regards Aparna [image: cid:image001.jpg@01CABACF.F71E38B0] [image: cid:image002.jpg@01CABACF.F71E38B0] ** The power of focus SancroSoft USA INC** 4944 Sunrise Blvd, Suite B-4 || Fair Oaks, CA 95628 Phone : 916-671-5584|| Fax: 916-200-0305 E-Mail : *apa...@sancrosoftusa.com* tho...@sancrosoftusa.com || * www.sancrosoftusa.com* http://www.sancrosoftusa.com/* * The information contained in this email message is intended only for the personal and confidential use of the recipient(s) named above. The message may be privileged and confidential and protected from