Jinna Harika

Over 18 Years of experience in Design, Coding, Administration, Development & Implementation of Data Warehouse/Data Marts. Over 15 Years of experience as a Sr.

Data Warehousing

Analyst with ETL tool like Informatica and PL/SQL programming. Over 10 Year of experience in Informatica Administration and have installed and upgraded various versions. Good Expertise in establishing ETL environments according to project requirements.

Advance

Knowledge and excellent concepts in ETL, Data warehousing and DataMart. Extensive knowledge in Informatica ETL Tools (Admin Console, PowerCenter, Repository Server, Informatica Server, Repository Admin Console, Repository Manager, Designer, Workflow Manager and Workflow Monitor).

Worked

Extensively on Informatica Designer Client Tool (Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet and Transformations). Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator.

Extensive

Knowledge in conversion of Corporate Data Model into Data Warehouse using Star or Snowflake schema. Involved in the extraction process to get the data from Oracle sources, Flat files etc. Expertise in implementing an efficient migration process to move ETL objects from development to test and production environments using Informatica deployment groups, Import/Export option.

Proficient in interaction with the business users. Pioneered load strategies of loading staging area and data marts. Dealt with SCD Type1/Type2 loads. Emphasized on Performance of Mapping Optimizations in Informatica.

Very strong skills in writing SQL Queries and Procedures for development and testing Business applications. Efficient in working on remote systems using FTP and hands on experience in modifying and uploading the files to the remote systems. Extensive knowledge in scheduling the jobs using Autosys.

Excellent

Communication and Interpersonal skills. Proven problem solving, Self-starter and worked individually as well as adapting rapid changes in team environments and priorities. Demonstrated ability in Grasping New Concepts (both Technical & Business) and utilize as needed.

Sr. Informatica Developer at IRS (2022-05 – Present)

• Validated and reconciled large datasets in Greenplum to ensure data accuracy, completeness, and consistency across source and target systems.
• Performed detailed data analysis using complex SQL queries to identify data discrepancies and support business validation requirements.
• Monitored, scheduled, and managed ETL workflows using Control-M, ensuring timely execution and quick resolution of job failures.
• Automated routine tasks such as file handling, job triggering, and data validation, reducing processing time and human errors.
• Conducted end-to-end data validation, including source-to-target reconciliation, data quality checks, and transformation verification.
• Created data validation frameworks and reusable SQL scripts to ensure consistent testing and validation across multiple projects.
• Utilized GitHub for version control, code check-in/check-out, and collaboration, ensuring proper code management and traceability.
• Followed branching and merging strategies in GitHub to support parallel development and maintain code integrity across environments.
• Participated in code reviews and enforced best practices for ETL development, version control, and deployment processes.
• Designed, developed, and deployed complex ETL workflows using Informatica PowerCenter 10.5.2, improving data processing efficiency and scalability.
• Led end-to-end data integration projects, including requirement gathering, data mapping, transformation logic, and deployment.
• Built reusable mappings, mapplets, and workflows to standardize ETL development and reduce development time by up to 30%.
• Optimized session performance using advanced techniques such as partitioning, pushdown optimization, caching strategies, and bulk loading.
• Implemented robust error handling, logging, and recovery mechanisms to ensure data accuracy and reliability.
• Tuned SQL queries and database performance in coordination with DBAs to enhance overall ETL throughput.
• Automated scheduling and monitoring of workflows using Informatica Workflow Manager and external schedulers like Control-M.
• Ensured data quality by implementing validation rules, data cleansing, and reconciliation processes.
• Worked with Agile/Scrum methodologies, participating in sprint planning, stand-ups, and retrospectives.
• Documented ETL processes, data lineage, and technical specifications for audit and compliance purposes.

Informatica Admin at IRS (2018-06 – 2022-04)

• Installed and configured various Informatica versions on Informatica ICC.
• Installed various Informatica Emergency Bug Fixes.
• Used Informatica OS Profile concepts with Informatica ICC to manage multiple projects under same domain.
• Worked on creating the various packages for Power Exchange Greenplum.
• Worked on creating the various packages in Drive for Emergency Bug Fixes.
• Worked on Key tabs Maintenance.
• Worked on configuring LDAP to setup the connection and specify users and groups in the security domain.
• Created and configured various objects within Informatica Admin Console using GUI and Informatica command line references.
• Extensive experience on Informatica Admin Console configuration for on boarding new projects and manage existing projects on Informatica Platform.
• Worked on restoring multiple files for Emergency Bug Fixes, DVO and Power Exchange.
• Worked on creating multiple change requests in KISAM.
• Worked on updating the scripts for various Informatica Emergency Bug fixes.
• Gave knowledge transfer to team members on how to stage in BigFix console.
• Gave knowledge transfer to team members on installing Emergency Bug Fixes.

Informatica Admin/Sr. Informatica Developer at Deloitte (2014-11 – 2018-05)

• Worked with the business along with the analysts to gather the requirements and provided numerous solutions based on the requirements.
• Installed and configured various Informatica versions on Informatica ICC.
• Installed various Informatica Emergency Bug Fixes.
• Created and configured various objects within Informatica Admin Console using GUI and Informatica command line references.
• Extensive experience on Informatica Admin Console configuration for on boarding new projects and manage existing projects on Informatica Platform.
• Used Informatica OS Profile concepts with Informatica ICC to manage multiple projects under same domain.
• Worked with enterprise architect to implement Informatica Solutions at various clients.
• Implemented various shell scripts to automate Informatica processes like backup repository on daily bases, repository restore process etc.
• Responsible for weekly status / triage meetings & preparing the Weekly Status Report (WSR) and showing progress and efforts to the Manager.
• Helped projects with their code migration processes with different Informatica environments.
• Manage multiple Informatica Products like PowerCenter, DVO, DT within organizations.
• Modified existing/Developed new complex Informatica PowerCenter Mappings to extract and pull the data according to the guidelines provided by the business users from different sources like Flat files, Oracle, SQL Server and populate the data into Oracle Target Systems.
• Created Mappings using Mapping Designer to load the data from various sources, using different transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Update Strategy, Joiner, Filter, and Sorter transformations.
• Developed mappings/Reusable Objects/Transformation/mapplets/user defined functions by using mapping designer, transformation developer and mapplet designer in Informatica Power center.
• Used Debugger within the Mapping Designer to test the data flow between source and target and to troubleshoot the invalid mappings.
• Involved in writing procedures, functions in PL/SQL and also involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
• Involved in using Autosys as a scheduling tool to schedule the jobs. Designed and created Autosys Jill jobs to schedule the workflows and the procedures.
• Involved in Unit testing, System testing and UAT to check data consistency.
• Assisted testing team for their System Integration Testing.
• Prepared all documents necessary for knowledge transfer such as ETL strategy, ETL development standards, ETL processes.

Jr Informatica Admin/Sr. Informatica Developer at Capital One (2012-12 – 2014-10)

Worked with the business along with the analysts to gather the requirements and

Bachelor's in computer science and Engineering