SQL with Pentaho Knowledge Remote
Key Skill /Skill :
Specialization SQL Server Integration Services (SSIS) with Azure knowledge
Mandatory Skills : Pentaho knowledge ,SQL , ETL-SSIS, Strong Communication Skills
Desired Skills : Azure, Azure Data factory, Azure Databricks, Other ETL & Cloud Technologies, Healthcare Data Experience
Job Description
Develop, analyze and maintain all ETL jobs according to Client standards
Scheduling and monitoring the ETL jobs
Build and review functional and business specifications (S2T)
Provide the estimates for the ETL work
Familiar with Agile methodologies.
Actively work with Architect, Business Analyst, Data Analyst, Cube and Report Developers
Work with DBA's on Database creation and performance tuning.
Strong understanding of Microsoft SQL Server, T-SQL, Stored Procedures, Views, and Functions Expertise in query construction, including writing and optimizing complex SQL queries that contain sub queries, joins, and derived tables
Troubleshooting and fixing the code.
Unit testing the code and documentation of results
Work with gate keeper on promoting the data stage jobs to QA and Production.
Participate in code reviews
Strong analytical and thinking capabilities, good communication skills to conduct requirement gathering sessions/interview customers
Ability to perform independent research to understand the product requirements and customer needs
Communicates effectively with the project teams and other stakeholders
Desired skills/ Good to have:
Good communication & interpersonal skills.
Healthcare domain.