Brillient Corporation

Backend Engineer

• Design and Development
• Move data and tables from Unix operating systems, performing extract, transformation, and load (ETL) operations into Sybase IQ
• Refactor existing jobs and build new solutions as needed
• Supporting users with documentation on moving data into Sybase IQ and providing metadata for the metadata repository
• Developing an object-oriented, UNIX-based framework and engine of scripts and stored procedures to execute and monitor multiple ETL and statistics processes
• Troubleshoot errors in shell and SQL; configure and operate SSH clients across servers
• Participate in Scrum and client meetings, create documentation, and update Kanban board cards
• Optimization and Performance
• Optimize ETL processes for efficient, timely data processing
• Monitor ETL jobs and resolve performance bottlenecks
• Data Quality
• Ensure data accuracy and integrity through validation, cleansing, and auditing
• Partner with the Data Quality team to resolve data inconsistencies and issues
• Collaboration and Documentation
• Work with Data Architects to design data models and schemas that meet business needs
• Partner with Business Analysts to understand transformation requirements
• Document ETL processes, workflows, and data dictionaries for transparency and future reference
• Troubleshooting and Support
• Diagnose and resolve ETL process failures in a timely manner
• Support business users with data-related queries and issues
• Continuous Improvement
• Stay current on ETL tools and techniques
• Recommend and implement improvements to ETL processes and infrastructure

Database Developer