SQL ETL Data Analyst

Role- SQL ETL Data Analyst Duration- 6 Months Location- 100% Remote Required Skills : 5+ years of Data Analysis experience 5+ years of relational database experience 5+ years of complex SQL script writing experience 5+ years of experience testing 3+ years of experience with Agile/Scrum project management methodology and Agile tools (e.g., Rally or Jira Additional Skills : 5+ years of Healthcare Data Analysis experience 3+ years of SQL or Teradata experience 3+ years of UNIX /Perl/Python scripting experiences 3+ years of experience with ETL tool 3+ years working on large data warehouse/big data projects Healthcare Industry experience Experience in an onshore/offshore model environment Experience with Data stage ETL tool Experience with Enterprise scheduling tools like Airflow, TWS CA Agile Rally Operations/production support Excellent oral and written communication skills Knowledge of open source tools and technologies like KAFKA , Github will be a plus. Primary Responsibilities: Full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance Gather and analyze business requirements Develop technical specifications and design documents Architect and design Data Warehouse infrastructure and solutions Develop Test Strategy, Test Plans, Test scenarios, and Test scripts. Create Test Strategy / Test Data Requirements. Test Data Warehouses/Data Marts Deploy and maintain Data Warehouses/Data Marts Write SQL statements to profile and analyze data Work concurrently on several projects, each with specific instructions that may differ from project to project Ensure that quality processes are carried out through all phases of the Software Development Lifecycle Design and implement efficient and effective functional design solutions Work closely with the Business and Developers to ensure requirements are met Understanding of all phases of the Software Development Life Cycle, and using Agile Methodology and Tools Respond to customer inquiries and production issues Document, discuss and resolve business, data, and reporting issues within the team, across functional teams, and with business stakeholders Partner with Business during User Acceptance Testing, assist business users in defining User Acceptance Testing, test cases and plans. Actively participate in user group meetings to review use cases and review Test Results prior to UAT start Present written and verbal data analysis findings, to both the project team and business stakeholders Monitor activities associated with responsible domains - job monitoring, issue identification, documentation, analysis, and resolution Continually look for ways to eliminate/reduce, streamline, and automate -- ---- Thanks & Regards, Tejash - Technical Recruiter Thought wave Software and Solutions 314 N. Lake St, Suite 6, Aurora IL 60506 Desk: 6304918494 EXTN: 157 Email :tejash@thoughtwavesoft.com Website:www.thoughtwavesoft.com https://www.linkedin.com/in/tejash-chettipalli-342aa2246