Design & Develop complex ETL projects in SSIS and implement Framework model.
Monitor and fix errors, performance optimization and quality testing of SSIS packages.
Migrate, re-design & Test ETL packages.
Create data jobs workflow in orchestration tools like Control-M
Deploy and Implement Projects in PROD
Prepare Technical and Operational Document.
Design & develop complex T-SQL/PL-SQL queries and stored procedures.
Optimize SQL queries.
Develop data models Star Schema, Snowflake Schema, implement databases, and analyze content and quality of packages
Design, develop and maintain business intelligence solutions.
Craft and execute queries upon request for data.
Present information through reports and visualization
Coordinate with various stakeholders across multiple functions to better understand their processes, data flows and priorities to manage projects related to data management and reporting
Collaborate with various IT teams for infrastructure and service readiness and continuity
Create advanced analysis tools to develop predictive models.
Administer the advanced analytics applications and ensure smooth operations