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 – Abinitio Developer
Location – Hartford, CT (Remote until COVID)
Roles/Responsibilities:
Perform detail design, development, documentation, debugging and implementation of solutions for Abinitio ETL requirements.
Should have strong skills on ETL design patterns and data architecture, UNIX and Db2.
To provide end to end ETL Design solutions and support Architecture in defining strategies. Leading team of designers and developers
To understand the overall purpose of the projects and contribute to requirements & data analysis, and provide solutions from an ETL perspective
Delivery of low level design documents with ETL & DWH strategy, standards and adhering to ETL & BIW principles & policies.
Strong understanding of ETL, DWH and Report designs with functional and non-functional assessment for global implementations.
Accountable for project related queries/issues.
Should be well versed with following concepts –
Co-operating System
Using GDE Graphical Development Environment
Able to design end to end solution for complex case studies.
Enterprise Meta Environment EME version control, dependency analysis, mcommands, air commands, sandboxes, PDLs, Metaprogramming.
Working knowledge of at least one Job scheduler tool.
Using all of the above components to create and maintain an enterprise data solution and rules execution.
Must have hands-on experience with SQL, Shell Scripting, bash, Korn shell scripting, SQL performance tuning, relational model analysis and data migration.
Should have good communication skills and client handling skills.
Strong knowledge in BI and Data Warehousing.
Required Qualifications:
Bachelor’s Degree in Engineering or relevant field.
7+ years of success in consultative/complex deployment project, architecture, design, implementation and/or support of data and analytics solutions.
Hands on development Design and Develop applications using Ab-Initio GDE.
Excellent skill in Ab-Initio ETL CO>OP, EME, GDE.
3-6 Years of work experience
Minimum 5+ years of development experience using Teradata Stored procedures, BTEQ, FastExport, MultiLoad etc., to perform ETL activities.
Possess experience in writing SQLs to perform unit testing and integration testing activities.
5+ years of experience in data warehousing projects implementing data models using Teradata database
Technical Skills
SNo
Primary Skill
Proficiency Level *
Rqrd./Dsrd.
1
Ab initio
PL1
Required
2
Unix
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.