DATA MODELING /ETL

Role: Data Modeling

Duration:12 months Location:Hybrid (3 days onsite in FL) Remote until September

Job Description:

Perform regular reviews of proposed ETL solution designs, vetting them against technology standards, compliance requirements and best practices to ensure a reliable, secure solution is implemented Perform data model reviews & set database objects naming & data model standards Analyze current data management environment to identify critical gaps/deficiencies, and design and propose solutions for improvement touching all aspects of data lifecycle Identify data quality issues and their root causes. Propose fixes and design data audits. Provide subject matter expertise and technical leadership to data modelers and ETL developers to bring improvement and optimizations in the implementation of data warehouses/ data lake, marts and universes Assist in Data Architecture landscape analysis, findings and recommendations leveraging industry best practices and proven methodologies. Part of Architecture Review Team (ART) in setting, governing & enforcing them both -- Data model & ETL design Excellent oral and written communication, Analytical and problem-solving skills, high attention to details

Qualification –

· 7+ years’ of experience in Informatica / ETL design & architecture · 7+ years of experience with data modeling & architecture · Strong understanding of database structures, theories, principles, and practices. · Strong understanding of Data Integration Patterns and Tooling including ELT/ETL, Replication and Streaming to support batch and real-time data needs. · Proven experience in architecting enterprise-wide data platforms and data management solutions for large and complex environments · Proficiency in SQL, query optimization and relational databases · Proven ability of translating business needs into architecture and design requirements · Knowledge of industry-wide technology trends and leading practices

Thanks & Regards, Ramyasree US IT RECRUITER Thought wave Software and Solutions 314 N. Lake St, Suite 6, Aurora IL 60506 Desk: 6302164696 Email:ramyasree@thoughtwavesoft.com LinkedIn: https://www.linkedin.com/in/ramya-sree-kolla-519839221/

A Certified Minority Business Enterprise, Disadvantaged Business Enterprise, SAM.gov, SOC2 & ISO2005, Vendors for: · STATES: IL, PA, TN, AK, OR, CT, GA, VA, ID, IA, UT, FL, MN & CO, · NATIONAL LABS: ARGONNE & FERMI, · COUNTIES: HENNEPIN, MN, FULTON & GA, · PUBLIC SCHOOLS: ATLANTA.