Job Title: Oracle Data Engineer w Cobol
Location: Westlake, TX/Smithfield, RI (Hybrid)
Duration : Long Term Contract
Interview: Virtual
Visa: USC/GC/GC EAD/H4 EAD
2 Openings. Okay with relocation.
Must Have Skills:
- 7+ years of hands-on experience in Data Engineering, Data Warehousing and analytics technologies
- 5+ years of experience with Informatica or any other ETL tools
- 5+ years of exp in Shell scripting
- 5+ years of experience with either Linux or AIX
- 7+ years of experience with Oracle
- Cobol: – Not coding in COBOL. However, they need to understand COBOL code and ensure it works. How to compile and how to make it run.
Preferred:
- AWS,Azure or (Airflow) is preferred
- CICD Automation Tools
Team Info:
We are seeking to migrate the IDA platform from IBM AIX to an on-premises Linux environment. This migration will encompass the transfer of Oracle databases, as well as Cobol and Pro*C components. Our goal is to ensure a seamless transition while maintaining system integrity and performance.
Expected outcome:
Migrate the current IDA platform on IBM AIX to Linux. This includes
- Cloning and compiling the code base ( Shell scripts, COBOL , Pro*C, Oracle StoredProcedures & pacakges )
- Install syncsort ( from Precisely) on Linux and compile the libraries in Linux.
- Integrate syncsort libraries with Pro*C & Cobol and ensure reports run in the new environment.
- Oracle Database migration
- Informatica can load & process files
- Ensure the 20+ applications can connect to the IDA platform ( via Direct Connect JDBC, SQL server integration services, Python)
- Establish OBIEE (PSW reporting) connectivity and run one report
• Bachelor’s Degree or equivalent in a technology related field (e.g., Computer Science, Engineering, etc.) required.
• 7+ years of hands-on experience in Data engineering, data warehousing and analytics technologies
• 7+ years of experience with Relational Databases (Preferably in Oracle)
• Not moving, but understand stored procedures
• Advanced experience with SQL and complex queries (should be able to debug)
• 5+ Experience with Informatica or any other ETL tools data integration and data movement design patterns (called via shell scripts)
• 5 + Experience in Shell scripting (K-Shell, Bash)
• 5 + years of experience working on Linux and AIX (proficient in at least one of these) • Ability to understand and code in COBOL and Pro*C • Not coding in COBOL. However, they need to understand COBOL code and ensure it works. How to compile and how to make it run. • Solid understanding of domain-based design, data modeling and data structures • Experience with DevOps, Continuous Integration and Continuous Delivery (understanding of DevOps)
• Your ability to collaborate with other technical and business minds in the organization.
• Your experience in executing projects in an Agile environment (Kanban and Scrum)
Nice to have:
• Experience with Python
• Experience with Apache Tomcat
• Experience with business intelligence and analytics tools such as OBIEE
• Experience in AWS, Azure, Airflow is preferred.
• Experience in CICD automation tools
• Good understanding of financial services.
The Skills You Bring
• Good technical design and analysis skill
• Ability to deal with ambiguity and work in fast paced environment.
• Deep experience supporting critically important applications quickly.
• Superb communication skills, both through written and verbal channels
• Excellent collaboration skills ability to work with multiple teams in the organization.
• Ability to understand and adapt to changing business priorities and technology advancements.
• Strong knowledge and technology trends in implementing business applications.
• Team player and versatile
Dynamic Working – Associates are expected to be in-person in the office, currently it is once a week which could potentially change.
Thanks & regards!
Sonu Chauhan
Sr. Technical Recruiter
Phone: +1 3025490259 Ext. 102
Email: Sonu@virishatech.com
—
