Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Claris Joseph

Claris Joseph

Plano,TX

Summary

12+ years of comprehensive and versatile exposure of IT experience on Data Warehouse and Business Intelligence with proven ability of implementation through Software Development Life cycle (SDLC) encapsulating the encyclopedic process like Business Requirement Gathering, Data Analysis, Data Profiling, Application Design, Development, Testing, Implementation and maintenance of data warehouse and data mart systems.

Overview

15
15
years of professional experience
1
1
Certification

Work History

Senior Solution Specialist

Deloitte
09.2021 - Current
  • Served as a Senior Data Engineer and played a pivotal role in leading data engineering project including requirement gathering, data analysis, data profiling, designing, developing and testing solutions for complex business problems involving large scale data warehouse solutions.
  • Conducted in-depth analysis of source data and applied techniques to identify the KPIs’ and presented data insights to key stakeholders, contributing to product strategic decision.
  • Designed and developed ETL/ELT processes using Pyspark coding on AWS services such as S3, Glue, Lambda, Step functions, Event Bridge with Terraform scripts.
  • Designed and modeled database components to load the curated data to multiple target systems such as Postgres, Oracle, Netezza and Snowflake databases.
  • Streamlined the data ingestion process and deployed changes to production using CI/CD tool Terraform
  • Collaborated with project managers to select ambitious, but realistic coding milestones on pre-release software project development.
  • Managed client relationships effectively, ensuring timely delivery of high-quality solutions that met their specific needs.

Technology Lead

Infosys
08.2016 - 08.2021
  • Collaborated with data engineering team to ensure data readiness in data lake from different source systems to build cloud data warehouse in Snowflake using Informatica, TalenD Integration tools
  • Created logical data models using Erwin and applied business logic to convert raw data objects into Facts and Dimensions
  • Performed feasibility study on reporting requirements to create prototype reporting models like wireframes, specification diagrams, chats
  • Designed, developed, and implemented BI solutions for Sales, Pro-Sales research, Product and Customer KPI's
  • Developed Semantic data models to build BI reports using Tableau, Looker BI tools
  • Acted as team leader in group projects, delegating tasks and providing feedback.

ETL Developer

Ajace Inc
04.2014 - 07.2016
  • Gathered requirements from client and followed ETL SDLC process
  • Created workflows, sessions, mapping variables and mapping parameters and created UNIX wrapper script to execute Informatica workflows
  • Created Low level design documents like Mapping sheet, Unit Test Plan, code review checklist and resolved issues maintained in tracker sheet
  • Actively supported during project deployment and resolved issues raised by production support team on jobs.

Project Engineer

Wipro Technologies
09.2009 - 06.2012
  • In-depth understanding of processes involving data modeling and building data marts and translated business processes into Informatica mappings using transformations like Aggregator, Joiner, Union, Lookup, Expression, Filter, Update Strategy, Router
  • Implemented entire ETL job scheduling using Autosys and monitored Informatica jobs daily and made a force start whenever job failed in DEV, QA and UAT environments
  • Performed Unit testing and created Mapping documents, code review documents, Unit Test Plan documents to track overall SDLC process.

Education

Anna University
India

Skills

  • Cloud Services - AWS, Microsoft Azure, GCP
  • Continuous Integration – Pyspark, Informatica Power Center, TalenD
  • Databases - Postgres, MySQL, Snowflake, BigQuery, AWS Redshift, Netezza, Oracle
  • Programming - Python, Scala, SnowSQL, NZ SQL, PL/SQL, Unix
  • CI/CD tools – Terraform, Jenkins
  • Developer tools –Visual studio code, Bit Bucket, Git hub, Confluence, JIRA
  • BI Reporting – Looker, Tableau, Power BI, OBIEE, SAP Crystal Report

Certification

  • Informatica Power Center Data Integration
  • SnowPro Core Certified
  • AWS Associate Architect
  • Microsoft Azure Data Engineering.

Timeline

Senior Solution Specialist

Deloitte
09.2021 - Current

Technology Lead

Infosys
08.2016 - 08.2021

ETL Developer

Ajace Inc
04.2014 - 07.2016

Project Engineer

Wipro Technologies
09.2009 - 06.2012

Anna University

Similar Profiles

CREATE PROFILE
Claris Joseph