ETL Solution Design : Collaborate with stakeholders, including business analysts, data architects, and developers, to understand data integration requirements and design optimal ETL solutions.
Ensure adherence to best practices and industry standards in data transformation and loading processes.
Development and Implementation : Develop, test, and deploy ETL processes using various ETL tools and technologies. Create scalable, efficient, and reliable data workflows that handle complex data transformation requirements.
Optimize performance and ensure data quality throughout the ETL lifecycle.
Data Modeling : Collaborate with data architects to define data models and design schemas that support efficient data storage and retrieval.
Implement appropriate data validation and cleansing routines to ensure data consistency, integrity, and accuracy.
Data Integration : Integrate data from multiple sources, such as databases, files, APIs, and external systems, into a centralized data warehouse or data lake.
Implement data extraction strategies that maximize efficiency and minimize impact on source systems.
Troubleshooting and Performance Tuning : Identify and resolve data extraction, transformation, and loading issues. Perform root cause analysis and implement performance optimization techniques to enhance overall ETL process efficiency.
Documentation : Create and maintain technical documentation, including ETL specifications, data mappings, and process workflows
Collaboration and Leadership : Collaborate with cross-functional teams, including report developers, database administrators, and business analysts, to ensure successful project delivery.
Provide technical guidance and mentoring to junior ETL developers, promoting knowledge sharing and continuous improvement.
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination.
All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role.
We promote and support a diverse workforce across all levels in the company.