ETL Developer

About Us We are a decision science organization assisting clients to leverage their under-utilized data in making complex business decisions successfully. We comprise of Data Enthusiasts (engineers, scientists visualizers), Business Consultants, and Sales Managers with a core focus to address your business growth via data. The most unique aspect of Data would be containing unique problems/opportunities even for organizations in the same sector. Since Marktine’s inception, we have worked with several sectors across Industries. We are still growing and consistently striving to improve to deliver world-class Data Assessment & Management Services. We do not follow a complex process rather strive to make complex data terminologies as simple as possible for our clients. From the team’s perspective, we adhere to complete industry standards following proper work-life balance among employees and provide the knowledge space for improvement. We encourage team building and follow a culture of innovation, transparency, and integrity. We are always open for the right enthusiasts to join our team. Job Description This is a remote position. Responsibilities: 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 Skills & Certifications: ​ 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. ​