RollupScanJoinPartition by keyNormalizeGatherMergeSortLookup
Work Authorization
US Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Preferred Employment
Corp-Corp
W2-Permanent
W2-Contract
Contract to Hire
Employment Type
Consulting/Contract
education qualification
UG :- - Not Required
PG :- - Not Required
Other Information
No of position :- ( 1 )
Post :- 1st Jun 2024
JOB DETAIL
Strong hands-on experience in data-warehouse and ETL - Ab Initio tool background.
Excellent working knowledge of Ab Initio suites of product - GDE, Co>Op, PSETS, PDL Programming, Meta Programming, Generic Graphs and usage of Conduct>IT (Plans).
Good experience in various Ab-initio parallelism techniques and implement overall solutions comprising of ETL jobs involving heavy volumes of data.
Knowledge on EME version control, Ab Initio air commands, m_ commands and UNIX/Linux shell scripting.
Experience working with various Ab Initio components such as Rollup, Scan, Join, Partition by key, Normalize, Gather, Merge, Sort, Lookup, etc.
Proficient and comfortable with Ab Initio metaprogramming using vectors and implementing tuning techniques for performance improvement.
Strong knowledge of any database such Oracle, DB2 or Greenplum is a must.
Flexible to support on-going BAU production jobs and release activities.
Must have knowledge on data warehousing concepts, data modeling and expert level Database/SQL skills.
Proficient in creating documentation related to design documents, Unit testing, handover and walk-through documents.
Analyze (though proof of concept, performance, and end-to-end testing) and effectively coordinate the infrastructure/service needs working with the architecture and Data Center teams.
Closely work with the architecture team to review the design and ETL code.
Identify and apply best practices and standard operating procedures.
Create innovative solutions to meet the technical needs of customers .