Denis Rex Arun Xavier
Atlanta,GA
Summary
An experienced Informatica professional of 16+ years of experience with an extensive Data Warehouse, Data Analytics and cloud platforms. Over 12+ years of experience in Informatica, SQL, PL/SQL, Teradata with Unix environment. Agile working experience with Scrum and SDLC methodologies and the best practices. Extensive experience in analyzing the Business Requirements, Data modeling, Designing and Building the largescale Data warehousing environment defining the ETL and ELT processes. Experience building horizontally scalable data pipeline development in Informatica, IDMC. Experience in writing and maintaining ETLs process using Informatica tool, which operate on a variety of structured, semi-structured and unstructured sources. Experience in cloud platform-Informatica Intelligent Cloud services, Google cloud, AZURE. Proficient with variety of Databases and ability to write complex SQL query and query optimization. Experience with Atlassian products such as JIRA, Confluences, Bitbuckets. Thorough working experience of DevOps, Jenkins and CI/CD.
Overview
18
18
years of professional experience
1
1
Certification
Work History
Technical Lead
Bank of the west (via TCS)
02.2023 - Current
- Worked closely with stakeholders across departments to design, build and deploy various initiatives with the data platform
- Experience in working with Agile Scrum and SDLC methodologies
- Experience with Atlassian products such as JIRA, Confluences, BitBucket, Devops, Jenkins and CI/CD
- Created Informatica mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner etc
- Experience in using different file formats like xml, xsd,json and used transformations like hierarchy schema and hierarchy parser to read the xml/json files in IICS
- Modified informatica 10.5.2 with IDMC mappings and added functionality like synchronization, Replication, data masking
- Involved in data verification and testing methods for the data warehouse to ensure data accuracy
- Experience on Designed, Developed, implemented ETL process.
Technical Lead
Kaiser Permanente (via TCS)
10.2018 - 01.2023
- Experience in working with Agile Scrum and SDLC methodologies
- Experience with Atlassian products such as JIRA, Confluences, BitBucket, Devops, Jenkins and CI/CD
- Kaiser will internally manage 1 tool called Atlas, it contains the information like desktop, asset and Server informations, user will raise service task came we need to look into it and need to provide the resolutions
- We need to co-ordinate with different team like source team, vendor team and Business team to get the requirements
- Involved in supporting Azure applications with ETL for Subscription, Resource group, Virtual Machine(IAAS), Database(PAAS), NIC(IAAS), Subnet (IAAS), Azure Storage (IAAS), Azure Event Hub (PAAS), Machine Learning(PAAS) & Azure Chatbot Service
- Performed tuning of Informatica Mappings for optimum performance
- Worked in basic Unix script to create reports and send it to management.
Senior Tech Lead Data Integration
TD Bank (via wipro Technologies)
08.2017 - 09.2018
- Experience in working with Agile Scrum and SDLC methodologies
- Experience with Atlassian products such as JIRA, Confluences, BitBucket, Devops, Jenkins and CI/CD
- Identified the high level approach being used for Self Service Delivery into SHARE by the BDW Line of Business and to establish common high level patterns that can be utilized by other share LOB Tenants
- BDW is broken into 5 different segments(SHARE Data Movement) -> podium Ingestion -> podium publish of Data to SHARE -> to HEAT Replication -> HEAT BI Tool usage, SHARE Test Data Creation, SHARE Heat Security Framework, HEAT to SHARE migration of Queries to production, SHARE metadata management and publish
- Source Data is delivered to Dev:EDPP via MFT, podium is used to ingest data into EDPP
- HIVETables/HDFS tables are created in SHARE staging Area via Podium Publish.
Senior Etl Developer
Mobile Application Development (via Veezolvian communication)
01.2016 - 05.2017
- Interacted with the Business Analysts to understand the process flow and the business
- Analyzing Source to Target mapping Excel document (BRS)
- Created Data Flow Mappings to extract data from source system and Loading to Target
- Converted the regular mappings to handle the Slowly Changing Dimension
- Created and used various re-usable tasks, workflows, worklets, mapplets, and re-usable transformations
- Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner etc.
ETL Developer
Kaiser Permanente, (via cognizant Technology Solutions)
01.2013 - 12.2015
- Fine-tuning of most frequently used transformations like Filter, Router, Sequence Generator, Lookups, Expression, Sorter, and Aggregator
- Minimized development, test and deployment efforts by using Variables, Parameters and Parameter Files
- Used labeler transformations for different types of inputs and describes the types of characters for input
- Supported business users through data Quality by creating scorecards
- Used reference file as a lookup file for standardizing, cleansing and parsing operations.
ETL Developer
Dun & Bradstreet, (via cognizant Technology solutions)
01.2011 - 12.2012
- Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center
- Created Mappings to extract the unique account numbers from the data warehouse tables and updated them with tokens in PCCD/SKOUT/KOUT files and data warehouse tables
- Developed various transformations like Source Qualifier, Sorter transformation, Joiner transformation, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
ETL Developer
CitiBank, Chennai(via Polaris Software Labs Ltd )
07.2008 - 12.2010
- Prepared High-Level Design and Low-Level Design documents based on Functional and Business requirements
- Data architect for Data analysis, mapping, Conversion, Quality and Migration projects
- Data Modeling (Logical & Physical) by using ER/Studio Data Architect tool and generate the scripts with appropriate security privileges based on the business needs
- In addition, provided L2 support for Informatica and BO provided for production environment.
Software Engineer
Pixel product (via Pixel soft solutions)
07.2006 - 12.2008
- Interacted with the Functional Analysts to understand the process flow and the business
- Implemented PL/SQL stored procedures for capturing the mismatches in target database for different environments and maintained them in Informatica
- Modified some of the functions as per the project requirement
- Used shell scripts for taking Domain backup of repository, which gave an alert if the space occupied was over 95% in the Dev Environment
- Executed test cases and supported the workflows in Dev and QA.
Education
Bachelors of Technology in computer science & Engineering -
shanmugha college of Engineering(SASTRA)
01.2005
Skills
- Agile Methodology
- Issue investigation
- Performance Optimization
- Test-driven development
Certification
- AZ-900 Microsoft certified Azure Fundamentals, 09/2023
- AI-102 Microsoft certified AI Engineer, 10/2023
- AZ-104 Microsoft certified Azure Administrator, 02/2024
- Cloud Digital Leader Google cloud certified, 04/04/2024
Technicaldetails
Informatica Intelligent cloud software, AWS, Azure, Oracle, Teradata, No-SQL, PL/SQL, MS SQL Server, Business objects, cognos TM1, SQL, PL/SQL, Unix shell scripting, Control-M, Tivoli, Autosys, Informatica-Power center 10.5.2, IDQ Talend 6.3 Data Integration
Personal Information
Title: Senior Data Engineer
Timeline
Technical Lead
Bank of the west (via TCS)
02.2023 - Current
Technical Lead
Kaiser Permanente (via TCS)
10.2018 - 01.2023
Senior Tech Lead Data Integration
TD Bank (via wipro Technologies)
08.2017 - 09.2018
Senior Etl Developer
Mobile Application Development (via Veezolvian communication)
01.2016 - 05.2017
ETL Developer
Kaiser Permanente, (via cognizant Technology Solutions)
01.2013 - 12.2015
ETL Developer
Dun & Bradstreet, (via cognizant Technology solutions)
01.2011 - 12.2012
ETL Developer
CitiBank, Chennai(via Polaris Software Labs Ltd )
07.2008 - 12.2010
Software Engineer
Pixel product (via Pixel soft solutions)
07.2006 - 12.2008
Bachelors of Technology in computer science & Engineering -
shanmugha college of Engineering(SASTRA)
Similar Profiles
MARIAM HOVSEPYANMARIAM HOVSEPYAN
Senior Teller at Bank of the WestSenior Teller at Bank of the West
Habetamua AbonehHabetamua Aboneh
Power Platform Developer at Bank of the WestPower Platform Developer at Bank of the West
Christophe BassonoChristophe Bassono
Cybersecurity Engineer II at Bank Of The WestCybersecurity Engineer II at Bank Of The West