Marktine Technology Solutions Pvt Ltd
Category: Technology
Location:
- Analyze, solve, and correct issues in real time.
- Provide suggestions for solutions.
- Create ETL packages. (Mandatory on SSIS, Knowledge of other ETL is good to have).
- Experience with complicated SSIS Package coding and maintenance.
- Participate in ongoing DW/BI performance tuning activities.
- Refine and automate regular processes, track issues, and document changes.
- Assist developers with query tuning and schema refinement.
- Provide support for critical production systems as required.
- Maintaining code versioning and support code deployments.
- Perform scheduled maintenance and support deployment activities as required.
- Manage SQL Databases but not limited and can extend to NoSQL/Cloud Database as applicable.
- Preserve data integrity.
- Maintains contemporary knowledge of industry trends, concepts, and techniques.
- Experience in creation of SQL Tables, Views, MVâs, Stored Procedures and working on complex T- SQL statements.
Requirements
- Expert knowledge in traditional relational database concepts and design.
- Fluent in SQL
- Database design and query optimization.
- Write and debug stored procedures and ability in advanced SQL operations.
- Advanced query, join operation, and aggregate.
- Knowledge of data warehousing.
- Automate manual data tasks through workflows and ETL packages.
- Should possess skill to maintain, monitor, troubleshoot daily jobs using SQL Server Agent.
- Administrate application and server environments.
- Analyze data quality and make recommendations for data preparation.
- Strong ability to communicate both verbally and in writing, especially with technical analysis (including understanding internal documents).
- Experience with data manipulation, data engineering, and working with large data sets.
Originally posted on Himalayas
To apply for this job please visit himalayas.app.
About this role & career path
Working in United States
The United States of America (USA), also known as the United States (U.S.) or America, is a country primarily located in North America. It is a federal republic consisting of 50 states and a federal capital district, Washington, D.C. The 48 contiguous states border Canada to the north and Mexico to the south, with the semi-exclave of Alaska in the northwest and the archipelago of Hawaii in the Pacific Ocean. The United States also asserts sovereignty over five major island territories and various uninhabited islands in Oceania and the Caribbean. It is a megadiverse country, with the world's th
More jobs at Marktine Technology Solutions Pvt Ltd
Keep exploring on Get A Job.ai
Not quite the right fit? Your next opportunity is a click away.
- Browse all jobs
- More jobs by category
- Remote jobs you can do from anywhere
- Research typical pay for this role
- Set a job alert so new matches reach you first
- Upload your resume to apply faster
Hiring instead? Post a job and reach candidates searching right now.