Navya Kalapala

• Created ETL workflows 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; clarified requirements through client discussions; created incidents for database or Informatica tool issues.
• 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 in writing SQL queries (sub queries and join conditions)
• Developed shell scripts for scheduling jobs in UNIX environment.

Developed data integration solutions as an Informatica Developer.

• Developed code for landing, staging, and incremental loading processes to populate target tables in atomic model.
• Created and maintained Informatica mappings and workflows according to project specifications.
• Creating mapplets, reusable transformations, worklets and using them in different mappings, workflows.
• Validated source flat file formats using Unix shell scripts to ensure compliance with specified requirements.
• Created parameter files and modified session parameters, mapping parameters, and variables during execution.
• Documenting at a functional level how the procedures work within the data quality applications.
• Gathering requirements and analyzing them for further development tasks.