Etl Developer Sql

VAISHNAVI RANGANATHAN

H* EAD Email: **********************@*****.***

ETL DEVELOPER Phone : 216-***-****

PROFESSIONAL SUMMARY

Strong experience in Complete Software Development Life cycle (SDLC) which includes Business Requirements Gathering, System Analysis, and Design, Development, and Implementation of Data warehouse.

Experience in using Oracle 10g/9i/8i, Netezza, Google Big Query, Postgres Sql, Sybase, Teradata, MS SQL Server 2005, MS Access 2007, SQL, PL/SQL.

Excellent hands on experience in creating measures groups, Scorecards and Key Performance Indicator (KPI) and defining actions, translations and perspectives in SSAS.

Worked with Dimensional Data warehouses in Star and Snowflake Schemas, slowly changing dimensions and created slowly growing target mappings, Type1/2/3 dimension mappings.

Proficient in transforming data from various sources (flat files, XML, Oracle) to Data warehouse using ETL tools.

Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.

Extensively experience in developing Informatica Mappings / Mapplets using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and Creating Workflows with Worklets & Tasks and Scheduling the Workflows.

Extensively involved in Informatica performance issue and Database performance issue, Expertise in error handling, debugging and problem fixing in Informatica.

Experience in design of logical and physical data modeling using E/R studio.

Extensive experience in writing PL/SQL programming units like Triggers, Procedures, Functions and packages in Unix and windows environment.

Exposure to on-shore and off-shore support activities

Excellent verbal and communication skills, has clear understanding of business procedures and ability to work as an individual or as a part of a team.

TECHNICAL SKILLS

Technologies: Data Warehouse,ETL,Oracle

ETL Tool: IBM DataStage 11.5,11.3,9.1/8.7,Informatica

Reporting BI Tools: Tableau, Power BI, Business Object

RDBMS: Oracle 12c/10g, Microsoft SQL Server, PostGres DB

Platforms: Unix

Languages: SQL,PL/SQL,Shell Script

PROFESSIONAL EXPERIENCE

Informatica ETL Developer

MNG HEALTH - Bensalem, PA Feb 2022 - Present

Responsibilities:

Developed ETL programs using Informatica to implement the business requirements.

Communicated with business customers to discuss the issues and requirements.

Created shell scripts to fine tune the ETL flow of the Informatica workflows.

Production Support has been done to resolve the ongoing issues and troubleshoot the problems.

Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.

Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.

Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.

Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.

Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.

Effectively worked on Onsite and Offshore work model.

Pre and post session assignment variables were used to pass the variable values from one session to other.

Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.

Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.

Performed unit testing at various levels of the ETL and actively involved in team code reviews.

Identified problems in existing production data and developed one time scripts to correct them.

Fixed the invalid mappings and troubleshoot the technical problems of the database.

Environment: Informatica 8.6.1,SQL Server 2008 R2, HP-UX

ETL Developer

DNB Financial - Downingtown, PA Jan 2021 to Feb 2022

Responsibilities:

Worked with Business users and Business analysts to understand and analyze ETL and reporting requirements. Conducted metric analytics to come up with technical specifications documents.

Used Informatica Powercenter components like Mapping Designer to design mappings, Workflow manager to create sessions and workflows to execute the mappings and workflow monitor to view the run properties, session logs and to do recovery process.

Worked with homogenous sources and heterogeneous sources and targets like relational tables, delimited and fixed width flat files and CSV format files while creating mappings.

Developed mappings using Expression, Source Qualifier, Filter, Router, Lookup and Joiner.

Created and used Views, Stored Procedures, Queries and tables while developing ETL mappings and reports.

Worked on building Xcelsius Dashboards on top of universes build using SAP Integration Kit.

Worked on Performance manager to create various metrics, Analytics and used Dashboard Manager to build corporate dashboards.

Developed reports by linking different data providers in a single report and made all possible incompatible objects as compatible by merging the common objects.

Performed unit testing on both ETL mappings and reports in order to match the amount and quantities figures against the transactional system.

Environment: Informatica 7.1, Business Objects XI R2/6.5, Oracle 10g/9i, Info View, Xcelsius, SAP Integration Kit

Informatica ETL Developer

Charter Communications - Denver, CO Dec 2018 – Dec 2020

Responsibilities:

Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracleand Delimited Flat files.

Development of ETL using Informatica 8.6.

Applied slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads.

Prepared various mappings to load the data into different stages like Landing, Staging and Target tables.

Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing the Mapping.

Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.

Created various tasks like Session, Command, Timer and Event wait.

Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.

Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.

Prepared SQL Queries to validate the data in both source and target databases.

Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages in Oracle.

Worked extensively on PL/SQL as part of the process to develop several scripts to handle different scenarios.

Created Test cases for the mappings developed and then created integration Testing Document.

Prepared the error handling document to maintain the error handling process.

Automated the Informatica jobs using UNIX shell scripting.

Closely worked with the reporting team to ensure that correct data is presented in the reports.

Interaction with the offshore team on a daily basis on the development activities.

Environment: Informatica Power Center 8.1, Oracle 9i, MS-SQL Server, PL/SQL Developer, Bourne shell, Windows XP,TOAD, MS Office

Data/ETL Analyst

Charter Global, Inc - Cleveland, OH Nov 2017 to Nov 2018

Responsibilities:

Responsible for creating mapping documents required for the ETL team.

Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Load data, analyze using OLAP tools).

Used Star Schema and Snow Flake Schema for data marts / Data Warehouse.

Gathered the business requirements by conducting a series of meetings with business users.

Created logical data model from the conceptual model and it's conversion into the physical database design.

Tuned the performance of the queries by working intensively over the indexes.

Extensively used Star Schema methodologies in building and designing the logical data model into Dimensional Models.

Used Sybase Power Designer tool for relational database and dimensional data warehouse designs.

Created reports using SQL Server Reporting Services (SSIS).

Involved in Data mapping specifications to create and execute detailed system test plans.

The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.

Used SQL for querying the database in the UNIX environment.

Prepared the Joins/Filter logic documents that would help the ETL design team perform the Joins on the tables that are in the form of flat files before loading them to FDS or any downstream systems.

Created documentation and test cases, worked with users for new module enhancements and testing.

Used SQL Server 2005 tools like Management Studio, Query Editor, Business Intelligence Development Studio (BIDS) including SSIS and SSRS.

Created job schedules to automate the ETL process.

Normalized the database up to 3NF to put them into the star schema of the data warehouse.

EDUCATION

M.E. (CSE) - Sasurie Academy of Engineering- Coimbatore, India 2016

B.E. (CSE) - Sree Sakthi Engineering College - Coimbatore, India 2014

Contact this candidate