*Hi Partner,* *Hope you are doing great!*
*Please respond with Resume, Rate & Phone numbers of consultant to: pra...@cigniti.com ASAP* * * *Position: ETL Informatica Developer* *Location: Irving, TX* *Duration: 8+ months contract* * * *Responsibilities: * * The person is responsible for handling the following day-to-day activities which are essential to deliver metrics on a timely basis and ensuring the validity of the same to satisfy highly demanding business needs. • Round the clock monitoring of Jobs that are running in production and taking necessary action when there are issues. • Implementation of Production Changes during the scheduled days and providing post-production support • IR Handling for all data marts – ensuring that all assigned IRs are attended and resolved to customer satisfaction in a timely manner • Analyzing and performance tuning of daily running jobs in production. Re-design & develop the jobs when there is a better way of getting the things done. • Informatica applications configuration, setup, applying HotFixes and administration • Hourly communicating to business users about ETA for metrics delivery on a daily basis. • Handling of adhoc reporting and feed requests from production and ensuring to provide monthly and quarterly feeds to finance and Internal audit teams • Checking on any long running production jobs and doing any performance tuning activities to ensure jobs are moving faster. • Cleaning up unwanted/decommissioned SQL Server Analysis Services databases • Monitoring DB backup, restore and cleanup of Logs • Ensuring all inbound feeds are received and data is loaded properly • Ensure that all metrics data loads are done for the right date and time • Ensuring all outbound feeds are sent on-time and accurately • Taking daily backups of Shell scripts and Informatica repository • Cleaning up of Old Logs and ensuring all UNIX file systems has enough space to handle daily jobs. • Gathering source system maintenance/downtimes during weekends and informing to business about metrics impact • Ensuring on-time delivery of metrics • Verifying and making sure that Microsoft Analysis services cubes are processed properly and reports are published properly in the reporting environment • Page/email source System support when there is any delay/issue with files/Database • Working with Database Administrators for any DB related issues • Analyzing problems, determining root cause, reporting on problem status, etc., for network and desktop (application hardware and software) issues • Activities associated with incident analysis, resolution and tracking, problem-related task forces, developing and running of utilities and recoveries • All the System generated tickets will be paged to on-call support and the same need to be resolved immediately Required Skill Sets: • Masters degree with 7+ years of professional experience working in building DataWarehouse Applications • 7+ years of development experience with a minimum of 5 years in Data Warehousing and Business Intelligence • 7+ years of strong experience in Analysis, Design, Development, Testing and deployment of ETL jobs • 7+ years of strong experience using Oracle SQL and PL/SQL. • 5+ years of experience with UNIX shell scripting(Ksh/Csh) • 5+ years of Informatica PowerCenter 9.x/8.x/7.x/6.x experience • Experience in Informatica PowerCenter Installation, upgrades and applying HotFixes. • Experience in complete life cycle implementation of an Enterprise Data Warehouse • Good understanding of Ralph Kimball Data Warehouse methodologies and knowledge on the various data design models like Star schema and Snowflake models • Exceptional analytical and problem solving skills. Team player with the ability to communicate effectively at all levels of development process • Experience in Oracle development and performance tuning related to large data volume • 3+ years of experience in Production Support and code migration from different environments to Production Desired/Nice to have Skill set (in addition to the Required Sill Set mentioned above): • Microsoft SQL server, Analysis Services(Cubes), Integration Services & reporting services experience • Working experience in Telecom Data Warehouse • Experience in SharePoint excel services • Working experience with scheduling tools like Appworx, Tidal Enterprise Scheduler.* *Thanks & Regards,* * * *Prasad Mamidela| Technical Recruiter* **** *Ph: W: 972-756-0622 Ext 132 | F: 972.767.0948 * *Email: *pra...@cigniti.com *| *www.cigniti.com *IM: prasad_cigniti <prasad_cign...@yahoo.co.in>* *GTalk: prasadmamidela* * *http://in.linkedin.com/in/prasadmamidela** *433 E Las Colinas Blvd. # 1240 Irving TX 75039* *P** **Save trees. Print Only When Necessary* -- You received this message because you are subscribed to the Google Groups "SAP Workflow" group. To post to this group, send email to sap-workflow@googlegroups.com. To unsubscribe from this group, send email to sap-workflow+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sap-workflow?hl=en.