Business Intelligence Engineer

12/2020 – 12/2021

• Worked on ingesting, synchronizing, integrating and cleansing data using
Informatica Intelligent Cloud Services(IICS) across various databases like
Oracle, SAP HANA, Microsoft SQL Server, Teradata and Snowflake.
• Good understanding and hands on experience of Data Engineering
principles – Data warehousing, ETL process, SQL and handling data in
JSON and another semi-structured formats.
• In - depth understanding of Snowflake cloud technology.

Informatica, Oracle Database, Snowflake, SQL

2/2020 – 12/2021

• Responsible for all activities related to the development, implementation, administration and support of ETL processes using Informatica Power Center
• End to end knowledge of Datawarehouse processes
.
.
• Constructing data fetching SQL Queries based on ETL approach whether incremental/complete refresh or based on DB Types
• Reviewed and provided technical oversight of requirements, designs and test plans
• Used PL/SQL to develop packages, functions and procedures
• Experience in complete SDLC using Agile as well as Waterfall model.

Informatica, Microsoft SQL-Server (MS SQL), Microstrategy, Oracle Database, PL/SQL, Postgresql, SAP BW/4HANA, SAP DS (BODS), Snowflake, SQL, Teradata Sql, UNIX

9/2016 – 1/2020

Have extensively worked in developing ETL program for supporting Data Extraction, transformations (like Source
• Qualifier, Aggregator, Filter, Router, Sequence Generator,
• Look-up, Rank, Joiner, Expression, Stored Procedure, SQL and Update Strategy) and loading using Informatica
• PowerCenter
• Understand the business rules completely based on High
• Level document specifications and implements the data transformation methodologies
• Used UNIX commands to run workflows, and import/export the same
• Involved in migrating database from Postgres to Oracle
• Continued testing, application, support, maintenance and updates throughout lifecycle of business applications
• Created database triggers, tables, indexes and programming views, stored procedure and functions.
Education

Informatica, SQL, UNIX