Location: CA
Education: Bachelor’s degree in Computer Science, Computer Applications, or a related Engineering discipline, or equivalent.
Job Responsibilities
- Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
- 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.
- Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
- Using Informatica Power Center Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g, DB2, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
- Design and develop mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations. Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
- Data modeling using Erwin, Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.
- 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.
- Copied/Exported/Imported the mappings/sessions/ worklets /workflows from development to Test Repository and promoted to Production.
- Used 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.