Senior ETL Developer

Dharanitharan Arumugam

SENIOR ETL DEVELOPER SENIOR DWBI CONSULTANT

LinkedIn Profile: https://www.linkedin.com/in/dharanitharan-arumugam-56555210 PROFESSIONAL PROFILE

Senior ETL developer and DWBI Consultant with 10+ years of experience and proven success in Data Integration, Data Warehousing and Business Intelligence. Proficient in ETL Tools, SQL Scripting, Unix scripting, Data Visualization and ETL scheduling tool. Experienced in handling the Onsite-Offshore model projects in Agile or Waterfall method and interacting with multiple stakeholders.

TECHNICAL SKILLS

• ETL Tools: Informatica 10.x,9.x, SSIS,

Oracle PL/SQL packages

• Dashboard and Report Testing: Power BI,

OBIEE, SSRS

• Data Analysis/ Visualization: SQL, JMP

Power BI

• Scripting Languages: Unix Shell scripting,

C, C++, Java, Python, Scala

• Database: MS SQL Server, Oracle

• ETL job scheduling tools: Appworx, CRON,

Informatica Scheduler.

• Cloud knowledge: MS Azure

AREAS OF EXPERTISE

• End to End Data Pipeline (ETL)

• Data Analysis

• Development

• Team Building & Leadership

• Planning & Time Management

• Project Estimations

• Agile, Waterfall Projects

• Onsite – Offshore Model

EDUCATION

Bachelor of Technology (B. Tech) - Aug 2006 – Apr 2010 - Anna University, Chennai, India CERTIFICATIONS

• Cognizant Certified Informatica Developer – Cognizant internal certification ONLINE TRAINING & CERTIFICATIONS

• Business Intelligence & Data/Business Analysis with PowerBI via Udemy

• Applied Scala via Udemy

• Big Data Hadoop Foundation via IBM

EXPERIENCE

Organization: Cognizant Technology Solutions – From Aug 2010 to till date. Designation: Senior Associate

Roles: Senior DWBI consultant, Senior ETL developer, ETL Developer Worked for the following clients and projects.

PROJECT EXPERIENCE

Senior DWBI Consultant Informatica 10.x, 9.x, Oracle PL/SQL, Unix Shell Scripting, PowerBI, OBIEE, Appworx

Cummins - Manufacturing - Senior ETL developer, Senior DWBI Consultant Jan 2016 – till date

Columbus, Indiana, USA

Senior ETL Developer and lead for this DWBI project. Agile team member.

• Facilitate meetings with business subject matter experts, decision makers, systems owners, and end users to define goals and requirements for reports, dashboards, and analytics.

• Involved in requirement gathering from business executives, and documentation.

• Engages with data architects and ETL developers to assist with creating optimal data structures to analytical, reporting, dashboards and analytics.

• Collaborates with source system engineers to identify relevant data to be included in the warehouse

• Responsible for design strategy. Designed the source data ingestion system with audit mechanism to ensure the data quality for the downstream.

• Responsible for design of the end-to-end Analytical system.

• Responsible for designing tables, their relationships using star schema, snowflake schemas.

• Created Informatica mappings using transformations like lookup, joiner, sorter, aggregator, Java, Update strategy, filter to read data from Relational DBs like Oracle, SQL Server, Flat file sources from SFTP, Unix servers to perform source data ingestion, cleansing and curation of data, transforming the data with business logic.

• Implemented performance tuning methods in Informatica jobs like partitioning the sessions, push down optimizations to reduce the run time of the jobs.

• Created Oracle PL/SQL packages, procedures to transform the data.

• Created Unix shell scripts to read data from SFTP servers, move the processed files to archive folders, capture the load stats, email the users about job completion.

• Used Appworx scheduling tool, Informatica scheduler to schedule the workflows and to create dependencies between the jobs.

• Implemented error handling mechanisms to route the records that failed business validation to error table and designed automatic error recycling feature.

• Analyzed the performance bottlenecks in Oracle packages, procedures and Informatica mappings and implemented appropriate performance tuning methods like indexing, partitioning methods for better performance.

• Converted existing legacy Oracle PL/SQL packages into Informatica mappings and workflows to achieve maximum performance and reduced the latency for data availability for the business.

• Designed jobs to alert the users in case of any business-critical job failures and job load stats.

• Built the semantic layer and the analytical layer for metric consumption.

• Responsible for designing and building the analytical layer in PowerBI and OBIEE, created reports, dashboards for the metric data to be consumed for business.

• Scheduled the OBIEE Reports using iBots for automatic report delivery for the users.

• Developed automations and alerts using Informatica and Unix Shell scripting to avoid manual intervention for the business users.

Senior ETL Developer Informatica 9.x,8.x Oracle PL/SQL, Unix Shell Scripting, OBIEE, Appworx

Cummins - Manufacturing - Senior ETL developer, DWBI Consultant Jul 2014 – Dec 2015 Coimbatore, India

Senior ETL developer in the team.

• Involved in Requirement gathering sessions, came up with appropriate design for the ETL loads, Reports design.

• Created Informatica mappings using various transformations like Lookup, Router, Filter, Aggregator, Sorter, Java, Joiner, Update strategy. Created PL/SQL packages, procedures, Unix shell scripts to read data from Oracle, SQL Server, Flat file sources from SFTP, Unix servers and loaded data to staging layer and warehouse layer.

• Implemented appropriate audit mechanism in Informatica jobs for incremental data flow.

• Analyzed and fixed performance bottlenecks by creating appropriate indexes, partitions in database and used partitioning in Informatica mappings.

• Implemented error handling techniques in Informatica mappings to move the bad records to error tables.

• Created jobs and process flows in Appworx for the Informatica workflows and scheduled the jobs, created dependencies among the jobs.

• Created new OBIEE reports for various KPIs and scheduled them in iBots. ETL Developer Informatica, SSIS, Oracle PL/SQL, SQL Server, Unix Shell Scripting, OBIEE, SSRS Appworx

Cummins - Manufacturing - ETL developer Sep 2012 – Jun 2014 Coimbatore, India

UnitedHealth Group - Healthcare - ETL developer Sep 2011 – Aug 2012 Coimbatore, India

Claimsphere analytics - Healthcare - ETL developer Aug 2010 – Aug 2011 Coimbatore, India ETL developer in the team.

• Involved in Requirement analysis to understand the existing system and design for the ETL loads, Reports design.

• Created Informatica mappings using various transformations like Lookup, Router, Filter, Aggregator, Sorter, Java, Joiner, Update strategy. Created PL/SQL packages, procedures, Unix shell scripts to read data from Oracle, SQL Server, Flat file sources from SFTP, Unix servers and loaded data to staging layer and warehouse layer.

• Analyzed impacted stored procedures with HIPAA standards.

• Analyzed existing SQL queries to accommodate HIPAA standards.

• Developed SQL Server Integration Services (SSIS) packages to load the data from source, perform ETL and write the data to file to be consumed by EDI file generator.

Contact this candidate