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 :- 30th Jul 2022
The role requires strong collaboration with application development teams, business teams and key stakeholders. This position demands a well-organized, action-oriented team player with exceptional time management and communication skills to simultaneously support multiple initiatives.
Role responsibilities:
Optimize, develop and maintain integration solutions using SQL Server SSIS and ETL framework as necessary to connect legacy data stores, the data warehouse, and third-party platforms including Salesforce
· Identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity
· Ensure the stabilization and high performance of existing ETL processes
· Troubleshoot any complex data-related issues as well as provide support to production
· Develop and deploy ETL job workflow with reliable error/exception handling and rollback
· Drive process improvement and improve process efficiency
· Document all ETL and data warehouse processes and flows
· Design data warehouse architecture for future expansion
· Communicate issues, risks and concerns proactively to management
· Minimum 5 years of professional experience in ETL development and Microsoft SSIS, SSAS
· Minimum 5 years of professional experience in T-SQL development, debugging and optimization
· Experience working in an Agile environment (Scrum, Kanban)
· Experience with SQL Server Reporting Services (SSRS) and Microsoft Power BI is a plus