Sr. Abinitio Developer with Oracle, Pl/SQL, data warehouse

Job Title:

Sr. Abinitio Developer with Oracle, Pl/SQL, data warehouse

Work Location :

Tampa FL Job Description:

Ab Initio Developer with 6 years of hands-on experience in designing, developing and optimizing ETL workflows using the Ab Initio platform The ideal candidate should possess strong technical expertise in Ab Initio components data warehousing concepts and Unix Python PLSQL along with a solid understanding of end-to-end ETL development lifecycle Key Responsibilities Design develop and maintain ETL workflows using Ab Initio GDE CoOp EME and other Ab Initio components Analyze business requirements and convert them into scalable technical solutions Develop and optimize Ab Initio graphs parameter sets plans and continuous flows Work with datasets using Ab Initio components such as Rollup Join Partition Scan Lookup Sort etc Perform unit testing debugging and performance tuning of ETL jobs Collaborate with data architects business analysts and QA teams to ensure high quality delivery Participate in end-to-end SDLC requirement analysis design development deployment and support Handle data extraction transformation and loading processes across multiple systems Create technical documentation including mapping sheets, design documents and deployment scripts Support production activities troubleshoot failures identify root causes and implement fixes Required Skills 6 years of hands-on experience with Ab Initio tools GDE Cooperating System EME Strong expertise in developing graphs plans PSETs XFRs DMLs and various parallelism techniques Solid understanding of ETL concepts data warehousing SCD types of data models and file formats Proficiency in UNIX Linux shell scripting Proficiency in Python scripting Strong knowledge of Oracle PLSQL knowledge Good analytical debugging and performance tuning skills Familiarity with file transfer protocols eg SFTP and scheduling tools Experience working in Agile Scrum environments Good to Have Knowledge of Big Data Hadoop Spark or cloud platforms Experience with CICD pipelines version control tools Git or job schedulers Exposure to Python or other scripting languages Soft Skills Strong communication and collaboration skills Ability to work independently and in cross functional teams Good problem solving and analytical mindset