Ugam, a Merkle company, is a leading analytics and technology services company. Our customer-centric approach delivers impactful business results for large corporations by leveraging data, technology, and expertise. We consistently deliver superior, impactful results through the right blend of human intelligence and AI. With 3600+ people spread across locations worldwide, we successfully deploy our services to create success stories across industries like Retail & Consumer Brands, High Tech, BFSI, Distribution, and Market Research & Consulting. Over the past 21 years, Ugam has been recognized by several firms including Forrester and Gartner, named the No.1 data science company in India by Analytics Insight, and certified as a Great Place to Work�. The name Ugam comes from the ancient Sanskrit language and means �source� or �origin.� Ugam seeks to be the source of solutions for the complex problems of retailers, brands and market research firms worldwide. The name signifies the company�s position as a pioneer in the market for data and analytics, and the source of relevant actionable insights for clients.

Role Description:

Functional
o Review Business Requirements to create databases with efficient structures
o Create stored procedures, triggers and views
o Identify ETL requirements and design, develop and test complex SSIS solutions
o Monitor and optimize database objects and SQL Server databases (2008 R2, 2014, 2016) using industry-standard tools and practices (SQL Profiler, Analyzer, Query Plans)
o Reverse engineer and understand complex integrations
o Develop and maintain data mappings between source and destination data stores
o Document project specific processes and data flows, data dependencies, data definitions and relevant business rules. Establish data dictionaries to support the buildout of a data governance infrastructure
o Must demonstrate strong problem-solving ability, logic and analytical skills
o Participate in data modelling initiatives
o Perform quality assurance and testing at the unit level
o Ability to manage multiple projects in a fast-paced environment
o Ability to work independently and collaborative with other team members
o Troubleshoots production issues, identifying root cause and implementing sound technical resolutions in a timely manner

Key Responsibilities:

 

Qualifications/Certifications:

 

Bachelors degree in computer science/IT

What are we looking for?

MS Office
- Hands on experience with SQL Server SSIS and ETL processes
- Demonstrable SQL development skills � packages, triggers, views, queries, etc
- Familiarity with designing and implementing ETL in large databases and data warehouses utilizing both relational and dimensional design concepts
- Familiarity with agile development techniques and objectives

Other information:

Communication
- Learnability
- Teamwork
- Result Orientation
- Problem Solving