We have partnered with our client in their search for a Data Engineer for one of our clients in Columbus, OH
Responsibilities
Required qualifications, capabilities, and skills.
• 4 to 7 years of strong SQL skills; SQL Server and PostgreSQL is preferred. experience in any other RDBMS is plus.
• Hands-on practical experience delivering database design, database administration, development, testing, and operational stability.
• Hands-on practical experience on Data Modelling.
• Hands on experience with Stored Proc, views, triggers, indexes. performance tuning.
• 5+ years of experience in Database technologies MS-SQL Server, Postgres, Aurora Postgres
• 2+ plus years of experience in AWS technologies especially Aurora and Amazon RDS
• Proficiency in automation and continuous delivery methods
• Proven understanding of agile methodologies such as CI/CD, Applicant Resiliency, and Security
• Proven experience in understanding requirement related to extraction, transformation, and loading (ETL)
• Formal training or certification on software engineering concepts and 3+ years applied experience.
• Ability to independently design, build, test, and deploy code. Should be able to lead by example and guide the team with his/her technical expertise.
• Ability to identify risks/issues for the project and manage them accordingly.
• Hands-on practical experience in system design, application development, testing, and operational stability
• Experience in developing, debugging, and maintaining code in a large corporate environment with one or more modern programming languages and database querying languages.
• Proficient in coding in one or more programming languages
• Experience across the whole Software Development Life Cycle
• Proven knowledge of software applications and technical processes within a technical discipline (e.g., cloud, artificial intelligence, etc.).
• Python and spark knowledge is plus.
Additional technologies like Liquibase and other automated deployment tools
Preferred qualifications, capabilities, and skills
• Knowledge about Database engineering and Data warehousing Concepts.
• Experience with Agile based project methodology.
• Ability to identify risks/issues for the project and manage them accordingly.
• Knowledge or experience on ETL technologies like Informatica or Ab-initio would be preferable.
• People management skills would be given preference but is not mandatory.
Skills Required
• Execute software solutions, design, development, and technical troubleshooting with ability to think beyond routine or conventional approaches to build solutions or break down technical problems.
• Write secure and high-quality code and maintains algorithms that run synchronously with appropriate systems.
• Produce architecture and design artifacts for complex applications while being accountable for ensuring design constraints are met by software code development.
• Apply knowledge of tools within the Software Development Life Cycle toolchain to improve the value realized by automation.
• Apply technical troubleshooting to break down solutions and solve technical problems of basic complexity.
• Gather, analyze, synthesize, and develop visualizations and reporting from large, diverse data sets in service of continuous improvement of software applications and systems.
• Proactively identify hidden problems and patterns in data and uses these insights to drive improvements to coding hygiene and system architecture.
• Contribute to software engineering communities of practice and events that explore new and emerging technologies.
• Add to team culture of diversity, equity, inclusion, and respect.