What are the responsibilities and job description for the ETL Developer position at Hallmark Global Solutions Ltd?
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