Around * years of ETL and data integration experience in developing ETL mappings and scripts using
Informatica PowerCenter and Power Mart.
Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
Well versed in OLTP Data Modeling and Data warehousing concepts.
Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
Experience in T - SQL, SSIS, SSRS, Power BI and Tableau with initiatives that utilizes software and hardware components within a creative and technology-driven organization.
Experience in Developing Applications, including Dimensional Data Modeling - Star Schema, Facts & Dimensions.
Experienced in executing complex queries using stored procedures, Triggers, Cursors, User Defined Functions using T - SQL.
Experience in Database Development using mainly Oracle database. Experience with Data Cleansing, Data Profiling and Data analysis. UNIX Shell Scripting, SQL and PL/SQL coding.
Experience in generating on-demand and scheduled reports for business analysis using SQL Server Reporting Services (SSRS). Generated Drill down reports, Parameterized reports, Linked reports, Sub reports, Matrix reports and Cascaded reports in SSRS.
Experience in Designing, Creating and processing of cubes using SSAS. Created and Configured Data Sources and Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s, Hierarchies and calculated measures for OLAP cubes.
Experience in data migration from various data sources like Excel, SQL Server, Oracle, XML files, Flat files using
SSIS packages and SQL commands. Monitoring, debugging and tuning ETL jobs and workflows.
Strong decision making and organizational skills along with outstanding analytical and problem-solving skills to undertake challenging jobs. Able to work well independently and also in a team by helping to troubleshoot technology and business-related problems.
SDLC, SSIS, SSRS, Tableau Desktop, Tableau Server, Tableau Reader, Informatica, Power BI, SSAS, SQL, PL/SQL, SQL Server, Oracle, OLAP, Visual Studio, Power Mart, Data Mining, Data mart, UNIX Shell Scripting, MS Office, Windows, Linux
Masters of Technology in Technology Management
Kent State University, Ohio
PepsiCo, OH Jan 2019 to Current Role: ETL Developer Responsibilities:
Working with business users and business analyst for requirements gathering and business analysis.
Designing and customizing data models for Data warehouse supporting data from multiple sources on real time.
Extracted data from different flat files, MS Excel, MS Access and transformed the data based on user requirement using Informatica Power Center and loaded data into target, by scheduling the sessions.
Worked on Informatica Power Center tool - Source Analyzer, Data Warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
Developed PL/SQL procedures/packages to kick off the SQL Loader control files/procedures to load the data into Oracle.
Created SSIS Packages to extract data from Excel Files, MS Access files using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
Developed Interfaces using UNIX Shell Scripts to automate the bulk load & update Processes.
Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart. Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage, ODS and Mart.
Used Trillium as a Data Cleansing tool to correct the data before loading into the staging area.
Worked with SQL*Loader tool to load the bulk data into Database.
Prepared test Scenarios and Test cases in HP Quality Center and involved in unit testing of mappings, system testing and user acceptance testing.
Used ETL to extract files for the external vendors and coordinated that effort. Wrote Triggers and Stored Procedures using
PL/SQL for Incremental updates. Created Dimension Tables and Fact Tables based on the warehouse design.
Lamda, India July 2014 – Dec 2016 Role: ETL Developer Responsibilities:
Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using
Worked in various transformations like Lookup, Joiner, Sorter, Aggregator, Router, Rank and Source Qualifier to create complex mapping.
Maintained development process for developing ETL Packages and reports as per the norms like Gathering requirements, Design, Development, Code review, Unit Testing, Peer Review and Review before releasing to QA.
Extensive SQL querying for Data Analysis and wrote, executed, performance tuned SQL Queries for Data Analysis & Profiling. Extracted business rule and implemented business logic to extract and load SQL server using T-SQL.
Developed Drill-through, Drill-down, sub Reports, Charts, Matrix reports, Linked reports using SQL Server Reporting Services (SSRS).
Designed and developed the ETL solution using SSIS packages to implement slowly changing dimensions of Type 2 to populate current and historical data into Dimensions. ETL solution validated incoming data and sent notifications when jobs are done.
The customer data loaded into the SQL Server was used to generate reports and charts using the SQL Server Reporting Services (SSRS) reporting functionality. Work in SSIS, MS SQL server and SQL programming.
Maintained and scheduled of Tableau Data Extracts using Tableau Server and the Tableau Command Utility.
Creating SQL agent jobs after successful development of ETL packages and SQL codes.
Interacting with Coordinator/Team for the clarifications on daily calls and updating Status on weekly scrum calls.