Roles and Responsibilities:• Design, develop, and test data processes per business requirements, following the development standards and best practices as well as participate in code peer reviews to ensure our applications comply with best practices.• Provided estimates for the required development and review activities.• Discuss with stakeholders, business, downstream to understand the feasibility of the solution.• Gather requirements to define data definitions, transformation… Show more Roles and Responsibilities:• Design, develop, and test data processes per business requirements, following the development standards and best practices as well as participate in code peer reviews to ensure our applications comply with best practices.• Provided estimates for the required development and review activities.• Discuss with stakeholders, business, downstream to understand the feasibility of the solution.• Gather requirements to define data definitions, transformation logic, and data model logical and physical designs, data flow, and process.• Assist developers with difficult Oracle PL/SQL code needed for queries and lead the team of 6 members.• Conduct reviews of developed code.• Test solutions to validate whether requirements have been met; develop test plans, test scripts, and test conditions based on the business and system requirements• Handled code migration, data load activities across all environments.• Monitor all business requirements and validate all designs and schedule all ETL processes and prepare documents for all data flow diagrams.Technology: Informatica, Redshift & UNIX Show less

Roles and Responsibilities:• Design, develop, and test data processes per business requirements, following the development standards and best practices as well as participate in code peer reviews to ensure our applications comply with best practices.• Provided estimates for the required development and review activities.• Discuss with stakeholders, business, downstream to understand the feasibility of the solution.• Gather requirements to define data definitions, transformation… Show more Roles and Responsibilities:• Design, develop, and test data processes per business requirements, following the development standards and best practices as well as participate in code peer reviews to ensure our applications comply with best practices.• Provided estimates for the required development and review activities.• Discuss with stakeholders, business, downstream to understand the feasibility of the solution.• Gather requirements to define data definitions, transformation logic, and data model logical and physical designs, data flow, and process.• Assist developers with difficult Oracle PL/SQL code needed for queries and lead the team of 6 members.• Conduct reviews of developed code.• Test solutions to validate whether requirements have been met; develop test plans, test scripts, and test conditions based on the business and system requirements• Handled code migration, data load activities across all environments.• Monitor all business requirements and validate all designs and schedule all ETL processes and prepare documents for all data flow diagrams.Technology: Informatica, Redshift & UNIX Show less

Roles and Responsibilities: • Design, develop, and test data processes per business requirements, following the development standards and best practices as well as participate in code peer reviews to ensure our applications comply with best practices.• Provided estimates for the required development and review activities.• Discuss with stakeholders, business, downstream to understand the feasibility of the solution.• Gather requirements to define data definitions, transformation… Show more Roles and Responsibilities: • Design, develop, and test data processes per business requirements, following the development standards and best practices as well as participate in code peer reviews to ensure our applications comply with best practices.• Provided estimates for the required development and review activities.• Discuss with stakeholders, business, downstream to understand the feasibility of the solution.• Gather requirements to define data definitions, transformation logic, and data model logical and physical designs, data flow, and process.• Assist developers with difficult Oracle PL/SQL code needed for queries and lead the team of 6 members.• Conduct reviews of developed code.• Test solutions to validate whether requirements have been met; develop test plans, test scripts, and test conditions based on the business and system requirements• Handled code migration, data load activities across all environments.• Monitor all business requirements and validate all designs and schedule all ETL processes and prepare documents for all data flow diagrams.Technology: Informatica, Redshift & UNIX Show less

Responsibilities :• Developing, testing, various ETL components using Oracle packages, procedures, views, triggers, informatica mappings, workflows etc ., for dara warehouse.• Mapping data from source to target.• Tuning procedures/queries for high performance.• Analyzing and developing various batch components.• Understand the ETL specifications and build the ETL applications like Mappings on daily basis• Need to fetch the daily data from various sources like… Show more Responsibilities :• Developing, testing, various ETL components using Oracle packages, procedures, views, triggers, informatica mappings, workflows etc ., for dara warehouse.• Mapping data from source to target.• Tuning procedures/queries for high performance.• Analyzing and developing various batch components.• Understand the ETL specifications and build the ETL applications like Mappings on daily basis• Need to fetch the daily data from various sources like relational and flat file sources.• Create the mappings, sessions and Workflows as per requirement of business to implement the logic• Perform the Unit Testing on developed code.• We need to participate in all phases of Data Warehousing like Analysis, requirement gathering and Design and Development of code• Create a mapping document based on High level design document • Develop and perform tests on all ETL codes for system data and analyze all data and design all data mapping techniques for all data models in systems.• Performance analysis.• Documents all technical and system specifications documents for all ETL processes and perform unit tests on all processes and prepare required programs and scripts. Show less

Worked in Various Project and gained knowledge in various roles, responsibilities as follows:• Responsible for gathering requirement from client.• Extensively worked ETL scripts using Informatica/Oracle source data and Validating the data in the MS SQL Server target DB.• Developed the Informatica mapping using SCD1 & SCD2 types.• Involved in Informatica Performance Tuning.• Performed integrated testing for various mappings. Tested the data and data integrity among… Show more Worked in Various Project and gained knowledge in various roles, responsibilities as follows:• Responsible for gathering requirement from client.• Extensively worked ETL scripts using Informatica/Oracle source data and Validating the data in the MS SQL Server target DB.• Developed the Informatica mapping using SCD1 & SCD2 types.• Involved in Informatica Performance Tuning.• Performed integrated testing for various mappings. Tested the data and data integrity among various sources and targets. Also prepared the required Test Case documents.• Prepared the functional specific low level document.• Developed the reports, Books & Batches as per the requirements.• Prepared Hyperion Financial reports training documents for client.• Involved in unit testing of reports from up gradation of Hyperion version 9 to Version 11.• Involved in preparation of Specification Documents, check list documents to ensure the defect minimization and Test Cases for DEV/UAT/PROD reports.• Involved in report migration activities (Import\Export) for all environment.• Perform Data Validation of the reports through Hyperion Excel Essbase to ensure the data in report output is accurate in all environments.• Handling resolution of QMS ticket with excellent turnaround time.• Supported the OBIEE team by preparing the Specification documents to develop the OBIEE reports.• Involved in design and execution of test cases and test scenarios along with generation of End to End UTP reports.• Provided support for the configuration of different AMD Feed Files.• Analyzed data for Tier 2 Validation.• Involved in code deployment activities for SIT, UAT & PROD environment.• Handled validation of both delimited and fixed width files.• Inbound/outbound configuration.• New feed configurations in the system.• Performance tuning for quick file validation.• Involved in the preparation of test cases for the reports.• Involved in Universe testing.• Data comparison of reports using beyond compare. Show less