Data Modeler
Location: New York, NY, us
Company Description
3S Business Corporation is a specialized Software & Consulting Services Provider based in Houston, TX, which helps clients plan, implement and maintain their technology investments cost effectively while improving the business performance. 3S Business Corporation’s customers find it to be nimble, responsive and committed not only to project & services success, but to constantly delivering customer value. We work with fortune 500 companies, several prime vendors and provide placements to our candidates with these companies. We are a primary supplier to direct clients and major SAP implementation partners. 3S Business Corporation partnership and alliances with global leaders helps to work on the latest technologies to provide business efficiencies for customers and partners
Job Description
- 10+ years in Information Technology with Expertise in Data modeling for Data Warehouse/Data Mart development, Data Warehousing (OLAP)/Business Intelligence (BI) applications and Data Analysis for Online Transaction Processing (OLTP).
• - Facilitated data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.
• - Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• - Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• - Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• - Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
• - Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.
• - Familiarity and experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers
• - Good understanding of views, Synonyms, Indexes, Joins and Partitioning.
• - Experience in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Microsoft SSIS and Informatica.
• - Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository.
• - Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
• - Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, data types, volumetric, domain definitions, and corporate meta-data definitions.
• - Exceptional communication and presentation skills and established track record of client interactions
Qualifications
Technical Skills
• Data Modeling Tools: Erwin and ER studio
• OLAP Tools: SAP Business Objects
• ETL Tools: Microsoft SSIS and Informatica 7.1.3
• Database Tools: Microsoft SQL Server 2000/2005/2008,2012
• Packages: Microsoft Office Suite, Microsoft Project 2010, SAP Business Objects
• Operating Systems: Microsoft Windows 9x/NT/2000/XP/Vista/7 and UNIX
Additional Information
Exp. On the Service cloud or Tech Support that we need from SFDC standpoint
There are more than 50,000 engineering jobs:
Subscribe to membership and unlock all jobs
Engineering Jobs
60,000+ jobs from 4,500+ well-funded companies
Updated Daily
New jobs are added every day as companies post them
Refined Search
Use filters like skill, location, etc to narrow results
Become a member
🥳🥳🥳 452 happy customers and counting...
Overall, over 80% of customers chose to renew their subscriptions after the initial sign-up.
To try it out
For active job seekers
For those who are passive looking
Cancel anytime
Frequently Asked Questions
- We prioritize job seekers as our customers, unlike bigger job sites, by charging a small fee to provide them with curated access to the best companies and up-to-date jobs. This focus allows us to deliver a more personalized and effective job search experience.
- We've got over 200,000 jobs from 15,000+ vetted companies. No fake or sleazy jobs here!
- We aggregate jobs from 15,000+ companies' career pages, so you can be sure that you're getting the most up-to-date and relevant jobs.
- We're the only job board *for* software engineers, *by* software engineers… in case you needed a reminder! We add thousands of new jobs daily and offer powerful search filters just for you. 🛠️
- Every single hour! We add 2,000-3,000 new jobs daily, so you'll always have fresh opportunities. 🚀
- Typically, job searches take 3-6 months. EchoJobs helps you spend more time applying and less time hunting. 🎯
- Check daily! We're always updating with new jobs. Set up job alerts for even quicker access. 📅
What Fellow Engineers Say