SSIS Technical Architect - US

At Thoucentric, we work on various problem statements.

• The most popular ones are -
  • Building capabilities that address a market need, basis our ongoing research efforts
  • Solving a specific use case for a current or potential client based on challenges on-ground
  • Developing new systems that help be a better employer and a better partner to clients
• All of these need the best of minds to work on them day-to-day; and we do exactly that!
• Your contribution to organization development is as important as outward facing consulting.
• We are invested in both, employee growth and client success!

Responsibilities:

• Design, build and deploy effective SSIS packages to validate, synthesize, transform customer data for integrated business planning and analytics
• Understand Client platform’s data model (table structures, linkages, optimal designs) for designing various planning use cases
• Review and analyze the data provided by customers along with its technical/functional intent and interdependencies
• Lead customer sessions 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
• Design and support execution of test plans, document issues and track progress at resolving issues.

Requirements

Required Skils:

• 4 to 6 years of ETL development with at least 1 years in designing ETL solutions for clients in different is a MUST. (SSIS is must)
• 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.
• Experience in Creating/Testing Web API’s via Postman /C#/ Java Script.

Added Advantage:

• Knowledge on handling JSON files, Serializing the data, Posting data to API is desirable.
• Good to have experience working with Hive/Hadoop/Python.
• Knowledge and experience in Apache NiFi / Apache Airflow.
• Prior work experience on Supply chain.
• Strong experience in Cloud Data Quality, Source Systems Analysis, Business Rules Validation, Source Target Mapping Design, Performance Tuning and High-Volume Data Loads.
• Strong ability to lead by example and demonstrate proficiency in both product and domain.
• Patient listener with the ability clearly articulate your viewpoint to manage and deliver to customer expectations, even under pressure.
• Mentor on approach and execution of solutions, coach on technologies and establishing a team wide comprehension of solution capabilities and direction.
• Ability to take complete ownership of the work and deliver with minimal oversight.

BenefitsBenefits

What is in it for You:

• Be part of the exciting Growth Story of Thoucentric!
• Work on projects that help you stay ahead of the curve. Not just exciting projects, if you are a self-starter, you will also get multiple opportunities to design, drive and contribute to the organizational and practice initiatives.
• Challenge yourself in an environment with higher expectations ensuring constant learning curve and steep growth opportunities
• 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.