Uploaded File
add photo
Sravya
sravya.etl1@gmail.com
857-228-8996
Boston, MA 02298
ETL Developer
9 years experience W2
0
Recommendations
Average rating
74
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
ETL Developer
Information Technology
Jan 2017 - present
Waukesha, WI
  • Analyzing, designing and developing ETL strategies and processes, writing ETL specifications, Informatica development, and administration and mentoring other team members.
  • Involved in gathering and analyzing the requirements and preparing business rules.
  • Parsing high-level design spec to simple ETL coding and mapping standards. Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
  • Creation of Informatica Workflows, sessions and Run that Sessions to load into Target and Debugging, Unit Testing of Mappings.
  • Actively participated in designing the Logical Data Model and Physical Data Model for Staging Area.
  • Developed transformation logic and designed various Complex Mappings and Mapplets using the Designer
  • Perform Informatica
  • Code migrations to different Informatica repositories.
  • Designed and developed Informatica Mappings to load data from Source systems to ODS.
  • Involved in gathering business requirements, logical modeling, physical database design, data sourcing and data transformation, data loading, SQL and performance tuning.
  • Defining the schema, staging tables, and landing zone tables, configuring base objects, foreign-key relationships, complex joins, and building efficient views.
  • Worked on Slowly Changing Dimensions - Type 1, Type 2 and Type 3 in different mappings as per the requirements.
  • Good exposure in Informatica MDM where data Cleansing, De-duping and Address correction were performed.
  • Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
  • Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes, performed performance tuning of the dashboard and created tableau functional design document.
  • Used SQL Assistant to querying Teradata tables.
  • Created a cleanup process for removing all the Intermediate temp files that were used prior to the loading process. Stream lined the Teradata scripts and shell scripts migration process on the UNIX box.
  • Wrote Teradata Macros and used various Teradata analytic functions. Monitoring the Teradata queries using Teradata View Point.
  • Creating and maintaining source-target mapping documents for ETL development team.
  • Created the Global shared location for storing the Cognos report outputs for different project streams.
  • Created the active reports by using Cognos.
  • Created control-M jobs and scheduled them.
  • Integrating the Work Flows to the Autosys jobs to schedule the run of the mappings.
  • Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
  • Understand the complex Java/Python scripts to write the mapping rules.
  • Developed SSIS packages with SQL Server and Oracle as data sources and loaded the data into target tables in SQL Server by performing different kinds of transformations.
  • Monitor the scheduled batch jobs for the execution of the workflows for any issues/failure or unusual behavior.
  • Attended daily standup meetings to update scrum master with what is achieved, what is being done and is there any impediment.
  • Ensure that all steps in implementation checklist have been verified.
  • Perform checkouts of the components after the production implementation.
  • Environment: Informatica 9.6.1, Oracle 11g, SQL server, T-SQL, PL/SQL, Agile, Toad, SQL Loader, Teradata, Java, Cognos, Python, PowerExchange, Power BI, Unix, Flat files. Microsoft Office, MS Access.
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
Remove Skill
ETL Developer
Professional/Consulting Services
Jan 2016 - Dec 2016
Broomfield, CO
  • Gathered Business Requirements, interacted with the Users, Project Manager to get a better understanding of the Business Processes.
  • Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g, DB2SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
  • Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.
  • Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.
  • Used various transformations like Source Qualifier, Joiner, Lookup, router, Filter, Expression and Update Strategy.
  • Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
  • Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools.
  • Worked on Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.
  • Good experience in migrating the views from Cognos.
  • Wrote Teradata Macros and used various Teradata analytic functions.
  • Extracted the data from various data source systems into the Landing Zone area by creating the Informatica mappings using the Teradata fast Loader Connections.
  • Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
  • Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
  • Involved in Unit, Integration, System, and Performance testing levels.
  • Written documentation to describe program development, logic, coding, testing, changes and corrections.
  • Modified existing mappings for enhancements of new business requirements. Involved in production support.
  • Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities.
  • Dealing with abends and perform restart, force complete and cancelling of jobs in Autosys.
  • Created Frameworks and processes for Autosys and UNIX development projects.
  • Used JIRA as the tracking tool for storing the test plan, uploading the test cases and storing the defects.
  • Environment: Informatica PowerCenter, Oracle 11g, Cognos, SQL Server, Autosys, (DB2), MS Access, Windows XP, Tableau, Python, Java, Teradata, Agile, Unix, Toad, JIRA, SQL developer.
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
Remove Skill
ETL Developer
Professional/Consulting Services
Aug 2012 - Jul 2015
  • Created Visual Basic applications to update Production databases.
  • Created Triggers and Stored Procedures for back-end validations.
  • Performance monitoring of Servers and Tuning SQL Code.
  • Establishing connectivity between Application software and the database.
  • Writing Windows Batch Programs to automate operations.
  • Managed historical data from various heterogeneous data sources like Excel, Fixed Width Flat Files.
  • Implementation and monitoring activities.
  • Writing complex Stored Procedures to meet the business requirements.
  • Creating tables, relationships, triggers and indexes for enforcing business rules.
  • Using SQL Profiler to estimate the Slow Running queries and performance tuning purpose.
  • Created and maintained various databases for production, development and testing using SQL Server
  • Import Data from MS-Access Database and XML to SQL Server Database.
  • Created packages, procedures, functions, and triggers.
  • Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into the database.
  • Worked on Migration techniques across different databases and servers.
  • Created Users and Roles, and managed security and permission of database.
  • Involved in analyzing SQL Server Storage Structure, Index and Security Architecture
  • Environment: MS SQL Server, MS SQL Server, Windows NT, Agile.
SQL Visual Basic XML Stored Procedure SQL Server ETL Agile Methodology Triggers ETL Developer
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Skills
Agile Methodology
2021
5
ETL
2021
5
ETL Developer
2021
5
SQL
2021
5
SQL Server
2021
5
Stored Procedure
2016
3
Cognos
2021
2
Data Analysis
2021
2
Informatica
2021
2
Informatica Powercenter
2021
2
Java
2021
2
Oracle
2021
2
Tableau
2021
2
Teradata
2021
2
TOAD
2021
2
Triggers
2015
2
UNIX
2021
2
Visual Basic
2015
2
XML
2015
2
Data Cleansing
2021
1
Data Profiling
2021
1
Data Warehousing
2021
1
Informatica MDM
2021
1
MS Power BI
2021
1
PL/SQL
2021
1
Scrum
2021
1
SQL Loader
2021
1
SSIS
2021
1
T-SQL
2021
1
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
JavaScript
0
1
jQuery
0
1
UI
0
1