Multiple openings with immediate interview are given below with full JD:
*Position 1: Data Warehouse Architect*(Need GC/USC) *Position 2: Data Warehouse Engineer*(Need GC/USC) ----------------------------------------------------------------------------- Position: Data Warehouse Architect(Need GC/USC) Location: Chicago, IL Duration: Long Term Interview Mode: Phone + Skype A. ArchitectA. Position Description1. A self-starting, hands-on Data Warehouse architect with full data life-cycle responsibility for a multi-billion dollar Global Real Estate management firm’s Data Warehouse.B. Principal Accountabilities1. Maintain Data Warehouse data management strategies, guiding principles, processes and standards.2. Maintain Conceptual, Logical, and Physical Data Models.3. Ensure data models are in compliance with Standards.4. Set up and administer all database objects for the DW in SQL Server 2014 or higher5. Assist Informatica Lead and ETL developers for Physical DDL creation 6. Assist Cognos Lead and report developers in mapping report requirements to data model, Report development, Report Metadata, etc.7. Assist in Data Quality research and UAT8. Write technical and business documents as well as produce and deliver oral presentations.9. Troubleshoot and optimize the performance of Cognos reports, Informatica and SSIS packages, triggers, stored procedures, and related database objects10. Direct the efforts of the local and offshore data team membersC. Required Skills1. Proven knowledge and experience implementing large scale BI/Data Warehouse solutions2. Demonstrable record of data warehouse and ETL architectures, concepts and technologies. 3. Development and usage of Data Warehousing best practices and standards4. Data Modeling and implementation experience (conceptual, logical and physical schemas, database creation and maintenance)5. Analyze business requirements in various business functional areas and translate them into data models. 6. Highly organized and capable of handling multiple projects and priorities simultaneously7. Ability to think independently and work with various teams on projects8. Ability to lead Data team to solve big problems with significant ambiguity9. Proactive and diligent in identifying and communicating scope, design, development issues and recommending potential solutions10. Database Administration and Development skills including triggers, stored procedures11. Excellent problem-solving skills, troubleshooting, and root cause analysis12. Able to coach and mentor other team membersD. Required Experience1. 10+ years of data warehouse architecture and implementation experience including hands-on solution design, architecture, development, and administration2. 7+ years developing solutions using relational databases3. 3+ years of Data Modeling experience (Data Warehouse conceptual, logical and physical schemas)4. 5+ years Expertise with Microsoft SQL Server 2012 or higher database technologies and structures5. 5+ years SQL Server performance tuning and ETL optimization6. Demonstrated skills creating and maintaining end to end data architectures including conceptual, logical, and physical data modeling, preferably with Informatica and SQL Server technologies7. Expert level skills in Logical and Physical Data Modeling E. Desired Experience1. Informatica ETL2. Cognos report development3. SSIS, SSAS, SSRS, Microsoft BI 4. Mixed on-shore and off-shore management and development *-------------------------------------------------------------------------* Position: Data Warehouse Engineer(Need GC/USC) Location: Chicago, IL Duration: Long Term Interview Mode: Phone + Skype A. EngineerA. Position Description1. A self-starting Senior SQL Server Data Warehouse developer with full development responsibility for a multi-billion dollar Global real estate management firm’s Data WarehouseB. Principal Accountabilities1. Create, administer, and maintain the SQL Server objects required to support the Data Warehouse2. Assist ETL team in developing source to target mapping.3. Assist Cognos Lead in mapping report requirements to data model.4. Source System of Record data analysis and source to target design.5. Assist in Data Quality research and UAT.6. Work with Informatica ETL developers for ETL & DBA for Physical DDL creation & 7. Work with Cognos Report Developers in Report development, Report Metadata, etc.8. Troubleshoot and optimize the performance of Cognos reports, Informatica ETL packages9. Troubleshoot and optimize the performance of SQL Server objects including SSIS, stored procedures, triggers, views, etc. C. Required Skills1. Extensive experience with SQL Server and ETL, including Integration Services.2. Excellent knowledge of databases, data warehouse/modeling concepts and understanding of business intelligence.3. Extensive experience with Stored Procedures, Triggers, Views, and Functions.4. Query performance analysis and tuning.5. Excellent problem solving and critical thinking skills.6. Excellent analytical skills, documentation, and ability to work in teams and/or independently.7. Fast learner.8. ETL development using a variety of tools to meet all technical specifications and business requirements according to the established designsD. Required Experience1. 5+ years SQL Server development including triggers, stored procedures, SSIS, views2. Expertise with Microsoft SQL Server 2012 or higher database technologies and structuresE. Desired Experience1. Informatica ETL2. Cognos report development3. SSIS, SSAS, SSRS, Microsoft BI 4. Mixed on-shore and off-shore development *Thanks & Regards,* *Ashutosh Singh* *Sr. IT Recruiter- LEAD* *Contact No.:614-662-1007* *Office ID: **ashut...@technocraftsol.com <ashut...@technocraftsol.com>* *Yahoo/ Gmail ID: ashu.technocraft* *Linked-in: https://www.linkedin.com/home?trk=nav_responsive_tab_home <https://www.linkedin.com/home?trk=nav_responsive_tab_home>* *Note: *Technocraft Solutions LLC works with Direct Client’s and Preferred Vendors Nationwide. Your confirmation would means that you understand the level of Technocraft Solutions LLC association for the mentioned project and will not approach Technocraft Solutions LLC Client directly. -- You received this message because you are subscribed to the Google Groups "SAP or Oracle Financials" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-or-oracle-financials+unsubscr...@googlegroups.com. To post to this group, send email to email@example.com. Visit this group at https://groups.google.com/group/sap-or-oracle-financials. For more options, visit https://groups.google.com/d/optout.