US Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
W2-Permanent
W2-Contract
Contract to Hire
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 4th Dec 2023
· The Sr. ETL (Ab-Initio) lead will be responsible, in coordination with ETL team, for the design, development, code review , testing & implementation of modules for the current strategic rollout of the DOI portfolio.
· The candidate will join the technology team that will be responsible for delivering a robust, scalable and a high quality application to be utilized by Compliance users and employees in multiple locations around the world. Ability to understand & dissect business requirements toward understanding impact on application code, its performance & data processes is crucial as is the skill to troubleshoot and fix issues in developed code.
· The candidate will report to the SPIDER Technology manager who is responsible for the successful deployment of the global platform.
Key skills-
· 6+ years of experience Ab Initio development experience
· Proven experience in ETL (Abinitio) Development and DW architecture in a volume intensive data warehouse environment preferably in financial industry.
· Proven experience with developing solutions using Abinitio ,Oracle Database, PL/SQL and Unix.
· Proven experience with physical and logical database modeling with hands on experience on Oracle PL/SQL
· Must have hands on experience in Unix Shell scripting, Autosys.
· Must have experience with Continuous Flow – This is Real time flow instead of the normal batch flow
· Must have experience with big data volumes – Loading at least 100 Million rows a time or larger
· Market Risk is a plus but need someone coming out of the financial domain or possibly retail because of the high data volume
· Complex graph, Data Lineage and other experience is a plus
· Meta Data Hub exp is a big plus