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 sap-or-oracle-financials@googlegroups.com.
Visit this group at https://groups.google.com/group/sap-or-oracle-financials.
For more options, visit https://groups.google.com/d/optout.

Reply via email to