• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 4th Aug 2022

Key Responsibilities
•Designing and deploying data products and solutions
•Create technical specification documents from the Jira tickets.
•Create, manage and maintain SSIS projects and packages
•Create, manage and maintain reports and dashboards using SSRS and Power BI.
•Create, manage and maintain SSAS projects. Troubleshooting and performance tuning of tabular model.
•Test and reconcile data between source and enterprise data warehouse
•Database monitoring, error handling and performance tuning
•Stakeholder management

Technical Skills and Expertise   
•Essential:
•Proven experience as a SQL Developer and/or Tester (industry experience preferred)
•Advanced SQL skills, including the creation complex queries (e.g. nested SQL statements, recursive CTEs, etc.)
•Microsoft BI Stack - advanced T-SQL, SSIS (with BIML), SSAS (Tabular), SSRS and DAX
•Knowledge or waterfall and/or agile methodologies (including all stages of software development)
•Oracle SQL Developer and Microsoft SQL Server Management Studio (SSMS)
•Data modelling and design
•Desirable:
•Team City
•TFS or similar
•Power BI
•Snowflake or similar (e.g., Amazon Redshift, Google Big Query)
•DataOps
•Python or R
•AnalytiX DS or similar
•Nice to Have:
•Job schedulers (i.e. creating, implementing and maintaining jobs using SQL Agent or equivalent) such as VisualCron or similar