Sravya
sravya.etl1@gmail.com
857-228-8996
Boston, MA 02298
ETL Developer
12 years experience W2
0
Recommendations
Average rating
191
Profile views
Summary

  • I have 5+ years of IT experience focusing on Data warehousing, Data modeling, Data integration, Data Migration, ETL (Extract, Transform and Load) Process and Business Intelligence.
  • Expertise in Informatica ETL and reporting tools. Deep understanding of the Data Warehousing SDLC and architecture of ETL, reporting and BI tools.
  • Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
  • Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using Erwin and ER-Studio.
  • Technical and Functional experience in Decision Support Systems - Data warehousing implementing ETL (Extract, Transform and Load) using Informatica Power Center 9.6.1/ 8.6.and IDQ, MDM.
  • Design and development of Business Intelligence Solutions using Informatica PowerCenter, IDQ and Business Intelligence Development Studio using SSIS (SQL Server Integration Services).
  • Extensive experience in Informatica (9.x) applications. Designed and developed the Workflows, Worklets, Mappings, Mapplets, Sessions, Tasks, Transformations and schedule the Workflows and Sessions.
  • Strong understanding of Data Modeling (Relational, dimensional, Star and Snowflake Schema), Data analysis, implementations of Data warehousing using Windows and UNIX.
  • Extensive experience in developing stored procedures, functions, Views and Triggers, Complex queries using SQL Server, TSQL and Oracle PL/SQL
  • Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
  • Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
  • Knowledgeable about Operational, Analytical MDM solutions and Registry, Repository and Hybrid MDM Approaches.
  • Extensive knowledge in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes and the scheduler tool Autosys.
  • Creating Process and Frameworks to Manage UNIX and Autosys development projects.
  • Analyzing new projects and helping them in implementing Autosys for scheduling, monitoring and reporting purpose.
  • Experience in Debugging of mappings using data and error conditions, Scheduling jobs using Control-M, Autosys, and Informatica Scheduler.
  • Extensive experience on tools like SQL Navigator, Application designer and Toad.
  • Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, FastExport and Tpump), Teradata parallel support and Unix Shell scripting.
  • Proficient in coding of optimized Teradata batch processing scripts for data transformation, aggregation and load using BTEQ.
  • Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
  • Experienced with Informatica Power Exchange for Loading/Retrieving data from mainframe systems.
  • Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
  • Experience in Combining views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
  • Experience in developing complex reports using drill-through reports, prompts, conditional formatting, master-detail, dashboards, burst-reports, dynamic filtering in Cognos Report Studio.
  • Experience in developing complex reports using drill-through reports, prompts, conditional formatting, master-detail, dashboards, burst-reports, dynamic filtering in Cognos Report Studio.
  • Experience in integration of various data sources like SQL Server, Oracle, Tera Data, Flat files.
  • Demonstrated work experience in Mainframe to DataStage Migration projects.
  • Provided extensive Production Support for Data Warehouse for internal and external data flows to Netezza, Oracle DBMS from ETL servers via remote servers.
  • Experienced as a Web Development/User Interface/Front End Developer in developing applications using HTML/HTML5, CSS/CSS3, JavaScript, DOM, jQuery, Ajax and JSON.
  • Experience in designing UI patterns and UI applications with the help of Adobe products like Adobe Dreamweaver CS3, Adobe Photoshop, and Adobe Illustrator CS3.
  • Stored reformatted data from relational, flat file, XML files using Informatica.
  • Having good Knowledge on understanding Java and Python programs.
  • Knowledge in developing and executing Test Plan, Test Scenarios, Test Cases, and documentation of Manual and Automated Tests based on analysis of business requirements.
  • Strong analytical, problem-solving, communication, learning and team skills.
  • Experience with multiple software development methodologies including Agile/SCRUM.

Experience
Education
Skills
Agile Methodology
2022
8
ETL
2022
8
ETL Developer
2022
8
SQL
2022
8
SQL Server
2022
8
Cognos
2022
6
Data Analysis
2022
6
Informatica
2022
6
Informatica Powercenter
2022
6
Java
2022
6
Oracle
2022
6
Tableau
2022
6
Teradata
2022
6
TOAD
2022
6
UNIX
2022
6
Ab Initio
2022
5
BMC Control-M
2022
5
Data Cleansing
2022
5
Data Profiling
2022
5
Data Warehousing
2022
5
Informatica MDM
2022
5
MS Power BI
2022
5
PL/SQL
2022
5
Scrum
2022
5
SQL Loader
2022
5
SSIS
2022
5
T-SQL
2022
5
Stored Procedure
2016
3
Triggers
2015
2
Visual Basic
2015
2
XML
2015
2
Adobe Dreamweaver
0
1
Adobe Illustrator
0
1
Adobe Photoshop
0
1
AJAX
0
1
Business Intelligence
2016
1
CSS
0
1
Data Integration
0
1
Data Mapping
0
1
Data Marts
0
1
Data Migration
2016
1
Data Modeling
0
1
Erwin Data Modler
0
1
HTML
0
1
IDQ
0
1
in-memory databases
0
1
JavaScript
0
1
jQuery
0
1
UI
0
1