DBA/ETL Developer - Canyon, United States - Verdant Infotech Solutions

Description

Title:
DBA/ETL developer


Visa:
No H1b ( Need genuine Visa or EAD consultants)

Location:
Boston, MA already ( local of Boston , It's remote allowed but must be on site when/if required kinda Hybrid too.


Duration:
Long term

Interview: 2 Videos


Need:
Updated LinkedIn with profile pic.


Job Description:


JD:
Position Overview

The DBA/ETL developer will be responsible for monitoring, maintaining, creating and supporting MSLC databases
nd ETL processes. The DBA/ETL developer will maintain software, scripts and reports that access MSLC databases
nd, as an experience ETL developer, will contribute their expertise with integration, transformation, and loading
of data. This is an exciting opportunity to work in a fast-paced environment, collaborating with cross-functional
teams to ensure efficient data flow and accurate analytics for our organization.

Note:
If your experience is stronger in one area versus another training will be available.





ESSENTIAL FUNCTIONS:

• Using DBMS(s) currently employed by the MSLC, create and maintain databases accessed by all MSLC users.
• Monitor MSLC databases and proactively perform modifications, optimization adjustments, updates and

upgrades as necessary.

• Recommend modifications and solutions regarding databases, security, backup and recovery and schedules.
• Update, modify, reconfigure, backup and restore systems and servers.
• Experience with database performance optimization.
• IBM DB2 and IBM InfoSphere suite experience
• Solid understanding of SQL and experience working with DB2 relational databases.
• Familiarity with RedHat Linux operating systems
• Work with MSLC users and programming personnel to identify application and technical requirements,

evaluate existing systems and propose/design database solutions.

• Familiarity with data warehousing concepts and methodologies.
• Strong problem-solving skills and the ability to analyze complex data integration challenges.
• Excellent communication skills to collaborate effectively with cross-functional teams.
• Design, develop, test, and maintain ETL processes to ensure the accurate and efficient movement of dat

from various sources into our data warehouse.

• Collaborate with data engineers, data analysts, and other stakeholders to gather requirements and ensure

the ETL processes align with business needs.

• Optimize and fine-tune ETL workflows for performance and scalability, identifying and resolving bottlenecks

nd inefficiencies.

• Monitor ETL jobs, troubleshoot and resolve data integration issues in a timely manner.
• Ensure data quality and integrity through validation and cleansing processes.
• Stay current with industry trends and best practices in ETL development and data integration.
• Knowledge of IT Best Practices for maintaining patch management, documentation, and archiving protocols.
• Advanced ability to use OS utilities.
• Perform additional duties and responsibilities as assigned.

PREFERRED QUALIFICATIONS:

• Bachelor's degree in computer science or equivalent work experience
• Associate Degree or Relevant Experience Required
• Analytic and logical problem-solving skills
• Experience in administration of multiple IBM DB2 databases
• Knowledge of Linux and Windows operating systems, with demonstrated ability to navigate in each and to

write simple scripts and reports

• Working knowledge of report writing software (e.g. SAP BO, Tableau)
• Ability to use standard Microsoft software (Excel, Word, Outlook, Sharepoint)
• Experience with cloud platforms such as AWS, Azure, or Google Cloud is a plus
• Strong communication skills