Excited to grow your career?
This position primary responsibility will be to translate software requirements into functions using Mainframe , ETL , Data Engineering with expertise in Databricks and Database technologies. This position offers the opportunity to work on modernizing legacy systems, contribute to cloud infrastructure automation, and support production systems in a fast-paced, agile environment. You will work across multiple teams and technologies to ensure reliable, high-performance data solutions that align with business goals.
As a Mainframe & ETL Engineer, you will be responsible for the end-to-end development and support of data processing solutions using tools such as Talend, Ab Initio, AWS Glue, and PySpark, with significant work on Databricks and modern cloud data platforms. You will support infrastructure provisioning using Terraform, assist in modernizing legacy systems including mainframe migration, and contribute to performance tuning of complex SQL queries across multiple database platforms including Teradata, Oracle, Postgres, and DB2. You will also be involved in CI/CD practices
Responsibilities
- 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, Ab-Initio, Python, PySpark using Databricks.
- Work with Databricks to design and manage scalable data processing solutions.
- Implement and support data integration workflows across cloud (AWS) and on-premises environments.
- Support cloud infrastructure deployment and management using Terraform.
- Participate in the modernization of legacy systems, including mainframe migration.
- Perform complex SQL queries and performance tuning on large datasets.
- Contribute to CI/CD pipelines, version control, and infrastructure automation.
- 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
- Engaged in fostering and improving organizational culture.
Qualifications
Required Skills:
- Strong analytical and technical skills.
- Proficiency in Databricks including notebook development, Delta Lake, and Spark-based process.
- Experience with mainframe modernization or migrating legacy systems to modern data platforms.
- Strong programming skills, particularly in PySpark for data processing.
- Familiarity with data warehousing concepts and cloud-native architecture.
- Solid understanding of Terraform for managing infrastructure as code on AWS.
- Familiarity with CI/CD practices and tools (e.g., Git, Jenkins).
- 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 experience 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 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 in 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.
- Strong interpersonal/relationship management skills.
- Strong time and project management skills.
- Familiarity with agile methodology including SCRUM team leadership.
- Familiarity with modern delivery practices such as continuous integration, behavior/test driven development, and specification by example.
- Desire to work in application support space
- Passion for learning and desire to explore all areas of IT.
Required Experience & Education:
- Minimum of 8-12 years of experience in application development role.
- Bachelor degree equivalent in Information Technology, Business Information Systems, Technology Management, or related field of study
