Data Modeler Architect

Company DescriptionSonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.Job DescriptionAt least 7 years of experience in DW/BI related technologies and tools – MUSTAt least 6 years of experience in Design and Architecture reviewAt least 6 years of experience in Data Modelling/Data Architect Architecting BI solutions in consultation with the architecture group/IT team/users which are best suited to solve a specific business needs..Collaborating with the enterprise architects for periodic assessment of the AS-IS system and if required recommending the improvements to BI IT stakeholders..Collaborating with the enterprise architects to define and regularly revisit BI best practices/guidelines in accordance to the industry.Interacting with the business users to understand the challenges faced by the users and documenting/communicating the same to the BI IT stakeholders.Understanding of Unix/Linux system, file systems, shell scriptingExperience with design and implementation of ETL/ELT framework for complex warehouses/martsHands-on development mentality, with a willingness to troubleshoot and solve complex problemsAbility to work in team in diverse/ multiple stakeholder environmentExperience in Cards and Payments domain.Experience and desire to work in a Global delivery environment.Hands on working exp in understanding business requirements, business rules and data requirements from Data modeling perspective.Analyze the requirements; construct the conceptual/logical model to support the requirements.Experience in meta data practices, standards and procedures.Experience in creating high-level data flow diagram.Hands on exp with conceptual, logical, & physical model development.Generate the DDLs and deploy them in the respective environments.Publish database change log, data model diagram and data dictionary reports to project team.Guide and support developers while they are developing against the development database.Support developers and QS resources while they are performing tests against the QA environment.Review actual table usage against physical data models to insure compliance with established standards, policies, and performance guidelines..QualificationsBachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.Minimum of 7 years of work experience in the Information Technology Field.At least 7 years of experience with DW/BI and related tools, Data modelling, Data Architect..Additional Information** U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.Note:-This is a Full-Time Permanent job opportunity for you.Only US Citizen, Green Card Holder, TN Visa, GC-EAD, H4-EAD & L2-EAD can apply.No OPT-EAD & H1B Consultants please.Please mention your Visa Status in your emailor resume.SummaryType: Full-timeFunction: Information TechnologyExperience level: Mid-Senior LevelIndustry: Information Technology And Services