LT
Job Description
- 6+ years of experience with Abinitio, GDE, Plans, PLSQL.
- PLSQL Development
- Expertise in writing complex SQL queries stored procedures and packages for ETL frameworks
- Strong understanding of query optimization and performance tuning
- Ab Initio Development
- Proficient in designing and developing generic XFRs and dynamic DMLs
- Ability to build maintain and troubleshoot generic graphs for largescale data processing
- Integration Data Handling
- Experience in handling JSON data and developing Ab Initio graphs to integrate with REST APIs using web services components
- Familiarity with API based integrations
- Python Scripting
- Ability to write Python scripts for REST API calls data extraction and transformation
- Experience in exporting data to CSV or loading into Oracle tables
- Data Normalization
- Strong understanding of normalization concepts at both database and Ab Initio levels
- Collaboration Requirement Analysis
- Ability to interact with business users interpret Jira requirements and translate them into technical solutions
- Version Control Deployment
- Experience with Bitbucket for code checkins and managing environment promotions UAT PROD
- Job Scheduling Automation
- Proficient in writing JIL scripts for Autosys to schedule and orchestrate ETL jobs
- Shell Scripting
- Strong knowledge of shell scripting for wrapscripts and automation tasks'