Digital technologies, including analytics and AI, give companies a once-in-a-generation opportunity to perform orders of magnitude better than ever before. But clients need new business models built from analyzing customers and business operations at every angle to really understand them.
With the power to apply artificial intelligence and data science to business decisions via enterprise data management solutions, we help leading companies prototype, refine, validate and scale the most desirable products and delivery models to enterprise scale within weeks
*You must be legally authorized to work in the United States without the need for employer sponsorship, now or at any time in the future *
Job Title – Teradata Developer
Location – Franklin Lakes, NJ Remote until COVID)
Roles/Responsibilities:
Experience in data integration activities including: designing, coding, testing, deploying and supporting of applications
Should possess strong Teradata ETL design and implementation skills and strong in writing Advanced SQLs to perform the desired activities
Strong ETL Background ( Data Extraction , Transformation and loading in target from heterogeneous Sources )
Strong Understanding On Teradata Architecture
Debug the complex SQLs and provide solution to fine tune the queries to minimize the load on the system
Experienced in Data Warehousing design and architecture and Data Integration Solutions using Teradata
Expertise in Query optimization and Performance tuning techniques
Expertise in Data Analysis, troubleshooting of issues and providing solution to complex applications
Strong in Teradata Stored Procedures, BTEQ, Utilities
Python / UNIX Shell scripting Knowledge
Engage with onsite-offshore team for daily activities
Required Qualifications:
Bachelor’s degree or equivalent experience in Computer Science
5-8 Years of work experience
Minimum 6+ years of development experience using Teradata Stored procedures, BTEQ, FastExport, MultiLoad etc., to perform ETL activities.
Ability to understand the complex requirements from customers and convert them to technical design document
Possess experience in creating test cases and writing SQLs to perform unit testing and integration testing activities.
5+ years of experience in data warehousing projects implementing data models using Teradata database
Demonstrated ability to complete multiple tasks under pressure with a high degree of flexibility
Must be able to understand data models and business logic in a short span of time
Person must have good analytical skills
Hands on in writing SQL.
Minimum 3+ years of Experience in UNIX / python programming
Should be good at communicating with Biz Teams/Clients
Is self-motivated to take initiatives and thrive in an ambiguous work environment
Technical Skills
SNo
Primary Skill
Proficiency Level *
Rqrd./Dsrd.
1
Informatica
PL1
Required
2
Teradata
PL1
Required
* Proficiency Legends
Proficiency Level
Generic Reference
PL1
The associate has basic awareness and comprehension of the skill and is in the process of acquiring this skill through various channels.
PL2
The associate possesses working knowledge of the skill, and can actively and independently apply this skill in engagements and projects.
PL3
The associate has comprehensive, in-depth and specialized knowledge of the skill. She / he has extensively demonstrated successful application of the skill in engagements or projects.
PL4
The associate can function as a subject matter expert for this skill. The associate is capable of analyzing, evaluating and synthesizing solutions using the skill.
