First Tek
IT|Software Engineering - Group 2 - Lead II - Software Engineering
First Tek, New York, New York, 10261
• 10 years of experience building solutions using Oracle, Informatica, Python and shell scripting. • Strong knowledge of Python frameworks (e.g., Pandas, Streamlit, etc). • Proficiency in Oracle PL/SQL and SQL. • Hands-on experience with Informatica PowerCenter or similar ETL tools. • Experience in Translating functional and technical requirements into detailed design • Experience in Coding and unit testing, support SIT, UAT and Production deployments • Must have good database programming skills covering Design/development of Stored Procedures, -Functions, Tables, and Triggers and tuning SQL queries for optimal performance. • Develop ETL processes using Informatica to manage data integration tasks. • Proficiency in shell scripting • Experience with performance tuning and optimization of Oracle databases • Document system configurations, procedures, and best practices • Excellent problem-solving skills and attention to detail. • Ability to work collaboratively in a team environment. Responsibilities: • Design, develop, and maintain applications using Oracle , Informatica, Python and Unix technologies. • Collaborate with cross-functional teams to define, design, and ship new features. • Optimize application performance and ensure scalability. • Implement security measures and data protection protocols. • Troubleshoot, debug, and upgrade existing systems. • Write clean, maintainable, and efficient code. • Stay up-to-date with the latest industry trends and technologies. • Experience with Tivoli Workload Scheduler (TWS) • Experience with cloud services preferably AWS • Experience with Snowflake • Knowledge of DevOps practices and tools. • Familiarity with Agile methodologies.