Uploaded File
no photo
Sravya
ETL Developer
8 years experience W2 Boston, MA
Actively seeking
no photo
Sravya
ETL Developer
69
views
0
Recommendations
Average rating
69
Profile views
Agile Methodology ETL ETL Developer SQL SQL Server Stored Procedure Cognos Data Analysis Informatica Informatica Powercenter
Remove Note
View Note
Recent Experience
ETL Developer 01/17 - present
Java SQL UNIX Informatica TOAD Data Analysis SQL Loader Teradata Data Cleansing Data Warehousing SQL Server Oracle Informatica Powercenter PL/SQL Cognos ETL SSIS Scrum T-SQL Agile Methodology Tableau Data Profiling ETL Developer Informatica MDM MS Power BI
ETL Developer 01/16 - 12/16
Java SQL UNIX Informatica TOAD Data Analysis Stored Procedure Teradata SQL Server Oracle Informatica Powercenter Data Migration Cognos ETL Business Intelligence Agile Methodology Tableau ETL Developer
ETL Developer 08/12 - 07/15
SQL Visual Basic XML Stored Procedure SQL Server ETL Agile Methodology Triggers ETL Developer
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.

Top 5 Skills
SkillsProficiencyLast Used
Agile Methodology
2020
ETL
2020
ETL Developer
2020
SQL
2020
SQL Server
2020
Education and Certifications
Preferences
Availability:Immediately
Willing to relocate?:Yes
Relocation preference
Any location
Prepared to Travel:No travel (0%)
Employment Type:Any
Security Clearance:No clearance
Citizenship:U.S. Citizen