Support, maintain and participate in the development of software utilizing technologies such as COBOL, DB2, CICS and JCL.
Support, maintain and participate in the ETL development of software utilizing technologies such as Talend, Abinitio, AWS Glue, PySpark.
Provide expertise, tools, and assistance to operations, development, and support teams for critical production issues and maintenance
Troubleshoot production issues, diagnose the problem, and implement a solution - First line of defense in finding the root cause
Work cross-functionally with the support team, development team and business team to efficiently address customer issues.
Active member of high-performance software development and support team in an agile environment.
Required Skills:
Strong Mainframe experience, using Cobol, JCL, DB2 and VSAM
Strong SQL knowledge on OLAP DB platforms (Teradata, Snowflake) and OLTP DB platforms (Oracle, DB2, Postgres, SingleStore).
Strong experience with Teradata SQL and Utilities
Strong experienced with Oracle, Postgres and DB2 SQL and Utilities
Develop high quality database solutions
Ability to do extensive analysis on complex SQL processes and design skills
Ability to analyze existing SQL queries for performance improvements
Experience in ETL frameworks like Talend, Abinitio, AWS Glue.
Experience in software development phases including design, configuration, testing, debugging, implementation, and support of large-scale, business centric and process-based applications
Proven experience working with diverse teams of technical architects, business users and IT areas on all phases of the software development life cycle.
Exceptional analytical and problem-solving skills
Structured, methodical approach to systems development and troubleshooting
Ability to ramp up fast on a system architecture
Experience designing and developing process-based solutions or BPM (business process management)
Strong written and verbal communication skills with the ability to interact with all levels of the organization.