Ambika Prasad Pati
Irving,TX
Summary
Over 6+ years of experience in Data engineering, Data governance, Data quality, Data Visualization to provide actionable insight for decision-making. Seasoned in developing Data warehouse and Business Intelligence assets using tools like Informatica PowerCenter, Informatica IDQ, Informatica IICS, AWS, Tableau, Oracle, and others. Involved in IT Business Analytics, Data Analytics and Data Profiling tasks with business to make data more accurate and result oriented. Experience on working with Agile, Scrum iterative approach project management and software development.
Overview
10
10
years of professional experience
Work History
Data engineer
Advithri Technologies
06.2023 - Current
- Redesigned views and maplets to support snowflake functionalities
- Worked with AWS cloud platform and its features which includes EC2, VPC, RDS, S3, Cloud Watch etc
- Involved in Policy management, Change Management
- Created Mappings using Informatica to load the data from various sources, using different transformations like Source Qualifier, Expression, Lookup
- Developed and implemented ETL process using Informatica cloud (IICS) Data integration
- Worked on python scripts to start and stop EC2 instances in AWS
- Created data stories, reports and visualizations using Tableau
- Developed and implemented data governance policies to ensure data quality, and compliance
- Performed ETL performance tuning of the sources, targets, transformations, mappings, workflows and sessions to resolve or remove the bottlenecks
- Created graphql queries and schemas to interact with mongo db.
ETL/Data Engineer
Deloitte
10.2021 - 06.2023
- Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration and reporting
- Created various IICS connections using various cloud connectors in IICS administrator
- Extensively used performance tuning techniques while loading data in snowflake using Informatica cloud (IICS)
- Worked on daily jobs to move files from remote host to s3 environment
- Implemented data validation mechanisms in SSIS packages to ensure data quality and integrity
- Worked to optimize SSIS packages for performance, reducing data processing times and resource consumption
- Led data governance training sessions for team members to promote best practices and awareness
- Developed and optimized SQL queries for SSRS reports to retrieve and present data efficiently
- Experience in extracting, cleaning, and transforming data from various sources and loading it into Snowflake for analysis
- Automated ETL workflows, reducing manual intervention and increasing the speed of data ingestion, while also minimizing errors.
Data Analyst
Cognizant
02.2020 - 10.2021
- Designed data warehouses and data marts using star schemas, snowflake architecture, and Kimball dimensional modeling
- Leveraged data analysis techniques to validate business rules and identify missing data of low quality in the existing enterprise data warehouse
- Created various artifacts for projects, including specification documents for data mapping and data analysis
- Enhanced the existing mappings in informatica to implement SCD Type 2
- Developed and Optimized SQL scripts by using User-Defined Functions (UDFs), Common Table Expressions (CTEs), stored procedure, creating indexes, and leveraging the SQL Profiler tuning advisor
- Monitored and resolved deadlocks in SQL Server databases using locks, isolation levels, and the SQL Profiler
- Designed fact tables and developed an ETL master package for loading data into the data mart.
ETL Developer/Designer
Infosys
06.2014 - 07.2018
- Used extensively Informatica transformations like Lookups, Aggregator, Update Strategy, Stored Procedure, Sequence generator, Joiner transformations
- Designed the Data Model using Erwin and integrating E-R models with the Oracle Database
- Translation of Business processes into Informatica mappings for enchantments of the project
- Involved in Unit testing of the mappings created Unit test cases for all the mappings
- Created global repository, Groups, Users assigned privileges using repository manager
- Involved in Version control of the jobs using GIT, SVN to keep track of the changes in the Development Environment
- Developed Shell scripts to setup runtime environment, and to run stored procedures, packages to populate the data in staging tables.
Education
Master of Science in Computer Science -
The University of Texas at Arlington
Arlington, Texas12.2018
Skills
- Windows,Mac,UNIX,LINUX
- Python basics,SQL,XML,HTML
- SSMS, TOAD, GRAPHIQL,SNOWFLAKE, Tableau
- Informatica Power Center, IDQ, IICS,AWS
- SQL Server,PostgreSQL,Teradata,Oracle,Mongo db
- GIT, SVN, JENKINS, JIRA
Timeline
Data engineer
Advithri Technologies
06.2023 - Current
ETL/Data Engineer
Deloitte
10.2021 - 06.2023
Data Analyst
Cognizant
02.2020 - 10.2021
ETL Developer/Designer
Infosys
06.2014 - 07.2018
Master of Science in Computer Science -
The University of Texas at Arlington
Similar Profiles
Rajesh MylaRajesh Myla
Data Analyst at Advithri TechnologiesData Analyst at Advithri Technologies
Ganesh PuliGanesh Puli
Senior DevOps Engineer at Advithri TechnologiesSenior DevOps Engineer at Advithri Technologies
Mahender VoddiMahender Voddi
Cloud DevOps Engineer at Advithri Technologies LLCCloud DevOps Engineer at Advithri Technologies LLC