Nisum is a leading global digital commerce firm headquartered in California, with services spanning digital strategy and transformation, insights and analytics, blockchain, business agility, and custom software development. Founded in 2000 with the customer-centric motto “Building Success Together®,” Nisum has grown to over 1,800 professionals across the United States, Chile,Colombia, India, Pakistan and Canada. A preferred advisor to leading Fortune 500 brands, Nisum enables clients to achieve direct business growth by building the advanced technology they need to reach end customers in today’s world, with immersive and seamless experiences across digital and physical channels.
What You'll Do
Solid work experience in Linux and shell scripting, Cron
Good Knowledge on Azure Systems, Azure VNET, Pvt Link
Self-motivated, hardworking, effective communicator and pleasant interpersonal skills.
Excellent verbal, written and presentation skills.
On-call during PST time as a job requirement.
Analyze, design, code, and test highly complex ETL processes, for data warehouses and/or operational data stores
Understand design for ETL application including data sources, data targets, data definitions, data relationships, and business rules
Implementing Data quality and data governance standards with in teradata environments.
Collaborating with cross-functional teams to integrate Teradata solutions with other systems and applications
What You Know
A minimum of 7+ years of proven professional experience is required.
Strong query writing skills, Debugging skills with respect to Teradata
Knowledge on Teradata DBMS Architecture
Experience on Teradata load and unload utilities -Fastload, Multiload, Fast export, Bteq and Teradata Parallel Transporter (TPT).
Experience in writing Teradata SQL and optimizing it to run in the best possible way.
Performance tuning techniques and Optimizer/explain plan.
Extensive experience in writing & reviewing the code and recommend best practices to application teams that helps to get optimal code to production.
Experience in developing complex ETL/ELT code.
Proficient in giving performance tuning recommendations to suspect queries and long running queries in the system.
Identify high resource consuming, long running and skewed jobs and work with application teams by recommending potential tuning opportunities.
Good Knowledge in Teradata tools like Teradata Sql Assistant, Teradata Administrator, Viewpoint, Teradata Studio, Dbeaver, Jupiter Notebook
Education
Bachelor's degree in a related field.
Benefits
In addition to competitive salaries and benefits packages, Nisum India offers its employees some unique and fun extras:
Continuous Learning - Year-round training sessions are offered as part of skill enhancement certifications sponsored by the company on a need basis. We support our team to excel in their field.
Parental Medical Insurance - Nisum believes our team is the heart of our business and we want to make sure to take care of the heart of theirs. We offer opt-in parental medical insurance in addition to our medical benefits.
Activities -From the Nisum Premier League's cricket tournaments to hosted Hack-a-thon, Nisum employees can participate in a variety of team-building activities such as skits, and dances performance in addition to festival celebrations.
Free Meals - Free snacks and dinner is provided on a daily basis, in addition to subsidized lunch.
