NAVYA KALAPALA

• Created ETLworkflows based on requirements, maintained historical data, ensured data equivalence in ETL and MDM databases,scheduled jobs,collaborated with QA to resolve production issues, and tuned performance for existing jobs.
• Migrated Informatica objects, parameter files, and scripts using GitHub and Jenkins.
• Documented user requirements, translated them into system solutions, and developed implementation plans and schedules.
• Extracting data from excel files, high volume of data sets from data files, Toad DB2 using informatica ETL Mappings/SQL and loaded to data store area.
• Creating and monitoring batches and sessions using informatica Powercenter server.
• Extensively involved inwriting SQL queries(sub queries and join conditions).
Developed shell scripts for scheduling jobs in UNIX environment.

• ETL – Creating workflows as per requirement, maintaining historical data, data equivalence in ETL and MDM dbs, scheduling jobs, working with QA to resolve production issues, performance tuning for existing jobs
• Migrating informatica objects, parm files, scripts using Git Hub and Jenkins, Discussions with client for clarifications on requirements, Creating incidents on issues with Database or informatica tool
• Documenting user requirements, translating requirements into system solutions and developing implementation plan and schedule
• Extracting data from excel files, high volume of data sets from data files, Toad DB2 using informatica ETL Mappings/SQL and loaded to data store area
• Creating and monitoring batches and sessions using informatica Powercenter server
• Working with various transformations, like router, expression, SQL, lookup, normalizer, and aggregator, in building complex mapping.
• Extensively involved in writing SQL queries (sub queries and join conditions)
• Developed shell scripts for scheduling jobs in UNIX environment.