Ravi Kumar R
Senior ETL Developer& Snowflake Lead
- Role
- Etl Snowflake Lead at Fidelity Investments
- Location
- Duluth, GA, US
- LinkedIn followers
- 500 followers
About Ravi Kumar R
14+ years of experience Database Design, Data warehouse, Application Development and…
Experience
Etl Snowflake Lead
Apr 2018 — Present
Responsibilities Integrated data into the database from different sources by creating SSIS packages. Integrating new vendors like pluralsight, into the One HR/ One LnD SSAS model for reporting features. Redesigning the existing models/creating new models based on the requirements to enhance the reporting capabilities for faster and efficient reporting scenarios. Creating Power BI reports based on location, SBU per business requirements. Performed encryption & decryption of source files to maintain data confidentiality. Created tables and stored procedures in different layers of database based on the business requirement. Involved in the process of creating the SSAS model. Created New Columns and New Measures over data models for the purpose of enhancing Power BI visuals using DAX. Created rich reports by using various visual objects like Table, Line chart,Bar chart, Single card, Map, Pie chart etc. Implemented Drilldown and Drill through functionality. Applied visual level, page level,and report level filters for restricting specific values. Created bookmarks for navigating from one visual to another visual or one page to another page. Created App with required reports and dashboards and shared the App to different users and security groups. Publishing reports to Power BI service and providing the access to required users. Created SQL Server agent jobs to automate and schedule SSIS packages execution. Participated in support activities like jobs monitoring and resolving failures, resolved data related issues in reports. Created internal and external stages and transformed data during load. Redesigned the Views in snowflake to increase the performance. Experience in working with AWS, Azure and Google data services Created ETL Mappings to populate the data into dimensions and fact tables.Environment: Snowflake, Redshift, SQL server, AWS, AZURE, TALEND, JENKINS and SQL
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.