SSIS Integration Consultant
Posted Updated
Summary
Integration consultant at Thoucentric building data crawlers and SSIS packages to extract, validate, and transform customer data for integrated business planning on the o9 platform. Day-to-day: designing columnar data warehouse models, writing and optimizing SQL, and owning the ETL development workflow alongside solution architects.
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
Requirements
Must Have:
o9 Platform exp is Mandatory.
- 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
- 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
Benefits
Opportunity to define your career path and not as enforced by a manager
A great consulting environment with a chance to work with Fortune 500 companies and startups alike.
A dynamic but relaxed and supportive working environment that encourages personal development.
Be part of One Extended Family. We bond beyond work - sports, get-togethers, common interests etc. Work in a very enriching environment with Open Culture, Flat Organization and Excellent Peer Group.
Be part of the exciting Growth Story of Thoucentric!