SQL/SSIS Consultant - ETL Processes (3-6 yrs)

Job Description :

This is a niche consulting firm that uses relevant digital and functional domain expertise to solve problems in Supply Chain, Sales & Distribution, and Finance.

The consulting framework of Company integrates subject matter expertise, technological understanding, structured project management, and governance. As a result, our consultants have a natural advantage over the traditional consultant, who concentrates solely on advisory services.

Our consulting capabilities have been institutionalized and anchored by the industry senior partners "who have been there and done that" as people in environments like our clients', this has allowed us to create teams who can act naturally as extensions of our client's teams.

In our problem-solving journey, we stay aware of the evolving technology landscape through partnerships with the best in the business. Company collaborates with our technology partners to develop strategies, and our consultants work on end-to-end projects incorporating these world-class technologies.

In the process, we have built a state-of-the-art digital workforce of data scientists, engineers, and visualization experts, creating solutions for clients who want to develop point solutions themselves

Company Labs' successful product launches in the areas of demand forecasting, predictive quality, business scenario planning, and commodity price forecasting validate our excellent problem-solving skills.

Job Description :

- Build data crawlers to extract data from customers' data sources using available ETL platforms, and troubleshoot the issues faced during data loading & processing

- Design and build data warehouse models in columnar databases

- Develop data processing scripts using SQL and be able to optimize complex sequences of SQL Queries

- Design, build and deploy effective SSIS packages to validate, synthesize, transform customer data for integrated business planning and analytics

- Work with Solution Architects to understand customers' business requirements and implement them

- Perform data analysis for complex use cases using SQL document technical specification for the cognitive applications that we are creating for the customers

- Own the entire development and implementation workflow

- Participate in the technical design, data requirements gathering and making recommendations on best practices, in case of inaccurate or missing data

- Design and automate the data loading and insights generation process with intelligent checks and balances for sustained value delivery

- Create and execute test plans, document issues and track progress at resolving issues.

Requirements :

Must Have :

- Very strong hands-on experience working in ETL (Extract/Transform/Load) processes

- Proficiency in databases (SQL Server, MySQL) and skills in one or more languages like SQL, MDX, T-SQL with knowledge of DDL, DML, stored procedures, triggers and performance tuning is a MUST

- Basic Unix knowledge

- Exposure to at least one Data Visualization tool - Tableau/Qlik etc

- Familiarity with workflows in programming concepts

- Experience using columnar databases

- Experience working directly with customers and presenting your ideas

- Excellent communication and presentation skills

Good to Have :

- Applied Python programming

- Experience working with JSON and XML files

- Experience using APIs

- Knowledge of SAP

- Knowledge of supply chain fundamentals and terminology