Vamsi Krishna Dasari

Sr Etl Informatica Developer @EverBank

Boston, MA, US

Developed ETL programs using Informatica IICS to implement business requirements.• Created multiple mappings and task flows based on requirement in CDI.• Communicated directly with the clients for requirement gatherings and discuss any issues.• Primarily worked on migrating the account and user ID details from BOTW system to BMO.• Migration involved working on large amounts of data using Slowly changing dimensions, complex transformations and SQL procedures.• Implemented data formatting using various logics on source qualifier, filter, expression, aggregator, lookup transformations.• Pre and post session assignment variables were used to pass the variable values from one session to other.• Create and maintain the short term and long term IICS processes road map.• Create architecture using Informatica Cloud, IICS (Data Integration & Application Integration).• Responsible for setting up IICS Org structure, Installing IICS Secure Agent and setting up IICS servers.• Review and create IICS mapping tasks, IICS task flows and IICS schedule.• Create and review ETL process migration strategy to migrate organizations ETL processes from Informatica Power enter to Informatica Cloud (IICS).• Create and manage IICS best practices and IICS naming and coding standards.• Experience using IICS/IDMC components – CDI, CDQ, Data Profiling.• Designed workflows with many sessions using decision, assignment task, event wait and event raise tasks.• Performed unit testing at various levels of the ETL and actively involved in team code reviews.• Worked on building SQL procedures for data pipelines in snowflake data warehouse and cloud environment.• Worked on data visualizations and dashboards using power BI to integrate and generate reports.• Worked on parameter files for defining mapping variables, task flow variables, FTP connections and relational connections.

New England College

MASTERS, Computer and Information Systems