*Hi ,* * Please check the job description and if you are interested on this position Kindly give reply to [email protected] <[email protected]>*
*Title: BI/SQL Developer* *Location: * *Chicago IL * *Duration: **6 mths+* *Must be local, F2F interview required* *Background: SQL Server, SSIS, ETL, Informatica* Create cutting-edge data architecture and ETL solutions for multiple data platforms, collaborate with business subject matter experts in healthcare industries, establish and drive data architecture thought leadership. The focus of this position will be on defining and promoting best practices in ETL/Data architecture and data modeling by collaborating with data intake team, DBA and developers to provide sound data framework for applications, easy data access for analysts on multiple data platforms (Vertica, SQL Server). This role will be responsible for creating and maintaining enterprise wide data dictionary, data-model and data architecture artifacts. Position involves rapidly developing dimensional models or analytical data sets based on specific business requirements. Strong foundation in industry standard SQL and Data Warehousing design concepts is required. Experience with BI and Informatica ETL is required. Experience with advanced analytics, Vertica, Hadoop, data mining is a very big plus. Any experience with implementing a metadata management system is a plus. *Skills: * - Analyzing functional and non-functional business requirements and translate into technical data requirements and create or update existing logical and physical data models - Creating and maintaining logical and physical data models and refining as necessary - Facilitating data modeling and ETL architecture sessions ranging from information gathering, model validation to ETL development - Creating the data architecture sections of the overall system design artifact - Analyzing data access and modification requirements to ensure SQL and optimal DB design - DB Design of Relational structures along with data warehouses, data marts and data mining *Experience:* - At least 10 year experience in combined experience in *data warehousing, BI and application development*. - At least 5 year hands on experience designing and implementing *Star Schemas* - At least 5 year experience implementing DW presentation layer - including design and definition of logical tables, physical sources, dimensions, columns, aggregation rules - At least 5 year experience in writing advanced SQL queries, views, and optimization of SQL queries - At least 5 years’ experience with Informatica and other ETL tools. - At least 2 year hands on experience with 3NF Data Modeling and NORMALIZED schema *Best Regards,* *Samir Mondal* *Executive Talent Acquition* *T: 248.565.4747* 130* * Email/**Gtalk**: [email protected] <[email protected]>* *www.tekshapers.com <http://www.tekshapers.com/>* *https://www.linkedin.com/profile/public-profile-settings?trk=prof-edit-edit-public_profile <https://www.linkedin.com/profile/public-profile-settings?trk=prof-edit-edit-public_profile>* -- You received this message because you are subscribed to the Google Groups "CorptoCorp" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/corptocorp. For more options, visit https://groups.google.com/d/optout.
