Location: OH
Education: Bachelor’s degree in Computer Science, Computer Applications, or a related Engineering discipline, or equivalent.
Job Responsibilities
- Integrate data to support both operations Operational Data Store (ODS) and Analytics (Data warehouse).
- Design data input and data collection processes for the enterprise data warehouse.
- Enhance and maintain relational databases to support new application features and maintain data repository with data definitions, relationships, linkages and sources. Analyze data or evaluating how information needs might be translated into back end database structures
- Transform to create work flow Model metadata, cubes, and maps as per business requirements. The workflow that is developed in lower environment is moved to production system after quality testing approvals from business teams.
- Design and develop mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations. Manage the Metadata associated with the ETL processes used to populate the Data Warehouse.
- Interpret logical and physical data models for business users to determine common data definitions and establish referential integrity of the system using ER-STUDIO.
- Work with Functional team to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.
- Import the mappings/sessions/ worklets /workflows from development to Test Repository and promoted to Production.
- Use Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
- Work with Static, Dynamic and Persistent Cache in lookup transformation for better throughput of Sessions. Used PMCMD command to automate the Power Center sessions and workflows through UNIX.
- Extract data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.
- Prepare codes for all modules according to require specification and client requirements and prepare all required test plans.
- Create reports from the jobs scheduled for audit purposes and sent out the internal audit teams to make sure that the reports are Compliant and monitoring compliance run results to the expected business owners as per daily, weekly and monthly process.
- Prepare UNIX Shell Scripts and these shell scripts will be scheduled in AUTOSYS for automatic execution at the specific timings.
- Prepare test Scenarios and Test cases in HP Quality Center and involved in unit testing of mappings, system testing and user acceptance testing.
- Work on identifying and resolving major production fixes and provide innovative solutions to meet the needs of the business.