Design, validate, publish logical and physical data models; evaluate and tune DW databases; manage metadata and documentation; collaborate with BAs, architects, DBAs, and developers; support data governance and quality; enforce naming standards and validate business use cases.
Company Description
Sonsoft , 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.
Mandatory Technical Skills
- Have strong experience in databases like Teradata, Netezza or Oracle
- Good Experience in Unix Environment
- Good experience in Industry standard data modeling tools like Erwin.
- Experience in Performance tuning in DW environment.
- Experience on data modeling using Dimensional as well as ER-Model
- Have working Knowledge of Industry Standard Reporting/ETL tools.
Preferred/Good to have
- Worked in both OLTP and DW implementation
- Have good understanding of the new technologies i.e. No SQL, Open source Technologies, Columnar databases.
- Ability to work in team in diverse/ multiple stakeholder environment.
- Analytical skills.
- Experience and desire to work in a Global delivery environment.
Job description
- Person needs to Interacting with Project stake holders to understand functional as well as technical requirements and documenting, publishing to Team.
- Experience in developing, validating, publishing, maintaining LOGICAL data models with exposure to or experience in developing, validating, publishing, maintaining PHYSICAL data models
- Evaluate existing data models and physical databases for variances and discrepancies
- Experience with managing meta data for data models
- To develop, publish, maintain all documentation for data models
- Work with Business Analysts, Data Architects, Software developers, DBAs to achieve project objectives - delivery dates, cost objectives, quality objectives, business customer satisfaction objectives, etc.
- Take part Data Quality, Data governance processes
- Leverage and enforce standards for data naming conventions to ensure consistency and reuse of data models
- Validate business use cases for accuracy and completeness of proposed data models.
- Ability to communicate strategies and processes around data modeling and architecture to cross functional groups and senior level.
- Bachelor’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.
- At least 4 years of experience in IT industry.
- At least 4 years of experience with DW/BI and related tools
- At least 2 years of experience with Data Modeling related tools
- Understanding of Data Modeling architectural principles
** 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 job opportunity for you.
- Only US Citizen, Green Card, EAD-GC, H4-EAD, L2-EAD, TN Visa can apply.
- Please do mention your current US Visa Status in your resume to submit your resume soon.
Similar Jobs
Professional Services • Consulting • Industrial
Design and evolve enterprise data architecture and models (conceptual, logical, physical). Lead LDM/PDM development, run JAD sessions, apply naming standards, use data profiling and modeling tools, review models with SMEs, coordinate multi-stream teams and third parties, and communicate architecture to senior stakeholders.
Top Skills:
CofData Modeling ToolsData Profiling ToolsModel RepositoryRupZachman
Consumer Web • eCommerce • Information Technology • Retail • Software • Analytics • App development
Lead full‑stack engineering for enterprise retail solutions: set technical direction, design and build scalable frontend/backend systems and APIs, drive operational excellence, mentor engineers, and partner with customers and product teams to deliver resilient, high‑scale commerce platforms.
Top Skills:
APIsAutomated TestingCi/CdCloudDatabasesDevOpsFrontend Ui/UxGoGoJavaMicroservicesNext.JsNode.jsObservabilityPythonReactTypescript
Consumer Web • eCommerce • Information Technology • Retail • Software • Analytics • App development
Build and maintain end-to-end enterprise retail applications across frontend, backend, APIs, databases, and cloud. Influence architecture, write high-quality tested code, mentor engineers, automate development and operations, and evaluate modern tools for scalable, secure, and maintainable systems.
Top Skills:
APIsDatabasesDevOpsGoJavaMicroservicesNext.JsNode.jsObservabilityPythonReactTypescript
What you need to know about the Charlotte Tech Scene
Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus
