Hive/Hadoop 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 effort.
• 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.
• 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.
• Patient listener with the ability clearly articulate your viewpoint to manage and deliver to customer expectations, even under pressure.
• Strong ability to lead by example and demonstrate proficiency in both product and domain.

Requirements

Required Skills:

• 4 to 6 years of ETL development with at least 1 years in designing ETL solutions for clients in different is a MUST.
• Experience working with Hive/Hadoop.
• 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.
• Strong experience in Cloud Data Quality, Source Systems Analysis, Business Rules Validation, Source Target Mapping Design, Performance Tuning and High-Volume Data Loads.
• Proficient in the use of Microsoft Excel/PowerPoint /Visio for analysis and presentation

Preferred Skills:

• Knowledge and experience in Apache NiFi / Apache Airflow.
• Prior work experience on Supply chain
• Some Knowledge of C# /JavaScript / VB.NET or analytical packages like R is desirable.
• Knowledge on handling JSON files, Serializing the data, and Posting data to API is desirable.

BenefitsBenefits

What a Consulting role at Thoucentric will offer you?

• 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!