Responsible for developing support and maintenance for the ETL Extract Transform and Load processes using Pentaho
Created several Pentaho Data Integration Transformations Jobs aka Kettle with UI as Spoon to extract data from OLTP systems and load into staging databases
Involved in performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
Wrote complex stored procedures in Confidential SQL using SQL Server Management Studio SSMS to summarize the data in staging environment and then developed PDI s to load the summarized data in Data warehouse Data Mart Dimension and Fact Tables
Wrote cursors in the stored procedures to perform row wise operations
Created triggers on master data tables in OLTP to keep track of insertion and updates
Created Profiling Cleansing and auditing plans with pdi jobs and transformation
Applied Configuration Logging Error reporting to all packages to make package deployment easy and troubleshoot package on run time
Implemented Logic with lookup table to maintain Parent Child relationship and maintain hierarchy Wrote Perl UNIX scripts for preliminary file check and extracting data from vendors
Used transformation like Merge Join Pivot lookup Fuzzy lookup and slowly changing Dimension
Generated reports using SSRS that could be used to send information to different managers of Different Branch
Created different type of reports including Crosstab Tabular Charts graphs Sub reports Drill down reports with Cascading Parameter prompts
Created sessions and batches to move data Confidential specific intervals on demand using Server Manager Responsibilities include creating the sessions and scheduling the sessions
Extracted the data from Oracle DB2 CSV and Flat files Confidential SQL PL SQL
Understanding the Functional Requirements Designed the dimension model of the OLAP data marts in Erwin Wrote documentation to describe program development logic coding testing changes and corrections
Performed Unit testing and System integration testing Preparing the documents for test data loading Troubleshoot the Productions failure and provide root cause analysis
We’re building a relationship-oriented bank for the modern world. We need talented, passionate professionals who are dedicated to doing what’s right for our clients.