Execute full life cycle implementations including requirements gathering, Fit Gap Analysis, design, coding, testing, debugging, deployment and maintenance in Agile SDLC methodologies. Implement security (data/object) in OBIEE. Create and implement aggregate tables for report performance improvement. Develop and design star and snowflake design using logical layer. Extensively work on configuring cache management and setting the purging process using event pooling. Build the ETL architecture and source to target mapping to load data into data warehouse by using InformaticaPower Center. Design SSIS packages to perform data profiling, data cleansing and data transformation. Create SSIS jobs and scheduled packages using SQL Server for the daily load. Work on SSRS to design and develop Matrix and Tabular Reports. Develop and schedule the Autosys jobs to call the UNIX Scripts to run in the desired manner. Design SSIS packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes. Develop metadata repository using OBIEE Administration tool in physical, business model and mapping, and presentation layer. Extensively use Toad to write, validate and analyze SQL queries. Write Teradata SQL queries to join or modify the table and create customized Mload scripts on UNIX platform for Teradata loads. Generate complex reports in Cognos studio including Drill Down reports from DMR modeled framework model. Create web services that access production data securely via XML and create transaction stored procedures to receive and to send the data to the XML web services. Serve as a contact to relationships outside of the company as appropriate. Perform special projects and other related duties as assigned/required.
Master’s degree or foreign equivalent in Computer Science, Engineering, or a related field of study, and one (1) year of experience in a related occupation. Work experience must have included: InformaticaPower Center, SSIS, SQL Server, SSRS, Autosys, SSAS, OBIEE, Toad, Agile, Teradata, Cognos and XML Web Services.
To apply, please send C.V. & cover letter to P. Sajja, 4030 Old Milton Parkway, Suite 200, Alpharetta, GA 30005.